Search results

Hi Many thanks for the reply After thinking about the issue for a while I decided there ws a better way to go in this which did'nt need the code but thanks for posting it anyway as It will come in useful at some point I'm sure

hmmm I know what you mean - I think I need to look at this again to work out what I need it to do as it could be a case of spending hours trying to resolve somthing that can be done another easier way ! thanks again

hi thanks for the reply On the right lines I think but does not seem to want to work I suppose what I need in simplistic terms is for the value in cbo1 to be copied to cbo2 before cbo 1 hits the undo line if the value is equal then as soon as cbo1 is undo so is cbo2?

Hi guys could someone avise me how to do the following please? I have a cbo on a form (cbo 1) if the notinlist event is triggered a msgbox pops up asking if the spelling is correct if response is no it un-does the entry and drops the box down so they can select an item from the list. If the...

yep I am pretty positive the error is coming from that control which is set as Plain Text (just for information this error is happening on the same type of controls on other related forms as well but I'm thinking if I can sort this one out I can apply the "fix" to the rest). So to update If...

as below - thanks again Private Sub txtTreatmentDate_BeforeUpdate(Cancel As Integer) If (IsDate(txtTreatmentDate)) = False Then MsgBox "Please enter a valid date using numbers only.", vbInformation Cancel = True End If End Sub

Many thanks for the explanation but I must not be writing this correctly would you mind showing me an example of it in code please - thanks

Thanks David - I've never seen that before could you explain what you mean by try checking please? thanks

Hi Guys could someone advise me on this please. I keep getting the error message on some date / time controls even though I have code behind them to stop this... Const INPUTMASK_VIOLATION = 2279 Or 2113 Dim msg As String If DataErr = INPUTMASK_VIOLATION Then Select Case...

Ahhhh thanks Bob it now seems to be working although It wouldn't work on the NotInList event - I'm assuming it is because that event had completed as soon as the new form had opened so until I had entered some data in that form and saved it, there was nothing for the combo to be re-queried on...

thanks again Bob I have tried the requery option on various events of the subform but it does not work. I am assuming it wont work on the NotInlist event of the combo either as this is coded to open another form and the control that needs to be requeried is not on this form its on the Subform...

it is on the Subform and is a bound control

firstly many thanks again for the reply and information - which has actually helped me on another problem ! but with this one it won't work because of the way the other controls are formatted. So what I have now is an open form "consumables" with the subform "treatmentCoonsumablesSubForm". I...

hi Bob thanks for the reply I am using 2010 but the DB is 2007 and you so right I have forgot to add the response !! duh !! thanks again

Firstly apologies if this is posted in the wrong thread but I am not sure what area is right ! I have a form called 'Consumables' and within that a Subform called 'TreatmentConsumablesSubForm'. The purpose of this form is to record any consumables used in a specific treatment of a patient. On...

ahhh light bulb has just come on moment !! many thanks again

Thanks for the reply not sure that I understand this though - I cannot use the Got Focus event as the control I want to have the focus is not in the Tab squence so when I tab out of the first control it will automaically go to the third control - or am i confusing myself? Thanks

Hi Guys is it possible to change a controls 'Tab Stop' setting through code. 1.cboCode - Tab index 0 2.txtProd - Tab index 1 3.txtQty - Tab index 2 When the form opens a new record controls 1 & 3 are enabled and tab stop is set to yes, control 2 is locked and tabstop is set to No. If the...

once bitten - twice shy !!!:rolleyes:

oops Thanks john I feel a right plonker that was meant to be me selecting the record source instead I changed the caption !! Re the naming protocol these are all just test forms for now but I will make the changes once it is ready to go Many thanks again