Could someone past some sample code of how to query my Access database? I am using VBA through MSAccess. Thank you!

I am very new at access and I know what it does but I don't know how to do things. I was wondering is there any simple tutorial that I can look at so I can...

I have created and ran a query. The query results showed the fields that I selected to be displayed, but when I scrolled to the right, the other fields in my...

this is a test

Does anyone know how, using asp and an access database, one could display the total of the records retrieved. all of the records retrieved are #'s and I need...

Is there a way to only show text boxes in a report only when there is related data and on other lines of the report hide it when there isn't any data?

Hi, My database has 3 table linked into another database. With coding, how can i refresh all table ? Thanks

After developing a (novice) application I have lots of queries, tables, forms, subforms, etc. that are no longer actually in use. How can I get lists of...

I want two fields side by side on a report - that can grow, can shrink for different records - they might both have info, only 1 might have info or both may...

My excel column headings changed from letters to numbers, and I don't know why. I now have numbers identitying both the columns and rows on my spreadsheet. I...

I have a table with a column that contains dates that are of the data type text. They are stored in the format mmddyy, so they appear as numbers. For example...

does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in column B always enters the date...

Does anybody know how to use Report Utilities Ver 2 from Stephen Lebans? Thanks

I am working with an existing database of nineteen fields. Field one is "LastFirstName". I am trying to set up a validation rule that will not allow...

Hi everyone I've created a form with a detail section that displays all records from a table. In code, when I reference a control and its properties in...

HI, How to manipulate records of 2 different tables on a form. Can anyone help me in the correct syntax? for eg: 23 is in table 1 and 75 is in table 2 how...

I have a form with embedded subforms. I want to rerun (or refresh or whatever) a subform (which is based on queries on a table), when a different subform...

I have an Access 2000 application with about 20 users. The backend corrupts quite frequently. I have experienced this: After I compact the database it beings...

I have a Form that collects simple data from a medical chart review. It is set up to always enter new data when opened and the data is placed into a table. The...

Hi guys, we have a new look in the discussion group. It seems the new look (the system response) is too slow. It took minutes and sometimes seemed hanged...