Search results

In Access you can just write an append query and force the ID to be written as any arbitrary value, such as 3. I think SQL server for instance won't do this behaviour .

@jwcolby54 I am not trying to do anything. I was just discussing some points raised in the thread. I never try to ascribe "sense" to an autonumber. If I want an intact sequence, I use an appropriate technique.

This bit. That's not correct. The order of the autonumber IDs corresponds to the order in which records were inserted. It's not random. If you insert records to fill gaps, then that's no longer correct. That's the point I was trying to make.

You can poke/stuff autonumber IDs into a table to fill gaps, but then your records won't be in the logical order that they should have been.

@dullster If you want the record ID to be kept in sequence and the sequence to be intact, then you can't use an autonumber. You need to manually control the sequence. I imagine this has been pointed out already. You also can't delete records, or you will get gaps.

Well FIFO comes into it because if you buy your widgets for 1.00, then the next lot are 1.02, then 1.05 the cost of the inventory should be evaluated by counting back the cost of the most recent orders. (Starting with the 1.05 batch). The corollary is that the absorbed cost of sales/production...

For what it's worth, an AI answer gives the following as acceptable valuation methods for inventory under International Accounting Standards. My understanding is that FIFO is the generally accepted method, although I no longer have to deal with such issues. Edit. Although there are other...

Quantity management of inventory is straightforward. Cost management is decidedly not. FIFO is the method that meets accounting standards, but will be very hard to code, because you need to manage the sequence of both goods received and goods issued.

Me too, I don't need the wizard.

I don't agree that there is no need to create an accde of the front end. If you want to protect your design elements, it's well worth doing. It also prevents users modifying the front end.

In passing, it's quite handy that rich text is still just text, so a rich text string will still be displayed with any Access version.

I was able to put together an image display function, but I can't recall where everything came from. It took a lot of fiddling to get it working, and in my case it takes a few seconds to show an image, but it is working now. It uses WIA - a reference to Windows Image Acquisition library. It...

The other day I realised that all the files in my documents folder C:/users/myname/documents had moved to my OneDrive. I must have clicked something to move them, but I can't think what.

Thanks all for the responses. @plog I think that sort of nails it. I had wondered whether Power BI could replace an Access database of itself, but it doesn't sound like it can. We currently generate reports etc using a dashboard/menu system to select pre-defined report examples. The...

@theDBguy Thanks Guy. I sent you a PM.

Someone at a client mentioned Power BI yesterday. Is that a useful addition to an Access based system. Does anyone have any useful explanatory links please?

Yes, but doesn't that mean you have to modify inside the form to call the appropriate function and determine what privileges are needed to execute the event? It's easy if the atomic event is "the form". It's much harder if each form contains multiple decision points. Don't you also need to...

There's two levels of security, if you will. The bit that's easy is managing access to a form. Design a set of user groups, and and users to those user groups. Then limit a form to a membership of a particular user group. That's easy - as all you have is a function in the open event of a...

@MarlonVisser0408 The trouble with spreadsheets is that they don't offer you the strong data-typing at the column level, that you get with a database field. Their really is no comparison. It's pretty bad that spreadsheets get used for all sorts of things where a database would make much more...

As an aside, if you don't really need 12dp accuracy, you could use currency format, which stores reliably to 4dps.