Search results for query: *

Thanks a lot Andy. I will give it a try. Hampshire UK. There is nothing so sad as an old guy trying to code.

Hi all, I am trying to open an existing specific Word document from a double click in a text box on a form. This document (which already exists) is selected from the entry in the text box on the double click. I have tried various methods to no avail. Can anyone suggest how this might be done...

dhookom many thanks. It worked. I would never have found that option. When I was programming there was no such options. I am very grateful. Hampshire UK. There is nothing so sad as an old guy trying to code.

Hi all, It is a few years since I carried out any Access/VBA development due to retirement and I decided I did not want to forget my skills - but I have a really basic question which I am rather embarrassed to admit!! I am using the latest Windows 10 Office 365 version of Access and I have a...

H, I have a database that was developed a few years ago which outputted a string to the 'To' box in Outlook email program, which worked fine. I have now upgraded to Mail for Windows 10 and would like to update the code to output to this. The code I have is: 'Place email address string into...

Brilliant, thank you very much. It's printing out fine now. Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Hi, thanks for your replies. dhookem you mentioned including the code so I have included the relevant part, I have not included all as its not necessary. 'Read birthdates until end of file and assign values to array variables x = 0 GetBirthDate.Open "SELECT Dateofbirth FROM...

Hi, I may just be a bit thick, but I will explain my problem. I have created coding within a loop to produce a list of birthdays that are coming up within the 'next' 14 days, and I am trying to output these to a text box in a form at the click of a button. This is working, but each time it goes...

Thanks chaps, I will give it a go. And thanks for the code. Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Hi all, In my distant past (in good old Basic programming - shows how old I am) I recall using an array to assign a value to a variable (say x) to collect a value in a loop (like x1 first pass, x2 second pass etc.) I am trying to do the same in VBA in an Access database within a loop. I have...

Thanks both of you. I will certainly try these. Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Hi, Does anybody have the VBA coding for texting from an Access database. I already have the database up and running with emailing to a group from the data, and I would like to be able to do the same with texting to mobile phones. Is this possible? Inky Hampshire UK. A fool and his money...

Is it possible to make the pdf printer the default for that computer? Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

I had this trouble some time ago so I placed all my coding on a 'Next' button to go from tab to tab, as I did not get any satisfactory way of clicking the tab itself. Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

You could try allowing it to save the file and then delete if they dont want to save it. Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Hi, Does anyone know of an appointments calender with a form and VBA coding. I dont need hourly appointments just by the days. Any suggestions? Inky Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Thanks to you all. Does anyone know if there is a comprehensive list anywhere, perhaps on the net? Inky Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!

Hi, Does anybody have the VBA coding for texting from an Access database. I already have the database up and running with emailing to a group from the data, and I would like to be able to do the same with texting to mobile phones. Is this possible? Inky Hampshire UK. A fool and his money are...

HI PHV, Can you tell me if when you used the coding that you pasted on 20th June, (see 2nd entry)if you had trouble getting this to work as in this application it seems that Between does not want to work when calling up two functions. Is that your experience or did it work for you? I have to get...

Hi Randy Thanks for your reply. Yes both variables are proved to have values. Seccondly I cannot use the # symbols because I am calling up functions. Ianky Hampshire UK. A fool and his money are soon parted - so you might as well send it to me!