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 Mike Lewis 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: *

  • Users: tamtf
  • Order by date
  1. tamtf

    MS Access and XP

    I have users under XP 6a using a database in Access97, when they are working with some of the forms checking boxes or clicking on the pencil, they get kick out of Access. I have users under Windows NT 4.0 using the same database and they are not experiencing the same problem. Any ideas? How...
  2. tamtf

    XP and MS Access 97

    I have user under XP 6a using a database in Access97, when they are working with some of the forms checking boxes or clicking on the pencil they get kicked out of Access. I have user under Windows NT 4.0 using the same database and they are not experiencing the same problem. Any ideas? How can...
  3. tamtf

    Copying and Pasting Records

    Steps: 1. Create an append query to copy the record to your table. 2. create a delete query to remove the record. You can write a macro to run these two queries in the order mentioned above. The event "on click" of your button you reference the name of the macro.
  4. tamtf

    Extract part of string

    how can I extract from the string below the character between the first dash and the second? string= GP - 87415A - greene - r result= 87415A Is there a function available? Thank you for your help. tamtf
  5. tamtf

    Check if Outlook is already open

    The link below may help. I use it to close MS Outlook. (e.g. close.exe "Inbox*")http://www.jsiinc.com/SUBA/tip0400/rh0431.htm To use close: Close "Title Bar text" where Title Bar text is case sensitive and may end in a * (wildcard). Typing Close at a command prompt displays...
  6. tamtf

    Sending email with MS Access

    Thanks to both of you for your help. Doing some research I found the HTMLbody property(shown below) and now my code works fine. Jnicks thanks for the getfile function. :-D Tamtf vbody = getfile$(&quot;C:\temp\TestingFU.html&quot;) or vbody = &quot;<HTML><H2>My HTML page.</H2><BODY>My...
  7. tamtf

    Sending email with MS Access

    If I use a text file, do I have to send it as an attachment? I don't want to send out attachments to our customers. The vbody is now as shown below and I still keep getting a syntax error. Thanks, Tam vBody = <html><head><title>Untitled Document</title> <meta...
  8. tamtf

    Sending email with MS Access

    I am running the VBA code below from MS Access 97. We are trying to send to our customer an email with a html format in the body. When the body of this email is blank the code runs fine, but when I add the html code under Vbody it doesn't work. We are also trying to pull the Lease# from the form...
  9. tamtf

    Exact match using case-sensitive

    I have a table with ID's, some of which appear multiple times. Each instance of these ID's is spelled using a different combination of upper and lowercase. Access disregards each instance's case and thinks these ID's are duplicates. I need to create a relationship between two tables using the...
  10. tamtf

    Exact match using case-sensitive

    I have a table with ID's, some of which appear multiple times. Each instance of these ID's is spelled using a different combination of upper and lowercase. Access disregards each instance's case and thinks these ID's are duplicates. I need to create a relationship between two tables using the...

Part and Inventory Search

Back
Top