I created a data entry form with a Save button. This button runs thru a procedure event which moves data to the proper fields, does a nested if-then-else...

Is there any way to set the validation rule for a text box to be "R" followed by any 7 number, such as R1234567. I am trying but haven't been able to come up...

you could put it right in a TextBox on the report.

After figuring out that you can't use a Split Form in Access 2007 as a subform, I went back to the old way of adding a datasheet view subform to my subform. ...

I am trying to use a datepicker to set number of days until an email reminder is sent. I am a little over my head. I am trying to use something like: If...

How would I see these invisible buttons on the form? When I look at the form in design view, there is only one button. "Daryl S" wrote: Gntlhnds - ...

I added a Combo Box after the Form was created There are now two fields that say "Vendor" the original and the Combo Box "Vendor" I'd like to remove the non...

The subject is basically my question... In some instances when I add a list box or combo box to a split form and am using that control to go to a specific...

Hi, I have form based on query. I want to choose value in one field on form, and then the other fields on form to fill with appropriate values (one row from...

I have a table (tblSO_Items, this is my master table containing all items) which contains the following fields Number (this is a number field) sono (text...

Hi, I need to make a website that has a calendar page which stores data on a MS SQL database. I've been told that Access would be useful for this (with or...

I have this form for inputting student grades that isn't working right. I have an unbound combo box for selecting the student, and then a subform as a...

G'day All, I have been having heaps of trouble trying to associate an option box with a field in a table. Not sure whyI am unable to achieve this as all the...

Hello All, I'm using the TransferText method to import a CSV file. It works fine. The problem is when I change the TableName argument to a attached table, I...

Hello, I don't really know how to formulate question, so I will try to explain problem shortly: I have created small invoicing application in Access 2007 for...

I hope this makes sense... My frmEmployeeMain contains one subform, frmProbation. Within frmProbation, there are three subforms, frmProb1, frmProb2,...

In 2007: In a form I created a button, used the wizard to set it to go to next record when clicked. When I click it, I get this: The expression ON CLICK you...

I have a basic for I'm trying to add a check box to. I add the check box then add a text box =IIf(=yes,"A","Left") simple yet I save the form and open in print...

I'd like to run a SQL statement which will return a single number, and assign this number to a variable. Here's the SQL statement: "SELECT COUNT(ReceiptID)...

I get an error when I try to create a combo box from the wizard. I am trying to use a database template of the Address book and wanted to look up a person by...