Would like starting point

[iSeriesCodePoet]

Hello all, I am new to this particular forum.

I have an Access application that I wrote for keeping track of modifications for a software package we have here at work. It works great except that for every new version I spend an hour adding the new version to the program records. I would like to automate this. My problem is I don't know where to begin. I am looking either for a sample with reading in a loop, adding records, and reading records; or someone to help me get a start. I used to know VB descently, but that was a few years ago.

I would be greatly appreciative of anyone that could help me. Thanks! Mike Wills
IBM iSeries (AS/400) Programmer

 

[xlbo]

Think this is probably more suitable for one of the Access forums (there's at least 3 and they're all high volume)
Not trying to say get lost but no-one has replied and there are specialist access forums - you may get a better response there Rgds
~Geoff~

 

[smah]

As a starting point, you may want to record a macro of exactly what you need to do. Then, enter the VBA editor and modify what you've recorded.

 

[xlbo]

Can't record in Access - only excel has that functionality......why M$ why ???
Surely the most useful VBA feature and it's not present on any of their other apps...
go figure Rgds
~Geoff~

 

[smah]

That's too bad, I didn't realize this. I know you can record in Word & Excel, so I assumed (wrongly) that you could in Access. I wonder what the (MS) reasoning is why this is not available in Access & Outlook.

 

[xlbo]

Well - I actually thought you coouldn't in Word either but just had a look and you can - maybe it was just '95 that you couldn't. Funny what you miss when you assume something ;-)
cheers for that - I think my word VBA is suddenly gonna get a whole lot better Rgds
~Geoff~

 

[iSeriesCodePoet]

Okay.... thanks guys! I thought I would try this first, since it is VBA. Mike Wills
IBM iSeries (AS/400) Programmer