Recent content by raziel3

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...