Search results for query: *

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...

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...

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)

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

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

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

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...

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

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

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,

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.

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?

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

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

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...

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...

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...

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...

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...

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...