Search results

What is your table structure? Do you have one table for the Purchase orders and one table for the Line Items? If you do then you could use a Form/Sub Form Design and Use the Parent/Child Relationship between the forms. Of course without understanding your table structure I can only guess what...

You can use the "Search" function of this site. Search for RecordSetClone. There are examples on how to set a recordset for ADO or DAO to equal the Recordsetclone of a Form. Basic ADO Dim rst as ADO.RecordSet Set rst=Me.RecordSetClone DAO Dim rst as DAO.RecordSet Set rst=Me.RecordSetClone

See this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;159328

You will need a Form with a Timer Event that does this. You can open this form Hidden so that it does not accedently get closed. If you only intend to send one email for each overdue then you will need to add an additional field to the Rental Record (Boolean) indicating that you have already...

Have you verified that "D:\Telewest_Alexis\CEASE_Records\IN\GO.BAT" Runs from the "Run" menu?

You will need to create a Popup/Modal form with a Rich-Text Box control to handle this type of message formating.

SendObjects is one method of sending an email. However, how automatic are you talking? Everytime the Access application is opened? At a certain time of day? Which days? Or at set intervals? For this to work MS Access must be open. For certain times of the day or set intervals you will...

Reset the RecordSetClone right after you set the RecordSet property of the form. When you want the form to be read-only set the allowadditions, allowedits and allowdeletions properties of the form to False. (Set them to true when you want the user to be able to do these functions).

From the Help File Access 2000 Change the color of the control that has focus on a form [list=1] Open the form in Design view or Form view. Make sure that the control is selected, and then, on the Format menu, click Conditional Formatting. In the Condition x area of the Conditional...

See knowledge Base Articles: Access 97 Access 2000 Access 2002 These articles will help you to understand how to use the LDB file to determine who is using the database.

You could have the code run on the Open event of a Form that you open in Hidden Mode. This should allow you to continue using the database.

Then to test remove the offending field from the Word Document. Run the merge (to verify that you don't get any messages). Once you have a clean run try adding the field back in.

What are the field names that you added to the query. What are the names you used when you added the fields to the word document? Did you use spaces in the field names?

On Error GoTo ErrorHandler Dim myset As ADODB.Recordset Set myset= New ADODB.Recordset With myset .Fields.Append "Field1", adBSTR, 10 .Fields.Append "Field2", adBSTR, 10 .Fields.Append "Field3", adBSTR, 10 End With...

Then all you need to do is not use Last on the professions and genders, instead use Group By. This will give you the Last for each profession and gender.

There's DLookup or even opening a DAO or ADO recordset.

Export using a Query that is sorted the way you want.

If you are using a Pure MS Access approach then you will need to use a form with its timer event. Checking to see if it is just after Sunday midnight and that the record has not yet been created. However this will require that MS Access and this form be open. Other methods are: to use the...

If this is the case the "Orders Table" is effectivly a lookup table. What you want is a Combobox on the form (Hide the First Field). The RowSource of the ComboBox is the "Orders Table" The OrdersID field is the ComboBox's Value and the FurnitureCatagory is the Viewable Field.

What are the relationships between these tables? What I'm see is Customers CustomerID Primary Key Name Address etc... Orders OrderID Primary Key Date FurnitureCatagory CustomerOrders CustomerOrdersID Assumption Primary Key OrderID Foreign Key CustomerID Foreign Key Date This looks like your...