I.T. Discussion Community!
SEPTA, Joe [Unspecified] -Collapse +Expand
-Collapse +Expand
Jocat
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (15)

Search Jocat:

Advanced
Personal Account . . .
Jocat
Philadelphia



Real Name:  Joe [Unspecified]
Primary Role:  Coder
Joined: Dec 2001 (18 years ago)
Visits: 18
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

15 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
I'm new here
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
18 years ago
Nothing New Since Your Last Visit
2224
Hits

PrestwoodBoards

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
Windows XP Log On Problem
{Too Long!}
15 years ago

lowster11
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
5643
Hits

Windows Users

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
Data Entry Form
{Too Long!}
Posted to MB Topic: MS Access Interactive « Access Board
16 years ago
Nothing New Since Your Last Visit
1884
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
Synchronizing w/o network
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
17 years ago

jdschram
best way? create an app using ASP...as far using just access...i would say create an FTP site where you post/DL/update the database
17 years ago
Nothing New Since Your Last Visit
2330
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
Re: Schedule database
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
17 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

Jocat
Re: designing a database
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
17 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access
More...
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech