Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. leslie746

    Word MailMerge Datasource Relocated

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

    Word MailMerge Datasource changed

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

    MS Outlook - saving, renaming and sending message as attachment

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

    MailMerge from Access - Parameterised Query as Datasource

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

    Textbox Field Disappears in some but not all records.

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

    Textbox Field Disappears in some but not all records.

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

    File Browser for Outlook attachment on Access Form

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

    File Browser for Outlook attachment on Access Form

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

    File Browser for Outlook attachment on Access Form

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

    Number of working days between to dates

    Hi 8177, You might try the following thread: 181-416139. It works beautifully for me. Good Luck
  11. leslie746

    EDITING ACCESSRT.MSI - DIRECTORY CORRECT SYNTAX??? URGENT

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

    ACCESS RUNTIME - ORCA EDITOR

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

    Variable derived from Recordset not passing into SQL Statement

    Thank you very much to both of you, Ken and PHV. You have been very helpful and everything seem to be working. Best Regards.
  14. leslie746

    Variable derived from Recordset not passing into SQL Statement

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

    Variable derived from Recordset not passing into SQL Statement

    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()...
  16. leslie746

    ODBC over a WAN question

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

    Editing Access Runtime Accessrt.msi 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...
  18. leslie746

    ODBC over a WAN question

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

    ODBC over a WAN question

    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?
  20. leslie746

    ACCESS Runtime - ORCA Customisation

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

Part and Inventory Search

Back
Top