Recent content by spn200286

Your a legend mate thank you! Cant believe how i missed something so simple, must be lack of caffeine

Good Afternoon My trouble today is as follows, i want to count the number of times a company buys from us. How i was planning on doing this was counting the number of dates they have baught from us, however a company can buy multiple purchases on same date So using the example below it would...

It is the DLOOKUP that deals with date. The problem is i dont know the dates the user will want to search, so i was using a parameter querie on the [Date] field. and im not sure how to add this into the DLOOKUP, or if i even can (I hate sounding like such a novice, however i forgotten alot...

Thank solved 1/2 my problem thank you! i changed it to STotal: Dsum("total","qrySales","SalesID <=" &[MySales] & " AND ClientID<=" & [MyClient]) because the tutorial I was using said < is important When i want to search between XX date and YY Date however hows the running total for all of the...

Good morning, hope everyone who read this is well I am trying to do a running Total for my marketing database my company has asked me to produce A client buys Product A, B, C the quantity is entered and a total (price*quantity) is figured. now in my form i created a text box that works out the...

i remember that now thank you once again (i remember why i never liked programming at uni, so easy to make a mistake)

Thank you very much for your time and patience, that's working now and thank you for your tips (i have risen rep where i can) 1 more question, why did you use "2" instead of the name, is it because that's the id for private individual?

03 format sorry for being a tad useless with this! JamesMcS thats on the frmreportmenu would that inter-fear with a different form?

frmSales is the form in question! i rebuilt the beforeupdate query aswell, not sure why that was like that

im posting off a different computer at the moment, will copy the database over in a moment moving from design to form view brings up the error Compile error: Invalid outside procedure the code highlighted is Private Sub Form_Current() (the code is set out exactly as above)

Im still having issues with this. I added the code to the on current event, and get a compiler error. Nothing happens if i have it just on the AfterUpdate(), BeforeUpdate() or any update! below is the code i have Private sub ClientGender_AfterUpdate() If ClientType = "Private Individual" Then...

edited sorry for not paying attention/having muddled notes Trying that now, thanks for your reply

Good Afternoon I want to disable a field (ClientGender)in a form (called frmSales) if ClientType does not = "Private Individual" , iv done this before and remeber it to be reasonably simple but that was a while ago and im afraid iv forgotten nearly all i knew about VB (i was never that good at...

wouldnt a Mail-Murge from excell surve you better in this situation? if i follow you correctly tho if you dont want to do this perhaps make a report based on a query like select Name, address...etc from Tablename where subject = XXX (i know its not perfect but too tired to think) hope that helps

Belated thanks to both of you for your help I shall try both methods and see which one i feel better with Im rusty on my VBA so relearning it aswe speak, so many pose one or two more questions if it all goes horribly wrong