I need to set up a function in my database where I can copy a record, but also all of the records that are associated with it in any related tables (of which...

Requery the form, e.g.: Forms!Form1.Requery The form will be reloaded, so it will return to the first record. Make sure the form is not dirty before you...

I enter financial data into a form that has a field, and four other fields that may contain data, a breakdown of the total. I would like to be able to enter...

Hi I need to block user from moving away from a record using any of First/Last/Prev/Next/New Record or any other way IF the record has not been saved, and...

I need to be able to populate a list using choices from another list for a science kit database I have. I have one form called "Activities" with a subform...

I have built a form in Access and a SQL query has been built as the source for the form's data. When I go into the Properties of the form in Design view and...

Is it possible to select multiple values from either a list or combo box?

I am using Access 2003. I have a form with 2 combo boxes: combo1=State combo2=Submarket I am using the following code in the After Update Event of combo1...

is there a possibility to generate a tabs for a tab control dynamically and then create other controls within each tab dynamically??? thanks in advance Stevie

I have a database created in Access 2000. I have ART (Access Run Time Files 2000). I also have Advance Installer. How can i package my database with the Access...

Hi J, are you displaying the field in a form? If yes, go into the edit section, click on the field which holds the Dog, Wolf data and selected...

I have a macro using Setvalue to set the value of several contols in a form to null. One of the contols I'd like to set the value to null is a list box. When...

I want to create a button to export a query to an excel file. Ideally, I'd like to just prompt the user for a name and location for the exported file, but I'm...

I would like to put in a verification check in a form, however I can't seem to figure out how to get it to work. I have a field entitled "PaymentType" and a...

Hello: I'm fairly new to Access 2003 so I may be overlooking the obvious or I did something wrong. I designed a One to Many Form as follows: I created a...

How to make 1.54 appear as 1.54 instead of 2.00

1. I have a calculated value field on a form. ( = *). The calculation works fine. But how do I save the answer in a table ? 2. I have a subform on on main...

Hi guys. I have a table in my database called SupplierCheck. This table contains amongst others, various fields called Quality, Price,...

I have a document in Word 2003 that i want to use as a form in Access, how do I get into Access?

How can I draw a horizontal line after every 5 records in a continuous form? thanks