Search results

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

I tried to copy a code that I found in this forum on how to auto import csv files into table, and something is wrong with my added code and an error message appear when im trying to run the code: Runtime error: 3625 "The text file specification "0" does not exist. You cannot import, export...

I would like to ask some guide on to automatic importing of table from a specific location of file. I would say \\3dif_avaya\jsmdr is the server path. I want to have a form to enter whether i want to create new table or save into existing table. Im thinking of DoCmd.TransferText but I really...

I know how to import csv from access using import table. I would like to ask if you have an idea on how to import csv files. Im building a program in access and importing table is one of the task. I would like to supply the path drive and an option of creating new table and using existing table...

hi to all who responded to my postings, OMG! you all have bright ideas on how to solve my problem. I took ideas of Jal and boblarson. as jal quoted: ********************************* textBox1 = listbox1.Column(colNo, rowNo) where "rowNo" and "colNo" are zero-based indexes indicating the row...

I have a listbox that has a value from my query, and i want to transfer it to text box. I tried several ways like, text2 = me.list497.value, text2 = list497.column(1) but it doesn't work. Is there any other ways to do it?? I appreciate any help. Thanks.