Search results for query: *

MajP - Thanks for your help. Your code does clear the next form and allows new info to be added, but is there a way that the new record started on the previous page will populate the next form with the same DWG# and DWGREV information?

I have several forms with subforms that are synchronized using the DWG# and DWGREV fields of each of the tables. Everything works fine until I try to add a record using an existing DWG# and give it a new DWGREV letter. It works on the form that I add the record to, but when I go to the next...

Thanks Terry. I broke the operation into two queries and the second query seems to give me the right answer. I appreciate the help.

I looked through the archives and couldn't find anything in specific terms so I thought I would just ask. I have a query that lists part number and quantities in inventory. Once I've supressed the duplicates I still have part numbers that are listed multiple times because of data in other...

Never mind. I guess I'm just not back in the groove from the long weekend. I just figured it out too. Thanks again for your help.

Terry, I just figured it all out. I had to insert the module instead of just open a new one. I was also using (column) instead of the field name. It's working like a champ. Now I am comparing the new list of part numbers with the dashes to another list. Since nothing is matching and I can...

OK, I think I have everything in the right place but... The function is in a new module named "ReplaceSpaces".I built an update query and put the "=ReplaceSpaces(column)" in the update to box and in the criteria box I put Like "* *". When I run the query the result...

Thanks Terry. I'll give it a try. I appreciate the help.

I know you all have come close to answering this in thread181-96793 but something isn't working quite right... I was given a document with a field of part numbers that have spaces inserted instead of "-". I need to add the dashes back in. Unfortunately, the part numbers are of varying...

Thanks very much for the help. I will try each of the suggestions and see which works best for me.

Just wondering if someone might have the answer... I have a table filled with drawing numbers and descriptions and it has a revision level field that is alphanumeric. The table lists each drawing number several times depending on the number of revisions. So for example, it may look like: Dwg...

I just tried Joe's suggestion and I had the same results as mentioned above. The tables are updated fine, but when I put the DeleteObject in the macro, it deletes both the original Table2 and the renamed Table2. So when the macro is run again, there is no Table2 to start with. Am I missing...

I guess I should have added: Table1 begins with generic info and is fed additional information from a form after it is in place. To maintain the complete database, these fields need to be re-instated in Table1. I know there are other ways to do this, but because of the type of data maintained...

I am interested in automating my Make Table and Update queries since I have to update a number of tables on a daily basis. I have two tables I am working with...Table1 and Table2. I need to copy the information from Table1 to Table2 and then delete Table1 so I can "Make" Table1 with...

Many thanks. You gave me the direction I needed. I opted for the delete query so I could automate the process.

Many thanks. That gave me the direction I needed. I opted for the delete query since other users were involved.

I am using list boxes to fill a table that will print a report or save as an Excel file. I was just wondering if there is a way to clear the table of its contents so it can be used again or do I have to go through the process of saving it as something else, deleting the table and making a new...

That must be the problem...it is a bound combo box. I will change it and see what happens. Thanks for your assistance.

I just tried your suggestion and it doesn't allow you to make any selection in the combo box.

You all were kind enough to help me this morning with using a combo box to set the parameter for a report. I am now noticing that when I select something from the combo box and then change my choice and select something else that it changes a field in the table it is reading from. For example...