Search results

Thanks for the replies guys. Jdraw: I am trying to use VBA code to "virtually click" a button. This button however was created by the auto button wizard and thus uses macros not vba code so doesnt seem to have a vba _click event I can refer to. Mdlueck: That looks a workable solution but I...

Probably the wrong approach but to enable me to run some code before a button is clicked I want to be able to click a button via VBA code. Basically I used the auto button wizard to make an add record button. To ensure a shed loads of if checks and queries on the entered form data run I...

Ive had my hands full in the last few days and have not been working on my project. Getting back I find that there had been lots of advice left fro me. Thankyou for your help. Gina, sorry I got the wrong end of the stick. I still cant quite fathom what you are trying to explain to me but I...

An alternative solution might be to use an if statement in VBA to change the validation property? Is this possible? Google isnt helping

Thankyou, Ill keep my validation to the form and leave the table alone then. Sadly I cant limit the INC number to be an autonumber as this is generated from another system, they arent sequential as its every incident the company globally deal with. >>>>>ok>>>>>> Ive done some more...

Im struggling again so once more return for advice, Ive been trying a few random work arounds but im sure my basic approach is askew. I have a combobox that selects the reason for access [CBreason] when the slection is "Incident" I want the user to input an Incident Number in the[IncidentNo]...

Thankyou, that solved it. There seemed to be a hidden column (im guessing ID) so it was checking that instead, when I changed the column number to 1 it worked straight away. This wont be one I wont forget in a while....

As previous ill start with im still learning.. Ive gone through pages of internet searches but nothing pertinent seems to come up making me think its something small im missing out. I have a combobox [CBreason] that reads from a table to show me why someone is gaining access to the building...

Thanks Neutron Flux I am trying the code I think I understand what references what, however im getting and error in the last two lines.. I'm getting compile error: Method or data member not found Code... Me.SubForm.Form.Filter = strFilter Me.SubForm.Form.FilterOn = True Ive tried using...

Hi All, My first post on this forum. As most people start with..."ive been teaching myself Access and Ive got a few problems I cant solve"... I am creating a data base to handle access requests to a building. All has gone well so far and ive built tables, reports, forms and used queries...