Search results for query: *

randysmid Also, in addition to adding the record from first table (A)/form to second table/form is it possible to have an error message if the part selected is already in second table (B)? Thank you for your time randysmid. hytina

randysmid I noticed a possible problem with the program and would like to know what you think. It seems to only transfer the ToolID number to the next form if the the ID is in both tables of both forms. In my case I will need to add a tool from 1st form/tbl to 2nd form/tbl. Once the new tool is...

Thank you. This is working beautifully. I appreciate your help. I had put the wrong name of the field for the select form [ToolID] s/b [Combo3]. [bigsmile] hytina

Thank you for replying randysmid. I am working on your suggestion today. I have just a couple stupid questions. One, do you suggest adding this code to the 'OnClick' property of the combo box on the form that is used to select a ToolID? Second, DocName, is that the name of the form I want the...

Hello, I have a form with a combo box that allows the user to select a part number from a list that is a query of table 'A' and when the part is selected I would like it to drop into the next form which updates table 'B'. There is a macro on the combo box located at the OnClick of the form, I...

Thank you for your response. I have tried the note in the footer of the subform. The only down side to this is that for every part number added to the req rpt a note will print. I was looking for a way to put one memo for the entire rpt. I had tried your second idea,in a somewhat different way...

I have a form used for entry of prototype parts and on this form is a subform used as a purchase requisition. These forms are connected through the ptp number. Once the req is filled out the user can print the req. More then one ptp # can be on a req.. Once the report or form is closed we run a...

Thanks!!! I have to tell you I screamed when I seen it work. Simple fabulous.

I need to "hide" a field(s) on a report based on criteria in a form, is this possible? The fields in the report are label and line fields. If the form user enters a 2 in a field we would like to "hide" a authorization field that is not needed for this selection. There are...

Thank you FancyPrairie for all your help. This morning I took another approach and it worked!! I can't tell you how happy I am. Why I din't try it before I'll never know, but like I said I am AMATUER status. I used the after update on the customer key(ID) combo box and typed in the following...

I finally figured this out. In the combo box row source I set up a query that selected the data I needed out of the customer table, set bound=1, column=2. Then I set up a text box with control source linked to the combo box and the column with customer name...

I had adjusted my column widths, and I can see both of the columns on the drop down, but once I select the item, only the first column which is the customer Id (& is also a PK in its table) is the only column that is visible on the form. I did notice the option to hide the PK on the wizard...

I am a amateur Access 2000 user so this may sound too basic for most of you but here goes.. I have a form that I need to add a combo box to that allows the user to select a customer by customer key (ID), it would also display the name of the customer associated to the customer key. I am having...

I am new to Access 2000, but have recently implemented two types of searches. I use the parameter query to search for part numbers by description and I also have a macro that I use to search for a specific number. These are set up as commands on my switchboard. Do you access your table through a...