Hi group, I have a program made on VBA Access and i wanna list down all printers avaible on windows( locals or on networks) on a combo box. People has sugest...

What is the maximum number of records an Access 2000 database table can manage?

Hi Access-Champs, Thanks in Advance I have one Access 2000 database which is giving me error while opening as follows : "Microsoft jet database engine has...

Hi, I have 2 tables; 1. Demo: ID, LastName, FirstName (fields in the table Demo) ID is the Primary key. 2. Orders: Last Name, First Name, NoOfOrders...

A table contains comments from various faculty about various residents..I would like to pull all the comments on Resident X and get them in to a table where...

How do I get rid of duplicate entries in a joined query where one entry has more than one related entry? My report total is overstate due to these automatic...

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...

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...

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 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...

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...

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...

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...

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

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...

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...

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 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...

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...

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