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!

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

Recent content by ericbjr2

  1. ericbjr2

    Auto zip code (didn't have zip code field at first)

    Well, I ended up paying $30 for a service that did it for me. I exported to an excel format, sent them the file, they added the zip codes and then I updated the database. I'm sure there is a free way to do it, but under time constraint I just paid for it.
  2. ericbjr2

    Auto zip code (didn't have zip code field at first)

    I created a table in which I should have placed a zip code field. I have about 5000 addresses that I would like to be able to query based on Zip codes. Is there a way to calculate the zip codes and populate the new zip code field automatically?
  3. ericbjr2

    Creating an XML file with specific header

    I have tried the Application.ExportXML method, but I don't know how to get the format to change. It always exports to the same format.
  4. ericbjr2

    Creating an XML file with specific header

    The ultimate goal is to show a map with addresses listed on it from addresses in my database. I have a query built to get the data into a readable format, but the problem is exporting to XML. How do I export the data to an XML file with specific headers <rss...blah blah blah> <channel>...
  5. ericbjr2

    Create outlook calendar item

    I get this error message when I try this... Compile error: User-defined type not defined and VBS highlights ", myEvent As AppointmentItem" I used: Private Sub SetAlarms_Click() Dim myOlApp As Object, myEvent As AppointmentItem Dim nsNameSpace As NameSpace, myFolderCalendar As...
  6. ericbjr2

    Create outlook calendar item

    I have a project tracking database, then I use outlook to schedule the orders in the tracking database I created. I was wondering if there is a way to create a calendar item using parameters already entered into the orders?

Part and Inventory Search

Back
Top