I have this code on my database that show certain records based on a training modules completed selected by the user from a drop down list. SELECT...

I am trying to create a Multivalued Lookup Field. I am using the Lookup Wizard, but when I get to the place where is should let me choose to store multiple...

Hi, im pretty new with access 2007, i decide to use northwind template. In order detail both form, i have 2 different Qty, the original Qty is the Qty that...

i know in the back of my mind i know how to do this but... when i select the suburb in the lookup field i need the table to automatically update the postcode...

All, I'm using Access 2003 in XP Pro w SP3 on XP Pro SP3. I have many years of development experience but am VERY new to Access. Instead of creating...

Hello, I'm trying to create a database that keeps a roster of employees. the problem is, the report that acts as a directory will not be alphabetical. It...

Hello - I'm Trying to run an sql statement that I'm creating in the VB code. DoCmd.RunSQL sSQLforUpdate The code is creating an update query...

Hi All, I have to do some work where I need to copy some original data from a existing table into another identical test table in another database. The tables...

Hi all, can anyone help with a wierd problem? I have been using a database for soem years, which involves a number of related tables. I have a table of...

Dear All: I have a question. Reading about lookup tables, (e.g. tax rates for different states) should I connect these lookup tables to my Data tables (e.g....

Does anybody know why all vba code would stop working after converting an Access 2007 accdb file to accde format? I have looked around for several hours but...

Hi all I'm working on a rooms reservation system based on Access 2003 and then realize an ASP web page to manage it. I need a little help in creating the DB...

I have appended query that scans a part number as shown below: INSERT INTO Triggers ( , , , , Qty, , Supplier, ) SELECT Products., Products., Products. ,...

trying to update msaccess database using infopath form. data source is drop down menu and infopath doesnt save the info into the fields.

While using Microsoft office access 2000 program I tried to close it down and it would not close the file I had created. the computer would not let me close it...

I have a form (frmMain, based on tblMain) that includes a combo box (cboUserName) from which the user selects his or her name. cboUserName is bound to , a...

Hi, i have a table where passwords are kept and i need a vaidation rule that means the password must have at least one letter and one number. Also woud it be...

I am currently building a database that holds a roster of employee names and what their work activities are. This database will be available to each person on...

I created a table with a field name of Start Date. There are a number of queries and html pages set to get the data in that field. I want to create another...

1. I have a table :"BuyerSeller" it has ID#, Company, Contact, Tel, City State, etc.( I keep track of all my BuyersSellers info in here) I have another table...