Recent content by Raddy

Thanks James Don't be hard on yourself - you got me out of a hole How many hours have you spent over a problem which has baffled you then when you find it you could kick yourself really hard ( a missing apostrophe, or a line of code commented out that you didn't spot). I spent a lot of time...

Still get the same error If DCount("*", "TblPupils", "[Parent/Guardian ID] = " & Forms!FrmPupils!ParentGuardianID & " AND [Child_ID] = " &Forms!Frm.Pupils!ChildID & ") > 0 Then I must say, looking at the brackets and quotations it now makes sense (I am from an iSeries background). This one has...

Thanks again James I'll try that It currently reads If DCount("*", "TblPupils", "[Parent/Guardian ID] =" & Forms!FrmPupils!ParentGuardianID & " AND [Child_ID] =" &Forms!Frm.Pupils!ChildID & ")" << Compile error "Expected list seperator or )" >>

James Still getting a syntax is there any way to look at the actual string generated by the VB line?

James That looks a lot clearer - however I'm getting a syntax error Any ideas?

I am using a form (FrmPupils) to update a Pupils table. I am checking the table to prevent duplicate entries (ParentGuardianID and ChildID). I am checking using 2 fields, both are integers I am using Dcount I have tried and changed and chopped and looked everywhere and I have nowhere left to...

I am trying to achieve a handy list that tells me what each property does

Does anyone know where you can get a definitive list of properties and their functions relating to forms, reports and fields?

Thanks I can design database in my sleep, since that is my main skill. It is just implementing the user interface that is tricky. Most input will be cross-tab'ed to preserve integrity. It usually is when the users are setting up static (as opposed to transactional) data that the problems arise...

Thanks for that too missingling I am new to VBA - I need to go and lie down - and reread my books

JANR many thanks - it works! I added a "Cancel= "true" This keeps the cursor on the offending field. I guess I will have to code similar validation for all the fields? thanks again

I have a piece of code to validate that a client doesn't already exist on a table when the user wants to add. Private Sub ParentGuardianIDX_AfterUpdate() If DCount("*", "TblGuardian", "[ParentGuardianID] = ParentGuardianIDX") > 0 Then MsgBox "Guardian already exists on Guardian File!"...

Mstef Thanks You can see how green I am with all this Access/Vba stuff

MStef Thanks for that. I hop you will bear with me, but how do i exit this form to get your message "Are you sure you want to save this changes?" displayed. I think I am missing something Thanks

I have a control in my form that says Exit, to return to a calling menu form. I have a macro attached to this which states: "Close, ,prompt" If I have changed the data the control returns to the menu, and any changes I have made remain How can I set up some code so Exit means "exit - no update"?