June 2025

S M T W T F S
1234567
891011121314
15161718 192021
22232425262728
2930     

Style Credit

Expand Cut Tags

No cut tags
Friday, May 21st, 2004 09:28 am (UTC)
Macro's are horid. There is nothing a Macro can do that VB can't do infinitely better and easier!

I started out as a Macro programmer, but as soon as I got my head round a teeny bit of VB I threw them away and never looked back. It looks scary at first, but is actualy way easier once you realise what it does as you don't have to jump through as many hoops as you do with Macros.

I'd be very intressed to see how you are back-ending it to SQL server without using VB though. Most likely it's using linked tables, which could well be slaughtering your server performance. Could be on pass through queries though, which isn't as bad, but not as usable either.

More than happy to advise on Access and/or SQL server, I've been doing it so long it's almost a hobby now. to be fair though my SQL is pretty rusty as until about a month ago it'd been two years since I last worked on one. I also do occational freelance Access dev if you want some more involved work doing.

Reply

(will be screened)
(will be screened if not on Access List)
(will be screened if not on Access List)
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org