Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goldygirl
  • Content: Threads
  • Order by date
  1. goldygirl

    Syntax

    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 = " &...
  2. goldygirl

    Passing Parms

    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'...
  3. goldygirl

    Access manuals

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

    Chart Wizard

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

    Error msg &quot;You can't assign a value to this object&quot;

    I have a field with a control source = Qty * item cost -- Field1; I have another Field2 (Text28) = 0; Private Sub Offer_Flag_Click() If Offer_Flag = -1 Then Offer_FreeDesc = Text28 End If Why I am getting an error msg that You cannot assign a valur to this object. What...
  6. goldygirl

    Check box question

    Dear Group, I am straggling with check box logic. Here what I have… I have a form with subform based on the query. Let’s say Form1, subform Form2 and based query name is Query1. One of query field is a check box. This check box is responsible for free goods and located in the subform (Form2)...
  7. goldygirl

    Passing Parameters in access

    I have an issue with a passing arguments in Access. Here is a problem description. I have Form1 and Form2 . Form2 calls Forms2 and pass 2 arguments. Both forms were aerated with access wizard. Attached is VBA code: stDocName = &quot;Offer USA&quot; stLinkCriteria = &quot;[Dtl_ID]=&quot...
  8. goldygirl

    Passing arguments

    I am working on the applications that pass 2 arguments from Form1 to Form2. I created Form 2 using Access wizard (I created form and subform). Attached is a code created but Access wizard: stDocName = &quot;Offer USA&quot; stLinkCriteria = &quot;[Dtl_ID]=&quot; & Me![Promo] DoCmd.OpenForm...

Part and Inventory Search

Back
Top