Search results

Hi I would like the database to look professional, but all of the themes i've seen on access are quite generic and block colour. Can anyone suggest any tips to improve how it looks? Thanks WB

Hi On the "CustomerReport" form, the bottom two combo boxes are not generating the report. It is linked to the query "CustomersViaCustomerName" and have put the scripting into the criteria box under the Last name collum, but the report is blank. Thanks

Hi I want to produce an invoice based on a number of tables. The issue im having is that for each invoice there may be several "Order Details". Order details consists of: > Invoice Number > Item Number > Quantity Each item corrosponding to each item number has a price. Theefore how do...

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

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

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