Search results

I only do access no VBA or SQL - sad I know, Have a customer who wants to save invoices to Word. I need to design a macro that will: print, save then delete. The name of the report needs to be the invoice number. Can anyone help me please?

I have no VB skills at all have to do everything with macros etc. So please keep any replies simple. I have a database for students, courses and tutors - all worked fine until the customer wanted each student to do 2 courses at a time. The whole database is designed for statistical returns ie...

Is it possible to save a report to a particular 'file'. I am trying to develop a database for the issue of parking permits, letters and permits are not a problem, but the boss wants the letters saved for later viewing, i.e. she wants to search for a particular person and be able to see all...

I have a small database with letters as reports, sometimes I have a titke for a person but not always I want an Iif statement or IsNull so that if there is no title I can address the customer as Dear Sir/Madam. I have tried many variations and none seem to work can anyone help? PLEASE

I have a form which shop staff complete, I have placed a box on the form showing staff how much stock is held, this is linked to stockid so shows the stock level for the current item. I have worked out an Iif statement for saying not enough stock or stock Ok. This works well but I think I need...

OK - learning lots from you guys and trying stuff out. The latest problem - I have sucessfully constructed a form (based on a query) where i can update stock for damaged goods and for annual stock check. However the stock check result overrides the adjustments, can I update stock levels from...

One day I will finish this database and leave you alone. Latest problem is that I have a query to calculate aged debts - it works very well so far. I have used expressions to get line total/VAT/Total and Balance outstanding. One expression leading to the next so balance oustanding is...

i have a form stock which records stocks codes/price/stock in hand and reorder levels. I have a macro (not very good at VB) on the Before Update property of stock in hand that checks if enough stock is available, I have some code on the On Exit property of stock in hand that deducts sales from...

I have very little knowledge of VB and am trying to do a stock controls/sales/purchases system on a database - have found some code in a text book that seems to solve all my problems but it doesn't want to work. I get an 'invalid Null' message when I use it. I assume that this is because there...

I have very limited knowledge and I need to extract data from sales transactions so that I can update stock levels. I can do the extraction bit with StockID , stocktransactionid and quantity in a query. This results in a list of all sales, some stock lines have been sold on more than once...

I have spent the last 4 hours trying to work this one out - I have a report (invoice ) which is based on a form with subforms etc. I have prepared a query to base the report on but it will not show the sales price. Having tried everything I know I give up and ask for help please. The report is...

I can't get my database to do a Sum of all product trasacions - I have used formulae layouts etc from Access templates but they don't work. My knowledge is limited any help gratefully received d/b attached

Help! I have no VB or SQL skills - just Access and simple macros, I have to design a database that does sales/purchaes and stock control. I can do most of this with macros and queries. However the client has some customers which are exempt from paying VAT and some which aren't. I have a...

I am fairly new to all this - did an IT degree recently but it was more theory than practical. Is there an index to explain what the command codes (far right) in the expression builder box do?