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 Rhinorhino 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 airon

  1. airon

    Word instance is not closing in MS Access VBA module

    Hooray I think I got something figured out, with and added bonus… A little more detail on the initial issue I was having. When I would execute this module it would execute without error. However, after execution is where the problem occurred, I would navigate to Outlook which would...
  2. airon

    Word instance is not closing in MS Access VBA module

    I have a module in MS Access, that sends an email using a word document as the body of the email. My issue is when the code runs the Word instance stays persistent even though I have closed it out. This is causing code and outlook to hang. My thinking is that possibly outlook is still...
  3. airon

    Searching for Current Date cases only

    I am trying to use the above date function in a search in remedy version 5.01.02, should this work in this version. I am getting the following error: Unknown field referenced in search line.: position 13 ('Create Time'^ >= $DATE$) (ARERR 1587)
  4. airon

    CreateObject in MS Access

    Does anyone know how I can open cmd.exe through VBA in MS Access. If anyone can help, I appreciate it. Aaron
  5. airon

    Class module & module in Excel

    Can anyone help me with better understanding the difference between a class module and a module in Excel VBA? Thanks in advance, Aaron
  6. airon

    Help with Sub Query PLEASE!

    Hmm, I think there are few glitches, because that is not seeming to work either :( thanks for the feedback.
  7. airon

    Help with Sub Query PLEASE!

    I am trying to create a query with four group by fields and then three derived fields. Derived fields: Filesize, HoldOver, CallableAccounts I need to create a query where CallableAccounts will execute for each row of data returned. In the current query layout, CallableAccounts returns the same...
  8. airon

    Disable Keyboard while using send keys

    Is it possible to disable the keyboard, while I am sending a send key command?
  9. airon

    Disabling Keyboard when using sendkeys?

    Is it possible to diable the computer keyboard for and instance when you are doing a send key command? Thanks in advance, Aaron
  10. airon

    Sending Lotus Notes through MS Access

    Does know how to send out Lotus Notes via MS Access. I am trying to set up a process that will send out Lotus Notes on Database failure. If anyone has any sample code, I would appreciate. Thanks in advance,
  11. airon

    creating .exe program to compact Access database

    I would like to create a program that will automatically compact a database. If anyone could provide an example or point me in the right direction, I would appreciate it. Thanks in advance.
  12. airon

    Phantom Excel Sheet

    I have had problems while exporting to MS Excel First I creat am MS Ecel instance, but when I kill it, it still stays as a phantom. Then the next time you try to open a document in MS Excel, it is not vissible. Any suggestions?
  13. airon

    How do I generate a DB in Visio 2000???

    Hello, I am trying to genereate a MS Acees DB from Visio 2000 ERD. I was told you can do this, but I can not figure out how. Can anyone help? Please & Thanks, Airon
  14. airon

    HLOOKUP & VLOOKUP

    Thanks for taking a minute and helping with my problem, it was very helpful. Airon
  15. airon

    HLOOKUP & VLOOKUP

    This is probably pretty simple, but I am having some trouble figurit out. I am trying to do some lookups in some Excel spreadsheets. Is there a way to use HLOOKUP in VBA, I can do it in the actual spreadsheet, but I am running in to problems when I try to do it in VBA. Aaron example...
See more

Part and Inventory Search

Back
Top