Page 4 of 4 FirstFirst 1234
Results 46 to 59 of 59
  1. #46
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

    Is it the Event template that ships with Access 2007? I loaded it and will look at it.

  2. #47
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It is in the query that is the RecordSource of the [Event List] form. Look in the criteria of the [Current Events] query and clear it.

  3. #48
    Guinea is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    48
    Ok here is a copy of everything I got through last night, let me know if you need help making your way through it. A lot of the original elements from the templates are still there because I am afraid to delete them and ruin the parts I need.

    The thing you have to look at it is the Events List. Why is the ID 1 event being hidden automatically?
    Last edited by Guinea; 09-02-2010 at 03:07 PM.

  4. #49
    Guinea is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    48
    I just saw your reply as I posted it....and did it and it worked. Thank you for that. If you want, you can still take a peak at my manipulations of the two templates and tell me what you think. I am open to criticism and suggestions. It still needs a little fine tuning....like changing some of the roster fields to be more relevant. Like Guardians isn't really necessary for us, nor is Room. I will probably change that to Degree Major and/or schedule.

  5. #50
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds to me like this thread is pretty well Solved. Are you ready to follow the link in my sig and mark it?

  6. #51
    Guinea is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    48
    Already done. Thanks for your help....I appreciate you staying with me through all of this, despite my frustrations.

  7. #52
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help.

  8. #53
    pp100 is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    8

    Cant open the attachment

    I am trying to open the attachment Members DataBase posted by Guinea on the Forum "access" and thred name is link meeting with roster.I get the error message "unexpected end of archive".What can i do?

  9. #54
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by pp100 View Post
    I am trying to open the attachment Members DataBase posted by Guinea on the Forum "access" and thred name is link meeting with roster.I get the error message "unexpected end of archive".What can i do?
    If you are talking about Post #48, I just downloaded it again and it works just fine. Did you right click first and "Unblock" the file?

  10. #55
    pp100 is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    8
    yes i am talking about post no 48.when i right click on the attachment i do not see "unblock" file.how else can i download?

  11. #56
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Left clicking on the attachment should eventually give you a Open or Save dialog box. pressing save should open a dialog that allows you to select the location. Is that not happening?

  12. #57
    pp100 is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    8
    yes i do that and i save the attachment.when i go to that location where i would saved the to open the database thats when i receive the message "unexpected end of archive"

  13. #58
    Matrix's Avatar
    Matrix is offline Admin
    Windows XP Access 2003
    Join Date
    Jan 2005
    Posts
    517
    Sounds like an incomplete download, please try re-downloading it.

  14. #59
    pp100 is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    8
    ok let me try again.will back

Page 4 of 4 FirstFirst 1234
Please reply to this thread with any new information or opinions.

Similar Threads

  1. One-way link between tables
    By Mikele di Sagitter in forum Database Design
    Replies: 1
    Last Post: 07-23-2010, 08:26 AM
  2. Link Master Field and Link Child Field
    By evander in forum Forms
    Replies: 2
    Last Post: 05-25-2010, 09:13 PM
  3. Link PDF on form
    By Cae in forum Forms
    Replies: 3
    Last Post: 01-09-2010, 07:49 AM
  4. Iff Statement Meeting 2 Conditions
    By newbie in forum Access
    Replies: 11
    Last Post: 06-11-2009, 11:59 AM
  5. Best way to link tables together?
    By marleyuk in forum Access
    Replies: 1
    Last Post: 06-07-2009, 08:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums