Search results

Hello All, I have a bill of materials form with a search box up top that will give me the components and usages of top level products in a sub form. Some of these components themselves have bills of materials associated with them also so what I want to do is be able to click on the component...

Hello all, I have a report (label actually) that i need to print and I wrote some code to adjust the font size based on the length of the text so it fits on the label. My problem is the text is always at the bottom of the text box so when it is small it doesn't look right. Here is my basic font...

Does anybody know of a way to format an unbound control on a report to always show a unit of measure. So whatever number is put in shows the ' foot symbol or " inch symbol. If I put it in as a label it doesn't stay aligned if the number changes digit size.

I am keeping track of production in access assigning lot numbers to products. I need to print labels for bins of products I make. I have created a query to give me the specific lot number I need to print, a form to feed the query and a report to print the labels. My problem is I want to have a...

Has anyone tried printing to a Dymo printer? I am having trouble printing basic address labels. When I print preview the spacing is not correct.

Novice Macro question. I have a subform open in datasheet view. I want to click on a cell with a tool number (text) in it and open a tools details form showing that record. I created a macro, on the on click event in that cell to open the form but I can't get it to open on that record. Probably...

Hello all Been using access for about 6 months now and working on an MRP program (see Queries question MRP database) and would like advice on a good VBA book to learn the basics. Thanks for your input. aa

I am trying to create a material requirements program in access for my company. I have multi level bill of materials and have a bom table and a bom details table with the component material usages. I pull the top level demand from a customer orders table but I can only get a single level by...