Search results

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...

Hi All, I'm doing a project on day to day Call Log Sheet and the details are saved in a folder named "callLog.csv" file. Here is the sample fields and record: ---------------------------------- Call Start : 7:02 Call duration : 00:00:41 Ring duration : 3 Caller...

Thank you so much for your help I appreciated. Maybe I post another question for more information. Regards,

hi speakers 86, I read the link that you sent me. I just want to ask about the code written on Scripting Guy site, is it Vbasic code or MS Access code? I have basic knowledge in programming in Access and VB just want to make it sure that it will run on Access code. Please advise. Thanks

Hi All, I'm doing a project on day to day Call Log Sheet and the details are saved in a folder named "callLog.csv" file. Here is the sample fields and record: ---------------------------------- Call Start : 7:02 Call duration : 00:00:41 Ring duration : 3 Caller...

Hi, I am just new in Access and I am trying to load another form from other form. On my first form I have a command button that call the other form. Please I need your help guys. Thank you in advance. Regards

Hi, anyone can help me how to load picture from file going to form? If possible, please help me to work on this. Thank you in advance.

Hi, Do we have a Calendar Object in the Toolbox, I am doing a date field in my form, and I would like to put an option of not keying the date in the text box, the calendar object will appear and you can easily select the date. Thanks in advance and more power. Regards, Jerry

Hi everyone, Im doing a report on string field named "designer location" (des_loc) as variable. The value of this field is "7001-Michael Coristine", how can I get only the number like "7001" then put it in a text field. I used form to get the value of this variable and I want to display within...

Hi Jep, I'm having a problem on string field, the value is "7081 - Paul Rooney" how can I get the 4 numbers on the string. Say I want to display the "7081" on a text field. I have an idea in my mind and when I applied it, it didn't work. Please help. Thanks a lot my friend, Regards, Jerry...

Hi all, I'm having a problem on string field, the value is "7081 - Paul Rooney" how can I apply the str() or any alternative function just to get the 4 numbers on the string. Say I want to display the "7081" on a text field. I have an idea in my mind and when I applied it, it didn't work...

jepoy need your help, I'm doing a report using between dates and using a Combo box to get a certain data for a particular customer from table. I created a form with two text fields (start date and end date) and a combo box for my customer field. I want to get the data for a particular customer...

thanks bob, i'l try to revise my coding. appreciated. Regards, jerry

Hello, I'm doing a report using between dates and using a Combo box to get a certain data for a particular customer. I created a form with two text fields (start date and end date) and a combo box for my customer field. I want to get the data for a particular customer within a specified dates...

Thanks a lot singh400 for help. It works. More power to you. Appreciated your kindness. Thanks Jerry

Hi to all, It's me again, I created a query for my report (sales rep per region) and I just want to add one more field (entered in Combo box) on my criteria. I made a form to be able to enter the value in combo field (for sales rep name). I am having problem on how can I get the value of combo...

hi singh400, I already added this just criteria on my query and it works. my problem is how can put it those two parameter value on my report. Namliam said, use it as dummy column but how can i do that? Please extend your help on this. Thanks, Jerry

hi namliam, thanks for a quick response. anyways, would you mind if i ask how can i use your first option? Yeah I had a query for this report, I mean what criteria should i add on my query? I know what dummy data is, but how can i put it on my query. I really appreciate your help on this...

Hi to all, I've been doing a report using "Between" dates and it works. The only thing that I want to ask from you guys is how can I put those dates (e.g. Start: 11/1/2008 to End: 11/30/2008) on the reports. Once I run the report it will ask for "Parameter Values" for both fields (start and...

hi to all, I learned that menu displays is not available in Access, and somebody recommends to use Main Switch Board to be able to make a form to display all forms you want to run. I tried to search this feature but a lot of site is popping up and I'm having hard times to figure which of those...