Search results

Thanks for that solution. I need to produce a report, would I have to use Dlookup, or could I use this in the query the report will be produced from

Sorry about this I will try to explain The combo box contains a list a products, when the user selects one the text box should put the price of the product in it. The Lookup code is on the subform in the rowsource of the text box "Price".

I am trying to use Dlookup. In my text box I have put =DLookUp("Price","Prices","[Product]=[forms]![Instruct].[Product]"). I put in After update in my combobox Requery "Price" and this works, but this form is a subform on my main form when I open my main form I get errors in the text box and an...

How would I be able able to add items to the subform

I am trying to build a quote database. On the main form I have a combo box, the user can pick the catergory, the list box below shows via a query want is avaiable in that catergory. I want to be able to select an item from the list box and click add , then another list box would show what I...

The combo box is attached to a query, the query will show Product number and product, but the user should only need the select the produce. The table only need to store User ID, Product Number, Produce. The table is linked the another table which stores all the produce details. But I need to...

I have a form where the user selects a product from a combo box, there is a text box on the form that fills in the product number, but it will not then save the produce number to the table. The text box have a Row Source with =[Product].column(1). How do I get the text box result to save into...

I have build a personal database, where the user can enter a persons details, and holidays taken. The database is based on a Pay No that the user enters for each person. If they change that number all the holiday records will be lost. Is there a way to update the holidays records with the new pay no

I had a look at that database, but it just shows all your addresses. It does not have a search form. I want to be able to search by the first letter of each company. As I posted this before, the query will work fine, but the SQl statement does not run the expression. Any ideas

I am building a address book where the user can click on button "a" and all companies beginning with "a" will be displayed in a list box. I want to do this by coding each button with the row source of the listbox. In my query I used LeftChar: Left([Company],1) this works fine, but if I use the...

How could I do that, is it possible to click on a item in the list box and have some code add it to the table

Is it possible to select froma list and have a command called add, so the item is added to a record. i.e if a customer wants a quote for parts, I could pick the parts froma list and create a record with these items, from that I could produce a report which would calculate the price. Any ideas

I am trying to build a database that will produce quotes for customers. I have a form that has a combo box on it, if the user selects an item say Hard drives it produces a list of all drives in stock into a listbox. I want to be able to select the drive I want and add it to another listbox, so...

I have been asked to build a stock and purchase database, does anybody know where I could get examples of these to give me some idea where to start

I have build a search form for users, they can type in a clients number or part of in a text box, the results are shown in alistbox, then the user clicks on which ever record they want and a forms opens with that record. However each record does not have a unique ID so I put a autonumber field...

When a search is run the Column heads appear, I assume that because there is no rowsource attached the listbox, it can not produce the query headings, I could put a rowsource in the Onload of the form so the query would run but make sure the result is nothing. What do you think

I tried that but they disappeared, what I meant was when the form opens the column heads appear in the listbox before a search is done. I tried lstMyListBox.ColumnHeads = True in the Onload part of the form but nothing

Thanks alot, I did not think of that it works great. Just one thing is there a way to keep the column headings visible I put Me.search.ColumnHeads = Visible but they disappeared

I am not sure how you put the code behind the search button to run the query and point the result to the list box. My search button basically refreshes the listbox each time the user enters some text intoa textbox. Can you help with this

I tried that but after I cleared the listbox and tried searching again the form returns nothing whatever you try and search for