Recent content by plucnik

Thanks for the suggestion. That may be the way I have to approach this. I thought I saw a solution to this at one time but Alzheimer’s is kicking in.......:D

Wasn't able to find this addressed in search although I'm sure this question has been raised before. We have a software program that automatically creates a daily text file. Each daily file is uniquely named so I have an archive of these files in a folder. I want to import the file that was...

Thanx TruckTime!

Ok, I admit it. I'm looking for the easy way out. Here's my predicament. We have a form with an embedded subform. Both forms have data. A command button (with code) on the main form manipulates an individual record chosen (with a check box) on the subform. I want to run the code on the main form...

Worked like a charm! Thanks for the assistance. :cool:

Is there a way for data NOT to be "painted" in a forms text box after a record search? What happens is if a key is accidentially struck, the data in the text box erases. I guess I can create an invisible text box and set the focus there after the search but is there a "best practice" for this...

Just wanted to let you know that putting the code in the Current event on the form in addition to the on click event on the yes/no box did the trick. Thanks!

Thanks Pat.........I'm working with an existing program that I do revisions on. An option group is probably the right way to go. Thanks for the info about putting the code behind the form as well. I'll try that and post the results. :D

Let me preface this with I know just enough VB to be dangerous :D I'm working with a form that has a subform. The subform is formatted to display multiple records from a query in a continuous form. Each record has several yes/no checkboxes. I want to disable several of the checkboxes in a...

Works like a charm! Thanks again.......

Thanks for the reply. I actually have the report running automatically each day from an "autoexec" macro so using command buttons to direct the report to a printer that way really isn't an option. I didn't think about the page setup. I guess I assumed that a report would always go to the default...

I've seen several posts regarding this but none seemed to answer the question We have several network printers. I would like to hardcode the output of a specific report to a specific printer. Using the acPrint command sends the report to the shared server "default" printer. I would like to...

Yes! I'll give that a try. Thanks :D

Is this possible? I want to auto close a Find Form (ctrl-F) after doing a search on a text box value on a form. There doesn't seem to be a way to do this unless you create a custom search form. I had a thought. Since pressing the ESC key closes an open Find Form, is it possible to insert a...

Thanks for the reply! I was considering doing just that. I really don't need anything fancy so it shouldn't be much of a chore. Just need a simple text box input to run a query off of and then populate that info into a form. Kinda weird that MS never thought that anyone would want their built in...