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!

  • Congratulations SkipVought 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. Girn13

    Database crashes on different computer

    Steve, Do the forms freeze if you run them without having any others open? I had an error closing form 2 but ONLY if I came from form 1. It didn't occur if I opened form 2 directly. Have you tried single stepping to see what instruction they're hanging on? Finally, I'd suggest re-building...
  2. Girn13

    Combo Box requery

    Griff, I'm guessing that the "Parts Used" is dependent on the "Item" selected. If that's true then your requery needs to be done when you select a new "Item" so the requery runs during the ON Click event of the "Item". The format is "Combo-box-name.requery".
  3. Girn13

    Database crashes on different computer

    Can you not open the db at all on the other machines or does it only freeze when you click on the unbound forms? You said you compiled on the other boxes. That suggests they have the "Full" version. Have you checked that all the references are there? I'm asking because I just recently...
  4. Girn13

    Linking forms when field contains "/"

    Here's two approachs I use, neither of which requires linking forms. If form2 ALWAYS opens from form1 then form2's record source can be hard coded to select the record that matches forms![form1]![yourcriteriacontrol]. If form2 can open from many places then leave the record source alone...
  5. Girn13

    Combo box won't change on form- Error!

    The way you describe it it sounds like the combo box is not being set by the new record on the way in but IS updating the record on the way out. Once you make a selection in the combo box it's updating every record after that. I wouldn't update the outgoing records with the combobox...
  6. Girn13

    Stop All Events Via A Button...

    Hi Roy, Look at these possibilities. Is the form bound to a table? That may be where the edits are coming from. You may have to unbind the form. Is the OnClose event for the form doing the editing? Bypass the edits if the "abort" button is clicked. The OnClick for the "abort" button nulls...
  7. Girn13

    Differences between 'runtime' and 'full' besides the obvious?

    Sorry for not getting back sooner. Thanks again for your interest in this issue. What angers me is that once we install the "Full" version on someone's box the problems disappear. I'm going to spend today re-creating one of the problem db's from scratch in XP and see if that alleviates the...
  8. Girn13

    If Then different form

    Is page8 Open? Here's some code I have used. DoCmd.OpenForm "Add Dependents" Forms![add dependents]!txtHiddenCategory = 3 Forms![add dependents]!cmbRelCde = "ch" Forms![add dependents]!lblInstr.Caption = "Enter new dependent's Information
  9. Girn13

    If Then different form

    Try this: If Med55 = "1" then forms![page8]!Med76.enabled=false. My syntax might be a little screwed up but that's it.
  10. Girn13

    Differences between 'runtime' and 'full' besides the obvious?

    Thanks for answering but I'm sorry about the bad news. We went from Office 97 under NT 4.0 SP-2 to Office 2002 SP-2 under Windows XP Professional SP-1. A question. Is there any way to determine, programmatically what version of a reference I'm using? I'm using MSCAL.OCX (version 10.0) but I...
  11. Girn13

    Differences between 'runtime' and 'full' besides the obvious?

    We recently converted from NT to XP and my dbs are exhibiting strange behaviors in the runtime version of access. Different applications on different machines and all references have been verified. 1. Runtime version ignores default printers while "full" version machines print to correct...

Part and Inventory Search

Back
Top