Search results

Hi arnelgp, am I correct in assuming I wouldn't need a subreport for this to work? Would you be able to expand on your explanation of your idea, as I am unsure what to do on the Detail's Format event using the recordset from the query? Thanks.

Hi all, I am using a report to create a custom layout for printing onto labels which stick onto pallets. Each label can have up to three product details on it and the report is grouped by pallet number. The report detail height is fine when a specific pallet number has three items but if the...

I understand what you are saying that it is too late to use logic in the unload event so I'm a bit confused now because what I have done in the unload event seems to work. The form closes if a new record hasn't been created (i.e the autonumbered ID field is blank) and if an incomplete record has...

I've tested with different scenarios and it seems to be working fine. I do have a continuation of the code which uses message boxes if vital fields are blank so the user can't close the form until these fields are entered. However, this new code is used when the user opens the form (possibly...

It was a simple fix in the end but took me a while to think of it! Basically I just wanted the form to close only if it was blank which meant the ID field would have to be blank so I used this code: If IsNull(Me.Ordered_Item_ID) Then Cancel = False Exit Sub End If

I've actually thought of another way around my problem without needing this code. Thanks for the suggestion anyway, Bob.

Hi all, I am using the below code to check if fields are blank before closing the form. However it's not completely what I am trying to do as it will still close the form even if only one of the fields is blank. What I want it to do is to only close the form if ALL the fields are blank. How can...

Bob, I wasn't aware of the term 'cascading combo boxes' before, but now I am I can see this is a frequently questions issue. I have tried some techniques to get this to work, such as in the link you provided, but non have been successful so far. Are there any alternatives to using cascading...

@Uncle Gizmo , I am unable to get your website to work. My browser says the website redirected too many times. Clearing cookies hasn't helped. Please can you explain how the pop-up form works for what I am trying to achieve?

Hi all, I'm looking for some advice on how to solve an issue I have with the combos in my subform. I have attached a screenshot to help me explain. I am using a query to limit the items in the 'Product Name' combos and then using this selection to limit the items in the 'Dimensions...' and...

I have the code all working perfectly now, so thanks Gasman and Isaac (and Fluff) for your assistance :)

Wow, thanks Gasman, that is powerful little piece of code. I don't really understand what the resize bit is doing. What does the 7 represent? I am getting an overflow error for 7*4932 but it works amazingly for a smaller number. Did you test it for 7*4932 and get an overflow error too?

Hi Isaac, Unfortunately I require some more help with this. I am new to VBA but trying to learn it so I appreciate you not providing me with the exact code straight away. I have followed your advice pretty much line for line and I have got an error. The error is with the line including the...

Hi, Can someone please help me write some code which copies C2 : D6 (including formulas) and pastes this to the next available row underneath. This will need to loop 4932 times. I also need the code to fill down columns A, B, F, G, H, I and J until the last row. Column A will need to be filled...

Thanks for helping me get my head around that, I understand what your idea is now. Next challenge is to populate the tables with 1000's of records! I think I will create the data in Excel and import it into Access, I'm sure that will be quicker. Cheers for your help, Minty!

I think I see what you're saying. Does that mean that the Products table and ProductComponents table aren't related directly but are indirectly through the ComponentsProductsJunction table?

Thanks for the help, Minty. Can I ask what the purpose is of the ComponentsProductsJunction table? Can the quantity of components field not go in the ProductComponents table?

Hi Minty, The formula determine what inventory item code and the quantity of that item are on the BOM. I tried to highlight these areas in the screenshots. There could be multiple item code possibilities for each product depending on the size of the product ordered. I'm not 100% sure what you...

Hi all, I am looking for some advice on what options I have to mimic in Access what I have in Excel. I work for a manufacturing company where we make bespoke fire barriers for walls and floors, as well as other products. A while ago I created an Excel workbook which allows staff to create a...

Thanks very much, I have set that option (y):)