Search results

Thanks again Bob. I'm just fiddling around with it again, this has given me a good starting point

Sorry, should have said, Access 2007 now.

Thanks Bob. I've been trying all sorts of things but am not clear where to start. To be clear, would the 'filter by form' command be applied to a query or a table? That's what I'm looking for. I don't think I need anything overly complex but, as ever, I'm out of my depth and struggling :)

Hi guys. I'm working on a relatively straightforward database to store product cost prices. I might have a product that comes from 3 different suppliers at different cost prices, what I need to do is filter my results by various criteria; product, category or supplier, in order to determine...

The problem is my lack of knowledge and experience :) I will have a look at the product table and filters as suggested. Thanks for the code, I'm trying to soak up as much info as possible and this really helps.

Hi All, hope this makes sense. I'm trying to set up a PLU comparison report, it will compare till sales to consumption through a stock movement report. The consumption is in a query, which draws its information from a product table. What I want to be able to do is report on a user-specified...

The dates don't do anything serious and are not calculated in anywhere, just simple opening and closing dates. I wanted to add one in that place because I have a 'date diff' that counts the days off in the table. 'How do I add one?' 'Have you tried '+1' Steve??' Classic.

I feel such a muppet. I tried a couple of searches and it was all SQL strings and tricky stuff, it never occurred to me to try the simple approach. Thanks for help, thanks for not laughing...

Ha ha, it works. Sorry, that has to be the dumbest question I've asked so far :o

Can't be that simple can it? :) How dumb will I feel if it is...

I have an update query that I want to add one day to. Is it straightforward or am I trying to add the date in to the wrong place? This is what the query looks like at the moment, I just want it to add one day when it updates the table. tblJob![Closing Date] Thanks for help.

I'm wondering if you should be looking at this in a slightly different way? Having been registered here for a while now, I could possibly be persuaded to pay a membership fee but, I'm fairly sure that if I had needed to pay a fee to join in the first place I would have passed. As has been said...

I need to spend some time on this, but the search fields look good and I'm sure I can work that kind of thinking into what I'm doing. I started off wanting a simple invoicing utility and am already seeing the possibilities of extending it into more of a data collecting and book keeping...

Holy crap, that's quite a piece of work!

I'm very interested :) there is just so much to learn. I've got the invoice printing nicely now, if I could resolve the search/history bit I would be very happy. Thanks for help.

The basic structure is there already, and I can print the invoice as I've created it. What I'm trying to do is generate a list of historical invoices and be able to re-print or re-send them. It's a service rather than a supply invoice, so we are looking at hundreds rather than thousands of...

So a form separate from the invoicing form itself? Then a text box that allows me to select a single invoice from the ones I've created? Clearly, the answer to this lies in forms so I'm further on already.

Ok, so forms/sub forms are the way forward? I will start there, thanks

Thanks to the great help already received I'm much further on with this. True to form though, I'm stumped. I can now produce invoices with the variable vat rate via a fairly simple form/query/table structure. What I can't do, and have struggled with for hours, is pick one invoice from the...

Every day's a school day with this stuff, there seems to be so much going on in the background; nothings simple!