Search results

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

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

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

Hi, I just found out that the search form we've been using for the last two years was fundamentally flawed- only showing records that were not null in certain fields. I guess there is ALOT of value in extensively testing before deploying!! Anyway- I have a query that receives its criteria from...

Hi, I have a search form where I enter criteria in a textbox and it limits the criteria of a query. The results are shown in the same form. I'm currently using the the following code to requery the the query after update on the textbox: Private Sub txtLastName_AfterUpdate()...

I have a checkbox and a combobox on my form. I would like the user to be able to choose a selection from the combobox , resulting in the checkbox being checked. Also if the checkbox is unchecked by the user, I would like the form to clear the entry in the combobox. Thanks for any help with...

Hi, I have a simple question about record sources for forms. I have a main customer form with a services performed subform. The services performed subform has a one to many relationship with customer number(in tables). I also have three buttons which bring up pop up forms. All the popup forms...

I'm having a problem with a subform that is based off a main customer form. My subform pulls up warranty information for the customer that is currently displayed in the main form. The problem is that whenever I enter a new customer into the main form and then go to the subform to enter...

Hi, I have two fields on my form. One is Unit Installed and the other is Unit Age. I would like to use VB to update the Unit Age field after entering a date into Unit Installed. I'm using this expression to find the age: =DateDiff("yyyy",[Unit...

Hi, I have a combo box on my form that has a list of builders. I have limited the input to the list but I would like to have the user be able to add additions to the list without having to leave the form. For example if the user types something that is not on the list, a message box will appear...

Hello, I having a really hard time trying to get a form/linked-form to work together. My main form (frmCustInf) has customer information fields with an autonumber customer number field. On this form I have a command button which brings up another form (frmModelSerialNum)which has model/serial...

Hello, I have a form that is based off a parameter query that allows the user to enter a customers last name to find the record. When the customer record is pulled up on the form I would like the user to be able to press a command button that prints a report off the currently displayed...

Hello, I have a customer form with a Yes/No checkmark box. I would like if the box is checked, for a button to be visible that allows the user to go to a form. Please forgive my ignorance as I'm sure there's probably a very easy way to do this. Thanks in advance for the help and insight. Scott

Hello, I have a customer form with personal information (ie name, address, phone, ect.). I am trying to create a control that dosen't allow duplicate customer information to be entered. For example if an address is entered already in the customer table- then if someone enters the same address...

Hello, I have a customer information form that has a last updated field. Currently our data entry person has to manually update this field any time the form is changed but I would like to find a way to automate this so that upon editing any fields in the form (or subform), the field (last...