Hi I have a form where i require user to select which safetyhazard images are required for each record upto 5 what is the best way to do this I thought of a...

I have a main form with 2 subforms to be used for data entry & they are all based on tables. I recently read here that forms should almost always be based on...

I have two labels on a form and want to populate them during the run time of my form. The name of the labels are "1" the other is called "2" (without the...

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 have a from with a whole bunch of subforms contained within a tab control, so that users can enter data into five or six related tables. In most cases the...

Hi all, I am attempting to use MS Access forms for a data entry project and am fairly new to database design and the use of forms. The data to be entered are...

Hi I've got a small problem. I'm in the process of designing an application for inspection process on production line. one of the issues I came across is...

Neither form is bound and only the subform is pulling data from a table. Would like to enter a date on the main form . The subform would then show all data...

On my form called f015KeyMilestones(continuous form) I have a field called KeyMilestonesSubID. How can I do the following.. If KeyMilestonesSubID =12 then...

i have a form that is used for data entry. employees use the form to bring up records. there are 2 combo boxes on the form to filter for specific records in...

Hello, I have some code who put event catchers on a control to do some AfterUpdate stuffs like this : Dim WithEvents myTrigger1 as CheckBox .... set...

I have two identical forms, each with a DOB field and an Age field. I'm using the following expression to display the age in each...

I have a database created in 2003. I have saved it as .accdb, but when I try to use autoformat my forms all I get are solid colors. I saw on another thread...

Hello ALL: not as long as it seems. just a good explanation :o) On a data entry form, The form (that pops up the below dialog) has: projectid*, issueid*,...

Hi everyone! I've made a couple a excel sheet about 3 monh ago, and I decide to use Access to compile the result, I what to use my excel sheet in a form so...

Hello, I had posted this question in design and i received a spammer link so here is my question and i hope you can help, On my form, i have tried the steps...

Hi, I have a table with part numbers and locations. There are multiple locations per part number. I would like to populate a listbox with a filtered list...

i cant remember my username and password for my windows mail can anyone help me retreive it? thanks

I've just opened earlier version in Access 2003. In the the earlier version I could see the database window but no longer in 2003. How do I get the Database...

Howdy. I'm using Filter-by-Form for searching. For each field, when in FBF, the pull down shows a list of distinct values for that column. One field on my...