Search results for query: *

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

neither worked. i didnt get anything in the table

they are two separate fields in the table

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

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

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

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

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

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" & _ "...

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

no. im using Access 2003. front end and backend

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

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?

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

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.

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

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

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

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.

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