Search results

It is worthwhile to check whether you even need such files. Unless the application inherently involves images, you may be able to reduce the data transfer. For example, sending the information needed to create an invoice rather than an image of the invoice.

You need a transaction table that records everything going in and out of inventory. Then you have a full audit trail. Transaction table would have autonumber key and reference the information you are tracking. The inventory in a location should be the sum of all the transactions, even if you...

You can have a default Supplier ID in the Product table. That can save time when creating orders but does not prevent you from using a different supplier.

Both computers are using 64-bit Access. Maybe there is OS compatibility problem with 32-bit ODBC administrator? I am going to try to upgrade that.

I recently got a new computer. When attempting to connect to a linked table in Access, I get the error ODBC--connection to <database> failed. It works fine on the old computer and the ODBC configuration is identical. When I test the ODBC connection from within ODBC Data Sources (32-bit)...

I was able to get everything to work. Thank you all for your help.

That works. Here is the result: Is there any way to get the image to center? The images I will be using may vary in size. The image seems to on left side of the control regardless of what I do.

How do I set the z-order? The image seems to block the text box, even if the text box is transparent. I am printing counters for a board/miniatures game, so space is very limited (1.5" x .75").

I have an application where each record has both text and an associated image. I would like to print both the text and image on top of each other in Access (in the context it should be legible). Is this possible in Access? I suppose that I could create 2 reports and run the page through the...

I have a business requirement that poses an interesting design question. My company makes dyes that detect leaks in fluid systems. All chemicals require an SDS (Safety Data Sheet) that specifies safety information about that chemical. The SDS is produced by specialized software, so I need to do...

I hope that the 2 million record table is not an Access native table. Such large table should be in heavy-duty database like SQL Server and linked to Access.

I do this sort of thing frequently. First you need to create some tables which have the correct fields you need to process the orders. Make sure you have a field for recording errors. You should also have a consistent place were you save the spreadsheet and link to it. The steps are then. 1...

You need at least 3 tables: Gauge, User, Calibration Gauge would be all the information you to describe the gauges. Your current Gauge ID# field would be the primary key. User is the Employee Names you already have. The Calibration table would be information you already have in columns D...

2206 is a beta build. How far should I roll back to fix this issue?

Thank you for making that clear, I was not aware of this being an Access bug.

If you delete a field in an SQL Server table, that can cause #Deleted issue when viewing the table in Access.

I did a web search on this, but no one had the same issue. People had some records or some fields with #deleted but no one had all fields & records affected.

I am suddenly getting values of #deleted in all fields in tables connected to 2 different SQL server databases, which have functioning for years. This affects most of the tables in the databases, regardless of the number of fields or records (I have 13 record, 2 field table that is affected) but...

I will check the Access build numbers when the user is off the system. I tested the same front end, not a copy of the front end.

Same front end & back end. Both are Windows 10.