Search results

Ok so more details. There are 2 designs that are used in the area I work in. Design 1 and Design 2. Design 1 will always be used when printing off signs, but in some cases we use design 2 to indicate an overflow location for the part that design 1 indicates. The text box, when a qty (say 2) is...

I'd like to have a qty textbox to show multiple copies of the second variant that I would design with VBA code.

Hey geniuses! So I've got a sign generator form where I can generate signs. I would love to have a text box where I can enter in how many I want of a different design. i.e. if it that box was empty, it would only show the normal design, but if the textbox had a qty in it, it would show the...

Hey guys, Seeing the viability of this, and I know the geniuses here can correct me. I'd like to see if theres a possibilty of a user pasting in the direct network path to an image and having that networked image show up in a specific place on a report upon export. Would this be done with VBA...

This nearly works perfectly! When I hit save, It pulls the ID number of that material I listed and saves it to the table instead of the Material. Any thoughts? Solved it! Changed the bound column to 2 and now it works perfectly!! Thank you!

So I would make the "Material" area a combo box and then the "location" and "Pick Aisle" area would be Dlookups?

that is EXACTLY what it was!

Alright wizards, Got another one that's been stumping me. I've attached a sample database to help with the explaining. I'd like the "location" and "pick aisle" fields in the form to auto fill based on the "material" field which my users will add in manually. I've got the dlookup function to work...

That solution worked perfectly! Now all i need to do is figure out how to stop every other report item from being light grey Thanks @arnelgp!

Thanks everyone! I'll give it shot when I get back to a computer and report back!

I have not tried the on format event! When I added the code as a module before, the text fields would throw a #Type error back.

Hi guys! I've been beating my head against this one for a while. I've got a query with a report attached to it to generate signs for my workplace. How would I go about showing or hiding 2 caution signs based on a yes / no checkbox? Is there VBA code for this? The table underneath has a Yes/No...