Recent content by jimbo08

Thanks, Ace Man! Your idea is a good one. You have not given me a complete solution, but a path to it. My users typically copy a string that may be one or two highlighted words in the source control, and then paste them to the end of existing text in the destination control. But -- since...

I have inherited a database that I recently converted from 97 to Access 2003. Several of the users have complained that they are unable to copy data from one field on a form, and paste the copied data to another field on a subform in that same form. When the user clicks 'paste", there is a few...

Thanks!

I am modifying someone else's code in an Access database. Can anyone explain the significance of the # in the following assignment: Const TIER_EE As Double = 1# Thanks

I have a text box in Access 2003 where users might sometimes enter "(c)" (lower case 'c' enclosed in parens). When they do, the three characters are immediately replaced by the Copyright symbol ©. I need to find a way to prevent this.

Thanks for your suggestion. It would seem to me that this would work, but it doesn't. However, (by accident) I found that if I call a message box early in my procedure, the hourglass returns. This must have something to do with making the calling form the active window again -- such things...

I have an Access form that takes user input, and then calls a procedure in a VB module. The procedure creates an instance of Excel, and then writes a considerable amount of data to it, taking several minutes. I change the mouse pointer to Hourglass just before I call the procedure, but the...

PH: Thank You! That worked great! Jimbo08

Is there any way to access the "description" property of an Access query through VBA? The "desciption" I am referring to is the one available by right-clicking on the query name in the database objects window.

Steve: Thanks for your help, but I am still not clear as to how to reference the foreign domain in the UNC. I am coding in VBA to create XLS files of Access data on a server in a domain other than the one I am logged into. So will I simply add domain to the beginning of the UNC? Such as -...

How could I modify the above path examples to access files on another domain in my company's network? Thanks, Jimbo

Please correct me if I'm wrong, but I think that both of these methods will return the term "Owner" instead of the username when used with Windows XP and the logged-in user happens to be the Owner of the machine. If anyone has a way to get around this, please advise. I've been hoping...