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!

  • Congratulations strongm 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: *

  1. valgore

    When checked, move to table

    im getting a compile error on the second [Merchant Name/Location]
  2. valgore

    When checked, move to table

    neither worked. i didnt get anything in the table
  3. valgore

    When checked, move to table

    they are two separate fields in the table
  4. valgore

    Crystal Cross-tab help

    the select distinct records was no checked and no, the suppress blank rows didnt work
  5. valgore

    Creating a log file

    can this work for an Access 2003 run-time app?
  6. valgore

    Crystal Cross-tab help

    where do i check to see if i have "select distinct records" checked? and when i remove row 2, it does change the amounts. so all i really need is the cross-tab to look nicer. do you know a way to remove the rows that are supressed? or if you have another idea, let me know. Valgore
  7. valgore

    When checked, move to table

    alright. i tried compacting a repair and it still didn't show the message box. but it did copy the table to the other table, but its still copying everything. so, my company is doing a massive CRM switch so im going to have to stop working on this project for awhile. so thank you dhookom for all...
  8. valgore

    Crystal Cross-tab help

    ok. the first attachment at the top of this thread is how it is currently. this is how I want it: March Total AD $2,096.22 $2,096.22 AU $275.53 $275.53 CO $659.79 $659.79 ME $39.11 $39.11 MI $770.62 $770.62...
  9. valgore

    When checked, move to table

    dhookom, i did try your button and it didnt do anything. my current code is Private Sub Command13_Click() On Error GoTo Err_SomeName Dim str As String strSQL = "INSERT INTO TestCheckboxtable([Merchant Name/Location],CategoryCode)" & _ " SELECT [Merchant Name/Location],CategoryCode" & _ "...
  10. valgore

    Crystal Cross-tab help

    that didnt do what i wanted. all that did want put the grand total on the top instead of the bottom. i dont really know how to explain it better....
  11. valgore

    When checked, move to table

    no. im using Access 2003. front end and backend
  12. valgore

    When checked, move to table

    alright. so i made the change from an OnClick to an OnClose. and i tried it, at it STILL copied all the records. im still really confused. i tried another breakpoint and it still went right through the code
  13. valgore

    When checked, move to table

    yes, the event is in the onclick of the checkbox. so your saying, i could something different like an OnClose event so when they close the form, it looks for any checked boxes and then it runs that code?
  14. valgore

    Crystal Cross-tab help

    Hello. i have uploaded a photo of my cross-tab. let me tell you the fields. the AD AU CO field is the category field. the 36,1,8,9,31 field is an auto number field because i have duplicate records that need to be there and Crystal combines all those into 1. and the number field is the amount...
  15. valgore

    When checked, move to table

    i dont understand.... i put a breakpoint and i clicked the checkbox and it finished the code and didnt stop. this is getting frustrating. im not mad at you dhookom :) your really trying to help me and i appreciate that.
  16. valgore

    When checked, move to table

    ok dhook, for you first statement, what it does when i check the checkbox on the form, it copies all the records in AmexCurrent and moves them to the other table and then makes all the check boxes checked. so yeah, i dont know why its doing that. and for the breakpoint, i put it at the strSQL...
  17. valgore

    When checked, move to table

    yeah, i was getting to it dhookom. sorry. my boss called me into his office and i wanted to submit as much as i could before i went in. the field is a yes/no. and i tried your code PHV and its still copying everything in the table over and making all the checkbox's checked
  18. valgore

    When checked, move to table

    ok my current code is Private Sub ChexBox_Click() On Error GoTo Err_SomeName Dim strSQL As String strSQL = "INSERT INTO TestCheckboxtable ([Merchant Name/Location], [CategoryCode], [ChexBox]) " & _ "SELECT [Merchant Name/Location], [CategoryCode], [ChexBox] " & _ "FROM AmexCurrent WHERE...
  19. valgore

    When checked, move to table

    i fixed that part already Randy. and i did set a break point. i set it on the DoCmd.RunSQL and i didnt get anything.
  20. valgore

    When checked, move to table

    i tried your code Duane and when i clicked it, it gave me a parameter value input msgbox

Part and Inventory Search

Back
Top