Import the two spreadsheets into access. To find the new records, run the "Find Unmatched Query Wizard" To identify changes on records that exist in both...

Right now I have my WorkedAreaHoursTotals query as a source for a crosstab query and it's working like I want it to. Now I want the hours on the crosstab...

I have 5 tables all on a 1 to 1 with the link being the PK on all plus 2 additional tables 1 to many with the link being PK to FK_Id on both. I then created a...

Just bought a new machine, Product key supplied comes up as invalid. Is there anyway to get a new one as distributor is giving no help! very frustrating!

I am a Access newbie: I am trying to add 3 fields together to get a sum on my form. the fields are , and . their respective value are 10, 20 and 30. When I...

Hello, I have two linked combo's and the second combo regularly drops it's entry. It's control source is set to a field in a table. Sometimes the entry...

i have more than 100 records for printing. what i did is, first i created report and used subreport to fit more than 5 reports in a single report.the first...

Hello group. I'm really stuck and don't know what I'm doing here so any advice would be appreciated. Every client has alot of companies that they owe money...

Hi, I have recently upgraded to Access 2003 from Access 2000 and now have a problem with a Code 39 barcode. I have a text box on a form which has it's control...

Hi All.............. I am trying to bring an Excel file into ACCESS. I have a specific named range on one Excel sheet and the top row of the range is the...

I am a beginner in using Access 2000. I have tried to change items such as "male" "female" on a drop-down list. I've changed the typed in values (using " and ;...

How do I set up predictive text in access? If I enter "today" in a cell and later on enter t, how do I get today automatically entered into the cell?

I have a large video database file created with Lotus Approach, dbf format. I created a new table in Access using a template. When I try to import the Approach...

I'm a new user and would like to use mic-access prog for my office purpose. This report will be named as Exception report, the basis concept of this report is...

I have a form which includes a memo field, sometimes there is a lot of text in the field ( half a page of a4) when i print or view a report I am only getting...

Hi! I've created a query using 3 different tables and linked together via common fields. I had already filled each table with some few records. Then I...

Hi, I am trying to create a calculated field in a query. The field has the following formula: freq: (1/numrecords) + valueofpreviousrecord where numrecords...

I have downloaded a form and was filling it out when I noticed that most of my macros in task bar are inactive. i really need to use some of them. How can I...

I have the following table in part --- TblClassDate ClassDateID CourseID ClassDate Classes for courses are held on multiple days. The data for a course in...

Hi all We have an Access 2000 database, split front and back end. Back end on Win2003 server, front ends on Win98 and NT4 clients. We are looking to upgrade...