Hello, I have a combo box with the following SQL RowSource attached to it: SELECT tblSource.Year & tblSource.SourceValue AS SourceCode FROM tblSource WHERE...

SELECT Sum(.Sales) AS Sales, Date()-1 FROM HAVING (! Not in ("25773621","afy04890)); It gives me a "type mismatch error" Thanks

I have been using the "Switchboard" (I believe it's used in Northwind.mdb) for a while now. One of my forms needs to open in "Datasheet" view. When the form...

How do I open an access database from an already open database. For example, I want to add tables and records from one database to an exisiting database.

I am working in a Form - design view. The format is Tabular. I have set up a field that has a simple math multiplication formula of two other fields. C=A*B ...

Thanks very much for the help, but can anyone walk me through this (Or give me more details) bearing in mind I am a complete amateur in the world of VB, and...

Hi everybody, (I hope that I can explain this well) I have a continous subform that holds more records that it can display. After update of a record I have...

Our payroll department uses a third-party database as a backend to a frontend MS Access 2000 database with all linked tables. Every pay period they generate a...

Hello, I have a form with multiple tabs. I created a field and put it on one tab. How do I get that field to only show on the tab selected? Right now,...

I have a running database to which I want to add some new functionality, and I can't figure out the best way to do it. It's a (botanical) plant database. A...

Hi, I have a form with a linked sub form on it. When i click through the records using the record navigator buttons, it says "calculating" in the status...

Hi All I have a number of tables, queries, forms and reports set up. Users will firstly enter customer details into one form then enter their order and...

Hi, I have an order entry form with a subform attached for order details. Whenever you add a product to the Order Details subform and then you try to add the...

I've recently started working with Access 2003 and can't for the life of me work out how to set a form so it always opens maximised. Can someone assist? I've...

Hi. Two (long) questions he Question 1: I have 26 tables and 26 matching forms for a survey. Every table has an ID field that is the primary key. When I...

wht are people not using this service tomits full pottential

I have created a form in Access with several controls that have drop downs for the user to choose. I now need to create a record in the table for every...

I have a form I designed in datasheet view. Everything is great until I open it with a command button I did through the wizard. How do I force the form to...

I would like to add a control in my form such that multiple items could be selected at once. The control should be a drop-down-menu where multiple menu-items...

Hello! Could anyone please help me as to how I can call the Oncurrent event in the main form from a command button of a subform. Thank you in advance.