i need to set up access to be able to scan item into it. also i would need it to be linked to excel to hold the information that will be entered into it....

I'm running the MS Access Performance Analyzer on my front-end database (so I can analyze forms/reports, etc.). I received suggestions adding indexes...

Hi, I have a database of users (Clients, Admin, and workers), but I need to split these into different tables so that I can open remote links to external...

Hello, I downloaded this " http://www.access-programmers.co.uk/forums/showthread.php?t=130978 sample database and I was wondering how I could use this form...

I have a table that contains more information than I need for my database. This is information I import daily and can not alter that. I have the fields...

Is thier anyway to set the primary Key of a table with VBA? I have a make table query that runs, however when it creats the table it does not set a primary...

I am developing a Scholarship database and how my tables are set up now- it works, but I feel like there is a better way to do it. The reason I am stuck is...

Hi, I have a main data entry form with subforms in their own tabbed areas, tabbed by category. Some of the data in the subforms use list boxes (created...

I am restructuring a database in Access 2007; it was built in older versions of Access progressively over the years. Yesterday everything was as it should...

Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Summer Weight Loss Recipes. Lose weight eating cookies and...

I have a database tbl_Vendors = Vendor_ID (auto) PK tbl_Sites = Site_ID (auto) PK, Vendor_ID (number) FK tbl_SiteVisits = SV_ID (auto) PK, Site_ID (number)...

I have to create a database which monitors outcomes every four hours. I have created a table which covers 1 day and have then copied this to make the 2nd...

I created custom template but the graphics gets lost when i want create form or report

I have a number data type in my primary key field and for some reason when i key in 016 it reverts to the number 16. What can be done so it does not remove...

Can someone help me understand how to require that a record be put in a table if a record is put in a related table. Example: If I am entering a Site Visit...

I am trying to figure a way out to make a table that will import data in this format. http://www.drf.com/entries/24/eCPW24.html?rn=500027 I was able to...

How do I connect a command button on an access page to a report

In design view, in an access table, under format a text field: What is the expression ( like "" that forces capitalization) to forced upper case for the...

I've run into several hurdles in trying to design a capacity planning model, and I was wondering if anyone knew of a good template. Something that might be...

All, I've got a database currently residing on my server. Many users access the database to: 1. View data 2. Update Data 3. Create Reports 4. Create Merged...