Recent content by pihutch

Thanks for the tip, but that didn't work. When I modify the variable assignment statement to match the example you gave, I get a syntax error when I submit the form. Any idea why? I noticed the last quotation mark is missing from the statement, but that didn't make a difference. As far as a...

I asked a question a couple of days ago about a problem I was having with a form and now I have a new one. Here is the thread for the original question if anyone wants to review the original problem: http://www.tek-tips.com/viewthread.cfm?qid=919138 dhookom was nice enough to help me figure...

Thank you so very much!!! That worked perfectly. I knew the asterisk needed to be in there somewhere, but just didn't know the exact syntax. I took VB and Access in college a couple of years ago, but don't remember much of it. As far as naming the controls goes, I was just trying to figure...

Thanks for the tip. I have discovered that I am not really doing a query. What I am doing is using the Access wizard to have the command button open the other form and display certain records based on what the user types in the text box. Here is the code that Access creates for the button's...

I have a database in which one of the fields on my main table contains a narrative description of the whole record. I have a form that will display all records in the table. I have command buttons on the switchboard that will display that form with only the records that match specific criteria...