Search results for query: *

Guys, I just fing out that c in cmd is missing....... Yahnoo :)) Thanks a lot for your help:))))

Hey guys, I did changed the code (per Randy)... mdHCQTD.CommandText = "select sum([IViami]) as Total from netsales where (((IVMKPL) IN('LA', 'PC')))" & _ " AND ihyear = " & Forms![DateRange]![Year] & _ " AND ihperd >= #" & FromPeriod & "#" & _ " AND ihperd <= #" & Forms![DateRange]![Period] &...

Dear Jamie, The command object set up OK. Here what I have: Dim FromPeriod As Integer Dim rstHCQTD As New ADODB.Recordset Dim cmdHCQTD As New ADODB.Command Set cmdHCQTD.ActiveConnection = CurrentProject.Connection If Forms!DateRange!Period = 3 Then FromPeriod = 0...

Here what I have…… mdHCQTD.CommandText = "select sum([IViami]) as Total from netsales where (((IVMKPL) IN('LA', 'PC')))" & _ "AND ihyear = " & Forms![DateRange]![Year] & _ "AND ihperd >= " & FromPeriod & _ "AND ihperd <= " & Forms![DateRange]![Period] & _ "AND cmcusn = " &...

Thanks, it worked:)))))

Year & Month are numeric fields... I removed single quotes , but I am still getting a sintax error... cmdHC.CommandText = "select sum([IViami]) as Total from netsales where (((IVMKPL) IN('LA', 'LB', 'LC', 'QA', 'QC', 'FA', 'FB', 'FD', 'NA', 'NB', 'NC', 'PA', 'HA', 'PB', 'PC'))) and ihyear= "...

Dear Group, Maybe somebody can help me out with a passing parameters issue. Here what I have…. I have a form DateRange; This form has month and year parameters for report data selection… cmdHC.CommandText = "select sum([IViami]) as Total from netsales where (((IVMKPL) IN('LA', 'LB'...

Thank you:)))

Thanks, Can you give me an author name, please.....

Hi, Is anybody can recommend good Access books where I can find some helpful examples of coding? Thanks for your time.

Thanks Dave :)))

I'll try to re-insall it on Monday.....Thank a good idea. Thanks Dave :)) Have a nice weekends

I have an Office XP profesional. I 've been working with access for 4 month and that's the first time I see thie error

Please HEPL:))

Dear Group, I am working with access database and I am trying to create chart using chart wizard. The problem is when I am selecting chat wizard option, I am getting an error msg “The class argument in the CeateObject function of the Visual Basic procedure you’re trying to run is invalid”. Why...

Chris, I entered this expression onto the &quot;field&quot; and now I am getting an error msg &quot;The exprssin you entered contains invalid index&quot; :((

Dear Steve, I am trying to change my query, I am in design mode... Where &quot;offer:iif(check_box=-1,&quot;Free&quot;,$$$$$)&quot; should go?? In qry criteria or somewhere else????

You can default date to today's date. Select a table where you want to default the date; use defaul value Now(). Hope it's helps :))

Any other ideas???

Hi Mike, Offer_flag is a check box. The logic I am working on is : If check box (offer_flag) if checked, then offer_freedesc = &quot;FREE&quot; If it is not checked, then offer_freedesc = qty * item_cost