Search results

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

Hi and thanks for the reply I will take a look many thanks

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

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

Great, thanks all

Hi And Thanks essaytee, minty and Frothingslosh Point snoted for all Where would I put strMyFilePath = CurrentProject.Path & "\Images" thanks

Brilliant, So can I put the access database in say C:\family Tree and the images in C:\family Tree\images and then hyperlink to C:\family Tree\images ?

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

Hi All and thanks for the advice I chickened out eventually as the solution using join table was great but I couldn't adapt it to my DB however, it did inspire me to do an append queries for each event IE Birth marriage etc and append them to a timeline tables (Yes, I can hear you all coughing...

Hi MajP Thanks so much for the quick reply The problem I have is it is all on one table ID,First,Middle,Last,Year of Birth,ChristenYear, Marriedyear,Year of Death Is it still possible ?

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

Yes, good point, I notice that I spend money via PayPal which could be for a variety of things

Hi And thanks for the reply the temp dbase I sent did only have payments to ... but I have refund from... transfer to .... transfer from..... Direct debit to.. thats why my supplier list would have transfer to fred smith 22 characters so I can compare this with the first 22 characters on my...

OK Will rethink it

Have reached this stage, wonder if you could take a look I have a table that has the first x characters of my Supplier (TblSuppliers) IE Card payment to McDonalds ( 26 characters in this case) I than have my statement with Card payment to McDonald's gillingham 123456 I guess I compare the first...

I was also joking about the McDonalds trips

Thanks for the quick return HAve also decided on a lifestyle change in view of your comments Now going to KFC:)

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