Recent content by pepegot1

Datasheet view Here is the code for the datasheet button. When the first button I click is the datsheet button, it works perfectly. the datasheet view is presented. However, if I then press another option button and the return to press the datasheet button, the Menu Form appears in front with...

datasheeyt view Hope this one flies?

Datasheet view ZIp files don't work. Attached is the error message:

Datasheet view First, Thanks a lot guys. I really appreciate your effort. I cannot attach the mdb file. Neglect this mesaage. It took off on me prematurely. Subsequent message will follow.

Datasheet view Rainman89 They do not let you upload mdb files. I can send code of the Menu form if that will help?

Datasheet view On trying to minimize the following error message appears: "You cannot switch to a different view at this time". Clicking OK and then the regular form view appears. We cannot fool the dam thing.

Datasheet view If I minimize or close the overlapping menu form I get the Datasheet view, but when I close it, it does not return to the calling form(the menu form)-it just exits the program completely. Something thay should as simple as the other option menu items is just plain recalcitrarnt

Datasheet view PopUp menu is set to "NO", but still the problem remains.

Datasheet view I entered the code and this is what occurs: Dataview opens, but with calling menu on top. I close calling menu and now can get at datasheet view form. When I close datasheet view form, the program ends. Why is the calling menu on top? I have another option that calls the same...

Delete confirmation I got the code from the search option and from a good soul. Here it is FYI: If MsgBox("Are you sure you want to delete the current record?", vbQuestion + vbYesNo, "Delete Record?") = vbYes Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdSelectRecord...

docmd.setwarnings true Unfortunately, it did not work. Amazing how poor those wizards are? There must be some code that relly works. Thanks away. I am stuck.

The prgram works well, except in one situation. When I delete a record, using the delete form, I do not get any confirmation. The record is deleted and the next record is displayed. This is not a good thing. How can I ensure delete confirmation? Here is the wizard button code: Looks like this...

Datasheet view Here is the code and it has what you suggested: Private Sub dvCommand38_Click() On Error GoTo Err_dvCommand38_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Datasheet" DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria...

Datasheet view In properties: default view:datasheet allow datasheet view This is what's in properties and still-no soap! I ditched the delete key and created a button, on the menu, form that open the datsheet view sucessfully. However, if I first open the menu form with...

Datasheet View I have allow datasheet view checked and allow form view uncheck in properties. I don't see what you mean?