Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RickSpr

    How do i remove the clipboard warnings??

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

    MS Access Error Message

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

    Read location of BE?

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

    List Boxes Value is Null

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

    Position of Pop up forms

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

    section of code generates an error, HELP

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

    section of code generates an error, HELP

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

    Can you programmatically change LastAccessed date

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

    Object required - Resume Exit_cmdSubmit_Click

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

    Extract information from MsgBox

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

    Database question

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

    Update form field based on count of two grouped table fields?

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

    Move A File From One Directory To Another

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

    stLinkCriteria Vs "=Forms!formName!refName"

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

    arccosine function?

    ...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 write a program from scratch, first create the universe. -...
  16. RickSpr

    I need help using and having button inside an Option Group!

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

    Is it possible to edit a form with multiple tables in backend query?

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

    Unbound forms / Comboboxes not refreshing

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

    code that link a database impedes performance when a form is opened

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

    Problem with Dlookup function used in VBA DoCmd.RunSQL method

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

Part and Inventory Search

Back
Top