I have a combobox om my form tha contains the values Open, closed. What I want is when the user selects closed, you cannot change anything in the form for...

I have a form with an unbound textbox (txtFind) and a button (cmdFind) in the header. In the detail section I have a continuous forms based on a multi-table...

Hi all, I have a form which when scrolling through records, certain field labels go bold & it appears they get bolder because they reach a point where the...

I have a text field called . It's a maximum of four characters. If the maximum isn't used I need to have leading zeros. I have tried everything I can...

When I open my form it does not open at the top. I have a tab control at the top. How can I set it to always open at the top.

I using the Combo Box Wizard and I choose "Find a record on my form based on the value..." I select two fields - "Office ID" and "Office Name" to use to...

Good afternoon all, I have a Mainform and a Subform, which is displayed in datasheet view. On my Subform I have a field that is a "Yes/No" checkbox. I want...

How do I make sure there is no Duplicate Entries for a Name in a given form. If you have 2 seperate fields of Last Name and First name. Do I build a Querie to...

I have two Access 2000, properly split, applications deployed at a client. Both are quite complex (58,000 and 26,000 lines of code) and connect to three (the...

hi I have created an unbound form that I would like to update some fields when I alter the figures in one part of the form. is there any way of refreshing...

If I want to make a button on MyOpenForm that opens a form with a table record source to a specific ID (e.g., 2) in the table, I write the following in the...

I am using Microsoft Access 2003 Beg-Intermediate user with a small! amount of programming knowledge. I need some direction about some lookup tables that I...

Hi i have created a payroll timecard entry form - i have all my formulas working unless someone does not work on a certain day then none of them work - the...

I want my form to update a field in the control source table with the user account name.

Hi All I have an Access 2002 database where I have forms that are bound to tables. Usually when I open the forms, the form loads the bound fields of the...

I need help with code that will verify if certain fields have been filled in. I dont want to use field required at the table level. I want to...

I have a large form that is controlled by a query that asked for an equipment number. When the form opens to the equipment record and you scroll down to see...

I use a form and associated query to select customer, month and year, and then produce a report showing all invoices for that customer in the month and year...

I am trying to set list box control "lst_Services" in a form "frm_Producers" which is bound to "Type_Sevrices" field in a table "Mapped_Producers". The goal...

Hi, I have inherited a 2003 Access database. One small problem. I want whatever the current form is to be maximized. But what happens, for example, is I...