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

Patient table should contain all information about the patient, such as name, address, age, insurance, medical conditions, medications, etc. Be sure to include a unique identifier (for primary key). Call it "Patient Number"., , Patient records should contain all treatments that the patient received. Each treatment is a new record. Suggested fields - Patient ID, Date of treatment, Type of treatment., , The appointment diary should contain date, time, Patient ID and reason (treatment)., , You will need another table for producing invoices. I am assuming you only producing the invoices and are not concerned with the accounting. I suggest the following fields: Invoice date, Invoice number, Patient ID, Treatment Date, Treatment type, Treatment cost., , You may want another table for the treatment names and cost. You can link to this table to get the cost of the treatment to put on the invoice., , I hope this helps.

Posted to MB Topic: MS Access Interactive « Access Board