I can tell if they are sold two ways, either in design view when the box is checked or when the querie is run. I have the combo box set up to the querie so I...

I have a designated field with a check box saying "sold" if the box is checked it is sold if not then it is not sold. When I use the querie I made, which...

I need to generate a report based on a query which displays a list where Date1 exceeds Date2 by more than 10 days. My query looks something like this: SELECT...

Hi all, I have a problem that I would like to be solved. I would like a field called "Failure to date" to be a counter field, where it counts the number of...

I have a main page, with 5 command buttons on it. Each button opens up a different form. And the way i set it up before, each "FW" field for the queries the...

My subform does not appear automatically in the main form. When I run the subform separately is works fine. I found that when I click design view and then...

I'm not very familiar with Access and yet somehow I was given the responsibility of creating a database. As much as I've been able to "pick it up" through...

I know this has to be easy.... Visual Aid: www.gotmerchant.com/dtnew.gif Customers is main table Got a form for CallNotes On CallNotes Form, I want two...

Hello Does anyone know how to make a textbox a required entry in a SUBFORM when a textbox on the main form is entered? -- Message posted via...

Thanks for any help on this. here is what i am trying to do In my form I want to be able to filter down what records users are working with in the list. I...

Every tells me I should have my names in 2 fields and an autonumber employee key. The problem is the key is meaningless so if there are say a hundred...

I am trying to create a subform in a form, based on a query, using the Control Wizard. I select "tables and queries" to find the query to base the subform...

I have a form that performs a simple calculation. It divides field1 (SALE PRICE) by field2 (RSF) to give me field3, (PRICE PSF) BUT, sometimes, when entering...

Hi, I'm new to Access and need some help to set up a form. At the moment I have a form where you make a selection of a client from a combo box. Then you click...

I think I need a list box.....maybe I need something totally different. This is what I want to do: Each night we get a .txt file. Each morning I load the...

Can you change the text size in the message box?

Hi, I've got Allow Additions set to Yes, and Data Entry set to yes, but still cannot add new records in my form. Spent too long on this with still no idea...

Hello, I'm new to the world of vba and I'm trying to write a boolean function that that returns true if the form exist or false if it doesn't. Here's what I...

Hi All, (Windows XP Pro, Access 2002) I have a music database with tables holding Recordings and Artists. It also has ‘tblLINKArtist_Recording’ making up...

Hi everybody, I would like to update many fields of the CURRENT record of a subform. I create a query to update these fields and a macro to execute the...