Search results

My database works 99.99% of the time. Once in a blue moon I get an error and this is usually rectified when the user restarts the database. Most of the time I'm not there to see what caused the error. Is there a way to suppress the error, log it in a table with the form name, error code and/or...

Good day all, I am trying to add an Item from a list of Products to a set of buttons on a form for quick selection (like in a POS System). It works somewhat but every time the db is closed the Buttons loses the bindings. See the attached db Form SaleF.

In post #9 I noticed that ResLiblD is the PK in 2 tables. Is it a typo?

@Imb this statement ☝️has a lot of significance. I DO NOT want to discourage you at all in achieving your goals but when I was younger and started out development I too wanted to create a well rounded database solution to fit any and all needs. The problem is that every time I implemented...

Preach on brother, preach on. 👏👏👏 This is my biggest workplace issue and how to translate this to management and worst of all I.T. This is why I like MS Access. It is customizable and not bloated and restrictive like many out of the box solutions which, from what the op described, is what @Imb...

Sometimes I like to use a helper column. Make a query and concatenate all the columns in both tables and call it KEY or something. Then using the query wizard, make a query with the "Find Unmatched Query Wizard" option and use the KEY field as the matching/difference criteria.

@Pat Hartman you want the imported data in one column or one cell? The method suggested by @Edgar_ will give you more flexibility on how the data is imported.

This is poor database design though. Use forms and comboboxes to achieve this.

Check this link @iamchemist . It help me with some of the issues you are describing. https://www.devhut.net/ms-access-persistent-connection-in-a-split-database/

So I made some progress. I redesigned subfrmSales and put the code to give a breakdown of the total after the Quantity is updated. By default the Quantity is 1 as a new item is entered. I think I can tidy up the code a little, really don't like all the IF statements.

Curious, how would you price 3 units? I'm thinking if the customer can rationalize that 3 units would cost them more per unit than if they just purchase one more then they opt to purchase 4 units. But I understand that the pricing structure should be like: 1 - $175 per unit 2 - $170 per unit...

In the attached db, the query ITEMDETAIL is the current price for all Items based on Quantity. It uses this query to get the latest/most recent price based on Max(EFFDATE) SELECT d.UPC, d.QUANTITY AS LQTY, t.LDATE, d.PRICE AS PPU, d.VAT AS LVAT FROM Prices AS d INNER JOIN (SELECT UPC, QUANTITY...

Post #8 has an example of special pricing on Item 7312040017010 Post #1 has the Item Price (PPU) by Quantity for Item 7312040017010

This is not the regular pricing system. I am trying to develop a method for specials/deals on certain items.

I was just thinking (just brainstorming here) that for 11 bottles of 7312040017010, if the user enters directly in the text box I can undo the record entry and open the popup. There the actual calculation will be done based on the Price Ranges So the available quantity ranges for Item...

I've attached a sample db. The form subfrmSales is where data entry will be done. Double-clicking the Quantity field will open up a popup to change the Quantity. This is where I need the help. On changing the Quantity, depending on the amount, say 11, it should fill 3 records to...

The ITEMDETAILS Query gets the most recent Price and last Cost from these two queries Latest Price SELECT d.UPC, d.QUANTITY AS LQTY, t.LDATE, d.PRICE AS PPU, d.VAT AS LVAT FROM Prices AS d INNER JOIN (SELECT UPC, QUANTITY, MAX(EFFDATE) AS LDATE FROM Prices GROUP BY UPC, QUANTITY) AS t ON...

Need some help getting the Current Price for an Item based on Quantity purchased. This is my Item Latest Data Query: SELECT Product.UPC, Product.PNAME, ITEMCOST.CPU, ITEMPRICE.PPU, ITEMPRICE.LQTY FROM (Product LEFT JOIN ITEMCOST ON Product.UPC = ITEMCOST.UPC) LEFT JOIN ITEMPRICE ON Product.UPC...

Windows 11 ughh. Terrible upgrade to deal with MS Access databases. If possible roll back to Win 10 and make sure you're hardwired to the server, NO WIFI.

All this can be done with power query. VBA may not be needed.