Recent content by artemisia

I'll keep working at it. The person who created the database is no longer with the company. I am trying to do updates as we need them. Thank you!

Here is the SQL statement: SELECT [Commissions payable2 by salesperson query].[Order Master].[Order Number], [Commissions payable2 by salesperson query].[Order Date], [Commissions payable2 by salesperson query].[Company Name], [Commissions payable2 by salesperson query].[SalesPerson]...

I am using Access 2000. I am trying to debug an SQL code for a Query that is not working. Access help says you can debug this but you need the debug toolbar. Problem is...I can't find the debug toolbar. I looked in View, Toolbar, Customize and it's not there. Whe I installed the program I just...

New user looking for help. Is there a way to debug or check the SQL statement in Access? Thank You ^.^

How should I do that. I'm a newbee.:p

I created several buttons: Add New Customer, Find a Customer, Add New Order and Edit Order using the Command Button Wizzard. The following message appears when I click each button: The expression OnClick you entered as the event property setting produced the following error: Ambiguous name...

I was just reading about compaction yesterday. I will check that out today. That could be part of the problem. I did check the options before I imported. When you import tables does Access rename them? For example, I imported Rate Plan and Access renamed it Rate Plan 1. I deleted Rate Plan and...

Thanks Jeremie, I checked the linked fields and they all have primary keys. I double checked the fields and they are identical, including the data type. I checked the relationship before I imported and there was a One-to-Many relationship established. During the import, the relationsip was...

I'm a newbie to Access, and I have been elected to maintain and update our database at work. This past month I took a crash course in Access. Now the challenge begins and I need help. I created a copy of our existing database and made changed to two tables…tblRatePlan and tblCompPlan. Then I...