Search results for query: *

I like to use continuous forms and 'Edit' buttons that open more complex forms for editing data. The system I am currently working on has a lot of data managed this way, and I find myself using this technique quite a bit. I'm using openargs to pass a unique ID to the form, to identify if we're...

BHAX, I'm glad you decided to stick with it. It gives me some hope! I'm in a similar, but somewhat backwards situation. I am not salaried but work 40 hours/wk. as a chargeback rep turned Access DBA, and make pretty lousy wages ($12/hr). Right now I am on the verge of giving this job up and...

I wanted to tell you sooner but Tek-Tips has been problematic lately. The solution you recommended is perfect, and the added benefit of setting the filter within each report is that I can run them alone or as sub-reports with no modifications. Thanks a ton for your help! www.fury-tech.com

Well I've gotten back to the reporting issues as of late; some other demands took precedence for a while but now I need to get reports going on a regular basis. I've rethought my reporting methods a little, and while I've found a way that I think will work very well for my needs, I'm having...

And two years later I reply.... [ponder] Sorry it took me so long, I've been fighting with an import script for moving client data into the system which has kind of taken precedence over reporting issues (as well as the rest of my life ;-)) I appreciate the responses though, I'm kind of second...

Hello, Is it possible to reference the value entered into a parameter query which is the data source of a subreport, from the parent report? The format: Reports![parentRpt]![subRptName].Report![Parameter Value] Does not seem to work for me.. Thanks www.fury-tech.com

Good thought, retrieving the # of records hadn't occurred to me. I can see this reducing load to a point, but isn't the most 'cumbersome' part of a query the criteria/clause? I do have all of my criteria fields indexed, so this should help though. Do you know of any good methods/apps for...

Thanks cmmrfrds. The ADO part was a typo, sorry. I meant DAO. I know I can set the rowsource as an SQL statement, but I want to test the results of the SQL statement before trying to populate the combobox. I.E. if the statement returns no records then deactivate the combobox and give a message...

Greets, Is it possible for me to assign an ADO recordset to a combobox rowsource? I'm trying to populate a combobox ina subform with transactions based on credit card number input. Here is the code I'm using in an onEnter event of the search submit form: Dim db As DAO.Database Set db...

Great approach Albion, I like the way you think :-) Also, just to throw in my two bits on the Big Corporations [evil background music] ( ;-) ), I think they do control the success of Open Source / Free software to a point. There is a difference between producing quality software and making...

Also, I did read this FAQ: http://www.tek-tips.com/faqs.cfm?spid=705&newpid=705&sfid=2529 I loaded my last good backup (AFAIK) which was from last night. I tried to duplicate the errors again by doing the one thing I tried this morning: I copied a form and pasted it within the same DB under a...

Hey all, I'm trying to finish up an Access DB for my employer but I am experiencing some debilitating problems this last week. For the record, the project is a chargeback recording, processing, reporting and analysis 'suite' in Access 2000. After nearing completion of the project I started...

See your first thread: thread705-583986 www.fury-tech.com

Copied from : After I added the DAO object in the references and re-ran the module I am now getting a "Data Type Mismatch in criteria expression" and it stops at the line: Set MySet = MyDB.OpenRecordset(MyQuery) I'm not totally sure, but this probably has to do with this line...

I just replied to the same post in "Access: Other Topics", asking the error message. I asked because I had the exact same problem, remedied via jrbarnett's first suggestion. I'm not sure you want to get in the habit of cross-forum posting, it makes the solution to the problem harder...

What is the error message you are seeing? www.fury-tech.com

Exactly, I like knowing where it came from. Now how do you handle primary keys? I modified my tables and prepended a shorter version of the table name. Ex. my transactions table now looks like: tbl_Transactions - transactionId - trns_orderId - trns_date - trns_amount - trns_authorizationNumber...

I could be wrong, but here's my guess. Every reference to the definition of MDE I can find explains that it's a "Microsoft Access MDE Database". In this case MDE could mean Multiple Data Entry, so MDE would in a way be a recursive acronym which ultimately sorts out to "Microsoft...

First of all, I apologize if this is the wrong place to post this question; but I'm using Access and it doesn't seem to fit in the other forums, so... here goes. Does anybody feel it is smart to prepend field names with a unique identifier to the table it belongs to? For example, I have a...

Rick, that works perfectly. Many thanks. www.fury-tech.com