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 bkrike 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: *

  • Users: mpmoore
  • Content: Threads
  • Order by date
  1. mpmoore

    Storing results of calculated fields

    I have several calculations on my form. I am looking for a way to store the results of a calculation in the underlying table. If the calculation formula is in the Control Source property, where do I put the real control source. Or can I do this? Thanks for any input.
  2. mpmoore

    Security Workgroup

    So, I have this security workgroup set up. Now I've decided my database has no need to be secure. How do I remove the security measures from my database altogether?
  3. mpmoore

    Replication problems

    I am trying to sychronize with my replicas and I am getting the error, "Could not update, currently locked." I have closed all the databases, could there be a problem with security? Any ideas would be helpful.
  4. mpmoore

    Help! I'm locked out.

    Somehow, I have setup security features that I can't get around. My database doesn't recognize my password. Is there any way around these security measures?
  5. mpmoore

    DLookup seems to be the way to go, but....

    OK Bear with me here, this could get hairy. I have a form, TheBigForm. On TheBigForm I have a control box called DealerName. This control is tied to the table DealerList. In the table, DealerList, there is a field, DealerGroup. TheBigForm needs to know what the DealerGroup is for each...
  6. mpmoore

    Help with DLOOKUP

    It's me again. Today's dilema concerns looking up data in another table and then acting on it depending on what the information is. This will sound familiar to some as it is based on an earlier question. (thread702-81848) [DealerName] is a field in the Lease_Table. [Automotive] is a field in...
  7. mpmoore

    Option info to report

    I am baffled. I have a form with several option groups such as: Option 1 1 Correct 2 Signature missing 3 Document missing I would like to print a report that displays a sentence which explains the selection from the option group. I have tried everything I know (granted, that's limited) to...
  8. mpmoore

    VBA can't find my form.

    If [Forms]![Dealer]![Checkbox] Then Me!BranchID = "R-3701" Else Me!BranchID = "R-3700" End If Upon entering the above code I get the following error. Microsoft Access can’t find the form ‘Dealer’… I have checked the spelling and the location. I haven’t received...
  9. mpmoore

    Where to put this darn IIf statement...

    I am trying to execute an immediate if based on a check box. I want certain fields to become invisible on my form if the box is not checked (true). Currently I have the code listed below in the "after update" control of the check box. When checked and exited, the box does nothing...
  10. mpmoore

    Option Group set up...Now what?

    I have several Option Groups set up in my form. The only problem is that I don't know how or where to define the values for the options. I have scoured several books to no avail. I realize this is a very basic question, but assistance would be greatly appreciated. Michael

Part and Inventory Search

Back
Top