Recent content by nicwnacw

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?

refreshing subform After a week of trying, I posted my query and went back to the drawing board. Problem solved with RunCommand on exit event I ran the rfresh command and all now works.

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

Thankyou Thanks I'll give it a try!

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

stop action Have tried it on the Before Update (thanx for the suggestion), I don't get error messages, or the Not Enough Stock message. Will the If work on B4 update as there is no value in the qty field? and the if is based on X being bigger than Y

stop action I adapted your code a little: Private Sub quantity_AfterUpdate() Dim qty As Variant qty = DLookup("[quantity]", "Stock", "[StockID] = '" & Me.stockid & "'") If qty < Forms![stock].QuantityInStock Then "Not Enough Stock" Else End If and I get a syntax error on the 'Not Enough...

stop action Thank you for that, but QuantityInStock is on a different table to sales transactions where the quantity field is, so will the Me. thingy work. so far i have tried code to open stock from the afterupdate event on sales trans - that works. I then insert an if x<y, MsgBox ("blah...

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

Thank you Thank you for that suggestion it would have been easier. You guys are a great help

criteria OK that worked - seems very long winded but there you go! I assume that I will now have to take Expr4 out of my IIf's and put the whole formula in - what fun

criteria tried again - I left the () off by mistake - now I have a parameter box for expr's 1-4 . the machine seems to want the entire equation. Expr1= [sales price]*[quantity] Expr2 = CCur([expr1]*17.5)/100 Expr3 = [expr1]-[expr2] Expr3 = [expr3]-[amount] Instead of using expr's in Expr...

criteria query Thank you - I just tried that and I got an error message saying that if I wanted the field to show i had to duplicate the column - so I did. Got an error message saying that i did not enter an aggregate function ??????. Now I'm even more confused.