Search results

  1. N

    send via gmail \9 not via outlook)

    Hi All Checking the forums it looks like this is a heavily discussed topic I need to send a report as an attachment via GMAIL. the code I have works well via OUTLOOK but i am now getting uneasy downgrading the security to allow outlook to work. I attach the code I have and wonder if someone far...
  2. N

    Backup a backend

    Hi I have a database split to front end and back end I would like to back up that back end to another drive on a daily basis BUT I would like the program to remain intact All the backup programs I have tried put them into their own format ie hdd-0_e00.pbe IE file from...
  3. N

    combine multiple fields into a query

    Hi All I have had a reply from MAJP and others which really helped I am doing a family tree and trying to make a timeline so It will be a persons birth date and then christened date and marriage date and date of death for both partners I currently have 8 append queries to do the job but im...
  4. N

    Question Family tree

    Hi I am trying to do a family tree database which is going fine so far I want to be able to distribute this program and supply the run time program for those who don't have Access, So, I need to embed pictures ( Rather than hyperlink) which I have in PDF files I was trying to drop an active X...
  5. N

    combine multiple fields into a query

    Hi. I don't know if this is possible I am making a family tree database and would like the ability to lookup date of birth, date of marriage, christening date ,and date of death, from one combo box ( like a timeline starting from a certain year) so I can do another combo to show and end date (...
  6. N

    Search for string in string in Table

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

    shopping basket

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

    Basket case

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

    Re: Automate *.pdf (multiple reports) to send from Access thru MS Outlook

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

    email current report ONLY to client

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