Recent content by rr191

Just a simple correction. The rst.Movefirst line should be moved to before the While Not rst.EOF. Otherwise you would have an infinite loop. -- Rob

RightFax has an API that you might be able to use to send the fax directly to it. Also, there appears to be an option were you can send the fax to the RightFAX print queue, but I don't think this is what you want. Here's a link to their message board with some info...

I use a commercial product called PDF and Mail Library for MS-Access from ACGSoft (http://www.groupacg.com/). This may be cost effective if you only have one or two PCs it needs to run on.

I believe the stored procedures will show up once you relink to the SQL database. Do you have access to the SQL database?

Actually, I have new info. It appears that I don't have two processes running. Rather, Access closes, but the process never stops and is begged at 95% cpu usage. (is there anyway to change the thread title?) -- Rob

I checked my code and I'm not using anything like that. It's also appearing on more than one PC. And, to top it off, it appears irregularly. -- Rob

I have a very strange problem that I haven't been able to nail down. It seems that my ADP application somehow is spawning an additional msaccess.exe process that stays active even when the main application is closed. This second process is left running and consume up to 99% of the processor...

Just to close the loop on this one, here is the solution I came up with: I found bmp of a pushpin button in the up and down position on the web. I copied these to a form and set the on click property of the controls to turn the visible property of one to true and the other to false. You...

I would like to implement a pushpin button on an Access form. The button would have a different picture when not pressed and another when pressed. Does anyone have any code or add-in that can be used this way?

I have a form that opens slowly (7-15 seconds) because it retrieves records (over 5,000) from an SQL database and loads them into a grid control. To let the users know that this is normal, I created a form with one control on it -- the animation activex control. It "plays" a simpe AVI of...

Rob -- Perhaps I wasn't clear. Basically, this is what is happening in my code: ... Application.Echo False '(this keeps the form designer from displaying) Set tmpForm = CreateForm(, "frmMap") '(Create the form) Set ctl = CreateControl(tmpFormName, acCommandButton...

Add the following code to your database, preferably in your startup form. Application.SetOption "ShowWindowsInTaskBar", False -- Rob

I am using the CreateForm function to create a new form based on a template that has controls (buttons) with VB code behind them. Everytime the CreateForm function is called, it creates the form and opens the VB editor window and leaves it open. I've tried turning echo off, but it must not...

An alternative method for deploying Access MDB/ADP's that employees Access code is discussed at this internet link ==> http://www.databasejournal.com/features/msaccess/article.php/3286111 -- Rob

As an aside, the information I found was in a two book set. The titles are Access 2002 Enterprise Developer's Handbook (ISBN: 0-7821-4010-6) and Access 2002 Desktop Developer's Handbook (ISBN: 0-7821-4009-2). I have found the Desktop Handbook to be invaluable (I also own the 97 version) and...