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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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
|
|||
|
|||
[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 | |
|
|
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 |