Search results

I have one table that contains all the base data for parts that I have. Numerous fields identify a part. No one category can 100% define it. I have another chart that I want to link to each part in the main table. I am going to be inserting values as parts are inserted or removed for use...

I have parts that go into and out of inventory. Each time a part is removed or returned, the user inputs the number into the computer. I was wondering how I could link the numbers so that as parts were removed or added, the total number in inventory and the total number on the floor...

I have a part that is specified by two categories--type and spec #. I have multiple of each part that I need to chart the in and outs of. I was trying to create a form that would give the part and then have a subform in it with which I could see past transactions along with insert new data...

When I set up my chart, I made the part number of pieces the primary key. I then made a form in which I could look up or enter the data that goes along with the part number. I used a combo box so the user could type in the part number and find the part in a list of all the parts. After...

On my forms, I have a button that prints that specific record which works great. Now I need to print page "____ of ___" only if a certain criteria is true. I know how to always print it but is there any way I can print it at certain times and not others? Thanks

What do the validation rule and validation text in the properties box do? Thanks

I am inputing data into a form and then printing that sheet from the form directly. It is working great for that as long as I input the data and print the form immediately. The trouble comes though when I am trying to find the specific form sheet again to either make changes to it or to check...

When I print queries (and maybe forms) I would like to have the date printed on the sheet so I know when I printed it out. How should I do this?? Thanks

Every time I put in an entry, it rounds the number. It will not allow any decimal places to be shown. It is extremely frustrating since many of the entries I need to put in are specific dimensions with decimal places. What do I need to do to make it stop rounding all of my numbers? Thanks!

Ok my goal is to have a calculation in a query that includes a bunch of addition, division, and multiplication. (It uses 10 pieces of data) I tryed typing it in the expression builder but it doesn't work. I don't know if I am setting it up wrong or putting it in the wrong spot or what. I've...

I would like to run a query and then be able to edit that information. I want the data I change to be put into the table the info was gathered from. Right now when I edit the query data it only saves it there, not on the other table. I tried to do the copy to table but the original table was...

In my chart I have a yes/no field that I would like to set up a query to for. I want the user to be able to input yes or no and then the data be displayed. Whenever I enter yes or no when the prompt comes up, I get an error saying the expression is typed incorrectly or the data is too complex...

Is there any way I can do a search that lets me put in a section of a part number and the part number be found? I only see how I can find the number if I put in the entire number. Thanks

:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks

I would like to put a query into a form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping.

I would like to put a query into my form so that I can look up a part number, order number, or both, and then open the form for editing. I set up the queries but can't get them into the form. How would I go about doing this? Thanks for helping out

I would like to put a query or some look up device into my form so that a certain part number can be found and its form opened for changes. How should I do this?

I have been working on this for hours and I can't seem to find how to take the data I input into a form and have it appear in another table I had created earlier. I want to be able to pull the data up from either source and then edit it. I can put the chart into database mode but that isn't...