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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rolandam

  1. rolandam

    Prevent Access from closing?

    You could try the following If you have a main form insert the following code: Option Compare DataBase Option Explicit Public bAllowClose as Boolean Private Sub Form_Unload(Cancel as Integer) Cancel = Not(bAllowClose) End Sub You would then include a button that the user has to use...
  2. rolandam

    Open Forms

    Is there a way to open a form using [highlight #FF99FF]Application.CurrentProject.ALLFORMS. [/highlight] If have a treeview menu where the user selects the form to open, I'am currently using the DoCmd.OpenForm, which works fine. I however want to set an object variable to the form from the...
  3. rolandam

    DLookup You Cancelled Previous Operation

    Private Sub Product_ID_AfterUpdate() On Error GoTo Err_Product_ID_AfterUpdate Dim strFilter As String ' Evaluate filter before it's passed to DLookup function. strFilter = "[Product_ID] = '" & Me!Product_ID & "'" ' Look up product's unit price and assign it to...

Part and Inventory Search

Back
Top