[MS_AccessPros] MS Access (2007) VBA codes - Login and Customer Follow Up Form

 

Dear Friends,
I need the help of MS Access (2007) experts in VBA codes.
I want to make a 'Customer Contantacts Management System'. I had
finished the Cusomer Contacts Enquiry Form and it is working properly.
But, please help me to solve the following:

1. TABLES and Some Fields

1. Employee(ID, Name, Address, Tel, Email, Designation,Salay, Etc..)

2. Users(are the same Name in the Employee table ) - (ID, Name,
Password, Grade)

3. CustomerContacts Enquiry/Customer follow up Table (ID, CustName,
Address, Tel, Email, Status, Notes, CalledBy_Name,

Enq_Date , Etc..)
2. I want to validate the User Name & Password to open/enter in Main
Form (CustomerContacts Enquiry Form).

3. The Name in Table (1 & 2) and CalledBy_Name in (3) are same.

4. Each time Login, the Table (3) should added by CalledBy_Name,
Enq_Date or in a New Table seperatly (Customer follow up details)
ie, CustName, Address, Tel, Email, Status, Notes, CalledBy_Name1,
Enq_Date1
CustName, Address, Tel, Email, Status, Notes, CalledBy_Name2,
Enq_Date2
CustName, Address, Tel, Email, Status, Notes,
CalledBy_Name3, Enq_Date3

5. Report According to Enq_Date(x) , CalledBy_Name(x)

Thanks.

Best Regards,
Shahid.


[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___