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

Ok thanks a lot

Yeah thats correct. Now i need to create a report which will be the invoice. I need it to calculate all the different prices (job details and order details). Do i need to write any scripting in the query or is this all done via the report?

no, when i leave the field blank. If i put 2 in there it brings up invoice 2, 3 brings up invoice 3 and so on...

thanks thats great. I did feel i was being rapetative in creating many queries. WB

ok, i've added data to the work orders table and removed the calculated values from my work order details. My query now brings up all the invoicez

Here you go Thanks

but i have resolved that using the totals button. Even so, just one tupple of data appears?

no, however when i leave it blank, only one invoice appears over and over again??

Do you mean in the query criteria field?

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

So for my query i've added "Work Orders", "Order Details" (Which takes stock item prices from "stock Items" table), and "Job Detail" (Which takes employee ID from "Labourers" table, which in turn takes hourly rate from "Labourer rates" table). As they are both have a relationship with "Work...

No, that is where I'm stuck

Yeah thats pretty much it. There will also be forms where the user will input "Labourer Costs" again linked thorugh the Invoice number.

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

Thanks for your help, really appreciate it

Thats worked great, thanks. But im still confused because looking at the "StockItems" query the criteria is under the supplier name and not the supplier ID, however the combo report generator still works.

I've updated the one you gave me, creating a new query. If you refer to the "StockItemsSuppliers" (of the attached) and attempt to pull a report from the bottom to combo's, then no data is outputted onto the report. (Sorry for the confusion)

Thats great, I understand everything you've said. I've adjusted the "StockItemsByDescAndSuppliersCombo" query to add the criteria (so that when I select the combo boxes the required report is created), but as soon as I add a criteria the query goes blank so I remove the criteria again and the...

Here you go. Its probably a bit messy compared to your standard (garunteed actually). The form with all the combo boxes on and the buttons is named "Stock Items Suppliers". Only 2 of the functions are actually working (top two on the left) and all the rest throw up errors. Thanks again WB