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 derfloh 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: airon
  • Order by date
  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...
  16. airon

    Running VBA Code sitting in another DB from current DB

    futher explanation: I have Reporting DB that sits on a network drive. In order to run this DB in efficient time conists of the following: In VBA Code: * compacting DB to local drive * once I have it on local drive I simply need to start the DB running. * The Db creates and deletes 250...
  17. airon

    Running VBA Code sitting in another DB from current DB

    I posted a topic about a week ago and thought I had my sollution and in part I did, but not total. I need to run code or call some code in another DB while sitting in my exsiting DB. I was advised to do this by refrencing the other DB. This I have done and it works, except it runs the VBA...
  18. airon

    How do you Run a Procedure from another DB? (HELP!)

    I am trying to set up a process where I will be able to open a DB and then run an exsisting module from with the DB I opened. Does anyone know how to do this? my example code: In the database I open I have a procedure called "test". This code attempts to run this procedure, but...
  19. airon

    MS ACCESS VBA Code (Instance of Excel.com sitting in sys tray)

    I am having problems with Excel.exe floating in my Sys Tray. How can I solve this. It seems like when I run the following code below, somtimes Excel.exe will close out in sys tray, and sometime it will not, causing to get multiple instances of Excel.exe which causes strange things. What is...
  20. airon

    Acces Dim Statment (Global VS Standard Dim)

    I have created a reporting DB. The DB generates reports via MS VBA code. there are several modules that are involved in running this DB. I Currently have one Module that holds all Global Declarations for common used variables in all modules. Question? Is diming Global Statemts memory...

Part and Inventory Search

Back
Top