on the save click command how do I clear the text boxes for new record entry.

I'm trying to sort out the best way to pass a form variable to a query that is used to generate a report. The form allows the user to select a Project ID and...

I've got a form that lists equipment. The form has many records and within the form I've got a subform that you can click open where you can enter companies...

OK, here's the problem... I need to connect an autofill form that stores the Agency information, to sub form that stores the invoice information for a travel...

Hello. I have a page header in the design view of my form but when I switch to form view it is gone. Whats up with that? Reid

Even though I am setting LockEdits parameter to dbOptimistic, continue to get run-time error 3027 "Can't update. Database or object is read-only" when it gets...

can anyone tell me why this won't work: Dim lastPaymentDate As Date lastPaymentDate = DMax ("Date", "PaymentsReceived", " = " & Me. ) previouspaymentnumber =...

If you have multiple Contacts in your database, and each contact can have multiple receipts for something.....How can you build your query to only bring up and...

Is there any way of changing how a scroll mouse operates in a form? Currently, when I scroll it moves to the next/previous records. I want it to scroll the...

I have a button on my main form that opens so the user can add financial information. How can I sync the pop-up form record to match the main forms. Thanks

I'm unable to get my command button to work properly in 2000. Trying to open a form based on the contents of a field in my current form. When I create the...

I have a form that opens when the database is opened and runs a batch file in the back ground. I want that form to remain on the screen until the batch file...

Dear all, When I set a text box in main form with formula : ! to show the total value of the subform. It only shows the value in access 2000, but it's blank...

I have a text box that allows input for a date. I use this date to run a query. How can I keep this date in the text box until I need to change it again. Even...

Hi Any body help me in solving the problem below: Error with the following code at .ControlType is "Method or Datamember not foud" Dim ctr As Controls For...

hi! I want to know the names of fields in fieldlist of my form. kindly help. how do it in vbcode. thanks. krish

Hi! Any one help me how to get field name through vb code from a form. thanks krish

I have a table of categories where I pull a category name (RS.Fields(0)) and a field that indicates whether that category should be included RS.Fields(1)....

Hi I palced Text Box, Combo, CheckBox controls on form. I want to get the names of the controls or control source of the above controls at BeforeUpdate event...

In a form, in an MS Access 2002XP form (having as record source a table) with: -6 combo boxes with values selected from a query (ex: For cboBox1 record souce...