Viewable Wizard Code

[Jeff Conrad]

Hi Yoda!

I use OE for posting, and have it set up to mung my e-mail address, as
you can see if you look at the headers of this message. On the
properties of the news account (Tools -> Accounts...) you can set the
posting e-mail address and reply-address, which will apply to that news
account and not to your regular e-mail.

Ok, here goes my first test using OE from home.
Hopefully it has the *correct* e-mail address.

Side note: Can you set up a sig for e-mail and a different one for NG posts?
Just curious.

StrReverse is a built-in function in Access 2000 and later. If you're
using that code in Access 97, you can add this function to your module:

'----- start of code -----
Public Function StrReverse(ByVal Expression As String) As String

' Replacement for A2K StrReverse() function, for use when
' that function is not available.

Dim strReversed As String
Dim lngX As Long
Dim lngY As Long

strReversed = Expression

lngY = 1
For lngX = Len(Expression) To 1 Step -1
Mid$(strReversed, lngY) = Mid$(Expression, lngX, 1)
lngY = lngY + 1
Next lngX

StrReverse = strReversed

End Function
'----- end of code -----

Ahhh, I see.
Yes, for the moment I'm testing this on 97 since I cannot access my work
machines with various OS/Access installations. The function does compile and
work correctly now. I'm hoping to have one version of the Add-In work for
all last four versions of Access. I would prefer not to have different
Add-In versions for different Access versions.

I imported the new functions you provided into my Add-In database, made some
adjustments and have been testing for a while now. Everything *seems* to be
working just fine for now! Sweeeet! I will do further testing with 97 and
then move up to the next version. Something tells me though that I'll
probably run into another entry point problem, but we'll see.

Thanks again for all the help and code, this is really cool!

 

[Jeff Conrad]

Hi Yoda,

Just a quick update.
The office satellite modem connection came back on a little while ago (boss
must have gone in to do some work) so I was able to spend a little time
testing the Add-In under Access 2000.

Now keep in mind I only spent a few minutes testing, but the Add-In *seemed*
to work just fine under Access 2000!! Yee-haa! No errors or problems and
everything worked as expected this time around! Verrrrrry cool.

I still have much more tweaking/adjusting as well as lots of more testing
with 2000, 2002, and 2003, but I'm definitely moving forward now. I cannot
thank you, Sco, and Doug for the help enough. You'll have the first
completed copy if you want one, assuming I can actually get it to work
perfectly!

 

[Dirk Goldgar]

Ok, here goes my first test using OE from home.
Hopefully it has the *correct* e-mail address.

Looks okay to me -- at least it's the one I'm used to seeing in your
messages.

Side note: Can you set up a sig for e-mail and a different one for NG
posts? Just curious.

Tools -> Options..., Signatures tab, Advanced...

 

[Dirk Goldgar]

Now keep in mind I only spent a few minutes testing, but the Add-In
*seemed* to work just fine under Access 2000!! Yee-haa! No errors or
problems and everything worked as expected this time around!
Verrrrrry cool.
Congratulations!

I still have much more tweaking/adjusting as well as lots of more
testing with 2000, 2002, and 2003, but I'm definitely moving forward
now. I cannot thank you, Sco, and Doug for the help enough. You'll
have the first completed copy if you want one, assuming I can
actually get it to work perfectly!

Gee, that sounds great! Uhh ... so what does this add-in do, anyway?

 

[Jeff Conrad]

Hi Yoda,

Looks okay to me -- at least it's the one I'm used to seeing in your messages.

Cool.


Tools -> Options..., Signatures tab, Advanced...

Got it, works perfect!
Thanks again.

 

[Jeff Conrad]

I still have much more tweaking/adjusting as well as lots of more

Gee, that sounds great! Uhh ... so what does this add-in do, anyway?

With your experience level it is something you will most likely never use,
but I'm pretty proud of it.
You'll see when it is finished.

 

[M.L. Sco Scofield]

Darn.
Does this imply the entry points for 97 WERE published
somewhere?? If they were, do you know where?

Never "officially." Just by Ken Get, et.al. in the ADH.

A couple of them love to document the undocumented.

Sco

 

[M.L. Sco Scofield]

Jeff,

I've seen all of your exchanges with Dirk. Did not have anything to add, so
I stayed out

As Dirk said, "Congratulations!"

And as Dirk asked, "Uhh ... so what does this add-in do, anyway?"

BTW, I'm not sure your tag, "Access Junkie" is really appropriate. Me thinks
yoz is a beyond hope addict.

Sco

 

[Jeff Conrad]

Hi Sco,

I've seen all of your exchanges with Dirk. Did not have anything to add, so I stayed out

No problem. I don't ever *expect* anything, just glad for whatever help anyone can offer.

As Dirk said, "Congratulations!"

Thanks, need to keep testing though.

And as Dirk asked, "Uhh ... so what does this add-in do, anyway?"

Patience, my young friend, patience.
<g>
Need to finish it first.
As noted before this is something you will never use for sure.

BTW, I'm not sure your tag, "Access Junkie" is really appropriate. Me thinks
yoz is a beyond hope addict.

ROFL!!!


And this coming from the guy who plays with Access, makes databases, and teaches classes on the
subject as well!!
;-)

 

[Jeff Conrad]

Hi Sco,

Never "officially." Just by Ken Get, et.al. in the ADH.

A couple of them love to document the undocumented.

Yep, those guys are the REAL Access Junkies of the world!

 

[M.L. Sco Scofield]

Inline...

Sco

----- Original Message -----
From: "Jeff Conrad" <[email protected]>
Newsgroups: microsoft.public.access
Sent: Monday, June 28, 2004 13:35
Subject: Re: Viewable Wizard Code

Hi Sco,
so I stayed out

No problem. I don't ever *expect* anything, just glad for whatever help anyone can offer.


Thanks, need to keep testing though.

Testing is good!

Patience, my young friend, patience.
<g>

*Young* friend? You obviously haven't been to my web site.

Need to finish it first.

Finished is good!

As noted before this is something you will never use for sure.

Never use? How can you say that? You never know. Besides, I teach bunches of
beginners. Maybe it's something that I might want to recommend to them?

ROFL!!!


And this coming from the guy who plays with Access, makes databases, and teaches classes on the
subject as well!!
;-)

*Plays* with Access? What makes you say that? Access is *serious* stuff!

 

[Jeff Conrad]

Hi Sco,

Testing is good!

Lots more of that to do, but hopefully I'll be finished soon.

*Young* friend? You obviously haven't been to my web site.

Sure, I've been to your site.
You're young enough to be my son Sco!

Never use? How can you say that? You never know. Besides, I teach bunches of
beginners. Maybe it's something that I might want to recommend to them?

Ok, I should probably never say never.
Yes, it is for beginners so they could find it useful I'm sure.

*Plays* with Access? What makes you say that? Access is *serious* stuff!
<VBG>

Yes, I have so much fun with it (and occasional aggravation) that I forget
it is serious stuff. For some it is their livelihood. No disrespect
intended.

 

[M.L. Sco Scofield]

Inline...

Sco

Hi Sco,


Lots more of that to do, but hopefully I'll be finished soon.


Sure, I've been to your site.
You're young enough to be my son Sco!

That's hard to believe. I didn't think people lived that long. ;-) My
picture is deceiving. I've aged well!

bunches

Ok, I should probably never say never.
Yes, it is for beginners so they could find it useful I'm sure.

See! I'm going to have to look at it. My students are at all levels, And
if it's that great, I might have to do a mini-presentation at our user
group!

 

[Jeff Conrad]

Hi Sco,

That's hard to believe. I didn't think people lived that long. ;-) My
picture is deceiving. I've aged well!

Humm.....maybe I had that backwards.

See! I'm going to have to look at it. My students are at all levels, And
if it's that great, I might have to do a mini-presentation at our user group!

Oh great, now I HAVE to finish it!!
I'll let you know when it is complete.

No disrespect taken. Did you miss the <VBG>? That's all I do is play! The
business is purely a side effect.

True, very true.
My comment was more for anyone that may have taken it the wrong way.

Have a good day,

 

[Douglas J. Steele]

That's hard to believe. I didn't think people lived that long. ;-) My
picture is deceiving. I've aged well!

In whose opinion? <g, d & r>

 

[M.L. Sco Scofield]

Douglas, you better be a runnin'!

Sco

In whose opinion? <g, d & r>

 

[Fred Boer]

How'd I miss this thread?! You are creating an add-in, Jeff? Well, if you
are looking for a beginner to test it, I'm your man! Good grief! An
add-in... I'm not even sure I know how to *use* an add-in without doing some
research... ! <g>

You are making me nervous, Jeff... veeerrrryyy nervous.... You'll be
snatching that pebble soon...


Fred

 

[Fred Boer]

Hey, is this what you were counting down to a few months ago?

Fred

 

[Jeff Conrad]

Hi Fred,

How'd I miss this thread?!

Not sure, did you fall asleep at your desk again?

You are creating an add-in, Jeff?

Let's be clear: **working** on one, not sure if everything will work quite
right yet.

Well, if you are looking for a beginner to test it, I'm your man!

That's very kind, I'll let you know when and "if" it is finished.

Good grief! An add-in... I'm not even sure I know how to *use* an
add-in without doing some research... ! <g>
You are making me nervous, Jeff... veeerrrryyy nervous.... You'll be
snatching that pebble soon...

???
"Snatching that pebble..."??
I must have lost something there in the Canadian translation.
;-)

Is that the pebble that causes the whole avalanche to fall on me?
<vbg>

 

[Jeff Conrad]

Hey, is this what you were counting down to a few months ago?

Mayyyyyyybe.


(Note to self: make sure everything works *before* counting down.)