I need quick programatic solution to the following problem.
I have created a large number of Word documents whereby the recipients contact details are taken from Contacts.mdb located at specific location.
Now, the database has been relocated to a different location and all old documents cannot...
I need quick programatic solution to the following problem.
I have created a large number of Word documents whereby the recipients contact details are taken from Contacts.mdb located at specific location.
Now, the database has been relocated to a different location and all old documents cannot...
Can anybody help?
I need to highlight (or create OnMouseClick event) Mail item in Inbox, save it as "filename.msg", zip it into "filename.zip" and send it out as attachment in a new ougoing e-mail. Can extra button be created in Toolbar for this purpose?
Early response would be most appreciated.
I have a following problem:
When I create Word document for printing labels, as soon as I point to the source Access database, and try to use the query which uses parameter, say Postcode, I am presented with Tables and some but not all Queries, namely, any parameterised queries are not shown...
Thank you for your rapid response.
Indeed, it was something wrong with the database. As usual, it was my silly typo error in the properties of some unrelated field which erroneously set the offending field to be not visible.
Best Regards.
Can anybody assist with this problem;
In Access 2002 I have a form with a number of textboxes.
Values of the fields derive from comparison of a number of pairs of dates, giving the DeltaDays for each pair.
There is one particular textbox which disappears completely from the form in 3 out 11...
Dear All,
Thank you very much for your kind assistance. You have made my day.
PHV - You helped me on number of previous occasions - special thanks.
RoyVidar - Point taken on choice of colours - thank you too!
Best Regards.
My thanks to both mp9 and RoyVidar.
On my form I have a textbox "Attachment" which gets filled with filename picked using the script below:
Private Sub cmdGetFile_Click()
Dim Attachment As String
Me.Attachment.Visible = True
Me.Attachment.SetFocus
Me.cmdGetFile.Visible = False...
I need to put a dialog box - File Browser (would it be Activex Control, if so, which one?) for picking the file to be attached to Outlook e-mail sent from Access form.
The Outlook part works OK and my script so far looks like this:
Private Sub btnEmail_Click()
On Error GoTo Err_btnEmail_Click...
Dear All,
I want to install the Access Runtime along with my application (say MyProg) using the directory tree:
Program Files\MyProg\Access_RT where "MyProg" is my application and "Access_RT" contains the Access runtime.
When I try to edit Accessrt.msi using Orca, I seem to be lost in Orca...
Dear All,
I want to install the Access Runtime along with my application (say MyProg) using the directory tree:
Program Files\MyProg\Access_RT where "MyProg" is my application and "Access_RT" contains the Access runtime.
When I try to edit Accessrt.msi using Orca, I seem to be lost in Orca...
Dear Ken,
Thank you very much for your unbelievably fast response.
It works, and if I can trouble you a bit more.
In the same script, there is a "WHERE" condition which I have hardcoded "West Sussex" because in the original query it was supposed to be a parameter "Select County" but for some...
Hi,
Can anybody help urgently, please?
In the script below the value of variable "strA" shows correctly in the Message Box, however, when I try to execute the SQL statement:
strSQL = "INSERT INTO [Material sent](Material, govt_id, [Date_Sent], sent) VALUES('Letter and Leaflet1', strA, Date()...
Dear LittleSmudge,
I have just had some "spark of inspiration":
Can't you create a tiny batch file which contains the line that authenticates the users to your Server (hosting MySQL) prior to accessing the database, e.g.:
net use \\1.2.3.4\MyShare$ /user:username password
....
and then the...
Dear All,
I want to install the Access Runtime along with my application (say MyProg) using the directory tree:
Program Files\MyProg\Access_RT where "MyProg" is my application and "Access_RT" contains the Access runtime.
When I try to edit Accessrt.msi using Orca, I seem to be lost in Orca...
I am a bit puzzled by what you are saying about connection string containing a string "Server".
If a MySQL ODBC Driver is used, then you should refer to "host" rather than "Server" in your connection string.
I have just tried to connect to my own MySQL situated somewhere else, by replacing...
Correct me if I am wrong. ODBC connection string contains reference to the host on which MySQL resides, why can't you point to it by means of its IP Address?
Dear All,
I want to install the Access Runtime along with my application (say MyProg) using the directory tree:
Program Files\MyProg\Access_RT where "MyProg" is my application and "Access_RT" contains the Access runtime.
When I try to edit Accessrt.msi using Orca, I seem to be lost in Orca...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.