Recent content by RickSpr

This would have been better posted in another forum such as Microsoft Office, rather than an Access forum. Try replacing the clipboard contents with something from the target worksheet before you close the source. Rick Sprague Want the best answers? See faq181-2886 To write a program from...

Are any controls on your form bound to OLE object fields? (Check the field definitions for 'OLE object' in the underlying tables.) If so, the OLE server may not be installed or registered on your machine, or you may perhaps have a different and incompatible OLE server registered for the type of...

There is not necessarily "a" back end. The front end database can link tables from multiple back ends in any combination. So you have to think of it as a back end with respect to a given table. The technique I use is to access the table's TableDef object (DAO) and then get the Connect property...

The value of a list box control is the value of the selected row. If no row is selected, the list box's Value property returns Null. Select an item in the list box and see if the text box becomes evaluated. If it does, the above statement is the key to your solution. You just need to figure out...

VBA is used in each of the Office programs, as well as in other products by both Microsoft and some ISV's (Independent Software Vendors). The version of VBA in Access (2000 or later) is exactly the same as in Excel, Word, etc. What's different is the "host application object model". The VBA...

GabberGod, I'm sorry, I was writing my post as you replied to PHV's, so I didn't have the information that you didn't know how to do it. You seemed to be familiar with writing code in your earlier posts. I see PHV is actively tracking this, so I'll leave you in his or her capable hands. Rick...

...not complex enough to need it." - But really, how much effort does it take to step through a few lines of code??? When you have experience and skill with some form of programming, and you hit a conflict between code which seems like it couldn't possibly be wrong and an error which is...

You can set the Last Accessed time using the SetFileTime API function. However, this is not trivial, because the API function requires a handle to a file (HFILE), so you'll have to open the file with an API call before you can get or change the time. If you decide to go ahead with this, you'll...

The error dialog box is being displayed by the MsgBox function preceding the Resume statement. Ctrl-Break when the message box is being displayed simply halts execution at the next statement. The error message is not about the Resume statement, though: It's about an error that is being trapped...

If you execute an action query with DAO Database.Execute or QueryDef.Execute, the DAO object's RecordsAffected property will give you the number. Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

1. Create a global (module-level) variable called, say, datLastActivity. At key points in your application (enough so that any user activity will definitely send you through at least one of them), set the variable to Now(). Create a blank form and set its TimerInterval to, say, 60000=1 minute...

Expanded? Sounds like it exploded!:-) This isn't scope creep, it's an all-out scope onslaught! Good luck! Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

There's a much easier way even than using FSO. See the VBA Name statement. People often forget that it can change the folder as well as the file name. Name string-expression1 As string-expression2 Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first...

Case #1 does, indeed, load all the data and then filter it for display. Case #2 only loads the data matching the criteria. Case #2 is more efficient, especially if your tables are across a network. Rick Sprague Want the best answers? See faq181-2886 To write a program from scratch, first...

This formula came from the help topic "Derived Math Functions" in Access 2000. All I did was wrap it in a function declaration. Public Function Arccos(X as Double) As Double Arccos = Atn(-X / Sqr(-X * X + 1)) + 2 * Atn(1) End Function Rick Sprague Want the best answers? See faq181-2886 To...