Search results

I have very little knowledge of VB and am trying to do a stock controls/sales/purchases system on a database - have found some code in a text book that seems to solve all my problems but it doesn't want to work. I get an 'invalid Null' message when I use it. I assume that this is because there...

totals query Phew - that's a relief Thanks again.

TOTALS QUERY I have been using both access templates (order and inventory) extensively, but not that easy to take apart if you don't 'do' code! Have got all working so far - sales, invoice etc. Thanks for the help and advice, one more small thing this has to be networked will it all be Ok if...

totals queries I am finding that out the hard way - still it's good to learn. That ref is very complex and as you might have guessed I have no VB or SQL skills at all, do I just copy it out ? changing field/table etc names?

stock calculations Thanks I will study that (when the rug rats are asleep), the problem is that I am doing this db for a builders merchants and they need to know what stock (in the yard) is available when customers ask. This will save them going to the yard to look! thus saving lots of time...

I have very limited knowledge and I need to extract data from sales transactions so that I can update stock levels. I can do the extraction bit with StockID , stocktransactionid and quantity in a query. This results in a list of all sales, some stock lines have been sold on more than once...

blamk fields in reports My lack of knowledge is even worse than I thought - I didn't know you could have sub reports. I will go and play - thanks again

Thank you for that help I have posted a new thread on reports - having got the form to work I cannot get Access to return a value for Sales Price on the invoice report - this is obviously essential

I have spent the last 4 hours trying to work this one out - I have a report (invoice ) which is based on a form with subforms etc. I have prepared a query to base the report on but it will not show the sales price. Having tried everything I know I give up and ask for help please. The report is...

Control Field Brilliant Thank you very much. I have one more little problem now, I have to calculate and add VAT to all sales and then deduct payments. I have this all working fine, BUT some calculations result in a -£0.01 balance. I assume that this has something to do with the VAT as this is...

I can't get my database to do a Sum of all product trasacions - I have used formulae layouts etc from Access templates but they don't work. My knowledge is limited any help gratefully received d/b attached

calculated fields Thank you sooooo much - not very good at sums either I should have been able to do that

Help! I have no VB or SQL skills - just Access and simple macros, I have to design a database that does sales/purchaes and stock control. I can do most of this with macros and queries. However the client has some customers which are exempt from paying VAT and some which aren't. I have a...

I am fairly new to all this - did an IT degree recently but it was more theory than practical. Is there an index to explain what the command codes (far right) in the expression builder box do?