I get a error message when I add the following to code to build a query: "IIf(Format(.,'ww')="",54,Format(.,'ww')) AS Week " It runs fine as part of a...

Hi All, I have this form with a"Close" button, "Save" button and 2 subform (value Claim and 3rd Party). I will like to enforce user to click on the save...

My form set Allowadditions to False and also do it on Current event to prevent adding record in an uncontrollable way. Users have to use the Add New buttom...

my subforms all do not have vertical scrollbars when main form loads up. -- Message posted via...

Hi there, I have got an order form designed in excel with macros, which i use to send an order to other providers. Everytime i get a new order over the...

I have a many-to-many relationship which I want to show on 2 forms. *Member table* Member ID Member First name Member Last Name *tblAttendance* Member...

I have created a form using tab control and inserted other already created forms for each tab by moving an dropping. When I click on any of the tabs the...

Hi I have created a Add Record COMMAND BUTTON in form and I want to assign a short cut menu for it that is like Hot key (^H). Any one please guide me how I...

How can I store the record ID in a textbox if i have just entert a new record Thanks in advance -- N2OLD2L

I have a form to enter new records. I want a button on it so that if the user wants to leave the form and cancel the update the form will close without...

I want to create a form that prevents the user from adding a new record. I do, however, want the user to be able to modify existing records. So I guess I...

hi!can somebody help me to set my form to allow additions only once?Meaning every time the form is opened it would allow additions but not more than...

In access i created table and form to coincide what the population is now doing in excel. How do i go about being able to type in 1 press enter and it will...

Some times when I use the "filter by form" feature the automatic drop downs do not work. Is there a reason?

never mind

i need hogan

I have a calculated field on a form (form and calculated field are based on a query). = * There is an option group on the form: 1 - option 1 2 - option...

How would I use access to fill out a variety of standard forms? I have most of the forms as fillable PDF, or they could be scanned in as any format. The...

I have a form with an input field for Organizations. I have a command button that takes me to the Organization form to add new organizations. This works...

can you use a case statement on a combobox? for example, i have 2 comboboxes (combobox 1 and combobox 2) if the value of combobox 1 is "new york" then values...