Recent content by spalmateer

Dynamic Range Hi - Thanks for the reply. Apparently I was overthinking the problem. I had another reply on another forum suggest that I define the range high enough to where I wouldn't have to worry about not having enough rows. I've set my range at 8000, and its working like a charm.

Hi, I am using VLOOKUP functions throughout my workbook that looks at the last worksheet which contains equipment costs. An example is: =IF(B30<>"",IF(ISERROR(VLOOKUP(B30,'Equipment Costs'!$A$2:$D$895,4,FALSE)),"No Match",VLOOKUP(B30,'Equipment Costs'!$A$2:$D$895,4,FALSE)),0) The problem is...

I'm still having a little trouble with this problem. Its really not a super big deal but more of an astetic problem. With the solution Pat presented, the user when entering data has to scroll through potentially hundreds of inactive records in the combobox. For example I'm using this for our...

I'm attempting to create a database with various product costs for all our vendors and their many products. I've created the following structure: tblProducts- (one to many with tblProductCost) ProductID (primarykey) ProductName ProductDesc ect. tblProductCost-(many to one with tblProducts &...

Hi Pat, Are you saying I should fill the combobox from code? Therefore the choices are not limited to the list? How do I fill the combobox from code? Could you elaborate a little? Thank You! Scott

Hello, I need to find a work around to this problem. In my database I have a field in my employee table that marks an employee either active or non-active. Then on the form I use a query to filter the selection so only active employees can be chosen from the combobox. The problem is when an...

Hi, I have two tables that were related with a one to one relationship. I no longer need all the fields in one of the tables and I want to combine the remaining fields of that table into the first table. I'm trying to use an append query with no luck. The method I've used is creating a new...

I have a query that summarizes sales by zipcode. Our zipcodes are stored in the ?????-???? format therefore the report has hundreds of different zip codes. Is there a way to group them by just the first five digits? I've tried Like "?????" but that only returns zips with the first five digits...

Thanks for your reply Travis, Would I need to change the actual relationships in my database or could I specify the join type in the query. Or would it simply require replacing the above SQL statement to read Left join instead of Inner?

No, I haven't been able to get it to work as of yet. The problem is that when including other tables in the query results (tblOrders and tblOrderDetails), its showing only customers who have an order record instead of showing all customers. I'll keep at it and hopefully come up with a solution...

Hi, I recommend that you make your own Switchboards vs using the Switchboard manager. You have more control over the design and more flexbilitity doing it that way. To close the last form when you open a new one. Have the wizard make the button for you that takes you to the new form. Then you...

The Solutions sample database on the Microsoft website also has a great example of an activex calendar control form. Solutions Database: usually located in the ACCESS\SAMPLES folder on your HD or you can search this forum or MS website. ActiveX Sample Database...

Hi, I'm in the process of creating a search form for my database. Works great but its showing multiple lines for each customer in the result. Is there a way I can modify this to eliminate duplicate customers in the results. I've tried SELECT DISTINCT but that doesn't work. SELECT...

Use DCount to find out how many records are in the query before you open the form. Use this code on your command button (on click) that opens the form. If DCount("*", "qrySearch") < 1 Then MsgBox "There are no records that matched your criteria!", vbCritical, "No Matching Records"...

Point well taken. I will try both. I understand from Bob's suggestion that I should use the onchange event but the question remains unanswered if it is possible to force update after every key stroke (without saving because it moves the cursor). I can get it to requery after every keystroke...