Search results

Hi Burrcm, Thank for your reply I think i have done that ok, I have a button on page 1 that takes me to page2. its when on Page 2 that I want to add the onclick to an Option button in effect Option9 (max number of option allowd on page 1 is set to 8) Let me know if this doesnt make any sense...

:confused:Hi ..I have a swichboard that has gone on to 2 pages I am trying to add code to the OnClick event of an OptionButton on page2, problem is when I go to design view to add the code to the optionbutton as I did to a button on Page1 it will only show Page1 and I cant work out how to get to...

thanks for your help..cheers:) Fi

Hi Lagbolt, on the Login Form the authoriser must enter their password to open the authorisation form, this info is not stored, on the authorisation form I originally had a combo box where the the authoriser selected their nam this was stored and used on the reports, prob was that once into the...

Hi...I have come up with this solution (helped of course by a few strings on the forum)which seems to be working, on the authorisation form I have an unbound textbox with the following code Private Sub txtPIN_BeforeUpdate(Cancel As Integer) txtUserID.Value = DLookup("[Authoriser]"...

hi AngelsGuardian...thanks for your reply, I have created a table to store the info, would I need to make this the record source for frm_Login ?? so that it can be saved there ?? your registry suggestion sounds good but I indeed know Jack, the OnClose SQL string would you be able to give some...

Hi lagbolt..I am using the form, opened from the Login form if the correct password is entered, for an authoriser to check info which if they agree with it they can select the tickbox which will add their name to the form and the subsequent report ..giving authority for the users to carry out...

Hi..i am using this code to forcing users to enter their password which will allow them to open a form, which is working fine, I would like if possible by using a tick box on the opened form have their username stored for use on subsequent report, would anyone be able to give me some help /...

Hi Wazz...works a treat just had to insert the name of the from where the combo box is rather than frm_payee On post 4 and 5 it was just that you had put...Forms(frm_Payee)!Payee = NewData to make it work ? I changed it to this...Forms!frm_Payee!Payee = NewData Thank you so much for all your...

Hi wazz..the form with the combobox isnt refreshing until I close and re-open ? I tried adding refresh into the NotIn List code but this doesnt seem to work, could you help me once again ???cheers Fi

Hi wazz...just changed Forms(frm_Payee)!Payee = NewData to Forms!frm_Payee!Payee = NewData and it appears to be working, does that look correct to you?? cheers Fi

Hi wazz..many thanks for your reply, looks like i am still doing something wrong, here is my code and below th error message I get when frm_Payee opens Private Sub cboPayee_NotInList(NewData As String, Response As Integer) If MsgBox("The Payee you have entered is new and not in this list." &...

Hi I have looked though lots of threads and have pieced together the following in an attempt to open frm_Payee when the Payee is not in the combo list, it is working in a fashion but gives the message and opens the form but that is about as far as I can get...I am trying to have the message...

thanks for this solution I have just used it to set the number of digits to be entered in a field on a form to 5 and in conjuction with it checking for duplicates with the following Private Sub ChqRecNo_BeforeUpdate(Cancel As Integer) If DCount("ChqRecNo", "tbl_DataStore", "ChqRecNo = " &...

Hi ...what it was doing though was, if the number was a duplicate all other fields that had been entered prior to the ChqRecNo were being undone by I assume the me.undo statement...I added me.refresh to the OnLost Focus event of the fields that are populated before this one ...which seems to...

Hi Ken & Dennisk....just tried this and it seems to work....what do you think ?? thanks again Fi Private Sub ChqRecNo_BeforeUpdate(Cancel As Integer) If DCount("ChqRecNo", "tbl_DataStore", "ChqRecNo = " & [Forms]![frm_DataForm_ChqRec]![ChqRecNo]) Then MsgBox "That Cheque Rec Number...

Hi,,,my code now looks like this Private Sub ChqRecNo_BeforeUpdate(Cancel As Integer) If DCount("ChqRecNo", "tbl_DataStore", "ChqRecNo = " & [Forms]![frm_DataForm_ChqRec]![ChqRecNo]) Then MsgBox "That Cheque Rec Number already exists" [Forms]![frm_DataForm_ChqRec]![ChqRecNo] = ""...

Hi Dennisk...I have tried adding Cancel=true to the statement possible not correctly but am gettign the same error message in the same place ? cheers Fi

Hi ken ...I dont have anything in the ValidationRule property ! should I ?? sorry not great at this ..cheers Fi

Hi Ken Exact test in the BeforeUpdate Event of the ChqRecNo Test box on the form is.... Private Sub ChqRecNo_BeforeUpdate(Cancel As Integer) If DCount("ChqRecNo", "tbl_DataStore", "ChqRecNo = " & [Forms]![frm_DataForm_ChqRec]![ChqRecNo]) Then MsgBox "That Cheque Rec Number already...