Search results

Whats the best way to upload my database?

Nope, just other combo boxes and buttons which generate reports.

Between [forms]![StockItemsSuppliersItemNumber]![comboSuppliers3] And [forms]![StockItemsSuppliersItemNumber]![comboSuppliers4] - this is the code on my query and I've ensured the combo box names are matching.

Hi I have two combo boxes so that I can select a range when I want to generate a report. I have created the query, but when I select the values in the combo boxes and press the button, instead of access getting the information needed from the combo boxes, a pop up box appears asking me to...

I've swapped it round so that between is outside the square brackets and it works!! thank you so much!

[between forms]![StockItemsSuppliers]![comboSuppliers1] and [forms]![StockItemsSuppliers]![comboSuppliers2] Does that look right?

So i now have a report that shows the suppliers name and ID. But my issues is still creating the 2nd combo box so that the report will return the range of suppliers and the stock corrosponding to that suppier

ok, i've changed round the tables so that the suppliers now reads: > Supplier ID (PK) > Supplier > Contact Number > Address > City > Post Code And the Stock Items Table Now reads: > Item Number (PK) > Item Description > Stock Price > Net Price > Supplier ID (FK)

ive already got a supplier table, but the PK is the suppliers name and in the stock list table the FK is also the suppliers name. Do you still need me to add a supplier ID?

Its a stock list table, with the following fields: > Item Number > Item Description > Stock Price > Net Price > In Stock (tick box) > Supplier I have sorted the report by supplier, but want to show a range so the user can make a selection in two drop down boxes (housing the suppliers name) and...

No, its basically "A Supplier" thorugh to "E Supplier". I have one combo box to show one supplier, but I want to show several on the report using the drop down menus Hope that clarifies things!

Hi I know how to create a report using a combo box where it shows me the options with a drop down menu, however I want to create a report using two combo boxes, so that the report reflects data from (for example) Supplier A to Suppler D. Can anyone assist me with this?? Thanks WB

Thanks. From a help page and your assistance i think it should be something like the following: DlookUp("[Mark-Up Percentage]", "tblMark-Up Rates", "[Net Price]>=forms!frmStock Items![Net Price]") Does that seem about right??

there you go!

Hey I've attached a print screen of the two tables

Hi I have a form where I enter the net price, but I want to calculate the Stock price automatically by running a query. The query needs to look up the mark up rate in the mark up rate table, but the rates are different depending on the net price of the item. How do i create a query that...

Hi I need to be able to search, amend and input new data into forms. I know how to input new data, but the searching and amending is proving more difficult. Is anyone able to show me a way of adding a search facility on to a form. Thanks (an exasperated) WB