Question Searching of Records

[jerry28ph]

I'm having a problem in searching and populating the records from table to display on the forms. I created a text box that I need to enter Client No. and I have a table name tab_client with client_id as primary key. Please help me on how to use OpenRecordSource function or if you any other alternative function that I can use to search and retrieve record from table then populate on the forms using labels or text box. Please help to find ways how to do this. I will really appreciate your kindness and help.

More power to all of you.

Thanks.

 

[jepoysaipan]

Hi Jerry,

Attached is a DB hope it helps.

Does the "ph" on your ID stands for Philippines?

Jeff

 

[jerry28ph]

Import .csv file into Access

Hi JepoySaipan,

Jep I really need your help, I know you have a lot of experience in Access. As of now I have a project, I'm doing a program on day to day Call Log Sheet and the details are saved in a folder named "callLog.csv" file. I need to save the following record into table.

Here is the sample fields and record:
----------------------------------
Call Start : 7:02
Call duration : 00:00:41
Ring duration : 3
Caller : 202-1020
Direction : I
Called No : 155511
Dialled No : 155511
----------------------------------

I would like to ask from you on how I can import and save the sample record into Access table ( I created the .mdb file and table with the same field). I want to use form, command buttons and SQL to perform this task. I have basic knowledge in SQL and working with databases and tables. I will appreciate any help that you may share with me. With your help I know I could make it.

Thank you in advance.

Best regards,
Jerry