Search results for query: *

I'm trying to show how many total vehicles our customers have bought. I run into problems when I want to combine that information (field) with the regular query I've always used. (This query helps record whether we've sent our recent customers a certain gift certificate.) The query that...

I have three tables Customer, Vehicles, and Employees. Each customer has an Sales Consultant. This is an EmpID field in the Customer's table. Each Vehicle was sold by a Sales Consultant. Sales Consultant field name = EmpID in the Vehicles table. After importing a few thousand records I have...

I've searched for a solution but have come up short so far. What I would like to do is open a form 'frmUsedMargins' based on input from the unbound 'frmSalesReports'. In frmSalesReports I created 4 drop down boxes. Two of the drop down boxes are based on date input. The first drop down box...

This is a straitforward request but I can't seem to find an answer anywhere. I'm modifying code from Desktop Developers Handbook: In the book's example it shows how to use command buttons to control how a list box is populated. My situation is a little different in that I need to have a combo...

I have found some code that helps me to create a custom Autonumber from the Access 2002 Developer Series books. However, I don't like or understand why the authors have the Counting Table in another database. I'm concerned this issue may cause me problems down the road, plus I should learn...

I've been working on this concept for some time and once it's done my database is ready to be field tested at work. There isn't too much time pressure just the occasional, "why is this taking so long?" right now. This is modified from MichaelRed's FAQ700-184. However, once it was running...

I'm probably going to cringe when I see the solution to this but I need to ask for help anyway. I'm very new to coding but having a blast learning. Lately I have been consumed trying to implement MichaelRed's FAQ 700-184. I'm using Access 2003 but thought I liked what I read enough to want...

I work for a car dealership and we are trying to query our database to return a segment of customers who are likely to want to switch out their vehicle. The goal is to get all previous Sunfire owners who have purchased a vehicle from 99-01 but exclude the Sunfire owners who have bought since...

I have a simple project but the relationships and/or append query functionality has had the best of me for a couple days. This is compilation of multiple systems run at vehicle dealership. The main issue I'm running into is there is an EmployeeID to every Vehicle transaction and there is a...