Recent content by Gwen61

Thank you for the instructions on how to post attachments, Stopher. I've not forgotten this thread, but the person in charge of the project won't be back in the office until 1/5. I'm in a holding pattern until then, but after I have a better idea of what he wants for the end result, I'll be...

I mentioned SharePoint because that's where I was directed on Access Help when I searched for publish to web. In any event, I'm in a holding pattern until 1/5, when the person in charge of the project returns to work and answers some questions I have. I'll be back then. Thanks.

Thanks very much for all your responses. I've been focused on something else today, but I'll be back at the db tomorrow, and when I read the responses in detail, I'm sure I'll have questions. Thanks, particularly, about the terminal server info. According to what I read in the Access 2007...

Thank you very much for your comments, Art and Stopher. I've been focused on something else today - I needed a break from the db - but I'll be back at it tomorrow. How does one post a db on here?

I've spent the last couple of weeks, off and on, teaching myself how to design a database, but now I'm thinking it should be handled another way. This is the scenario of the project: There are 5 people in different parts of one state, who will be accumulating the same information...

So, would I do 5 reports, one for each service officer? Another thought I had since I posted was to have each service officer enter their info in Excel, import each spreadsheet into Access as a separate database, then generate reports from each table. Does that make any sense?

I think I have the db table the way I want it, sort of, but I'm hung up on how to extract the neccessary data for a simple report. I'll try to explain what I need. The db is going to be used by 5 people (Service Officers), who will be accumulating a bunch of info from each person that contacts...

Thanks for the info, wazz & Mike. I sent the db the other day, and the person to whom I sent it still hasn't let me know if she was able to open it. When I hear from her, if she wasn't successful, I'll try zipping it.

Thank you so much, Bob. The Microsoft Tutorials just aren't doing it for me, and I haven't been very successful at finding any other good ones on the web. I appreciate it.

Me, too! I think I've got the Contact List the way I want it. At least, for now. Would you be able to suggest what I need to learn next? Querys? Reports? Which one first?

Fixed it, Bob! I think I must have deleted the Notes field from the Contact List, so I made a new Notes field in the table and, voila, the error is gone. I'm teaching myself how to build a table in Access 2007, so I'm taking a lot of baby steps. Thanks, again.

Makes sense, Bob. Now, to figure out what I renamed. Thanks.

I may have renamed something, but I honestly don't remember. Would that be what's causing the problem?

In the "Notes" section of the Contact Details, "#Name?" error is listed. I switched back to Contact List and noticed that in "Show/Hide" fields, I had hidden Notes because I didn't want it on the Contact List database. I changed it to Show, and now the #Name? error is listed in the cells in...

Thank you, pbaldy. For some reason (ignorance), I didn't think I could email the database as an attachment, like one can email other attachments, but I did send it and it seems to work. Thanks again.