Search results

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

Hi Rabbie, Thanks you for the reply. I would like to take this opportunity to get some advise on my script. Im trying to save the value of Total Talk Time in my Tab_Summary. The field is Talk_CCEC and set as Text (i know it should be date/time but i just used it as Text for now because the...

Hi All, Do we have an option in Table Design to format the time value in just "mm:ss" only, coz i cant find in design tab, may be there another way on access script to return the value in this format. Any help is highly appreciated. Thanks.

Hi CameronM, It didn't work, when I click the command button that has the SQL string, still null value was saved. I know it should be "00:00:00". ****** '"'" & IIf(IsNull([Forms]![frmLog].[Total Talk Time CCEC subform]), "00:00:00", [Forms]![frmLog]![Total Talk Time CCEC...

Hi, Thank you for your post replied. Appreciated, would you mind if I'l get back to you if didn't work? Regards,

thru my query and main form. when you run the query and the value showed on the screen and once you change your criteria on your main form, does the value of your query be overwritten by a new value? Pls correct me if i am wrong, i tried it and it was overwritten by a new value. THanks. Jerry

Hi, After running the query, and you want to input another set of criteria, how can we reset the query? Please need your help. Thanks, Jerry

Hi, Im just using Access not VBA, its my first time to use access that's why im having hard times to utilize my queries. Do you have an example of code for IIF condition in INSERT INTO statement? Maybe you have one. Please, Thanks

Hello, I created a TOP 3 query and it gives me the correct report value, I would like to ask how can I save the TOP 3 value in the table, I have 3 fields (Top1, Top2, Top3) in my TblCall and I have report generated from my query. Please need your help. Thank you very much. Regards

Hi Banana, I know its too much for me to ask this, maybe you have an example of a script on how to write IIF() in INSERT INTO statement. I tried to write the syntax that you gave, but still "Object required" is missing. Here's my code: strSQL = "INSERT INTO tab_Summary (id_no, cs_datefrom...

Hi CameronM, I cc'd you my reply to Banana re my problem wth IIF: Maybe you could help me to utilize this. ****************** Hi, Im trying to insert the code with IIF statement inside my INSERT INTO statement, and I dont if I can do it as follows: strSQL = "INSERT INTO tab_Summary (id_no...

Hi, Im trying to insert the code with IIF statement inside my INSERT INTO statement, and I dont if I can do it as follows: strSQL = "INSERT INTO tab_Summary (id_no, cs_datefrom, cs_dateto, pc_ext, pc_hunt, pc_name, in_ccec, in_totccec, in_int_ext, in_ext_caller, ttt_ccec, ttt_in_ext...

Hi Everyone, I'd like to ask your help on how to write IIF() condition inside the INSERT INTO statement. HEre's my code: strSQL = "INSERT INTO tab_Summary (areaOfCalls, cs_datefrom, cs_dateto, MCalls, Destin, OCalls) " & _ "VALUES ('" & Me.[Text295] & "', " & _ "'" & Me.[dfrom] &...

hi pbaldy, i broke it into 3 separate lines (3 fields) like this: strSQL = "UPDATE tab_Summary" Set cs_datefrom = "'" & Me.[Smdr Qry_Total_Direct subform1].Form!Format([Text2], "mm/dd/yyyy") & _ in_int_ext = "'" & in_int_ext = "'" & Me.[Smdr Qry_Total_Direct...

Hi ALL, I'm trying to run this query using command button to update my table using the supplied field value and calculated values on my main table, but it seems there's a problem on running this script. It gave me "Compile Error - Invalid use of property" on Set cs_datefrom line. cs_datefrom...

it should be the total no. of records that filtered on this query based on the criteria. That why I created a subform/subreport on my main form, and put the a calculated control under form footer which is Text2=count(*).Can we just get the count of records on my subform and put it on Text235 on...

ok here: Smrdr Qry_Total_Direct - name of query SELECT [Smdr(backup1-6-2009)].Party1Name, [Smdr(backup1-6-2009)].Dialled_number, [Smdr(backup1-6-2009)].Direction, [Smdr(backup1-6-2009)].[Call duration] FROM [Smdr(backup1-6-2009)] WHERE...

i tried all the possibilities that you given, but still the detailed result of my query displays (should I say data grid) it looks like spreadsheet. can we set it on properties? Thanks for your patience. regards, Jerry

the name of the Text box is Text235 and to be able to get the value of my subform and put it in Text235, I set the controlSource for Text235=[Smdr Qry_Total_Direct subform1].Form!Text2.

hi, for my question #2 these 2 subforms are part of my main form, i put command button on each and the content is: On Error GoTo Err_RnRfrshQry_Click Dim stDocName As String stDocName = "Smdr Qry_Total_Direct" DoCmd.SetWarnings False DoCmd.OpenQuery stDocName, acNormal, acReadOnly [Smdr...