Search results

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...

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

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!"...

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"?

I have a menu which opens forms in either "update" or "add" mode How can I protect specific fields in the form if "update" is selected?

I want to add a record through a form, but I have to check if the value already exists on the table. The value composed of a client number and account number. Now, I can run a query in VB and add the record if the query is unsuccessful i.e. no current records match the record I am trying to...

How can I enter a record in a form1 then navigate another form from within form1 form to add a records that are dependent on form1. I'm not sure if this is possible - should I just exit form1 then select the option to enter the servant form?

In a form enter a value in a field on a new record. I decide I don't want to add the record after all, so I blank the field and press enter. Access tells me I have entered an invalid value in the field. the only way to escape is to close Access Why, and how do I get around this as thre will be...

I have created a form but I have to scroll down to see the bottom 2 input fierlds. Is there a form parameter I have set up incorrectly?

I'm new to Access so I hope you'll all bear with me Is it possible to change the field lengths on input fields in Design View if the form was created using the wizard? If so, how?