Recent content by ablim

Hi all wonder if you could advise on this problem I am having with a database I inherited. Not experienced with code so not sure why I'm getting this runtime error Usual kind of thing, click a button data imported from CSV which should be being updated/appended to tables. It initially looks...

Thats access letting you create a monster of query the shorthand way. Because you have options (the OR bit) in your criteria access separates them out into seperate bits. I had one with 3 category levels and that was scary enough! This is what i think it does, i could be wrong but here goes...

Thanks, I did look into the TOP SQL statement but its too rigid. I need to be able to vary the the number of top items dependent on the stock level associated to the stockid. i.e. if i have 5 in stock of Item with stockid 11111 and need to return the last 5 dates and if i have 3 of stock item...

I have a query that returns a set of records which details stock items that are older than a date given in a form. However i need to limit the results to the number of items held in stock i.e say i want to look at stock over 1 year old, i get a list of all the stockids, and the date added. Say...

Yes I'm affraid it does cos there will be some further development at some point to delete indvidual records before printing the list, tho that is a good idea for a temporary measure

...seems such a simple thing to do but I'm completly stuck. Everything I've found on the forum suggests alternatives to doing to above i.e. setting the query that produces the list to produce that report print directly but that wont work for this situation unfortunately.:eek: Some...

FoFa thanks for you help buddy, I got it working when I set up the option group Thanks :-)

I have had it working but only when I left out the [Forms]![Frm_randselection]! bit and manually typed the Head Office when the prompt came up. is it ok to leave the Else statement out for now?? I'm going to put some error handling in there later for if they dont select a branch...

I think I get it. So in plain english I'm asking it to do is check whats in the option group/combo box to see if it is "Shop1" (ie stocklevel_1) & use the StockLevel_1 column if that condition is true, if not it checks the next statement. I'll give it a try thanks :)...

Looking at the help access gives i can't see how that would help me They give: This example uses the IIf function to evaluate the TestMe parameter of the CheckIt procedure and returns the word "Large" if the amount is greater than 1000; otherwise, it returns the word "Small". Function CheckIt...

Any help or advice on what to search on would be appreciated please I have a table with the stocklevels of all my shops Fields (PLU, Stocklevel_1 to StockLevel_6..) Currently I have a form with 3 category levels which set the criteria in a query so I can gereate a list of 50 random PLU's as...