Search results

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?

I created a form in datasheet view and it works as it should. However, when I call it from a Form Menu, it reverts to the form view. How can I make the datasheet view stick? I turned off "Allow form View', in the Datsheet form, but it does no good.

How can I sort string addresses so as to get the correct number order? I know that strings sort on each character, which causes the problem. I have tried some things (with VAL and Len), but was not completely successful. I do not want to enter an address number as 0630, when I want 630. Why...

I made a Menu using a frame and buttons and it works well except for one item: When I select a report, the "Report" Window stays behind the Menu and I cannot get at it. How can I make the report stay on top of the Menu, so I can use it??

Switchboard not working, addendum The Form wizard was not working, but after a time , I got it to work. However, the Switchboard does function. How can I get it back as it makes menus a simple task?

Fields do not empty Thank Yoooou!!!! It was just what I needed. There must be similiar code that will clear the input screen after data entry when Data Entry (Yes) fails to work? Something with a new record or so, but I don't know the code. Something like, Me.formname = Me.newrecord, or...