Search results

Hi Chris, To b honest I can barely remember what I did. I do remember I used nested quireis in order to calculate out all the levels and that I could only go so far (4 I think). I was going to eventually try to code it but haven't gotten around to it yet. That is way over my ability and would...

so old I forgot the question was still here. Make a product so it has a bill of material, or buy so it has a vendor. Thanks Rock I will check that e z mrp out. i have made a pretty sophisticated mrp now ( 1 year later) but am refining continuously. Thanks for the response

Sorry guess I am not explaining correctly. The form is already open with a subform showing the component materials. I want to click on the component material and have the same form/ subform combination change to show the components bill of material. Can I open a form that is already open? Do I...

Thanks for the reply mailman. After looking up record set clone it just reinforces the fact that the more I know, the more I don't know. So to do what I want to do I need to create a record set clone then go to the record I have in focus? I'm sorry I don't really get it. When I opened a new...

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

:DThank you pbaldy that worked. I looked up bookmark property and understand it a little better but don't think i get it fully. Thanks again for all your help.

Sorry for the long delay with this but I got pulled off onto another project and am just getting back to this. I fixed the bracketing problem now the error goes to the last line and says Object does not support this property or method.:(

:confused:My label is vertical so I actually need to adjust the right margin. I found the correct margin dimension, .025", and it works if I put it in the properties box but when I use this code it does not work. Any ideas what I am doing wrong.

Is there a way to adjust my top margin? I can find the correct top margin spacing for each font size I specify, by trial and error, and set it accordingly.

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

Worked like a charm. So I don't put the value in quotes I use CStr in front. Can you walk me through why it worked?

Genius !!!!!!!!!!!!!!!!!!! Thanks Much

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.

Ok 95% successful My code The top comment was my attempt to have my message read with the number of labels to print included. Currently it says "Print Labels?" I want "Print 5 Labels?" where 5 is the user input (same as number of copies)

Thank you D-Fly. I had 2 problems with my code. 1st I had brackets around the report name and they should have been quotation marks. And I removed the = sign and added .value at the end and it worked!! Here is the code that worked. DoCmd.OpenReport "LabelShopOrderQuery", acViewPreview...

Thanks Trevor, how do I get the "2", for 2 copies, to come from a user input form?

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.

sorry, the error is unknown or invalid field reference Product_Number

I guess I messed up somewhere. Here is the code i put in. Private Sub Command75_Click() 'DoCmd.OpenForm "EditBom3", , , "[Product Number] = '" & Me.Product_Number & "'" Dim rs As Object Dim StringBookmark As String 'set variable to current record StringBookmark = Me.Product_Number 'open...