Search results

I haven't done anything with Access for a long while but my last big project, a stocktaking DB, is still working like a charm. It's still my daily workhorse and has kept me going for the best part of ten years so absolute kudos to all the knowledgable folk here and the few who I drove potty...

Need some help with a message box if possible, thanks in advance. I have a text box that the user enters a number into between 1 and 5. I can use the validation rule in the table and that works nicely, the trouble is that I don't want the standard Access message box. I've read through the...

...are, I fully accept, the work of the devil. So what do we use instead? My last database ran into some issues because of my clumsy/inept design and probably the biggest mistake ( among many :) ) was using lookups to reference one table from another. I want to get this one right from the...

Hi all, I'm trying to filter a form and really struggling with it. I've spent some time searching the forum and tried the various solutions posted and can't get it done. I want to filter products based on a checkbox, so a list of around 1000 products filters to show only the 100 or so 'active'...

Hi Guys, I hope I can explain this properly. I have a stock and audit database setup with a folder called 'Outlets', within the outlets folder there are many sets of tables storing data for the various sites we work on. In a separate database I have a scheduling setup which holds site...

Hi all, it's dumb question time again :) I'm trying to get a field in one of my forms to calculate a total and write the total to the relevant table. I would like it to work like an excel spreadsheet, number '+' number then 'enter' gives a total. We enter till sales data and there may be...

I had a conversation today about PDAs or handheld computers and it got me thinking that I may be able to use a handheld device to speed our process up. We are stocktakers, so traditionally we would use printed count sheets and write down counts as we come across them. We may find the same...

I don't know whether this is a query or table question, so am trying it here first. I have a stock movement/consumption database and want to add cocktail recipes to it and am struggling. I have attached a JPEG of the product table which is where everything lives. What I want to be able to do...

Hi All, I wonder if anyone can help me with an odd problem? I have a stock consumption database that I add functions to quite often. I've just added another function and am now seeing some odd behaviour when I run one of the append queries. The query is supposed to move the closing stock...

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...

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...

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.

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...

It's almost two years since I registered here so about time I introduced myself. I work in the licensed trade, pubs, clubs, hotels etc., and have found databases a great tool. I first started asking dumb questions about a stock control utility back in 2008 and it was up and running fairly...

I'm sure this has been asked before, but I have searched and can't find the answer. I'm writing a simple invoicing utility but want the VAT rate to be variable. I have: tbl_invoice and tbl_vatrate. The VAT rate in the invoice table looks the rate of from the VAT table. The problem is that...

Hi guys. Probably dumb question time again so apologies in advance if that's the case. I'm building a risk assessment database and it's going quite well, but I'm struggling to get the reporting to work the way I want. I have a form that adds data to my table: frm_risktype & tbl_risktype. What...

I have a stock control database and am starting to want to tweak it a little. We often work in dozens and have always rounded up or rounded down so that our closing stock will go to one decimal place, 23 would be entered as 2.0 while 22 would be 1.9 What I would like to be able to do is...

Hi guys, I wonder if some of you clever folk could help me out again? I have a stock control database that I'm very happy with. When I need to set up a new site, I just copy the database and re-name it. All the databases sit together in a single folder called 'Stocks'. What I want to do now...

Bit of an odd problem, but I'm hoping someone has the answer. I've converted my 2000 / 2003 DB into 2007 so that I can use the developer tools and create a package. Before it's packaged, all the numbers and reports appear as they should, but when I create and install the package a couple of my...

I have converted my DB from 2000/2003 to 2007. It's gone very well and everything seems to be working, but I have a problem with a couple of my forms and could do with some advice. I have two forms that I use in datasheet format, when they open up in 2007 format I see lots of drop-down menus...