Search results

Okay!! Too easy! Thanks for seeing that. Sometimes I can look at something too long. Thanks for the assist! Works perfect! Dave

I am doing a query to populate a listbox from a separate table. When I do the query, I receive multiple returned values, and multiple values that are the same. Can I limit the number of returned values to be a list of the values in the table I am pulling from? Vendor Table- -Only 2 entries...

Thanks Doc! Very good information. It is greatly appreciated!

Thanks ridders! I believe the form is working properly, it was the new code I was trying to implement that simply didn't take this into account. Now that I am aware of it, I know how to handle it. Thank you for the information. I hadn't thought of using this as a tool for maintenance. Good...

I got this figured out...with everyone's help of course! There is an Autoexec Macro that runs on startup and opens a hidden form. It is a timer to test if the database has been sitting idle, then exits the database automatically once the specified time has expired. When I executed the close, the...

Do I remove the Cancel=True statements completely, or leave the one in the Else statement. I borrowed the code from another post, so I am trying to understand myself. Learning at every opportunity. Yes, there is a autoexec Macro. I found this last night, and I am trying to figure out if it is...

Okay, even weirder. If I open the database by holding the shift key down. I then run the startup form when the database runs normally, select my form, everything works great. All of the forms work as advertised. As soon as I run the database and the default startup form opens, then my form...

It is acting strangely like I am not handling something. There is a form with a bunch of buttons, and one of the buttons opens this form. If I run the database normally, this first form loads, then I can open this other form. If I run it this way, I have to basically hit the close button twice...

I have a form with a close button on it. When I press the close button, I want it to close the form without saving the data. When I first open the form the close button doesn't work the first time I click it. It works every time after that, but I can not figure out why it doesn't work the first...

I have a table with IDs 50-59 only, and part numbers that are added by entering a value. I want to find a max value of a part number based on a dropdown. For example, if I choose Divergent from the dropdown, it is group 55, then I want to find the highest part number of that group. Is this...

So with this method, I can use one textbox and one button and continue to filter down the list in a recordset? Then I have another button to show all records again, correct? Thanks!

Thanks for your responses. I am almost there in understanding this. arnelgp, is there a filter you set up to run in your code? Do you do a DoCmd.setfilter? It looks like you can simply use this code to continually whittle down the list. Can you run multiple where statements? Would it just be a...

I have found several posts concerning filtering a recordset, but I am still a little befuddled. I have a text box where a person can enter a keyword to narrow the items on a subform. This is done using a recordsource. My question is, can I then set a filter on that recordsource, and continue to...

Thank you for your responses. I knew there would certainly be different methods to accomplish this task. Now, to go try them out!! Thanks everyone!

Thanks for your inquiry. I have a form which has a lot of information from a purchase order. Items such as PO, Part#, Description, Customer, Customer PO, etc. I want to open a separate form for shipments and log a shipment against this Purchase order. A lot of the information is on this shipping...

What is the best method to pass a value from one form to another when I open the new from from a button click? I have a lot of the information I need on one form, and I believe I could load those into variables and then pass them into the new form from those variables. But, is there a better...

My apologies. Yes, I have a button on a form that opens a report I can then print. When I am working on the form, I see everything just as I would like to see it. Once I hit the open report button I get multiple copies within my report if I have entered more than one entry on my subform. Your...

I am trying to print from a form to a report. The problem I am running into is I am getting a long report and I have discovered I have basically the same number of pages in my report as I have entries in my subform. If I have one entry in my subform I get a 1 page report. If I have 2 entries in...

That got it easy enough. Just stored the email in a separate column and everything ran great. I have tested the checkboxes and everything seems to work as planned!! Thank you all for your assistance!!

I was thinking the same thing last night on my drive home. I will give this a try and let you know how it goes. Again, thanks for the assist!