Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Aimee88

  1. Aimee88

    User accounts internet & program access

    One problem solved, and thank you for the ideas. I still don't know why it's happening, but when the limited users cannot access the internet, IE7 has a "diagnose connection problem" in the tools menu. This starts up and finds a problem with Winsoc and after a restart we are good again...
  2. Aimee88

    User accounts internet & program access

    I found this and started into it and it asks if you can browse from the host and client computers. We aren't on a network, just different users on one computer. Does the term network ever apply within one computer? All the help seems to be for sharing a connection between computers. We just...
  3. Aimee88

    User accounts internet & program access

    Linney, We tried the login as you described. Nothing changed. Same response. Thank you for your help.
  4. Aimee88

    User accounts internet & program access

    Thank you for your help. The web browser says "page cannot be displayed" and "you might not be connected", but the computer definitely is. We have broadband, a new one today, and it is reacting the same as the one we switched from, which was also broadband. I don't know if they can access...
  5. Aimee88

    User accounts internet & program access

    We are running XP Home and having trouble with the user accounts accessing the internet and some programs. We also have AVG for anti-virus and firewall and Registry Patrol. We selected these two because they did allow the other users to access the internet when we loaded them. Now we can't...
  6. Aimee88

    Time Format in Mail Merge Access to Publisher

    Well, I found a workable solution. The Excel option acutally would only have worked, if I wanted to re-enter my data. I opened the export from Access and tried to reformat the cells to text, and it didn't keep my data, so I went back to Access and changed the cell format to text. The only...
  7. Aimee88

    Time Format in Mail Merge Access to Publisher

    I'm merging from Access to Publisher (ideally) and one field is an appointment time. In Access it is formatted as "medium date" (ie 1:04 PM). When I merge to Publisher it comes out 1:04:00 PM. I found an article addressing this issue, and the recommendation was to use Excel and reformat...
  8. Aimee88

    Zip Codes with and without the 4-digit extension

    Never mind, I found it in the help files: Zip:Left([ZIPCODE],5)does just what I need it to. Thank you, thank you! Aimee
  9. Aimee88

    Zip Codes with and without the 4-digit extension

    MichaelRed, Thanks for the quick response. Can I have more specific instructions? Thanks! Aimee
  10. Aimee88

    Zip Codes with and without the 4-digit extension

    I need a report to show how many people we track/service in each zipcode. I have a simple query that shows City, State, and count of zip, but not the zip codes themselves. In this view, it seems to show just what I need to know, for instance, Greensburg PA 168 (count), except for the zipcode...
  11. Aimee88

    Excluding records in a query using multiple tables

    I'm back. I was sure that it had worked, using the max function, but when I attempted to use the query yesterday, I find that it is listing people whose latest gift was within the date range, but also any other (usually just one) gift given in the date range. I need to merge to a letter that...
  12. Aimee88

    Excluding records in a query using multiple tables

    Thanks for your help, all! I accomplished it using mostly the design view, but used the max concept (which is new to me). I had to use it with the dates, though, because in my fiscal year system FY99 would be perceived as more "max" than FY00, I would think. Aimee
  13. Aimee88

    Excluding records in a query using multiple tables

    gol4, Thanks. I think I'm starting to understand. However, I'm not great at trouble shooting these things yet. The query you wrote out for me is returing "syntax error in Group By". I tried a couple things, but didn't get anywhere. I also saw the post about learning SQL and...
  14. Aimee88

    Excluding records in a query using multiple tables

    Thanks for the suggestions, but I'm not sure just what to do with them. My query(s) pull from two tables. The Master table stores name, address, etc. The Donations table stores every instance of a donation. I don't need all the donations from FY00 and FY01. I just need to know the people...
  15. Aimee88

    Excluding records in a query using multiple tables

    I am trying to produce a list of those who donated to our orchestra in FY00 or FY01 *but not* in FY02 and FY03. (FY=Fiscal Year ending) The query [FY00 or FY01 but not FY02 Donations Query] produces a list of those that donated in FY00 or FY01 but not FY02. However a few of those did give...
See more

Part and Inventory Search

Back
Top