Search results

Never have done a subreport so I'll look into that Can't do that since payments are made infrequently and don't always match charges. Some pay late, in advance, partial, more than, etc.

CID (Cust ID) is the common key for each table. Actually, I am just trying to get both lists displayed on the same page of a report so the payments can easily be scrutinized against the charges. That would be used if a customer calls and wants a history of his charges and payments, as in a...

No, just thought it should be about twice that size without clicking on it. Just a thought BTW, When I use the ? in a query for a prompt, it says Input Parameter. How to I get it to display "Input CID" ?

Make the pic on your site a little bigger so it can be appreciated more.

Have a query that simply displays two columns (Chargeamt and ChargeDate) depending on the CID input SELECT TblCharges.CID, TblCharges.Chargeamt, TblCharges.Chargedate FROM TblCharges WHERE (((TblCharges.CID)=[?])); Works fine Have another query that does the same thing for credits (Creditamt...

Yes that was stupid of me to not replace the word 'criteria' with the actual fieldname. Thanks Paul, again Now I have one more problem putting 2 queries together I will post over in queries. Thanks again. You are a gentleman and scholar.

CID is an autonumber field The DLookup I used is what you gave me =DLookUp("RunBalance","QryCIDBal") What I was saying, if I take the "Like" statement out of the query to use only the DLookup, then it seems to me I would need two different criteria in the DLookup, one for whatever CID is...

I looked at that but not sure how I would refer to the CID field of the form (criteria) and the query result field (RunBalance) Not having to have the "Like" statement in the query WOULD allow me to use the Balance field in different forms with virtually the same DLookup statement

I love Vegas. But have to wait for good deals. As a local, you should be able to get me a great deal! BTW, really like your website

As always, thanks Paul. How is the great Vegas ? PresBO has hurt the gambling world with his rhetoric , or so the casino owners say. I've got to get out there this year.

That worked fine. Much more simple than I thought. One other question. In a query, if you change the joins of tables for that query, does it change the joins of those tables overall or just for the query ?

That goes in the control source field of the text box ? then I don't need the "Like' statement in the query ?

Yes Paul, I'm afraid so. Just thought I could use the steps I used in another app to do this without a bunch of code. Oh well, just a thought. Thanks

I know it's on here but I can't find it. Have a payment form (FrmCustPay) showing name, CID, etc. Have Subform to enter payments. I am trying to add a text box that shows the balance of the customer (using QryCIDBal) based on the CID field. My query: SELECT TblCustInfo.CID...

Thanks guys!!

Startup options

Startup Options Name thanks guys!

Have a split DB named brooks.mdb and brooks_data.mdb. Trying to rename to rlg.mdb and rlg_data.mdb. 1. placed in a separate directory c:\rlg 2. renamed each to rlg.mdb and rlg_data.mdb 3. opened rlg.mdb and linked rlg_data. (tables) 4. changed path to C:\rlg 5. changed name in db properties to...

As always, THANKS for the help guys. BTW, I notice when I run the analyzer, it has some suggestions of inserting 'Option Explicit statements'. How important is this ? Seems to run ok without them.

That worked now, does it hurt to rename the db ? and wonder why it did that ?