Search results

Is there a way of finding out what objected called this update function (Form_BeforeUpdate(Cancel As Integer)). Like navigation button or a "save" button on the form. I have some validations that I want to run when the user saves but it must not run when the user trys to exit the form i.e...

not to worry I did it the messy way created a global variable then displayed the form and exitted the function then run the function again if the user logged in and if the variable is set then jump down the code to the label I declared.

Hi, I have an autoexec function which runs but I want it to pause and bring up a login form and if the login is successfully then continue with the rest of the autoexec. How can I make autoexec function wait for a response from a form before continuing?

Not to worry I got it working. Brillant util!!!!!

Hi, I'm trying to get this to work but before I run it I think I've confused myself but just double checking When you open the updated You have to browse three this. 1. The first browse is that the fe the user would normally use or is it the master. 2. Simply the BE and its location. 3. Is...

Yes that correct. Though you first reply was helpful as I can now change the column that needs to be group by. I just need to change the period using a radio button option group.

Thanks I'll give that a try. Does that cover grouping within a time frame i.e day/week/month/year or what ever you want a date field to be grouped by?

Hi, Is there anyway I can change my grouping on a specific field either by changing the field or changing the criteria eg a date field group by day/week/month/year I have to date fields that I would like to use. If I can do this with code what is the best event to use to trigger this. Or...

:D rofl - classic....... If you a VBA newbie as stated on your opening sentence then how do you know that your way is the right way? I confess I do not know everything in Access but these guys on this forum know what they talking about and have helped me and many others alike. Word of...

That looks really good unfortunately my companies IT security restricts me from runnning exe files from the net.

I want to run this function on a form when a user updates a record as well as when they input. So I thought if I make it a function in a module I can call it from my form and I may need it somewhere else.

If I use variant can i test to ensure its a date or a valid database id? dcb - cool you must be glad that summers coming up. Winter is Shyt here but the summers are really good. I have some family that stay in boxsburg actually they around the corner from east rand mall and some family in...

Whats sme? Sorry its been awhile since I've done vba coding. I've been using ORACLE PL/SQL for a while and just trying to remember syntax.

dcd where about in SA are you from? I'm in the UK but born and raised in sunny Durb's. Should I declare the variable type in the function.

thanks I'll change that but in this case the null seems to lie with DATA_FOR

Hi whats the difference between class and module. I've done loads of vba coding in Excel and recently access but I've never got my head around these two so I tend to put all my code into modules. Could someone explain it in laymans terms. Many Thanks

Hi, Any tips on how to make code fail gracefull and report back the error to the end use? I've done a bit of vba coding and would like to better my coding skills which I think one of my weaknesses is capturing errors and making it fail gracefully.

Hi, I want to check my values before they update a record. this is the private sub on the form Private Sub Form_BeforeUpdate(Cancel As Integer) 'On Error GoTo err_validations Dim l_check As Boolean l_check = validate_SO_record(Me.database_id, Me.data_for) 'If (l_che = False)...

This has now been resolved. The problem was that it was a Name confict. I had a textbox whose name was data_for and so it was causing the conflict.

Thanks no the name conflict (i.e Name column) is only in the demo. I did have a control that had a Name of data_for and another with bank_statement_date. I renamed both and it works perfectly. Thanks yet again. Rep points on their way.