Search results

I didn't always feel this way, but I now agree with the mainstream - storing and updating a stock figure isn't as good a solution as calculating stock based on the sum of transactions. If you calculate stock based on a starting figure (opening stock, initially zero) minus* any subsequent...

Someone is going to ask this, so it might as well be me... Please could you paste a copy of your code into this thread? Ideally, the whole of the sub in which the error occurs, as the declarations might be relevant.

Based on what kind of data?

I agree. Assuming this is a project to try to normalise your data (and it sounds like it is), you might have to do it in a number of smaller steps - if it's a one-time conversion of a legacy database into something more robust, then this is one of those occasions when it's quite OK to store...

Not sure it would help - I expect at least some of the spammers attacking here are not doing so in person, but are just unleashing a bot on a list of sites. But Bayesian or even keyword filtering would be quite effective - if any three items from a list of phone brands appear in a single...

CanvasShoes is a member (well, registered guest, which means the same thing there) in good standing at the Straight Dope Message Board, as far as I can see (I'm a regular there myself, posting under the ID Mangetout). The standards of board etiquette at the SDMB are quite considerably more...

Really, that's just a pretty simple data capture job. Almost any kind of handheld scanning device should be able to do it.

The 'zero' bit refers to its default behaviour - if no substitute value is specified, it returns a zero or zero-length string. (well that's what the help says, I have a feeling that it doesn't automatically return a numeric zero for a numeric null input) I wasn't aware of the optional...

Are you expecting the device to be able to ask different questions depending on the identity of the item scanned? (within a single outing)

I've had to set up barcode scanning in several of my past jobs - mainly for stocktaking. The best handheld barcode scanners I ever found were these: http://www.barcode.co.uk/products/metrologic-scanpal2.htm Reason being: They're compact, light, rugged, have excellent battery life (from AAA...

Nz comes from 'null to zero' - meaning it converts on the fly.

It is possible to force the record to be updated, even mid-way through editing a row, by manipulating the Dirty property of a bound form: If Me.Dirty then Me.Dirty = False You might do this on a timer event (not recommended though), or you can do it on a focus event - when the focus moves...

Beware of reporting your own posts for any reason. I did this the other day (there was a thread with no opening post, so I posted in it, then reported my post to bring it to the attention of TPTB. Next time I tried to log in, I had been banned. Interestingly, when you're banned, it becomes...

I used to have arguments with my previous boss about this sort of thing - he had designed a program that had forms laid out in such a way that they didn't work properly unless the windows desktop properties were set just so - and he wanted the program to set them on opening and put them back on...

These thoughts had crossed my mind, but in a slightly different way. A program that tries to do these things may end up being identified as malware by heuristic security programs - so even if the motives are all completely innocent, it might fail badly in the real world. My take on these...

I appreciate funding is probably an issue, but if I was in your position, I would probably be looking to contract a web developer to write a PHP front end. Alternatively, you might be able to find a bit of open source group working software out there that already does what you need - what kind...

I think Access may not be the best tool for the job here, but I'll try to explain this bit anyway... Access deals with files where tables, forms, reports, queries and other objects are all stored in one big container file (you might see this referred to as an MDB, or ACCDB, because those are...

My question:

I typed out a lengthy reply and the message board software ate it... Grrr... I'll try to remember what I said.... Which field(s) in these tables are you looking to use to relate them to each other? It doesn't look like it should be ID, as this appears to be just a record identity not relating...

That's a more decent reason than anything I had in mind, but still... if it is that, it seems like a workaround that probably means something should be done differently elsewhere in the application.