Search results

Hi @arnelgp I have returned to working on these pallet labels after spending some time on other areas of my database and I'm still not getting the results I would like. I have attached a screenshot of what's happening. Basically, it's duplicating the results by the amount of items that are on...

@jdraw This database isn't interim, it's more of an expanding database as my company realize the benefits of it compared to having everything on Excel. I understand that I should be using autonumbered ID fields instead of number or text datatypes but I would appreciate some guidance to...

Thanks for the advice and will remember for the future but I fear I might be too far down the road as the database has been split and is currently live in my workplace. The Product_Code field is used everyday for inventory purposes so this I why I decided not to change it after realizing it...

Hi, Product_Code is a number data type (I realized I should have had this as an autonumber later into the development of the database but it is working as a number without any issues) Suppliers Parts FK Product_Code is a Number Datatype Staff_Initials is a Text Field Customers_Ref is a Text DataType

@Gasman I had it in mind that the status would automatically update so that's why I thought tblOrderStatus would be updated using code. @jdraw I sometimes walk myself into projects at work where I think of an idea but then wonder how am I actually going to create it. This status idea has grown...

Text

@arnelgp I'm yet to get past this error, do you have any thoughts about what this is referring to?

@Gasman @mike60smart @jdraw thanks for this, I like the table structure in terms of normalization. My initial idea lacked structure which is why I thought I'd better speak to you guys about a better solution. As my idea was more simple (which is great for my limited Access experience) I could...

Hi Gasman, The warning messages sound like a good solution. I'm not sure what you mean by "That way if you ever get another mid status requirement, it is just a new record in the table."

Hi all, I'm seeking some advice on a good way of implementing an order status field for my Shipments table. This field will be displayed under the shipments section of the orders form to quickly show the user what stage of the process the order is currently in. I would like this to be a field...

After updating the code, I am now getting a syntax error (image attached). Combo0 contains '16710A'. Is this referring to the syntax in the code because the report's record source query is working? I can't see any issues with the code though. The field names you entered for the filter look to...

Would that be done by changing the code? I have the following as criteria on the query which is the report's record source to limit the number of records returned: [Forms]![Pallet_Labels_Shipment_Number_Pop_Up_Form]![Combo0]

@arnelgp your assistance with the above would be much appreciated, thank you.

Hi arnelgp, I have been away from this project for the past couple of weeks but thank you for sending the example database and it's great that you have been able to get it working. I have tried to amend the code to fit my database but I haven't been able to get the code working. My 'MasterID'...

I have attached a screenshot of the report (the one outlined in red is a separate output of the report to the one in blue). The one outlined in red shows what happens when only 1 item is on a pallet and I would like the height to be fixed to what happens when 3 items are on a pallet (as shown...

@arnelgp are you able to provide the above advice on your idea please? Cheers.

Thanks for your help theDBguy, but I can't make this work with my set up. It's a lot more complicated than the example in your blog and although I'm getting the expected results in the query, when running the report it just looks like duplicated records for each pallet number. I'm struggling to...

Haha, ok, I'm misunderstanding what the Cartesian Product can do. It's difficult for me to attach the database for you to test because it is live as a split database for the company I work for. Do you have any pointers for me to go in the right direction on how to use a Cartesian Product as in...

Thanks for explaining, I see what you're saying. Where would the blank item come from in your example for pallet 2 item 3?

Hi theDBguy, please can you explain how you think this might work as from my understanding wouldn't it group all items on each pallet number?