Search results for query: *

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

I don't think it's possible to make toggle buttons (or radio buttons or check boxes) transparent. But how about replacing them with transparent command buttons and letting the command buttons set the value of the option group directly, in their Click events? That's all the toggle buttons do...

Is your back end a Jet database? If so, it must have to do with how you joined it to the other tables. You may have an extra relationship in the query, for instance, and that can make the query non-updatable. Or, you might have multiple outer joins that conflict, where before you didn't...

First, when you say "one or more of the comboboxes has one or more fields go blank", are you talking about columns within a combo box being blank, or are you talking about whole rows going blank? I have seen situations (though not all that similar to this as far as I can tell) where it seems as...

Nothing in that code would slow it down (though I have to say, it wouldn't act very nicely if the dbName doesn't have a "\" in it). What about the number of records in the table? (Reread my earlier post.) Have you stepped through the code that opens the form, so that you know for sure the...

Once again, on looking more carefully, I see something I missed before. If ID_New is Null, you can't assign it to a Long variable (if you try, you get that message). I imagine you're getting the error on the statement ID_New = Me.ID_New.Value Try reorganizing your code so that you don't do...