Search results

Sorry David I should of said (doh!) this event is in the Not In List ! sorry !

Hi all another problem which seem to be taking hours for me to work out !! I have a combo box Called 'Name' and another called 'details'. A value must be entered in one of them but not always both of them - which is where my problem is... If I enter a value in cboName and it is not in the...

Many thanks Bob and John - I think I was having 'Database Overload' as I came back to it this morning saw your post and John's and everything was clear again !! I must stop over commplicating things is my new mantra for this week !! Thanks again guys

I think I will leave this one for now John as it is becoming very confusing to me quiet simply as I don't understand whats is going on with this DB. I am going to 'stand back' from it for a while as it is giving me brain damage !! Thanks for your patience tho ;)

sorry about the repoort confusion - I don't make things easy !! The report mentioned was really for me to highlight the fact that the values entered were not going into the table and the report was based on the table contents. as to setting the Control Source to DetailsID in the table New I...

Thanks John but I think I may not be explaining myself well (as usual sorry) for clarification I will try to explain in detail with an example.. I have 1 table called 'Details' with DetailsID (Pk) Names (Text) I have 1 table called 'New' with NewID (PK) Reason (Text) Other (Text) DetailsID...

Thanks for the replies I have just checked the form and the control is unbound? I have selected the dropdown from control source and run the report but it is giving me a number 1 in field of the report. Im assuming it is a query I need but what one? Many thanks guys

I am sure I am missing something very simple here but for the life of me can't seem to think what is is !! this is just a basic example here for simmplicity! I have a two tables Tbl1 NameID (PK) FirstName LastName & Tbl2 EventTypeID (PK) Date NameID NameID is related on a 1 to many...

I am actually smiling !! thanks John sometimes the most simplist soultions are the ones we forget !!:D

thanks for the replies guys. John, unfortunately It needs to be in the lostfocus (or I am assuming it does?)as it is code that follows on from the previous field. As Below Private Sub cboProductionEmployerName_AfterUpdate() 'Check to see if a value has been entered into the field If...

thanks again John

07 format copy attached. thanks for your time on this :)

thanks again John, I can certainly post a copy but it is in 07 format and I am not sure how or if I can convert it backwards?

Thanks for the reply John but sadly it didn't work - revised code shown below Private Sub cboProductonEventTitle_LostFocus() Dim Response As Integer Dim Cancel As Integer If IsNull(Me.cboProductonEventTitle) = True Then Response = MsgBox("As you do not have a Production or Employer Name...

hi guys, well after hours of searching I really cannot figure out why my form is not closing using docmd. I have form1 which you select a name from this enables an option group where you choose the form type, click a command button and form2 opens. all the fields on form2 are disabled except...

sorry may of been the way I replied but it is a 'stand alone' normal form thanks

thanks for the reply The form control name is spelt correctly and is open. there are events on the Sub form as follows Private Sub Form_Current() 'Checks to see if a new record has been selected and looks up new number If Me.NewRecord = True Then lngTrNum = DLookup("NextTreatmentNumber"...

would someone mind having a look at the following code please - I can't work out why the form does not close on the doCmd bit at the bottom. If IsNull(Me.cboProductionEmployerName) Then vbResponse = MsgBox("You have not enterted a Production or Employer Name." & vbCrLf & vbCrLf & _ "Do you...

wow thnks for such a fast reply ! I was thinking along those lines just wasn't sure Many thanks again

Hi Guys, could someone please guide me on how to do this please as I am confusing myself !! I have 2 combo boxes CBO1 CBO2 A user must select a value in at least 1 of the boxes. e.g if they do not select a value in CBO1 then they must select a value in CBO2 (or visa versa) Once they have...