Recent content by al0y0u

it was getting to it because it was in an ERRORHANDLER and since there was never technically an error thrown in the vba no need to goto so argh thanxs for advice ill check that out in help

VBA for microsoft office 2000 UNLEASHED has saved my hiney many times has some good examples and pretty much answers 90% of my questions.

yea ok but to do that simply wouldnt all the fields have to be contained in an array or is there a way ... hmmmmmmmmm also i havent been able to make a msg box appear for some reason. always frustrating when your this close to having something done and hung up on one issue lol

actually you might look at another thread i just replyed in that code might apply to you also its simple and fast it would have to be done in each form but wouldnt take but a minute per form Wrap your brain around this one is name of thread

the easiest way to do it would be to create a stored procedure that does the query and apply the result to the current form prob is I couldnt tell ya off top of my head how to do it with access LOL but i would try looking up stored procedures in help or a macro would prob work too hope that...

not totally quite sure what you are trying to achieve here. you want to keep track of participants events devices and you want to keep track of what devices are given to what participants at what events. am i correct so far? then you want to be able to retrieve data based on the device...

okie lemme see if i can explain this easy enough I have a simple cmdButton that opens a diff frm and closes the excisting frm. Not a problem so far now heres the problem when using the standard x in the corner to close a form you will be prompted if you have forgotten to fill in a required...