Search results

I imagine the issue is that the 64 bit is now the default, and not many people need to deal with the differences. I have apps in use that's built in 32bit, and I don't want to try to convert it to 64, so users have to install 32bit office to use the databases.

Transparent buttons are still clickable I think.

If you don't set a database as a trusted database/location it will always warn you when you open it. The runtime doesn't let you set it as trusted, so you have to authorise it each time it opens. It's a minor inconvenience in order to use MS Access as free software, I believe.

I agree with this. I'm sure I've seen error messages like "you can't set the focus to a hidden control".

An arbitrary number. A specific number rather than the next autonumber provided by the seed. As I say, I don't think you can do this with SQL Server.

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.