Search results

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...

I've found several posts regarding this question but no answers...maybe I'll be the lucky one................. Is it possible to automatically close (with a bit of VB) the (ctrl-F) Find Record input box after searching once (instead of pressing Cancel or hitting Esc)? Thanks!

Sorry, maybe I'm doing a poor job of explaining........I only mentioned that we haven't configured Access security because I didn't want to confuse the issue. This seems to be solely a NTFS file rights issue, not an internal Access security configuration issue. The system.mdw warning that we are...

We recently upgraded our small network (25 users) from a stand alone W2K server to Active Directory. The Access 2000 database is split into front ends on the workstations and the back end, which resides on the server. Since we did this, there has been a security issue with the client...

I don't know if you were ever able to work this out but I stumbled on to a solution (I had exactly the same issue). Try this. Set the focus to a different control first and then immediatly return to the control that you want the focus on. Like this..... me.dummyfocus.setfocus...

Thanks to all who took the time to help! I finally figured it out. The previous designer had put this line of code *DoCmd.GoToControl "dispatchnumber"* in the CURRENT code field behind the form. While it didn't seem to "focus" in this field......it must have returned the focus there every time...