Hi, I would like to know how to update a field with the value from another field from another table? For example: I have Table1, StatusField. and Table2,...

I have two tables: customer and employee. Each has a field , formatted as Yes/No, Indexed (dupes ok). When viewing table data, why does one show checkbox...

I am converting an excel database to Access, a rather large one, that has clients assigned with a unique id that start at 1000000001 and currently ends at...

Hello, I want to set up a new database with actual sales figures, budgets and forecasts. The actuals and forecasts are updated on a daily base and the...

Should I set the properties when creating the tables, or should i sset the properties when I creating the forms. And if you have the same properties on...

Hello, I started a small database many years ago in access that kept track of some patient details - I work in a GP surgery - and their recalls. This has...

I have two tables. The first contains company names, addresses, phone and fax numbers. The second table contains peoples names, cell phone numbers and...

Hello, I have been challenged with making a yes/no field either stay on or off based and contract end date field in my table. I am using Access 2003. So for...

I have created a look up table and the fields are SuburbID (primary key) Suburb, State, District, Map Ref. Then I have created a form that allows me to put...

is it possible to assign a hot ket to a switchboard button??

I have created a data access page and added a dropdown list to the page with values from a table. How do I get it to sort?

I am trying to create a 2 column combo box using the lookup wizard. But I want whatever field I choose in a column to be saved in the record. If I choose a...

I am trying to create a field in my database that uses the lookup wizard and displays 2 columns. No problem so far, but instead of one column being the keyed...

Hi All, Many to many relationship. I have this many-to-many relationship: 2 primary tables, and a junction table. 2 primary...

I have an access database. It uses linked tables accross a network. haven't been any issues, until now. everything is working ok, but on a form i have there...

I am utilizing a database that imports jpgs according to the file name from another field. This works great and keeps my database's file size to a...

How would I input in a field a formula that automatically counts the number of say yesses in the previous fields of the same table? What I'm...

I would like to know if i can turn the usualy database warnings off. i know the option on the tool bar, but i want to turn it off in the database itself. i...

I have multiple contractor categories in a Categories Table and I would like to link this to a Contractors Table (e.g. Names of individual...

You could import the data from the two sources, creating a table for each. Then, you can create a query that compares the data in the tables. "TedChicago"...