Search results for query: *

PHV - [b]THAT DID IT!!!![\b] Thank You Very Much!!! I see that you created another JOIN with a subquery but is there a name to that technique? I'm wondering in case someone searches this thread or for a simliar solution. The solution you posted was not in any books I keep laying around or in...

Thanks for your input Duane. I've spent some time evaluating what you suggested and I don't think I worded the question properly. The output should be in columns that look like this: Customer Name, Customer Address, Recent Sale Date, etc, TOTAL OF ALL VEHICLES EVER BOUGHT. This would then...

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...

Thanks PHV You made working with SQL fun again. It was a great sense of satisfaction when I pressed the run query icon and updated 1197 records in 3 seconds. For anyone looking through this post here is the working code. SELECT Customers.OrgName, Customers.IndivLastName...

PHV, This looks like a great suggestion. Thank you. I need to modify the qryGetLastSold to filter out Customer Records where the EmployeeID is no longer active. I don't want to update these records. That is also why I defaulted everything to EmpID = 444 when I was importing my data. The...

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...

Whoops! Just when I thought I'd tried everything I got the VBA to output the same as my working SQL statement. This is what comes up in the Locals window: "SELECT * FROM qryMarginsUsed WHERE(((InventorySource) = 'Used') AND Year(TransactionDate) LIKE "2004" AND Month(TransactionDate) LIKE "9"...

This is almost working! I have come up with a seperate SQL statement that works after modifying my combo boxes. SELECT * FROM qryMarginsUsed WHERE (((InventorySource) = 'Used') AND Year(TransactionDate) LIKE "2004" AND Month(TransactionDate) LIKE "9" AND ((EmpName) = 'Rene Aubin')) ORDER BY...

Thanks for your input Zion. Interesting Handle. I've spent several hours working on a solution and really appreciated the little kickstart your input gave me. I have two of the combo boxes working perfectly. However, I'm having a real struggle with the date options. cmbMonthChosen -...

I suppose I could work on it that way. Being new to VBA it would be faster than my recent progress. However, I'm wondering if there might be another way because I also need to do the same thing for the year combo box as well -cmbYearChosen (1995-2004). This would create a large # of Case...

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...

I've been doing some more reading and am now wondering if this is even an available approach with access. In the book where I got the original code from nothing is mentioned about combo boxes but they do discuss incremental searches with list boxes. I tried their sample and incremental...

Thanks PH, Your last post got me thinking outside of the box. I searched past posts with that error code and fixed up the basic combobox coding. The Following now works to find OrgName's - but only by using the scroll bar. The 'Findfirst' method doesn't seem to be working like a normal...

Ali, This is easy. In design view, at the top left of the form there is a box. Right click the box and chose properties. Then chose the format tab and change the Yes to No for the Navigation Buttons option.

Whoops! The code is as you suggested it. I just used the highlight feature for the 1st time and got the bang in the wrong spot when i was editing my post.

Your suggestion is very new to me. I have tried it and get the following compile error: Method or data member not found Dim rs As Object Dim AnyName As String Set rs = Me.Recordset.Clone Me.FindFirst "AnyName = '" & Me[!cmbCustSearch] & "'" This was copied from the combobox...

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 never did get this solution running. However, I bought the Access 2002 Developer's Handbook series and used the solution included in it. It is very similar but seems a little more bullet proof in design.

Thnaks PHV, This code compiles fine and goes through the debugger ok but still fails to add the value of lngBigCustomerID to the Customer ID field of a new record. I thought if I tried the bookmark command it may be the missing link but it's not at least the way I've used it. There's a logic...