Hello everyone. This is the first forum I have ever joined. I'm an accounting/finance type who started doing a lot of programming in Microsoft Access. People call me an expert, but my definition of an expert is anyone who knows a little more than you do., , Originally I wrote applications for myself, so I didn't have to worry about the user-friendliness. I would write queries to extract the information I needed at the time. However, I am now writing Access Applications for other departments and have to make them very user-friendly. Everything has to be automatic, therefore, i must utilize macros, etc and create user friendly forms. That is where my problems begin and I hope I can find solutions within this group., , I'll offer any help I can, but don't expect much of me at first., , Be talking to you., , Jocat

Posted to MB Topic: Member Introductions « PrestwoodBoards Board

{Too Long!}

Posted to MB Topic: Windows 9x, ME, NT, 2000, XP « Windows Board

{Too Long!}

Posted to MB Topic: MS Access Interactive « Access Board

I have a situation where we have a remote office and we want the staff to be able to enter complaints (and their subsequent resolution)into a database. Note that this office is not connected to our lan. We want to be able to view the information on that database at the home office. , , I am thinking of placing a replica of the remote office database on the home office lan and update it periodically. Because there is no network link to the remote office, what is the best way to update the home office lan database replica?, , We are using Access 97., , Any help or suggestions would be greatly appreciated., , Joe

Posted to MB Topic: Access News / Other « Access Board

From what I read in your request, it looks like you are tyring to edit an existing record. You state that when you enter the date again, you create a new record. I believe you are trying to look up a record and edit the data. If that is the case, you should create a second form for editing (you will have one form for the initial entering of the data, and a second form for editing). Include a combo box on the edit form to look up the date and go to that record (use the combo box wizzard and select the option to go to an existing record). , , Hint - when creating your second form, just duplicate your current form and edit it to include the combo box., , Hope this helps.

Posted to MB Topic: Access News / Other « Access Board

i have to design a database for use by an imaginary dentist., , The system must be able to:, - store patient files, - store appointment diary, - produce invoices for treatment (only 6 possible treatment available), , i was suggested to create three tables:, patient, patient records and appointments, when handling the first two objectives., , wat do you guys think? Can anyone please suggest what attributes (fields) to include as i don';t know where to start., , i think the relationship is as follows:, patient record - 1.2.1 - Patient - 1.2.Many - Appointments

Posted to MB Topic: MS Access Interactive « Access Board