A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access Viewer



 
 
Thread Tools Display Modes
  #21  
Old August 12th, 2004, 09:46 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default Access Viewer

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.

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


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


Excellent, well done!

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

"Jan Il" wrote in message ...
Hi Jeff! :-)

"Jeff Conrad" wrote in message
...
"Jan Il" wrote:

Hi Jan,

Just a suggestion from left field.
Do you or your office still have a copy of Office 97 Professional

Edition?
On that CD is a program called Microsoft Camcorder.
In essence it is a utility that "records" what you are doing on the

screen.
You press start to record and then stop to finish.
You can then compress and covert the .avi output file to an .exe file.
The file could still be pretty big if you record for a very long time,

but
burning it onto a CD should be no problem.
You could break up certain aspects of the project into smaller chunks.

I have a personal restaurant database I have been working on for a

couple
of years and for Version 1.0 ALL of my Help files were created with

this utility.
For example, to display posting an invoice I simply recorded an

example.
All of the Help topics were launched from a "Help Form." It worked
very well, but became too much maintenance as the project became MUCH

bigger.

Since these are .exe files, virtually any computer should be able to

open
the files whether or not they have any Access/Office version. I'm not

sure
if this utility came bundled with later Office versions.
I know you can also purchase programs like these as well.


Just a thought.


And it sounds like a very good idea one, too! But, neither I, or the
company, ever had Access 97, as we went from Word Perfect straight to

Office
2000. I still have ME at home, but, we have NT at work. I have heard of
similar programs that you probably are thinking of too. I'll check out

the
possiblities of some of them, as it might be worth it in presenting app.
excerpts on machines that don't have Access.


Sounds like Camcorder might not be an option based on Brendan's

observations.

I'm in Virginia at the moment, so I can't check my home machine right

now,
but, as you mention this, it seems to me I have seen something in

reference
to a 'Camcorder' in my trees somewhere on the hard drive and I just

never
paid attention to it. It may be someting that came with another program

I
have, or just a thingie to 'go with'. I'll check this out when I get

home.

Well you may find this to be a complete surprise, especially since you are

a "PowerPoint Junkie",
but have you looked at the Producer Add-In for Powerpoint 2002 and 2003? I

did a little research and
came across it. I've never heard of it, but it appears to do basically the

same thing as Camcorder
does (not positive though).

The 2003 Producer Add-In works with PowerPoint 2002 and 2003. I know you

have 2002, but the OS may
be a problem. It looks like it won't work on ME. The articles say "not

supported" so it may not
install at all or it will, but you would not receive any support for

problems. Not sure.

Here are some links to get you started:

http://www.microsoft.com/office/powe.../overview.mspx

http://www.microsoft.com/office/powe...fo/sysreq.mspx



http://www.microsoft.com/downloads/d...displaylang=en



http://office.microsoft.com/search/r...EC010331121033

(Watch out for any line wrapping)

I would definitely ask your PowerPoint MVP friends about it. Maybe someone

has a spot to download
the older 2002-only Add-In which might work on ME. Just a thought.



Thank you very much for the additional information. It would be nice if
they had continued to include such a function with their newer Office
versions, or at least an add-to maybe. Perhaps I can make a wish?? g


Well your wish may have already been granted.


Hopefully so...g

*281 Days Left*

And counting!! ;=)))





Jan

"Jan Il" wrote in message
...
Hi All - Access 2002 XP - Win ME

Is there an Viewer for Access like the one for Word? I need to show

a
sample
of an Access app. on a machine that does not have Access loaded.

If so, I would truly appreciate a reference or a link where I can
downloaded
it. I've been searching for one on the Internet for the past hour or

so,
but, haven't turned up any information for one yet. Just thought I'd

see
if
one was available before I went any further. :-)

Best regards.

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



  #22  
Old August 12th, 2004, 09:52 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default Access Viewer

"TC" wrote:

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.

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

"Jeff Conrad" wrote in message

...
Hi Brendan,

Humm...I may just have to test this out with different configurations for my own curiosity.
Thanks for the info.

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

"Brendan Reynolds" brenreyn at indigo dot ie wrote in message
...
Recording. I don't think it will work with ME, but it's been a while, I
could be wrong. And no, it was not included with any version later than 97.

--
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.


"Jeff Conrad" wrote in message
...
Hi Brendan,

Are you referring to the actual recording process or the 'playing' process

on later Windows
versions?
I know the utility could not record using an NT machine, but I could play

them on one.
I used 98 to record all the Help files.
Since Jan is still using ME, maybe by chance it works with that OS???

Just a thought.
Do you know if that came bundled with 2000, 2002, or 2003?

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

"Brendan Reynolds" brenreyn at indigo dot ie wrote in message
...
Unfortunately, Camcorder doesn't work with recent versions of Windows.

Some
problem with a missing video codec, whatever that means.

--
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.

"Jeff Conrad" wrote in message
...
Hi Jan,

Just a suggestion from left field.
Do you or your office still have a copy of Office 97 Professional

Edition?
On that CD is a program called Microsoft Camcorder.
In essence it is a utility that "records" what you are doing on the

screen.
You press start to record and then stop to finish.
You can then compress and covert the .avi output file to an .exe file.
The file could still be pretty big if you record for a very long time,

but
burning it onto a CD
should be no problem.
You could break up certain aspects of the project into smaller chunks.

I have a personal restaurant database I have been working on for a

couple
of years and for Version
1.0 ALL of my Help files were created with this utility. For example,

to
display posting an invoice
I simply recorded an example. All of the Help topics were launched

from a
"Help Form." It worked
very well, but became too much maintenance as the project became MUCH

bigger.

Since these are .exe files, virtually any computer should be able to

open
the files whether or not
they have any Access/Office version. I'm not sure if this utility came

bundled with later Office
versions. I know you can also purchase programs like these as well.

Just a thought.

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

"Jan Il" wrote in message

...
Hi All - Access 2002 XP - Win ME

Is there an Viewer for Access like the one for Word? I need to show

a
sample
of an Access app. on a machine that does not have Access loaded.

If so, I would truly appreciate a reference or a link where I can

downloaded
it. I've been searching for one on the Internet for the past hour or

so,
but, haven't turned up any information for one yet. Just thought I'd

see
if
one was available before I went any further. :-)

Best regards.

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






  #23  
Old August 12th, 2004, 11:02 PM
Fred Boer
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

Oh no, she's not!

Fred Boer


*281 Days Left*


And counting!! ;=)))


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

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



  #24  
Old August 12th, 2004, 11:25 PM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

"Fred Boer" wrote:

*281 Days Left*

And counting!! ;=)))


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


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!!

;-)

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


  #25  
Old August 13th, 2004, 12:24 AM
Fred Boer
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

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" wrote in message
...
"Fred Boer" wrote:

*281 Days Left*

And counting!! ;=)))

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


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!!

;-)

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




  #26  
Old August 13th, 2004, 03:13 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

"Fred Boer" wrote:

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.
g

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.

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

"Jeff Conrad" wrote in message
...
"Fred Boer" wrote:

*281 Days Left*

And counting!! ;=)))

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


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!!

;-)

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



  #27  
Old August 13th, 2004, 03:45 AM
Fred Boer
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

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


  #28  
Old August 13th, 2004, 04:22 AM
Fred Boer
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

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" wrote in message
...
"Fred Boer" wrote:

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.
g

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.

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

"Jeff Conrad" wrote in message
...
"Fred Boer" wrote:

*281 Days Left*

And counting!! ;=)))

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

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!!

;-)

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





  #29  
Old August 13th, 2004, 04:43 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

"Fred Boer" wrote:

Make sure you ask for that day off.


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


Should be in my opinion.
:-)

Ohhhhh ouch that hurt! :-)


Just a flesh wound, I trust!


I'll survive.
;-)

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!


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.

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!


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

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


  #30  
Old August 13th, 2004, 04:45 AM
Jeff Conrad
external usenet poster
 
Posts: n/a
Default [OT] Access Viewer

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

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

"Fred Boer" wrote in message
...
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" wrote in message
...
"Fred Boer" wrote:

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.
g

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.

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

"Jeff Conrad" wrote in message
...
"Fred Boer" wrote:

*281 Days Left*

And counting!! ;=)))

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

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!!

;-)

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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access user profile Michael Breitsameter General Discussion 7 July 23rd, 2004 07:47 AM
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Informal testing of Access 97 Skills david epsom dot com dot au General Discussion 7 July 13th, 2004 01:36 PM
Data Access Page Problem Doug Munich General Discussion 0 June 5th, 2004 12:03 AM
Does not switch from VBE to Access Main Window Tony_VBACoder General Discussion 1 June 4th, 2004 04:20 PM


All times are GMT +1. The time now is 01:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.