Search results for query: *

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

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

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

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

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

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!

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 all, For reasons which are to long to explain I find that I have the need to create the equivalent to a query to filter and return records between two dates but using only VBA. Can anyone tell me the coding I need to do this. Inky Hampshire UK. A fool and his money are soon parted - so you...

Hi all, I dont think I am thick - but that is a leading question. I need to create a line graph in a report and the wizard does not seem to be that clear as to what I need to do. Does anybody know of a link or document that will spell out the procedure for me. I have looked on the Microsoft...

Hi all, I dont think I am thick - but that is a leading question. I need to create a line graph in a report and the wizard does not seem to be that clear as to what I need to do. Does anybody know of a link or document that will spell out the procedure for me. I have looked on the Microsoft...

Hello, I need to turn off the right-click access to the design of a form. I have been using the code: ChangeProperty "AllowBypassKey", DB_BOOLEAN, False to turn off other facilities is there one I can use for turning off the right click? Inky A fool and his money are soon parted - so you...

Hi, I am trying to open the database window using the shortcut keys. I know how to set up the Autokeys but can anyone tell me the code I need to open the database window. I have been trying the DoCmd.SelectObject class/member, can anyone tell me from here please. Inky A fool and his money are...

Hi, Am I able to interrupt a loop with a click from a button? Basically I have a basic alarm which I want to stop running from a button. Any idea how I do this? Inky A fool and his money are soon parted - so you might as well send it to me!

Hello, I want to be able to use two global variables in the criteria row of a select query e.g. Between DateBegin And DateEnd. Is this possible and if so what is the correct syntax? Hope you can help. Inky A fool and his money are soon parted - so you might as well send it to me!

Hello, I have to try to open an external file in Notepad from a button click in an Access form. What code do I need to do that? InkyRich A fool and his money are soon parted - so you might as well send it to me!

Hello, I am trying to restore a form that has been minimized previously, on the click of a button in another form. Minimize was straightforward but restoring the form back to its original size is proving difficult. I have tried the code DoCmd.Maximize "FormName" and DoCmd.Maximize acForm...

Hello, I need to create an alarm in an application. I don't really want to use the 'beep', what other sounds do I have that I can use? Are there any ready-made code that I can use also? Regards Inky A fool and his money are soon parted - so you might as well send it to me!

Hello, I am having trouble printing a report. My report is selected by a query and is under one page long and yet it always prints the second page with the header and footer. I have tried inserting a page break in the report but it does not make any difference. Any suggestion please? InkyRich A...

Hello all, I am tearing my hair out!! - and I dont have a lot now! I am trying simply to open a form either in Add or Read mode (in which case I want the last record entered) depending on a variable like OpenVar equalling 1 or -1 and whatever I try it always opens in Add mode. What am I doing...