Recent content by Ricky1946

Thanks for your input. That is an interesting site dhookom. That's another one for my list. I did not know that site existed. Regards Ricky To say 'thankyou' encourages others.

Hello, Does anybody know where I can find a good 'bolt-on' drive and file list selection form that I can use in my application? Ricky To say 'thankyou' encourages others.

Hello again zion7, I have not visited for a few days due to the Christmas celebrations, but here I am back to the stress. Your code is nearly working, here it is with updated fields etc. CODE: Dim dbSpazio As DAO.Database Dim rcdStockQty As DAO.Recordset Set dbSpazio = CurrentDb Set...

Hello again zion7, Yes I think you do understand what I am trying to do. I have tried your code but on the line: rcdStockQty!Quantity = rcdStockQty!Quantity - DSUM etc etc. I get an error which states 'Item Not Found In This Collection'. Also when typing in the code it does not like the "'"...

Thankyou Zion7, I will try it out and let you know. Regards Ricky "To say 'thankyou' encourages others."

Hello hkqing79, I will take a look at your comments and get back to you. Thanks for your help. Regards Ricky "To say 'thankyou' encourages others."

Hello all of you helpers, I have a problem trying to update a table from a list of parts in a sub form. I will try to explain: I have a table of parts. I have an assembly which contains some of the parts in this table which shows a quantity to be extracted from the parts table via a query. I...

M8KWR, Hello again. I have solved the problem. It was a case of not seeing the wood for the trees. I had to take a break and stand back and have a look and the answer came to me - I had not referenced the query to look at the data in the form to sort to that specific customer. Simple!! but so...

M8KWR Thanks. I will take a look and get back to you. Regards Rick "To say 'thankyou' encourages others."

All of your comments have been noted - and I am very grateful. As this database is for a small company and I suspect only one person will create an invoice I will leave it as it is but your relevant points have been kept for future reference. Thanks again. Ricky "To say 'thankyou'...

The first issue is as (a) in your first question - I view all invoices in one workbook. The second question I really need (b) in the first instance because having created the invoice the customer needs to click a button to print it to send off. After that (c) would be a good thing for the...

Thanks Lupins46 and MichaelRed, I have used Lupins code and it works brilliantly, but I have included a bit of code to prevent the user clicking twice in the same session. I have put a variable flag called InvNoFlag which is set to zero. When the event is carried out the flag becomes 1. The sub...

I have two tables. One is CustomerTBL and the other is InvoiceTBL. They are linked via the CustomerID field. I also have a Customer form and an Invoice sub-form. The invoice sub-form works fine on the screen but as soon as I try to preview/print the invoice (report), It chooses the first invoice...

Thanks to both of you I will give it a try and report back. Ian "To say 'thankyou' encourages others."

Hello, I have a problem with printing a report (invoice) which is linked through a sub-form to a form which contains the customer details. The first one I create is fine, but when I create a second one, even if its for another customer it copies to the second page of the same report and so on...