Top "Ms-access-2003" questions

Microsoft Access 2003 - a rapid database application development tool - Use this tag for questions specific to Microsoft Access 2003.

How to find duplicates from two tables and also to find duplicate in itself?

I have created this statement in access 2003 SELECT COUNT(*) FROM TABLEA WHERE NOT EXISTS(SELECT * FROM TABLEB); Does this statement …

sql ms-access ms-access-2003
How to determine if any row is selected in a listbox

I have a list box in my Access form. I need to know if any of the rows in this …

ms-access listbox vba ms-access-2003
MS Access 2003 - Opening a report without it printing

I used Docmd.OpenReport "Report1" from another form and it seems to just want to print the report without actually …

ms-access vba report ms-access-2003
inserting multiple rows with 1 query

I have problem in inserting multiple rows with 1 query using ms access 2003. When I use INSERT INTO like the code …

sql ms-access ms-access-2003
Search between date and time in access query

I have the following data on a table tbl Admission : Date and Time are two different fields and stored in …

sql date ms-access-2003
inserting data from multiple tables into one table

Im trying to add data from tables into one table using this SQl below: INSERT INTO myNewTable SELECT * FROM 2010-tbl, 2011…

mysql ms-access ms-access-2003
Opening an MS-Access database from the command line without running any of the startup vba code?

Is there a way to open an MS-Access 2003 database from the command line without running any of the startup vba …

vba ms-access ms-access-2003
Populate a variant array from a comma-delimited string

Usually if I want to create an array from a comma-delimited string then it's a String array I want and …

vba ms-access-2003
Dynamically resize a report Detail area

Is it possible to resize the Detail area of a report dynamically, in MS Access? I have a report and …

ms-access vba ms-access-2003
How can I always round up decimal values to the nearest integer value?

On a report I have the following code for a field: =Sum([PartQty]*[ModuleQty]) Example results are 2.1 and 2.6. What I …

ms-access ms-access-2003