Search results for query: *

Hi, I have a query, well it comprises of a query and two underlying sub qieries if you like and it's takes the form that uses it forever to load. Unfortunately, I'm doing this database for someone else and they HAVE to have this form but I need to get the query to run about 10 times faster...

Thanks for the help but I am getting an error when I compile the code I get: User-defined type not defined for the line Dim con As Container

Thanks for the help but I am getting an error when I compile the code I get the error: User-defined type not defined for the line Dim con As Container

Can I refer to tables or the information in tables in a database that is closed from an open one? Liam

Here it is, nothing special, just lots of DoCmd.CopyObject commands like these.That's it! DoCmd.CopyObject "C:\WINDOWS\Desktop\Liam\T .L. I\TLI-backup", , acTable, "GENERAL-CODING" DoCmd.CopyObject "C:\WINDOWS\Desktop\Liam\T .L. I\TLI-backup", , acTable...

I am backing up all the tables in my database onto a blank database using the DoCmd.CopyObject method. This is working fine but I have trouble with tables that are in relationships. I want to keep the relationships but I am prevented from copying over tables that are in relationships. How do I...

Hi, I have two forms, networkRefurbishment and addASpecialCode. After entering information onto the form addASpecialCode and exitng from this form I need the information contained in a field called newCode to be transferred over to a field called Code in the second form networkRefurbishment...

I have a continuous form which has the following fields: Code Description Quantity Code is a combo box with a list of values from an underlying table. When I select a particular code I need the relevant description to appear in the Description field. I have managed this much by inserting...

I have a Combo Box on a continuous form which allows me to select from a list of values that are stored in the field of a table. When I select a particular value I want the rest of the information from that record in the table to be dispalyed also but how do I set this association between the...