Elimate message box when transitioning between forms...

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Access has a default message box that displays an "OK"
when closing one form and opening another. Does anyone
know how to stop this default message?
 
Scott,
Access has no code
involved because I have coded the whole application
myself in VB and I use my own message boxes for user
guidance.
Click to expand...

Now, I have a question ... Is this a Visual Basic application in which you
are using Automation to open and manipulate an Access database? If so, are
the forms you're opening and closing Access forms or VB forms?

Can you post your Visual Basic code?
 
Cheryl,

I am developing in the Access 2002 IDE and it has a VB
backbone while incorporating the Access code when you use
wizards or if you decide to learn the code the wizards
generate for you automatically.

The problem I have is Access likes to work with existing
data in its DB so its forms work with it accordingly. I
am designing a program that inputs data into the DB so it
can utilize the Access features later in other
applications. That is why I need to use my skills in VB
programming at this stage. Once the data is in there,
Access will be perfect for report generation and record
manipulation.

Here is the segment of code that generates that pop-up
window:

strFormName = "InitialIntake_2"
DoCmd.OpenForm strFormName, , , strLinkCriteria
strFormName = "InitialIntakeForm"
DoCmd.Close acForm, strFormName

Of course, the variables are declared in the Dim. It
appears the window is not generated by the close, but on
the open of the other form.

This pop-up window is the only thing in my program I am
not able to control.

Thanks for your help,
Scott
 
Scott said:
Cheryl,

I am developing in the Access 2002 IDE and it has a VB
backbone while incorporating the Access code when you use
wizards or if you decide to learn the code the wizards
generate for you automatically.

The problem I have is Access likes to work with existing
data in its DB so its forms work with it accordingly. I
am designing a program that inputs data into the DB so it
can utilize the Access features later in other
applications. That is why I need to use my skills in VB
programming at this stage. Once the data is in there,
Access will be perfect for report generation and record
manipulation.

Here is the segment of code that generates that pop-up
window:

strFormName = "InitialIntake_2"
DoCmd.OpenForm strFormName, , , strLinkCriteria
strFormName = "InitialIntakeForm"
DoCmd.Close acForm, strFormName

Of course, the variables are declared in the Dim. It
appears the window is not generated by the close, but on
the open of the other form.

This pop-up window is the only thing in my program I am
not able to control.
Click to expand...

Sounds a lot like an error handler that doesn't have an Exit Sub before it so it
is being executed even when there is no error to display.
 
Rick,

Thanks a million, buddy! That is precisely what it was. I
had an End If and figured it was the end of the procedure
so I didn't need an Exit Sub. Turns out I was wrong.

Thanks again,
Scott
 
Back
Top