Is it possible to filter a form by distinct values in a text field? I tried making a query and failed badly. Text field has tool names and I am trying to...

Hi! I'm working on a database right now that has a drop- down menu of search terms. I originally had the menu in three separate text boxes so the user could...

Hi, I have created a top level form with two subforms. The top level form has it's own table and each of the subforms have tables. When I add a new field to...

Hi guys: I have created a function that calculates sign in/ sign out times for a datashee. It works for the record level when a user updates or tabs from the...

I want to click a button on the switchboard and have it open a form and assign the recordsource, which will be based on the selection that is made.

Hi Is it possible to have the redo action available on a form in data view. I have users who think Undo is like Word so click on it every time they make a...

Hi, I'm working in Access 2003. I've got a problem with a form. The thing is, the OnOpen Event does not fire! If I simply write some VBA code to show a...

Hi I am trying to make a code that gets values from a sheet i Excel into a form in Access, and I want to read the values from the cell D22 and downwords in the...

Using Access 2002 I have used this code before, and it always worked. Now for some reason it is not working. I am using it to merge a record to a word doc...

I'm sure that there is a fairly "simple" solution to my problem but I am apprently having a "brain fart" and can't figure it out. I want to print the current...

I have a form with a combo box on it that is populated from a query. This all works OK but when the query runs, it not only populates the combo box but also...

Hello all, I have a database which I use for document tracking. It is now recommended for use by all. I have two date fields in the form. 1) When the...

I have a form shows the number of days before and after date. So some numbers are a negative valve some a postive valve. I would like a way to count only...

My form has a combo box to select a client company, which then populates a list box showing all the employees for that company. I have a "DoubleClick" event on...

I am trying to display a picture on an Access 2003 form using the Unbound Object Frame tool. If I BROWSE for a picture, what shows in the control is just the...

In a Form, i run a query, if the query result is empty, put true in a checkbox, else false. thank u..

Hi I am curious to hear what others think would be the most efficient way to sum some values given that in Access (2000, 2002 & 2003) there are many ways to...

Hi, I would like to create a macro that asks user for password before opening another form upon a click of a command button. Is this possible with a macro? Or...

Tracy, 2 things come to mind from your description. The first is you stated that the form is based on a query. Is it possible that the query that the form is...

What is wrong with the following expression? calc date due: (DateAdd("m",! ,!)) This calculation works when I do it in a query, but when I try to create the...