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" & _
"...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.