Recent content by 0bsidian

Hi again Mike, If only! I have to finish this up by tomorrow and am still having issues with this code (though by all accounts it should be relatively simple). I've even tried some other methods and hit similar road bumps. VBA is certainly not my strong suit, and I have no colleagues who...

Mike, Thanks for all your help here. I completed the various steps you had described and the process is almost done! Admittedly, I am still trying to get the VBA code right to print, move to next record and stop at the final record, but I am sure I'll get that with a bit more effort. Many...

Thanks again Mike. I have begun working on what you've described. I guess my fear is that I haven't explained myself clearly, and thus have influence your response in the negative, leading me to work on something that actually might not create the desired result. I have only one report (for...

Hi Mike, I think I am clearer on that now - thank you. However, jumping the gun slightly, assuming I can get it so it prints the report based on the record displayed on the form, how do I move from that, to getting it to print a cumulative report for all the entries under the specific...

Thanks for the advice Mike. I am however, a little confused (apologies, I know the basic design aspect of Access but dont have a great deal of experience beyond that, but can usually muddle my way through). 1. Would I be correct in assuming that the query can just be based on all...

Just a wee bump guys, in the hope that someone out there can help me remedy my problem. Unfortunately, I'm beginning to run short on the time I have to solve this problem. If anyone can offer advice, I'd be most grateful. 0bs

MStef, thanks for the prompt response (unlike this reply!). Unfortunately, I don't think thats exactly what I am looking for - though it is closer. I need each customer to have their own independent invoice (report), but all customers should have their invoice created (see: printed) at the...

Hi folks, Hope you can help with this. I currently have a database that is used to log customer transactions. The database also contains reports which are used as invoices for the various customers who have purchased items. However at present, I can create one report which shows all...

Excellent stuff Bob. I opted for the latter approach, which I thank you for directing me to. Good work. 0bs

Hmm..not sure about the bracket thing - will look into that. I can't use the result of another formula (in this case the formula that totals BuyBack) in the formula on the parent report? Darn, I wasn't aware of this. Apologies for being a bit thick, but I am not sure I follow your...

I thought the same, but Access seems to take them away once I've entered the exact formula you gave me. I even copy-pasted your formatting in, but once you change from design mode to view mode (and see the #Name error), it seems to remove the brackets. I'm not sure why that is. Do you think...

Thanks Bob. I have changed my formula to the one you suggested, and I have checked (I think) the name of the control is the same as contained within the formula - unfortunately, I still get the same error. I've included a screenshot in this post to let you check if I have misinterpreted what...

I currently have a parent report, with an embedded subreport. In the report footer of the parent, I have a selection of text boxes which do a series of calculations to give me report totals. I want one of them to take a figure from the parent (Total PurchasesIncVAT) and deduct a figure...

Hi, I, like most people can manage to report effectively from one table, however I am having some difficulty when it comes to reporting from two. I have a pupil transaction table and a "buyback" table (for purchasing items back from students). I want to create an invoice report for each...

I currently use a database into which I import a fair amount of data on a bi-monthly basis. Before I can import that data, I need to delete the existing records from the tables. I currently do this with a selection of delete queries which I call sequentially through a vb sub. Is there a...