Results 1 to 12 of 12
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access97 (Templates)

    I have created a database for data entry of address information and easy printing of labels for a non-computer type client. I changed the extension to .mdz and I placed it in the proper area where the other Access 97 templates are kept and when I select File/New I do see it in the list of templates available. However, when I double-click it it does not even open. I realize typically with templates you get a wizard prompting for information but didn't think I needed that. Can anyone help me get this working so that all we need to do is give it a file name (it is now labels.mdz) and be able to use it over and over?

    Thanks

  2. #2
    New Lounger
    Join Date
    May 2001
    Location
    QLD, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 (Templates)

    I don't have a fix for you, but I wonder why you require a template . Couldn't you just have a simple database sitting on the users PC ?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access97 (Templates)

    The database templates you see in that folder aren't just simple databases that get copied over. They're wizards that *create* new databases of that particular type. I have to echo Craig's question. Why would you (or your client) be creating new databases to enter addresses and print labels?
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access97 (Templates)

    I'm puzzled too <img src=/S/question.gif border=0 alt=question width=15 height=15>
    Wendell

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 (Templates)

    I know they are wizards, Charlotte, and the only answer to "why" is that I did this with the idea that they could use it for multiple projects and since they are not very proficient computer users to begin with, use of a template just would have bypassed the steps of getting them to remember to rename the file each time so they preserve the original for future use. So, I guess the question perhaps should have been how do I create a wizard which I can look up in some of the documentation I have. In the meantime, I have provided them with step-by-step instructions for renaming this file each time they use it for a different project - which they have already done twice in the last three days.

    Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access97 (Templates)

    Sorry, I didn't mean that as a put down. I just meant that copying a database into that folder won't make it act like a template. I agree it would be handy to be able to do that in some circumstances, but i've never found a way. If you do, post it back here. There are probably lots of us who would be interested.
    Charlotte

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 (Templates)

    No problem; did not take it as a put-down. I was rushed when I responded and am sorry if what I said made you think so. I think you know how much I appreciate your (constant) help.

    Thanks

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access97 (Templates)

    Hi CD,

    Help me here - why do you need to have separate databases? Are they being put on different user's workstations, or are they being stored on a server? If you have network connectivity (could be a big IF I guess), then why not use a single database with tables for each user, or even a single table with ownership based on the user for each record, and use a batching process. Otherwise it seems like you would have a complex organizational and management problem if people create one new database after another. Maybe I'm not seeing the trees for the forest or however that saying goes. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Wendell

  9. #9
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 (Templates)

    Here's the story, Wendell. The people using this do marketing for medical facilities - nursing home companies primarily. So each time they have to do this it is for a different company. As a result the files have to be separate as sometimes they even share them with the client if the client is doing a large mailing on their own. The foregoing coupled with the fact that I put this mini program together so they could create their mailing labels and I have all I can do to get the lady doing the work to push a button to access a data entry screen and then push another one to print labels. If I get into a situation where she continues to add to the database, it will be a never-ending task to show her how to query the database to bring up only specific records - and I'm just not going to spend that kind of time on what was a cheapie deal to start.

    Thanks for listening.

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access97 (Templates)

    Interesting things we get stuck into, aren't they. If you are wanting to push the envelope a bit, there is a pretty detailed section on writing wizards in Helen Feddema's new book. I haven't gotten all the way through it yet, but it looks like it may have enough information to actually make it work. Let me know if you are inclined to pursue the true wizard concept.
    Wendell

  11. #11
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Ohio - USA, Ohio, USA
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access97 (Templates)

    Thanks I'll take a look. I am not sure I am in the category of expertise it would take to explore the true wizard conccept but who knows, maybe I'll take a crack at it some day. Yes, it is interesting the stuff that happens when you get involved in this kind of work - which started out ot be a challenge, became somewhat of a hobby and then when I would show people what it could do, suddenly they had work for me. I don't push it as it isn't something I want to spend my life doing but I guess I have enough knowlege and proficiency that I can earn a little money on the side.

    Thanks again

  12. #12
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Access97 (Templates)

    I came across this posting when I did a search on templates. I recently had a similar problem to yours and tried to make a template out of an empty database and found I couldn't.

    In my case I have a main database sitting at one site, and someone at another site needs to write some data that needs to be imported into the main database. They will create small data sets each day, that are emailed, or delivered by floppy disk, and then imported. I could have created a Word template for them, but I thought a small one table database with a single data entry form would be better.

    I actually found a way around it. I did create the empty database that I wanted to be my template, then I created another database with no tables, just some code that makes a copy of the empty database, prompts for a filename, then opens the copy. It works fine.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •