Stack Overflow
Stack Overflow

Questions tagged [ms-access-2003]

Microsoft Access 2003 - a rapid database application development tool - Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

Office 2003 reached end of support on April 8, 2014. If you haven't already begun to upgrade your Office 2003 environment, Microsoft recommends you start now. MS Access is a member of the MS Office suite of applications, included in the current Office 365 edition.

Use this tag for questions specific to Microsoft Access 2003. Also use the more generic [ms-access] tag for general MS Access questions and [access-vba] for questions involving MS Access Visual Basic for Applications

803 questions
0
votes
2 answers

Sub Reports In Main Report - Access Reports

I have an access report that has 4 sub reports/forms. each of these sub report is meant to display patients admitted,transfers in , transferred out and discharged from a particular ward. I have 4 different queries to perform the task. When i run the…
Mohammed Rishal
  • 649
  • 2
  • 11
  • 13
0
votes
1 answer

Multiple Tables with a single Tabed Form

Can you connect multiple tables with a single tabbed form? For example, if I have 3 tables and I have 1 tabbed form with 3 tabs and I want tab 1 to use table 1, tab 2 to use table 2 and tab 3 to use table 3. Currently, I can only point to one table…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

DLookup ControlSource

Summary: I want to display a value (in a text box) stored in another form upon choosing specific values from combo boxes. I want to pass the two combo box values I have into the DLoopup property but every time I do so it gives me an error. Below…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

Filter and then Save

I have a two forms: "Cover" and "Form_1". I have two comboboxes in "COVER". One contains a list of years and the second contains a list of names. The first one is of type Number and the second one is Text. On the "Cover" there is a button which…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

Bind Textbox To a Field

I have a form in MS access. I have created a few textboxs in that form. I have input a function in the control source property of a particular textbox(TOTAL). This basically sums up numbers entered by the user and displays it in the textbox. The…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

Add Numbers from two different forms

I want to obtain Numbers from different forms, add them up and display the output in a different form. For example, There are two forms: Form 1 and Form 2. The information I need is located in Form 1. So I get the numbers from Form 1, add them up…
Ish
  • 671
  • 5
  • 21
  • 36
0
votes
1 answer

Effect of subdatasheet property in Access database on the performance

I have read that if a subdatasheet property in a table is Automatic,then the performance reduces. Would you please tell me the reason?
Baper
  • 1,533
  • 5
  • 22
  • 30
0
votes
1 answer

DBEngine Variable not defined in vb 6.0

when i write dbengine.Workspace("", "", "") it shows error near dbengine variable not defined.
Phani
  • 23
  • 2
  • 9
0
votes
2 answers

Access/VBA and SQL WHERE clause format issue

I have read a huge pile of problems and solutions, and I just can't figure out what I'm doing wrong. BounceDate = DateValue(txtBounceDate.Value) bncSql = "DELETE _BounceMaster.* FROM _BounceMaster" & _ " WHERE _BounceMaster.DateCheck >= #" &…
graidan
  • 151
  • 2
  • 11
-1
votes
1 answer

Check for existence of a certain table in access DB using C# OleDB connection

I'm struggling to find a valid answer to what I'm trying to find. Basically, I want to check if for example: "tableNO1" exists or if every other table exists... By the way, I'm using Access 2002-2003 if that somehow helps :) Do you think I should…
SPekkOPs
  • 13
  • 2
-1
votes
1 answer

In report, not show the updated data

I got a problem in showing report. The system flows like below - Systems insert records in CSV file into a table,A in ms access database by batch. Systems update in another table, B, based on these inserted records. Systems shows a report from this…
soclose
  • 2,773
  • 12
  • 51
  • 60
-1
votes
1 answer

dlookup not working for other month than MAY

I am using dlookup (date = date) its fine when the date is of "May" but when I put date of any other month like 1/6/19 the dlookup remains silent. in Dlookup if date is of MAY its fine but not working when date id of JUN the code I am using is as…
Mahmood Malik
  • 1
-1
votes
1 answer

How to Query attendance on MS-ACCESS

I want to query an attendance from ms-access with one table on it and calculate the number of hrs work : emp_id emp_name emp_date emp_time emp_dept emp_mode 1 mike 20140819 201040 security 5 1 mike 20140820 …
dlanorfeb24
  • 3
  • 3
-1
votes
1 answer

SQL Select Statement Column Selection Based on Checkbox TickMark Access

I would like to select specific columns based on the user checkbox selection. I can able to achieve it using VBA but is it possible to arrive the fields in SQL itself based on forms checkbox tick status?
Sixthsense
  • 1,927
  • 2
  • 16
  • 38
-1
votes
1 answer

Error when looping through Image slideshow from pics in folder

I am trying to create a image slideshow by changing the Image control .picture property by looping through all images in a predefined folder C:\Images The code I am using: Public pixpaths As Collection Public pix_path As String Public…
Tinker
  • 1
  • 3
1 2 3
…
53 54