Recent content by Artemis Hothmire

  1. A

    Updating Access Data with Internet Files

    your awesome spikepl!!
  2. A

    Updating Access Data with Internet Files

    Good morning, I am new to Microsoft Acces and am still earning my degree in Data Programming. I am currently updating a database I built, so that will be able to go to a certain webpage and download certain content with a built in Macro. Is that possible? how would I go about building that...
  3. A

    Character spacing in VBA

    Paul, I hate to ask this as it might seem like your doing my work, but how would I use this code with the fields that I already have. In other words, when its finished, what would the code look like. Sorry, I hate to be that guy, but I am still learning.....
  4. A

    Character spacing in VBA

    And yes, at the end of the day, the email should look like the attachment (Sorry, had to zip it to upload it). The greeting of the email is being called by a different piece of code. Its the messages body, the columns of data, that I need to structure.
  5. A

    Character spacing in VBA

    I am rather new to most of this, so no. I have yet to take a basic programing course through my university. I dont know about HTML script and am really just getting used to SQL/VBA
  6. A

    Character spacing in VBA

    sorry about the code tags guys and gals
  7. A

    Character spacing in VBA

    Below is what the message looks like using Windows XP: Feild 1: Feild 2: 123 456 In Windows 7, it looks like this: Feild 1: Feild 2: 123 456 The sacing is inaccurate. I would like to tab out the formatting in the "spacer" instead of giving it individual digit spacing. This way...
  8. A

    Character spacing in VBA

    Good afternoon, I am trying to figure out how to tab out data in VBA, to creat formatted messages through outlook. Instead of identifying the different fields with random number sapcing, i.e., 6, 7 or 10. Below is what I have for spacing in my code. Public Function GetF6IMRLDATA() Dim db As...
  9. A

    Using DateDiff function

    I was able to get it to work, thanks guys
  10. A

    Using DateDiff function

    DateDiff ( "d", [DATE UPDATED], [TODAYS DATE])
  11. A

    Using DateDiff function

    Good afternoon, I am trying to calculate the difference in dates between two fields. How do I find the difference in days between field one which contains the date 04/12/2011 and field two which contains the date 04/12/2013? I have tried to use the datediff function, but it keeps telling me it...
  12. A

    Creating a query that contains Unmatched data

    Good afternoon, I am trying to create a query that matches two other querys and finds records that are in the primary, but not the secondary query. I have tried to use the query wizard for this, but it will not work for me the way I want. If I have A,B,C,D in one query and only have A,B,D...
  13. A

    Insert Into Statement

    never mind...i found it...Thanks agian Michael!
  14. A

    Insert Into Statement

    I have created the following parameters for the form control: str = "SELECT * FROM qryAnnualMidYearBudgetReviewRepairableCOGTotalDeficits" Set rs = db.OpenRecordset(str) If rs.EOF = False Then Me.txtRepairCogTotalDefVal = rs![sumofTotalDeficit] ElseIf Me.txtRepairCogTotalDefVal = Null Then...
  15. A

    Insert Into Statement

    Micheal J Ryan, your a freaking lifesaver!!!! It was the damned null value. I couldn't understand it at first, but because there was a null value, I had to many commas. I have to figure out how to make that null value a 0 if nothing is going to appear. At least that way I have some data to put...
See more
Back
Top Bottom