Search results for query: *

You can also schedule it through Windows Task Scheduler using a bat file and a reference to the macro. If you have windows task scheduler it will be located under Start | Programs | Accessories | System Tools | Scheduled Tasks. I can post more info about this if you're interested.

Are you expecting that they be pressing the enter key after entering data in each field or after they have entered data in every field? I've found that many users are not accustomed to using the TAB key to move between fields. They end up pressing enter.

When you get past the ambiguous name error, you may also have a problem with rst!CompanyName. Whenever I have referenced the value in a particular field returned in a recordset, I have used the following syntax rst.Fields(0) The '(0)' is a zero-based index number where 0 would return the value...

See this article from Microsoft about the difference between Chr and ChrW: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctChr.asp It seems that ChrW is not dependent on code page settings and Chr is dependent on them.

antonyx and I are both trying to understand what you need to accomplish. Will there only be one company that will have active as 'yes' or will there be more than one?

Thanks!

I have encountered this as well. The solution was this: "Unlike files on a work-station which most likely used by one user, the server keeps track of open file and you cannot delete an open file on the server. You need server / network administrator right to close the open file before (using...

This is a link to a list of some Microsoft system colors... http://www.peterssoftware.com/sysclrs.htm

Default grey in Access is -2147483633. And yes, you do need to include the minus sign.

You must do this in the relationships window under Tools-->Relationships-->. You should have relationships already established, but if you do not, you will need to add the tables and create the relationships. When you do, the dialog will give you the option of enforcing referential integrity...

You also do not need to have single quotes around Me.Text52. You could write the DCount portion of your code as follows DCount("[COPProjectNo]", "tbStoredProjectNo", "[COPProjectInfo] = Me.Text52") You only need to enclose it in single quotes like that if you were inserting a variable there...

In tht case, I have a few questions: (1) Is the list that shows in the combo box right now a value list or does it come from a query? (2) When you say you need a null at the top of the list, which of the following do you mean? (a)the first row in the drop down will be blank and when it is...

Have a look at this... http://www22.brinkster.com/accessory/forms/007.shtml

Is the change you're making a one-time change where you just don't want the forms to show up while you're making the change, but want them to show up in the future when a user is closing the workbook? If this is the case, just comment out the line that opens the form and then remove the comment...

Are you setting any values in the user form with your code or is the form not being used anymore? If it is not being used, it would be better to remove the code that triggers the user form to open. If you do still need it to open and be closed, try this... Unload "frmTBP" before closing the...

You will need to reference the user form by name to close it.

This may not fix your current problem, but you also want to make sure that you release the Excel object when you're through with it. If you don't, it will definitely cause problems. You'll need to add this at the end of your code: Set oApp = Nothing

By design, the pop-up property of the switchboard is set to yes. The pop-up property is what is causing it to remain on top of all other windows. If you change the pop-up property of the seitchboard form to no, and open the message form with the pop-up property set to yes, the message form...

Just an idea... You may be having a problem with VBA references. On the Access 2003 machine, select Tools|References... from the menu in the VBA editor. You may notice that some of these are marked MISSING. Access 2003 uses Microsoft Access 11 Object Library where Access 2000 is using a...

Figured it out. Visio does not use file DSNs -- only User or System DSNs. These can be created through Control Panel --> Administrative Tools --> Data Sources (ODBC).