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

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

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

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

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

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.

I have 4 criteria to be pass thru my dlookup(), and it seems I coded it wrong, my level in access is not that high so I'm asking your help with this. criteria1 = combo1 (string data type) criteria2 = text38 (value) criteria3 = <> "12:00:00 AM" (date) criteria4 = between [start] AND [end]...

A strange Runtime Error appears after a click my command button containing my Dlookup functions. Any idea what does it mean? ******************************** * Runtime Error: '2001' * * You canceled the previous...

I have a combo box and 2 text boxes in my main form to enter my criteria for my query, every time I run the main form (frmLog), instead of showing it, a small screen will appear to "Enter Parameter Value", how can I use my main form to enter my criteria? Please i need you help. Thank you.

Got a confusing screen, i suppose to run my main form to enter criteria for my query when a strange small screen saying "Enter Parameter Value" appears. Please is there something wrong with my query? SELECT Count(*) AS TDirect FROM TabLogs WHERE...

Im confusing on how to get my query to be done and show the value on my subreport using command button. I need help about the procedure and the correct syntax on how to put my query inside the command button, when you click the button on your main form, it will run the query and result will come...

I created a query on how to get the TOP 3 most called numbers with count functions. I had my subform on my main form showing the results of that query. How do I save those 3 called number into table. Some fields associated with this TOP 3 values are already saved in my table tab_summary. How...

How can we add Date Picker in my main form. I tried to search on the net but they gave me lots of sites to download. Please help how can I add date picker on my form. Thanks Regards, Jerry

Hi, Just want to ask anybody how can we write an SQL string to run a subform. Correct me if I'm wrong, subform is one way how to view of query results on your main form, but how can we run a query (with user criteria that can enter only in main form) that when you click a command button the...