Hello, I require some help with my query -- it doesn't work properly. Quasicode: From Table School, Select all people in any Class where that Class Contains a...

Which advanced reports for a store system (does sell and does buy)?

I would like to filter a subform by using a sql statement in vba. I want to be able to say. afterupdate on a combo box. select "*" where"ne" and = bu then...

MainForm: DailyData SubForm: MinData I have a control on The MainForm that i requery so that the subform is updated. After data is entered the Form returns...

I know this is simple but... I have an expense tracking form bound to a table. To the delight of the user I've created a textbox control that adds the...

Hi On my first form I have a drop-down box and I want if user selects specific value, access opens my second from, I tried following code but not...

I currently have a field in an Access query, which accepts an input as a criteria and executes the query based on that input. How can I know automate the...

Hi All, Just a quick one. I have a table with contact names (contact 1, contact 2, contact 3...) i want to be able to complie these contacts together and list...

In my form I have a field that looks up a employee name so as I start to type that persons name it brings it up in the field. The problem I am having is when...

We have a large database of clients. When I opened it this morning the Contacts form (where we enter new client information) showed only 1 of 1 at the bottom...

I am having a problem with a query-based form populating fields as expected, and am hopeful it is a simple solution. The query is based on several tables, so...

I've set up a form with the "Date Modified" field on it. I would like the user to be able to filter the records by those that have been modified within the...

Good afternoon, I have developed a database and have come to a halt as I am having trouble getting a certain functionality that I want. Here is the skinny- I...

Hi, this is probably simple and yet I don't seem to get it... Using the properties I select a custom format for time so the control displays a 12 hour clock...

In Office 2003, I have a text box control on a form. I want to restrict this text box to numbers only from 1 to 20 digits in length and I want to make this...

Does the combo box only capture data in the first column when you use a multi column display? I want to display the list as p_type, type_phase and capture...

Hi I have a main form which is a continuous form. The Subform is also continuous where you input expenses related to the main form record. There is a...

I do not have any of my fields shown under any wizards I start in access. I know the fields are there, and I can create forms in design view, but they do...

I have a table that has three fields, one is the group ID, one is a minimum value and another is a maximum value. I have a query that counts the number of...

Is it possible to set an OnClick event to a cell in a form with Datasheet View? I want to create a "button" using an onclick event and don't know how to set...