Search results

I have built a form and a report. However, what I want is to print the report with only the one record that's showing in the form. For example, workorder number 300045 is displayed on my form, I want to be able to print this but in report form. However, everytime I try to do this, all the...

I have been using the code "PWW" & Format([PWWorkorder],"0000000") in order to automate a workorder number. However, because this field is primary key it keeps giving me the error Index or primary key cannot be null. It's not throwing the number back into the table. How can I fix this...

I'm sure this is easy. I'm just slow. ha ha. Anyway, I have a combo box that lists vendor names. Now I want the vendor ID number to be automatically shown in either a text box or list box, whatever. I just want the ID number to show, that corresponds to the vendor name. Help! The ID and...

Hi! I have a form, let's say it's called form1. In one of the fields I have the OnClick set to open another form, form2. This form2 is acting as a list of values for the user to select from. My question is how do I get the information from form2 to be placed in the field of form1 based on...

I would like to automate the number in my form. I have the field within the table set to autonumber. However, I would like to place three characters in front of the automated number. For example, PWW000001, PWW000002, PWW000003, PWW000004 etc etc. Can anyone help me? It's probably easy but...