I have a form that has a tab control on the bottom with three tabs (Staff, Client and Special Circumstances. The upper part of the main form contains Event,...

I have created a main form and subform and want to prevent Access from adding new data into the subform until I've entered key data, like a Primary...

Is there any way I can have my mouse wheel scoll up and down the actual contents of a list on of a combo box. I don't mean the standard 'scroll the list'...

Hi, How does one prevent a form from being changed? I am trying to have the form open for confirmation purposes, but opening in print preview mode is not...

Hi, I am facing some problems in binding the control source of a textbox to a query that is NOT in the record set of Form (I don't want to change the record...

Is it possible to save the changes to a form when I make changes to the underlying database table? It seems that every time I add a new field or rename a...

i have designed a form in that there are two fields called actual payment and commission the scenario is like this if is from 1 to 25000 - the bank will...

I make changes to my Access database using the Tables, but enter data using Forms. I like to redesign my forms. However, it seems as if each time I make a...

What I'm trying to do is, in a date field, on "has focus", if related "check box" is positive (yes) then insert current date + (plus) 45 days. (to present a...

Dear all, I want to set the focus in the one textbox even if I press enter or tab key until I use the mouse to point to another textbox. How can I do...

My company currently uses an access database to run queries, reports, etc. from our accounting system CODA because CODA is not user friendly. My first...

I've building a form with a subform. The subform is based on a query that draws info from several tables. Each of these tables relates to the others using...

I'd like to replicate the way the Northwind sample database list products on a sub form (Product List) on the Categories form. In the Northwind sample, a...

I posted the following (see below) a number of months ago. The response I got back then was to make sure that the reference to Microsoft DAO 3.6 Object...

How do I add a column to an exsiting Access form (ie. order form) but then get it to be part of a calculation? My order form currently has "order Id, order...

I want to permanently display the previous record in a subform. But whenever I go to add a new record on the main form the subform data goes! I have had a...

How do I make lcase("A") = ucase("A") return false. I can perform the oposite in DOS/CMD (if /i A==a returns true, if A==a returns fasle ) but how is it done...

Good Afternoon, I am creating a report based on input in a table that calculates ticket revenue from athletic events. I have the report completed and a total...

Forms will not sort by Order by. I have to use the select statement including the ordering for the forms sdata source. Thanks, J.

Is there anyway to have a secure database where a person can't access the passwords that are stored expect to change their own password? Thnaks, J.