Search results

Okay, I figured out my problem (just not a solution). The query is not returning transactions which are related to the specified chargebackId, BUT, if a transaction is related to the specified chargebackId and another chargebackId, it then returns the transaction since it fits the criteria. I...

Hmm, perhaps I spoke too soon. The query is still showing transactions where the specified chargebackId exists in tbl_Chargebacks_Transactions. Here's the SQL I'm using: sqlUnassignedCredits = _ "SELECT [tbl_Transactions].[trns_amount], [tbl_Transactions].[trns_date]...

I tweaked it out a bit to work with my specific fields and such, but it seems to be working like a charm :) Thanks a heap GumbyD!! :)

Ooh, this looks promising :) I'm heading out of work right now but I'll check this out first thing in the morning! Thanks for the post I'll be sure to let you know how it works :)

I'm having a real tough time with this query I'm trying to create. I need to retreive transactions which are not related to a specific chargeback, but are related to a specific credit card number. tbl_Transactions stores all of the transactions. Each transaction record has an orderId with a...

I'm trying to set a report's filter property to the filter used by the parent report. Is this possible? I would ideally like to say: Me.subReportName.Report.Filter = Me.Filter Or somethign along those lines. I'm setting the filter property of the parent report from a form; the user selects a...

Jeebus, that is some hoop jumping. Thank your for the info though, I'll have a look at the link. I converted to prior Access version (assuming this makes it a '97 database). The ZIP is attached.

Hiya all, Been playing around with ways to to apply colors to my command buttons, as well as use GIF's as a command button image. I came up with a really simple solution using the MouseDown and MouseUp events to make a realistic looking command button out of a box and an image. Just thought...

YEEEEEEESSSSSSSSSSSSSSSS!!!!!!!!!!! :D :D :D I fixed it, thank the gods!! I had a field called cbStatus which I could sworn I renamed... but just to be sure I checked again... nope! Still cbStatus! Changed the name and all is good now :) Wow, I knew it was something simple and stupid. Rich --...

Identical :(

Awesome, I found it thanks! Although, I don't think this has anything to do with my syntax or usage now. As I said, I created a new form, based on the same query, and used the exact same code as I posted to call the function, and it worked fine. I even removed the form module from the real form...

Okay I created a new form with a button that ran the EXACT code in the sub on my last form. It works fine. MsgBox with the statusCode showing it's correct, no problems. This must have somethign to do with some other code in the form I was working on, I just don't know WHAT. I'll keep poking...

Okay, I was curious about looking at the entry but I can't find that in the help file (Access 2000). I tried this: codestatus= Call(cbstatus Me!checkbackID) To no avail (still saying Expected: expression). I guess I could resort to using a global variable, it just seems wrong that I cannot...

Can you tell me where in the help file you found this?

Hi fuzzygeek, as I indicated a few posts back I actually did try that out: statusCode = cbStatus(CInt(Me!chargebackId)) With the exact same error. I've also tried variant and long for my types. Thanks for the reply though, I can use all the input I can get on this! :)

Nope, it says "expected expression" after Call. The line I posted did not have quotes in the code either...

Mile, I tried Me.chargebackId to no avail. Ancient One I think you might be on to something! Part of that paragraph confuses me, though: Does this mean if I use the function without the Call keyword it still discards the return value? Also I wonder how I can call the function and assign it's...

Ahh, it's okay, I figured. Considering I'm using Option explicit it wouldn't be possible to avoid that declaration anyway :) Okay, this is driving me nuts! I'm looking at the the evaluation VBA editor shows in the 'tooltip' box that pops up when you hover over a chunk of code. I'll show you...

Why don't I need to declare it, can you explain? I also tried: statusCode = cbStatus(CInt(Me!chargebackId)) With the same results ....

Yes, it echoes the proper chargebackId (43 in this case). PS thanks for making the case statements ;)