Search results

OH! I did use the following when closing Form1 DoCmd.Close Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria

OK - I Got It! Enter the following in Form2 - Open Event Private Sub Form_Open(Cancel As Integer) Me.TimerInterval = 1 End Sub Enter the following in Form2 - On Timer Event Private Sub Form_Timer() Me.TimerInterval = 0 DoCmd.DeleteObject acForm, "Form1" End Sub I just...

I developed an order system. At times up to four computers are involved with entering orders. The way I was able to overcome the problem of all four computers entering the same order number is as follows. Let’s assume 4 computers open the order form simultaneously. All four computers will...

Sorry about that the correct error is "Method or data member not found"

It's Possible you have not set up a control called AccessLevel. When using "Me." you are telling Access that a control or some method is located on/in your form named AccessLevel. You will get the errror msg "Method Or Date Method Not Found" if you do not have the above control located on the form

Try closing form1 first and then open form2 Private Sub Command0_Click() DoCmd.Close Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub:)

Try closing form1 and then open form2 Private Sub Command0_Click() DoCmd.Close Dim stDocName As String Dim stLinkCriteria As String stDocName = "Form2" DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub

Play a Sound Wave Dear Mr. Craig Dolphin Already tried your answer. It worked PEFECTLY! Thank a million and a half. Richard:cool:

HI EVERYBODY! I'm programming an audible cash register that will play sound files when the purchase is completed. EXAM: "Your Total Is Four Dollars And Thirty-Six Cents". I've completed the algorithm for computing which sound files will play; calling each sound file as needed for playback...

I forgot to mention... If the application is not hidden. Using AppActivate lngAppID will activate the application and set focus on the application. Sorry... Richard

The shell command can open an application and hide it. lngAppID = Shell(strApplication, vbHide) lngAppID is the numeric value that is returned that references the application that was opened. By keeping track of this value, the AppActivate command can activate the application using lngAppID...

Ok Ladies and Gentlemen The Shell function opens an executable program using… Private Function OpenPayroll() ‘Open the Payroll program strAppName = "MSACCESS.exe" strPath = "C:\My Files\Private\Payroll\" strAppType = "mdb" strFileName = "Payroll" & "." & strAppType strConCan = strAppName &...

DAO – Data Access Object(s) What are Data Access Object(s)? Data Access Objects are objects that allow access to data stored in a database (In this case Microsoft Access) Two objects used for accessing data in MS Access are 1. Database 2. Recordset. Before data can be read from or written...

Thank you, it worked! Dear Bob Larson May I introduce myself. My name is Richard A. Perez, Sr. I would like to thank you for your snippet of code regarding my Enter Key Behavior problem. I copied your code into my program exactly as you posted it. When I compiled the code, it gave me an...

Enter Key behavior Thank you for your assistance. The cycle property does in fact control TAB key behavior. However more precisely, what I am looking for is a way to control the ENTER key behavior. Thanks again! Have a very “Merry Christmas” Richard (Rapsr59)

Access 2000 In Access the Enter Key can be programmed to either go to the next record or go to the next field depending on the global setting. The setting, which can be changed, using Tools, Options, Keyboard Tab, and selecting “Move after enter” setting: - 1. Next Field or 2. Next record...