Search results

Hi I currently downolad my bank statement via excel and add a code number to each entry in order for me to see where I am spending most momey IE Code...........Shop.........Date...........Amount 1................Amazon.....1/1/18........£100 2................McDonalds..1/1/2018....£9.99...

Hi JHB and thanks for your reply. Yes, that's what I thought, however, this works and fills the table (TblTemp) correctly but I cant show the result in the sub form, It appears to be locked and only shows the ID as NEW. (Waiting for data entry before it issues an ID Number I have tried...

Hi All I am at the end of a very long journey with a database I promised I would help with. Effectively, the salesperson looks up a product from a lookup list, this info goes to a temporary table(Basket)(to protect price rises in the lookup table affecting the customers invoice), where...

Hi All I have pestered utter access so much I feel that you guys deserve a bit of punishment. I have a table that has a list of printer manufacturers, what printers they make and finally the toner cartridge they use. I need to be able to 1 Filter the list by make and model until just the...

Re: Automate *.pdf (multiple reports) to send from Access thru MS Outlook Hi Peter Thanks for your prompt reply Sorry, I should have submitted the full code to give you an idea of what I was trying to achieve I need to email 2 attachments in pdf format to one email recipient. the...

Re: Automate *.pdf (multiple reports) to send from Access thru MS Outlook After hours of search I found this excellent code from Trevor G and have used it on a new project. Its perfect for me with 1 exception. I would like it to be able to filter the reports by user. currently it sends the same...

Hi I have been reading through the post to try to find the solution to my problem but after adding different chunks of code I always hit the same problem. I am doing some work for a plumber who having completed his work needs to produce a printed copy of a landlords report ( from his vans...