Stupid Question TIme! Where do you put the VB coding in Access?

[ksouth]

I have visual basic coding that I need to help me get the info out of my queries. WHere do I put this code? Is this VB coding as hard as I am making it? Any help would be appreciated. And by the way this is the best,the best Access help site on the web!
Thanks

 

[dawnd3]

Haven't you heard, there is no such thing as a stupid question! Especially when they are the only questions I can answer. LOL Now, I am not sure what you are trying to do, so it depends a lot on that. If you are trying to get info out of queries, you may be able to do some of that without VBA. There are many "places" to put in the code, so please be a little more specific and I can give you a better idea about where to go. What are you trying to do with the query? Dawn

 

[andrewvanbeck]

It depends on what you are using your code for. If you are making custom functions that you can use to return values depending on the specified data, you just keep these in a module.
If you want to be able to move through your data one record at a time and perform calculations or checks on each record, use a form based on your table/query, then move through each record and perform your checks in the 'On Current' code.

HTH

Andrew.

 

[mymou]

ksouth


I would be careful about jumping in at the deep end.

Visual Basic is very powerful, but Access itself is also a powerful tool excluding the programming side. Programming is not as user friendly and is full of 'interesting' pitfalls.


Stew