Search results

Hi Alc, Thank you so much it works now. You're such a nice person more power to you. If you dont mind, I have 2 last question for you. Im sure you know this one. 1. The script that you gave me is how to append new record, how about if you jus want to update some fields of a record, I mean...

hi ALC, i ran the my form and clicked the button with this script, and here' the error msg: Runtime error: 2465 Microsoft Office Access can't find the field "|" referred in your expression. I set the data type for all 3 fields as Text. Please advise. Thanks.

Hi All, I trying to run a query using command button on my main form, but it seems i have an error in writing this code. I want to save the two values from my sub forms, and a value supplied by user from my main form. Private Sub Command351_Click() Dim strSQL As String 'build the string...

Hi, Prior to my reply here's the script that I wrote once I click the command button: Private Sub Command351_Click() Dim strSQL As String 'build the string including the field names as required strSQL = "INSERT INTO tab_Summary (cs_datefrom, in_int_ext, in_ext_caller)"...

Hi CameronM, I tried to add a command button and put the code that you gave me, but when I saved it, the "VALUES" line turned into red, I know this code belongs to VB, how am i going to write this code into Access script, please bear with coz im really newbie in access. Regards, Jerry PS...

hi CameronM, main problem: see my title it goes: i have my main form [frmLogs], 2 subforms [qryTotalDirect subform] and [qryTotalQueue subform] i used =count(*) on each subform, and i could see the count of each subform on my main form. I have a tbl_operator, and i want to update 2 fields to my...

Hi all, I'd like to ask how to bring the value of query into table. I have 2 subforms on my main form and I would like to update 2 fields value calculated from my main form. can you please send me the syntax or sample how to save or update my table with my query value. Please help. Regards, JE

Thank so much. Appreciated. More power JOHN... Regards, Jerry

hi john, for now i would use to view the values of my collected query, i had my subform on my main form, i use this to get the value of my query, is it normal to show the details in data grid of my query on another window? How can I avoid not to show this, since i can see the value of my...

Thanks a lot.

Thanks for your help, i really appreciated. I try to do it, and search for any similar code on the net. More power. Regards, Jerry

i have other values on my main form that came from my subform, I want it to view them in my main form so that I could save them in one table for my report. please bear with my question i know sometimes its kind a confusing for you and the others, Im just starting to work with access and sql, and...

Hi all, how can I control the showing up of query value after I click my command button, I supposed to get only the value of my query to be store in my sub form "Smdr Qry_Total_Direct subform1", but using the DoCmd.OpenQuery I cant stop showing the window for the query details. Do I need to...

hi, i did what you said =count(*) but the total is showing up though i didnt enter the criteria. did you opened my attachments? how do you find it? is it confusing?

hi nedkelly, i had 3 queries, the other 2 are related, 1 main form and 2 subforms and 4 tables the table that im using for main form is Smdr(backup1-6-2009). I cant delete those 3 coz they're linked to each other. Thank you so much. Regards, Jerry

hi nedkelly, I wish to attached a copy of db on this forum and i tried to compress the file but still not to fit in 748 KB. Would you mind to send you on your email address? If ok to you, please send me your email. i also note on the FrmLog form. incase you dont understand, I can also post...

ok i understand what you said. maybe you help me to resolve my last question. i have a main form and 2 subforms, the criteria of my subforms (value from my queries) can be supplied from my main form. criteria: 1. Party1Name 2. Dialled_number 3. Direction to get the total calls of the...

hi nedkelly, I had a query getting the total no. of record being filtered by a certain criteria using =count(*) and I can see it after I ran. How can I save the value of my query into table.

hi, How can I save the results of my query into table? Please need your help, I'm stuck with this. REgards,

hi all, I created a a subform in my main form. The value of my subform is based on my query result (as "Total Calls"), how can I store the value of a subform in a text box? I really appreciate for any help. Thanks, Jerry