Access Viewer

[Jeff Conrad]

Hi Jan,

Yes, I have heard of this, and thought about that too, but, with ME, I have
not had much luck with some of the newer add-ins, either installing
properly, or working properly. I'll to attenting the 2nd annual PowerPoint
Live Conference being held in San Diego in Oct this year, and I'll be able
to meet up again with my PPT MVP buddies Steve Rindsberg, Brian Rielly, and
a few of the other top PPT graphics and media MVP's who will be hosting the
various siminars there, as well as John Langhans, MS PowerPoint
Supportability Program Manager, and Richard Brettschneider, Lead Program
Manager for PowerPoint, who will also be attending again this year. Sooo...
I'll make this one of my primary investigation projects while there. ;=))

Sounds like the perfect place to bounce some ideas around.
If you happen to come across some good ideas, pass them along.
I'm in the same boat about wanting to 'show' people a database
program who do not have Access. I don't really have the money for
the Developer's Edition.

LOL!! W'll hey....the Gold Star calendar on the wall over my 'puter is
totally dedicated to that! ;=))

Excellent, well done!

 

[Jeff Conrad]

Hi TC,

I'd never heard of camcorder!

I'm sure you're not alone.
I stumbled across it by accident a long time ago.

I just tried it out on win 98, & it worked fine. About 20 seconds
recording gave a 10Mb AVI file (gak!), but a 300Kb stand-alone EXE
file! So the EXE option seems the way to go. (And, the AVI file did
not play back correctly with Windows Media Player v9.)

Yep, the AVI files were huge, but the EXE compressed files were all between 300-500K
Very reasonable size.
I placed them all in a 'Help' folder and launched them from my form.
Worked really nice.

It seems to use some VXD's, so that is why it would only work on win
9x. MS must have decided not to rewrite those for win 2k+.

You could be right about that.

I guess the "win 9x only" restriction will kill it eventually. But it
has certainly prompted me to think of looking at similar products for
creating tutorials and help information.

Incidentally, out of curiosity I ran my old Help EXE files I created from
Camcorder on a Windows XP system to see if they would play.
They played just fine with no problems at all!

I'm sure there are very similar products out there and probably more powerful as well.
Microsoft may sell something themselves, I just haven't really looked around.

 

[Fred Boer]

Oh no, she's not!

Fred Boer

You might be the only one who understands what that is.
;-)

--
Jeff Conrad
Access Junkie
Bend, Oregon
*281 Days Left*

 

[Jeff Conrad]

Oh no, she's not!

Very good Fred!

Are you back? I thought you were still gone?
Strange coincidence, I was just working on your database a few minutes ago (serious).

So you never forget Fred:

1. Create a new blank database called Countdown

2. Copy/Paste the following code to a new standard module:

' Begin Code
Public Function funcCountdown()
On Error GoTo ErrorPoint

Dim strMessage As String
Dim TargetDate As Date

TargetDate = "05/19/2005"

strMessage = Chr$(83) & Chr$(116) & Chr$(97) & Chr$(114) & " " _
& Chr$(87) & Chr$(97) & Chr$(114) & Chr$(115)
strMessage = strMessage & " " & Chr$(45) & " "
strMessage = strMessage & Chr$(69) & Chr$(112) & Chr$(105) & Chr$(115) _
& Chr$(111) & Chr$(100) & Chr$(101) & " " _
& Chr$(73) & Chr$(73) & Chr$(73)
strMessage = strMessage & vbNewLine
strMessage = strMessage & Chr$(34) & Chr$(82) & Chr$(101) & Chr$(118) _
& Chr$(101) & Chr$(110) & Chr$(103) & Chr$(101) & " "
strMessage = strMessage & Chr$(111) & Chr$(102) & " " & Chr$(116) & Chr$(104) _
& Chr$(101) & " " & Chr$(83) & Chr$(105) & Chr$(116) & Chr$(104) & Chr$(34)
strMessage = strMessage & vbNewLine & vbNewLine
strMessage = strMessage & Chr$(79) & Chr$(112) & Chr$(101) & Chr$(110) _
& Chr$(105) & Chr$(110) & Chr$(103) & " - "
strMessage = strMessage & TargetDate
strMessage = strMessage & vbNewLine & vbNewLine
strMessage = strMessage & Chr$(68) & Chr$(97) & Chr$(121) & Chr$(115) _
& " " & Chr$(108) & Chr$(101) & Chr$(102) & Chr$(116) & Chr$(58) & " "
strMessage = strMessage & DateDiff("d", Now, TargetDate)

MsgBox strMessage, vbExclamation, "Mark Your Calendar!"

DoCmd.Quit

ExitPoint:
Exit Function

ErrorPoint:
MsgBox "The following error has occurred:" _
& vbNewLine & "Error Number: " & Err.Number _
& vbNewLine & "Error Description: " _
& Err.Description, vbExclamation, _
"Unexpected Error"
Resume ExitPoint

End Function
' Code End

3. Compile the code and save the module as modCountdown

4. Create a new macro with RunCode as the action and funcCountdown() as the Function Name.

5. Save the macro with the name AutoExec so it will run on Startup

6. Go to Tools--Startup and uncheck the Display Database Window option

7. Close the database and create a desktop shortcut icon and launch it any day you want to find out
how many days are left till the BIG day!!

;-)

 

[Fred Boer]

Hi Jeff!

Yes, we got back last night, and today I've been wringing out all the
sopping wet clothes and camping gear from the soaking they got in Cape
Breton!

I've never actually used macros, and I couldn't make your instructions work
(my fault I am sure!), but when I put the code behind a command button I got
the desired effect. So *that's* what you are talking about... I thought it
was the add-in, and you were just giving yourself a bit more realistic lead
time!! (g,d,r.... as fast as possible!)

Fred

P.S. Thanks for helping with my database... obviously no hurry. I'll be in
touch privately as soon as I get a bit more time...

 

[Jeff Conrad]

Yes, we got back last night, and today I've been wringing out all the
sopping wet clothes and camping gear from the soaking they got in Cape Breton!

Welcome back, glad you made it home safe.

I've never actually used macros, and I couldn't make your instructions work
(my fault I am sure!), but when I put the code behind a command button I got
the desired effect. So *that's* what you are talking about...

1. Create a new macro
2. In the Action column select RunCode from the list
3. In the bottom left corner of the screen a new line will appear that says "Function Name"
4. Just put funcCountdown () in that area
5. Save the macro with the name AutoExec
That's it.

Make sure you ask for that day off.

I thought it was the add-in, and you were just giving yourself a bit more realistic lead
time!! (g,d,r.... as fast as possible!)

Ohhhhh ouch that hurt!

Actually I started and finished creating another Add-In while I was on vacation last week!
Would you like to be the first one to try it out after I finish testing everything?

P.S. Thanks for helping with my database... obviously no hurry. I'll be in
touch privately as soon as I get a bit more time...

No problem, right now I just have more questions than answers on your database.

 

[Fred Boer]

Hey Jeff:

Make sure you ask for that day off.

What, isn't is going to be a national holiday??

Ohhhhh ouch that hurt!

Just a flesh wound, I trust!

Actually I started and finished creating another Add-In while I was on vacation last week!
Would you like to be the first one to try it out after I finish testing

everything?

Of course!

No problem, right now I just have more questions than answers on your

database.

Write me and I'll try to answer them... and if you're lucky, I won't send
you vacation pictures!

Fred

 

[Fred Boer]

P.S. Got the macro working... Earlier, I had put the name of the function in
the "Comment" column. Whooo boy... am I rusty!

Fred

 

[Jeff Conrad]

What, isn't is going to be a national holiday??

Should be in my opinion.

Just a flesh wound, I trust!

I'll survive.
;-)

Of course!

Cool.
I'm having fun making some Add-Ins for stuff that I have been using for quite a while.
The Doug Steele Object Documentor will create a slick report of all the objects in a database.
This new one is called the "John Viescas Table Documentor."
It creates a very nice report (and table) of all the fields in all the tables of the database.
It uses code found in his sample files.
I got tired of importing everything into my databases so I decided to make an Add-In.

This is so much simpler than the built-in Documentor.
For objects I just do Tools-->Add-Ins-->Doug Steele Object Documentor.
For table fields Tools-->Add-Ins-->John Viescas Table Documentor.
Bam!! All done in just a few seconds. Very nice and extremely easy.

I have a couple other ideas as well for other Add-Ins.

Write me and I'll try to answer them... and if you're lucky, I won't send
you vacation pictures!

Ok, it will be a while though.
I'm still trying to get caught up on work.

 

[Jeff Conrad]

Glad you got it fixed.
Add it to your Startup folder now.
<g>

 

[Jan Il]

Sounds interesting!

The ability to "automate" the various Office applications, is one of
Microsoft's primary achievements, from a software viewpoint, IMO. When I
started in computing maaaany years ago, there was no way that seperate
programs could communicate, except by flat-file import/export. Now, your
Access application can run the other Office applications automatically -
even "behind the scenes" (with no user interface) - to do whatever they need
to do.

Yes! And the best part is, most of the time it works well! Also,
Corel has now begun to format their Corel Draw Graphics Suite, Draw and
PhotoPaint, to also work with PowerPoint and Word as well as WordPerfect and
Presentations. Their new CDGS v12 has these capabilities, which makes it
really nice. I also use the CDGS, but only have v11. The new v12 does not
support ME, sooooo...for now I can't get the newer update. Boooo!

I plan on storing all the data for setup and filtering of the various
training information in the Access database, and use it to call up and run
the selected PowerPoint training projects. These will be used for
electrified or non-electrified commuter and/or Light Rail transit Wayside
equipment inspection and maintenance training at the 3 levels of job
classification advancement, Asst. Lineman, Lineman, and Electromechanic
(Journeyman electrician). As soon as I've completed the first training
project I'm going to test it out. It should

All good stuff!

Indeed! And fun stuff too! )


Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jan Il]

I'm sure there are very similar products out there and probably more powerful as well.
Microsoft may sell something themselves, I just haven't really looked

around.

If you hear of, or find anything of the sort, please post the information
for us if you would. I for one would appreciate it very much.

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Brendan Reynolds]

There's a list at the following URL. Not all of these record video, some of
them are just static screen capture apps, but there seem to be a few video
recording apps in there too ...

http://lan.tucows.com/scapt95_pop.html

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Jan Il]

Hi Jeff!

Hi Jan,
;=))

Sounds like the perfect place to bounce some ideas around.
If you happen to come across some good ideas, pass them along.
I'm in the same boat about wanting to 'show' people a database
program who do not have Access. I don't really have the money for
the Developer's Edition.

Absolutely! There is going to be a special siminar on graphics and just
such inter-action of various programs this year, and the two MS Managers are
very open and eager to help find better ways of doing things. If there is a
need for a better method of interaction between Access and PowerPoint, I
feel sure they will be willing to see what they can do. John Langhans is a
great supporter on the PowerPoint newsgroup now as well, and he has some
really great ideas. I'll be sure to pass on any information I get from that
end, and perhaps there might be some here on the Access end who would be
willing to put in a good word to MS as well. It would be a very powerful
combination for the growing needs of many companies, however, right now,
it's rather difficult to accomplish with some types of apps.

Excellent, well done!

Jeff Conrad
Access Junkie
Bend, Oregon
*280 Days Left*

Got your tickets ordered yet??? ;=))

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jan Il]

Oh no, she's not!

Hey Fred! Hope you had a great trip! Glad to kow I'm not alone....;=))

Got any good pics to share again this year?

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jan Il]

Should be in my opinion.



I'll survive.
;-)


Cool.
I'm having fun making some Add-Ins for stuff that I have been using for quite a while.
The Doug Steele Object Documentor will create a slick report of all the objects in a database.
This new one is called the "John Viescas Table Documentor."
It creates a very nice report (and table) of all the fields in all the tables of the database.
It uses code found in his sample files.
I got tired of importing everything into my databases so I decided to make an Add-In.

This is so much simpler than the built-in Documentor.
For objects I just do Tools-->Add-Ins-->Doug Steele Object Documentor.
For table fields Tools-->Add-Ins-->John Viescas Table Documentor.
Bam!! All done in just a few seconds. Very nice and extremely easy.

I have a couple other ideas as well for other Add-Ins.


Ok, it will be a while though.
I'm still trying to get caught up on work.

W'll hey, as long as you're passing around the add-in goodies, mind thowing
a few my way too? Can't let you guys get too far ahead of me, ya know.
;=)) BTW...I'm down to (or up to??) 1/2 hour on your Access MVP Match
Game. How far ahead of me is Arica now? <vbg>

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jeff Conrad]

Thanks for the great links Brendan!

--
Jeff Conrad
Access Junkie
Bend, Oregon
*279 Days Left*

 

[Jeff Conrad]

W'll hey, as long as you're passing around the add-in goodies, mind thowing
a few my way too? Can't let you guys get too far ahead of me, ya know.
;=)) BTW...I'm down to (or up to??) 1/2 hour on your Access MVP Match
Game. How far ahead of me is Arica now? <vbg>

Doug will actually be posting the "Doug Steele Object Documentor" on his website in the very near
future. Keep checking back there once in a while for that one.

I've completed testing the "John Viescas Table Documentor" for 97 and everything is fine. I still
need to test on the later Access versions before releasing that one. I should hopefully be finished
this weekend. I'll ask John to see if he would be willing to post that one on his site. I'll get
back to you on this.

On the Access MVP Name Matching Game I *think* my best time is around four minutes. I'd have to
check. Arica is not very good at that one, but she loves the color matching one!

 

[Jan Il]

Hi Brendan!

There's a list at the following URL. Not all of these record video, some of
them are just static screen capture apps, but there seem to be a few video
recording apps in there too ...

http://lan.tucows.com/scapt95_pop.html

Thank you very much for the information, Brendan. The Snagit program is one
that the PowerPoint MVP's speak very highly of, and I know many also use it,
as it works well with most programs and OS's.

Jan
Smiles are meant to be shared,
that's why they're so contagious.

 

[Jan Il]

Doug will actually be posting the "Doug Steele Object Documentor" on his website in the very near
future. Keep checking back there once in a while for that one.

Great! I'll check Doug's site then for this one.

I've completed testing the "John Viescas Table Documentor" for 97 and everything is fine. I still
need to test on the later Access versions before releasing that one. I should hopefully be finished
this weekend. I'll ask John to see if he would be willing to post that one on his site. I'll get
back to you on this.

'k...just five me a holler.

On the Access MVP Name Matching Game I *think* my best time is around four minutes. I'd have to
check. Arica is not very good at that one, but she loves the color

matching one!

Four minutes?? Heh....seems lately I have the attention span of a 2 y/o at
nap time. But......I'm slowly getting there with the color one too.

Jan
Smiles are meant to be shared,
that's why they're so contagious.