Comments | emma

emma_b79

HELP

Feb 19, 2009 12:22

I need help with microsoft access specifically programming vb in microsoft access ( Read more... )

Comments 9

syllopsium February 19 2009, 13:24:11 UTC

You're probably better using at least one stored procedure. If it's possible to parameterise it in VB, it'll be possible to parameterise it in a stored procedure. If it's not possible to parameterise it, stick each one in a stored procedure and call it from SQL/another stored procedure.

emma_b79 February 19 2009, 13:43:56 UTC

I have got append queries that do the job but I just dont want loads of them cluttering up the database ( ... )

syllopsium February 19 2009, 13:51:52 UTC

Yup - you definitely want a stored procedure. You'll be able to pass your parameters and reduce the amount of code. Your worst case scenario should be a main routine taking parameters and another script/stored procedure calling it :

sp_appendmystuff(bread,cheese,milk)
sp_appendmystuff(cat,dog,pig)
sp_appendmystuff(wood,brass,iron)

emma_b79 February 19 2009, 13:54:59 UTC

so how do i get the stored procedure?

(this is the first time I've actually used anything harder than queries and simple macros in access so I'm struggling)

Thread 9