I have a form that has a subform built into it. The main form pulls from a table with 4 fields. The parent field is Department. The subform (pasted into a tab) within my form is linked to the child field Department and pulls in 8 other fields. I created a report to report by department. Within my form...

Hi. I have a database that contains Images. I have them entered by file name in a table. Then on the forms or reports I have them using the control source. All is relatively fine. However, I want to be able to use a a relative path(s). I want to keep them all in a 'Images' folder in the same...

Hi I'm currently developing an Access 2007/SQL 2005 (.adp) database. A requirement of the project is to allow a user to enter a job and to allocate an urgency to the job which in turn assignes the time allowed for the job (eg: Critical = 2 hours, Urgent = 4 hours ASAP = 8 hours etc). An Expected...

When i try to import a spreadsheet in Microsoft Access, it gives me the Error "Error in Loading DLL". The title of the window is "Import Spreadsheet Wizard". I am able to import something from another access DB, just not from spreadsheets or the Import Text Wizard. I am currently...

My 2003 Db is getting close to being finalized. I have made a simple customized Menu with only Compact and Repair Database, Backup Database and Exit as the only functions on it. I don't what I'm missing. Can I simply turn off the 2007 ribbon and use my 2003 customized menu?

I am looking to write a function that will delete all data from all of the tables except 1 in my database. This is the code I have below, but as I step through it is doing something different. Is this possible without specifically calling out each table by name. Thanks Code Snippet: 1: 2: 3: 4: 5: 6...

I am looking to write a function that will delete all data from all of the tables except 1 in my database. This is the code I have below, but as I step through it is doing something different. Is this possible without specifically calling out each table by name. Thanks Code Snippet: 1: 2: 3: 4: 5: 6...

I am looking to write a function that will delete all data from all of the tables except 1 in my database. This is the code I have below, but as I step through it is doing something different. Is this possible without specifically calling out each table by name. Thanks Code Snippet: 1: 2: 3: 4: 5: 6...

I am looking to write a function that will delete all data from all of the tables except 1 in my database. This is the code I have below, but as I step through it is doing something different. Is this possible without specifically calling out each table by name. Thanks Code Snippet: 1: 2: 3: 4: 5: 6...

Hello. We have an Access 2007 query that we need to run in order to populate another Access table. The query generally returns about 15,000 rows of data. When we run the query it is fast (1-2 seconds), but when we run attempt to INSERT INTO those records into another table it takes forever. Below is...