I have 2 check boxes on my form. One is "projection" and the other is "actual". When doing data entry the user must check one or the other, but never both....

I would like to reference scanned field slips and photographs in the forms I have created- how is this best done?

Hi, I have a problem with a form. I have designed a form for entering information for a village (which is further defined by a commune, district and...

I have a form/subform in my database, each has a data table. The subform table has a foreign key tied to the form's table and the subform is linked with a...

I have a field that outputs a -1 or 0 depending on whether the field is not null or is null. I am having troubles finding the right statement to the four...

Access 2007 I am attempting to write an estimating program - all good so far I have my Item Header form linked to the subform Item Details many records can...

Hi I have a database that I created a Main Menu to go to my forms, but when I open the form from my Main Menu my "Find" command button on my form brings up a...

Is there a way to make buttons invisible to users so that only administrators have access to them? I'm trying to make sure my users don't try to run a query...

On a form I have a combo box that pull out text. The items in this combo box are 30-XXX or 31-XXX etc. I have a textbox: =nz(,0). Then I have a textbox ...

All, I'm on Access via XP Office Pro w SP3 on XP PRO w SP3. I want to change the control's border color as I enter control and reset it when I leave a...

In my form I have a drop down lists that lists all the office supply products. My question is: How do I get the drop down lists to display only those...

I had a list of report names in something I thought was an option group in an old mdb. I had 2 command buttons - 1 to preview and the other to print. I had a...

Hello All. I've done my search and have not found the same situation that I have, so I am hoping you can help me. I have a form with three text boxes:...

I've got a combo box in a subform datasheet that won't take the first selection when you're using the mouse. This is a combo box that is bound to one of...

I have a form called order form that has all our customer info for a particular job we did with a subform that shows what unit went on the job and what the...

Hello, I have 2 tables namely "tblUpdate" and "tblRecord". These 2 tables are joined by a primary key known as Job_No with referential integrity set....

Is there a way to separate data on a form by month? For example, a person is working on the current month and see all records created for that month and...

I am using Access 2003. For whatever reason, I cannot save forms created by the Wizard . After I select that option not only it is not automatically saved in...

I was asked this question - we have a field that is blank, if this field is blank how can we get it to auto fill with the word "Active". Thanks

Hello, I have a form with a subform that is in continous view that allows the user to add/change records in a table. Before moving the records from one table...