Search results for query: *

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

Here's a short excerpt from the Access 2002 Enterprise Developer's Handbook that also lists some issues with using the runtime version of Access or the retail version of Access in runtime mode: 1. The database window is permanently hidden. (Because the database window is permanently hidden...

Here's what my shortcut looks like: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" P:\OFFADMIN\VacAppXP.ADP /runtime I found this information in "Access 2002 Enterprise Developer's Handbook" by Litwin, Getz and Gunderloy. I could not find it in any of the help...

I was able to eliminate the message by adding the /runtime parameter to the command in the shortcut that I have deployed on each user's desk. If I understand correctly, I now lose some error handling capabilities and now need to account for these errors in my code. Does anyone know if there...

Thanks for the help. I've added a button to the form and use it to close without saving the design changes. The only problem is that it seems to work sometimes and not other -- I get an error that the expression cannot be evaluated. I guess I must have a problem in my code somewhere. -- Rob

I have an Access 97 form that I add label controls to based on data from a query. I open the base form in design mode, use CreateControl() to add the labels and then display the resulting form. When the form is closed, I get a prompt to save changes to the form. How can I close the form and...