Recent content by jerry28ph

I have table name logtime, how can I filter the same date and time log and count it as 1 activity in query. Below is a sample, for 7/3/2009 9:55 count as 1, 7/3/2009 10:42 count as 1, 7/3/2009 8:23 count as 1 and so on. In total, i have only 9 call activity. All log time activity that logs more...

Thank so much.. it works. More power HiTechCoach

I have a memo field on my form and im using this field to store information about the customer order status. How can I add new information with the username and date attach at the end without overwriting the old information after i click the "Save" button. I dont want to go directly to the memo...

Hi, Just wondering if we can rename the PDF files after scanning and sending to any email. Ex. fax@jcl.ca_20090409_100524.pdf this file was automatically given by the fax system, I want to change it to another file. Please need your help asap. Thanks guys. Jerry

i have a task on between time. I have a table name timelogs and calltime fieldname with data type of date/time which the value is "03/15/2009 8:45 AM". How can i get the records that called between 8:30 to 9:00 AM only? I tried to apply the command between but there's no record showing. Please...

ok here's the spreadsheet. just download attachment. Thanks.

I got an answer from my question re the "extra quotes on my fieldname after importing the spreadsheet". My date/time fieldname was empty due to datatype used and i'm not able to change the data type because it was just supplied to me from the phone server. Somebody told me why not link the the...

hi dCrake: Ok but how can I do that, i mean how can link xls? what is the procedure, do you have a sample script how to write it? Please need your help. I am really newbie with Access. Please. Thanks.

Hi Namliam, Ok the reason why is when im importing CSV files from the server using import table from access, the field name on my table (Call Start which Date/Time data type) always giving me an empty data, but the rest of the field names were okey. I tried to open the csv file manually in...

I have folder of my company's phone server and it consist of files save as CSV. I need to get a day to day file from the server (saved in csv type) and I want it to auto open and save to excel. Please if you have an idea, i need you help on this. On my access form, i will supply the date of the...

I have folder from my company's phone server, i need to get a day to day file from the server (saved in csv type) and must be auto open and save to excel. Please if you have an idea, i need you help on this. On my form, i will supply the date of the day that we will need to get from the server...

i mean the data in the field, sorry for my first posting, all field have data except my field in date which the value has date/time like "1/12/2009 7:41:00 AM". This is the only field in my table which is empty. My solution on this is to open the csv file in excel then save it again, then when...

i have a problem in importing ".csv" files into my existing table in access. There's no problem in my script, i can ran my script w/o problems, but when it comes to importing, i need to open the csv file in Excel then save it as .csv file type, if not, all fields names will have double quotes...

hi kiwiman, thanks a lot for your guidance. I got it now. Thanks a million. Regards, Jerry

hi, ok just want to know after i click inside the object page and i selected import, what kind of file should i select, is it file that i will use to store the record which is ".csv" and did til the last procedure and I have my "tablogs spec" filename for the specification. Im confuse on when to...