Search results

I would do, just haven't gotten to changing it. Actually, I'll probably replace the color codes with preset variables and change a few other things around, but I'm leaving it alone until I get this sorted out. Well I moved the exact code over to the onClick event of a button I added. Same...

Hmm.. okay played around some more. Right now the code calling the function is in the OnLoad event of my form. I'll post the entire event sub (it's not too long): Private Sub Form_Current() Dim statusCode As Integer ' Breaks on this line statusCode =...

I'm sending an integer. Right now the value is < 100. The line I mentioned above that you referenced Mile: =cbStatusTitle(cbStatus([chargebackId])) Works perfectly. It's only when I try to call the function from form module that it gives an error. So I know the function works, I just can't...

Nothing.. it gives me run-time error 13: Type mismatch before it ever hits the Debug.Print statment :( Unless I'm using it incorrectly? I just placed Debug.Print after the SQL statement.

Hey, thanks for the replies guys. I tried assigning zero to cbStatus where mentioned, and adding debug.print after the SQL statement assignment. Still the same thing though, type mismatch. The strangest thing is that the function is working perfectly fine when I use it in the form (as a control...

This line in the form module: statusCode = cbStatus(1) Actually, I call this function with a reference to the value of a control on the form, but I have tested it with just a number and left it that way for clarity. I can use the function in, say, the control source of a control on my form...

Is it possible to use a public function from within a private form sub? I am trying to pass a value to the function, and assign the return value to a variable. The function is defined as such in a module: Public Function cbStatus(chargebackId As Integer) As Integer ' Determine the current...

Hi Sharon, I don't see an attachment? Is it just me? :confused:

The file is still there, but Geocities does not support direct linking of files. Drag the URL to your address bar or copy/paste: http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf

Hi Sharon, I hope I'm not too late to the show, I've been battling my own reporting issues as of late :) I think I know what you want to do, could you post an .MDB of what you have so I can take a look at how your DB structure is now? I think you can probably add a check box beside each...

You can see the relationship between the four tables in question above. If there is more than one record in tbl_Chargebacks_Transactions, then a record will be returned for each record in that table. I fixed RI between tbl_Transactions and tbl_Orders and the problem still persists, though. I...

I've already done that, two versions in fact. I would like to experiment with this method, though. It would be faster for the people using the system. Not to mention, once I run into a problem the last thing I want to do is give up on it. :( Unless you are saying it's impossible to create an...

1. The CIO here removed RI from this relationship when creating the import scripts to import orders and transactions. I haven't touched it for this reason, although I have designed every other part of the DB to enforce RI. Will this make a difference regarding my problem? If so I will dig into...

Hi all, I'm trying to get an updateable recordset using a complex query involving many joins, but I'm running into some problems. I'll explain what the database is for and a bit about how it is designed to give you an idea of what's going on. I would appreciate any help with this :) The...

Well there are many joins in the queries I am most concerned with. I think I will limit my 'lookup form' recordsource by dates to limit the number of records returned. Although, there will never be hundreds of thousands of records returned. We will be using the system to track chargebacks, so...

I suspected that was the case, but the first control on my parent form always got focus first. After your post I hunted around a little more and apparantly each field maintains their own focus even if the focus is set to a parent form. Since I can't set focus to a hidden field, I created a...

Hi all, I have a continuous subform which shows a record of transactions related to a chargeback in a database I am building. It's working perfectly aside from one thing. The top and left side of one of the fields in the transaction list will always reveal about 2px of the background color. If...

Thanks for the reply Pat. In all honesty, I can almost guarantee we won't be moving away from Jet within the next few years. Chances are we'll backup a bunch of records and strip them from the database when it becomes unwieldy. This isn't a choice I have any influence on, unfortunately :( I...

Thank you kindly jfgambit, problem is solved! I won't need to do any additions from this form though, so luckily I will not have to worry about the additional command button.

Hi all, I hope this belongs here instead of the forms forum. I am nearing completion of a chargeback database I have created in Access 2000. The database has ~100,000 records in the orders table and ~100,000 records in the transactions table. Both of these figures will most likely balloon to...