Search results

thanks Barry, will give that a try...............

sorry for misunderstanding you Bob, the code that opens the form (from which i want to open the report from) is: Private Sub Command11_Click() On Error GoTo Err_Command11_Click ''OPENS THE FORM IN A NEW POPUP WINDOW DoCmd.OpenForm "reportform", acNormal, , , , acDialog...

Hi, I have a table called tab_main with all the mobile phone users details. I have form with contains a combobox that lists all the users names alphabetically. i would like to select a name from the list and only show the details of the individual selected as a report? ie his name, phone...

Private Sub Command11_Click() On Error GoTo Err_Command11_Click ''OPENS THE report IN A NEW POPUP WINDOW DoCmd.OpenForm "reportform", acWindowNormal, , , , acDialog Exit_Command11_Click: Exit Sub Err_Command11_Click: MsgBox Err.Description Resume Exit_Command11_Click...

the popup and modal are NO...... what shall i change the dialog to ?????????

Hi, KATCanDo, ive tried it that way too, but it still opens the report behind my button window.......... y is that??????????????? any1?

Hi, just a simple one........... ive got a button to open a report............. but the report opens behind the button window and to view the report fully i must close down the button window.......... how do i open the report above the button window?????????????????????????????? the code im...

??? any1 got an idea?

OK Gemma hun, im using the following code: Private Sub addrec_Click() On Error GoTo Err_addrec_Click DoCmd.GoToRecord , , acNewRec Dim blnValidation As Boolean Dim strValidate As String strValidate = "These item(s) were not filled out and are required:" & vbCrLf & vbCrLf If...

The validation message is set on the form, so it only shows when i click the 'x'. the add doesnt have an before update event (or am i missing sumat?) ive added the the validation code to the forms before update event. shall i insert my validation code into the ADD REC code?

do you get your validation error message in the before update event displaying, and then the record saves anyway? does this mean we have 2 problems then 1. saving incomplete records 2. the close form message the validation error message comes in the before update event of the form..... its...

What happens at the moment is that it adds an invalid record because your add button tries to do a gotonewrec, the current record will automatically try to save, and therefore it will fire the before update event. it saves straight away as I type in, whether i click on the add button or not...

cheers gemma, you gave me a better idea, as you know, Ive got an ADD button with the following code: Private Sub addrec_Click() On Error GoTo Err_addrec_Click DoCmd.GoToRecord , , acNewRec Exit_addrec_Click: Exit Sub Err_addrec_Click: MsgBox Err.Description Resume Exit_addrec_Click End Sub...

thanx Bob, any1 else with an idea?

Alright Bob? ive tried(with ur code) the following on the On Close event in form properties: Private Sub Form_Close() If Me.Dirty Then Me.Undo End If End Sub but im still getting the same error? am i doing sumat obviously wrong?

Hi folks, i have a form that allows me to save mobile phone details. The problem with this form is that if its incomplete and i click 'x' it shows me the validation message followed by an error message (which is attached with this thread)..... why is that? is there anyway i can exit the form...

gemma and colin thanks for info... its worked with 'Me.undo'.................. ur both stars! :D :D :D

sorry i cant not post the database as it has confidential information. im gonna try gemmas and colins ideas..............

gemma hun, im using the following code now: Private Sub Command25_Click() Dim intResponse As Integer intResponse = MsgBox("Are you sure you want to clear all entries?", vbYesNo, Change) If intResponse = 6 Then DoCmd.Undo End If End Sub but im getting an error message: Method or data member...

thanks gemma, 6 does the job! :) why fix sumat when it aint broke? im jokin im gona try ur way! cheers