Search results

Ok, I believe the split db is the way to go. So all I have to do is send her the mde after I make any changes and it will auto link with the 'be' ? Then if i want to freshen the 'data' on my end, she can send me the be ? If I got that correct, fairly simple.

aw come on guys, you're getting way above this ole redneck's head! One db, she is the only one who uses it. I (along with you guys) built it and will be making some minor changes to the design for a little while. It is only 3mb so I just zip it and email it to her. She zips the mde and emails...

I have my sister using the db (in mde form). When I make design changes to the mdb, I need to import (freshen) the data from her mde. (We're in different states) Obviously, when I do this, I get a duplicate table renamed. If I do a query to freshen the data, will an update query just copy the...

that fixed it I hope I have run out of stuff to fix!! Thanks I did do something sort of smart - for me anyway. All existing balances I made a query to put them in charges table as Balance forward and any negative balances (credits) into payments as Credit forward. worked pretty well.

Ok, my balance sheet is only showing positive balances based on this query: SELECT TblCustInfo.CID, TblCustInfo.Name, TblCustInfo.SrvAddr, TblCustInfo.SrvAmt, TblCustInfo.BLCAT, Sum([TblCharges.Chargeamt]) AS SumOfCharges, Sum([TblPayments.Creditamt]) AS SumofCredits...

I was on the assumption that the table of any field specified had to be in the window. Guess we know what assume does. But I don't understand why just having the table open was doubling, tripling, etc each time. Oh well, as usual, thanks for bailing me out.

Well He--, just found a problem. My QryDbtM1 and Q1 - Once you debit once, the second time adds 2 more debits, the third time adds 3 more, etc. Is that because of the "Debit" word I have appending to Chargereason and Date() to Chargedate ??

The dLookup works. And it works for the debit dates also. I think, for the present, I'll just have her input the dates of debit in the Invoice memo form. Now I'll finish checking everything and I think it will all work. Need to import all her live data. Maybe I can try to refine some things...

well, I can put data in from a form, I can query the table, but I can not get any data from it on a report. just gives the ambiguous outer join bla bla bla There HAS to be an easier way to hold data in three fields and either display or print any one or all. * Command button, next to it shows...

made TblMisc and added two date fields QDbtDate and MDbtDate and a Invmemo field for my invoices. added to my Invoice query but when I try to retrieve the memo, it says it can't do it because of an ambiguous join, bla bla, bla. Thought I had run into this before. The more I try to do the more...

That works Paul, Thanks Now, one more thing and I believe this is done. I think. Tell me how one can have a table with 3 or 4 fields and none of them associated with any records ? Like the debit dates and a memo ? Stuff that is retrievable for just printing or displaying purposes ??

pops up a parameter box for Sumofcredits tried just RunBalance does the same

using is there a way to return only records resulting in greater than zero from the ([SumofCharges]-nz([SumOfCredits])) AS RunBalance part ???

This code in the Before Update event properties The first line and last line will already be there so do not duplicate them.

I tried to put it in before the DoCmd.Maximize I have in the open event but it didn't like that. I am opening those invoice reports in the switchboard. The two fields for the criteria for each are Cancel="n" for both and BLCAT="M1" for the monthly and "Q1" for the quarterly You lost me on the...

Ok, where does that line of code go ? In an event ? Also, how do i pick a random record on the dates for the query ? Other than those two things, looks like everything else is working. so far

If I get them from "specific" record(cust), then they (the customer) cancel ......... ???? So I need another table with two fields ? The problem with that is I can't 'update' to that table from an append query which is what I am running for the debits. ???? also, I got my balance and debit...

Yes, I agree this is better. Just having to redo a lot, but it's worth it. No, I have buttons to debit ALL monthly customers and quarterly customers. I want the date the debit was last ran next to the button so she KNOWS when it was last ran just as a precaution. So it isn't single record...

ok, trying the two table method. got the "charges' table set up , the debit queries working, and the input form for any charges set up. seems like this will make the db grow somewhat quicker but what the heck. still need a way to display that last debit date next to the button without depending...

That sounds great, but, working with what I already have, I have no idea how to do the Trantype and TranAmount. I would have to set it all up on one form for input and be able to select which input type it would be. Ain't got a clue how to do that. Then I suppose the debit (invoice) part would...