Search results for query: *

Great idea, I certainly don't want to be "sloppy". I'll give that a try and see how the users like it. I guess I can get it to search both fields concurrently (because they won't know necessarily which of the two fields what they are searching for exists in.

MAJP, thankyou so much, I am going to try your example tomorrow when I get to the office. Re:First, I would never write code like this. The concept of search mutliple fields for the same type of data does not make a whole lot of sense to me. The requirement is to be able to search an...

Dear MAJP, Thanks for trying to educate me. I tried to do exactly what you indicated would work. There are three forms involved, a little popup search form which contains all the search logic and the text field the user types the argument into and a seperate main form with a subform. In my...

Well I played around and decided to try to put the search logic on the Main form and got the search to work. I just cannot search a subform using a separate form. I did not have much space on the main form but I was able to put the search argument text box on it along with the option group and...

OK, I tried some recommendations and it fails on the .Setfocus statement following the With statement. If the subform is opened BY ITSELF and I set mstrFormToSearch to the name of the subform it works. I have tried all sorts of ways to set mstrFormToSearch to the subform on it's main form...

I certainly appreciate everyones assistance. Basically what I do have working is a small popup form on which a user can type a search argument, click a command button and execute an event which uses Findrecord to search all the data on another form (all data fields, not just the field having...

Bottom line, I have concluded that it IS possible to setfocus to a control on a subform but it is not possibe to setfocus to the Form itself within the main forms container. If it were possible, the .setfocus on the subform would not fail and the subform controls collection would be exposed but...

Re: MazeWorx "why post twice Paul" Two different scenarios with the same issue. The VBA code forum didn't produce a solution. I reconfigured the forms / code and got an error with a singe form with a subform so I concluded the issue may have to do wity FORMS and not necessarily VBA code...

I have a form with one subform. The subform is in datasheet view, nothing unusual about it. The main form is named "OtherMain" The subform name is "OtherSubform" The subform source object is "OtherSubform" (same as it's name on the main form). On the Main form, I have a control button and...

Thanks MazeWorX, I looked over the thread you referred me to and came up with someting to put in the "With" statement but I still get the error on the .Setfocus command. This is what I used: With Forms![OtherMain]![OtherSubform].Form .Setfocus The .Setfocus command results in the...

I have a form with code that I use to find records containing a search argument typed by the user. The code resides in a small separate form used to type the search argument in and it works well. It will find any data in any control on a form that matches what the user typed. The form being...

There are lot's of companies that sell serialized pre-printed bar code labels and tags, off the shelf or custom made (with your company logo etc.). Naturally, these tags won't have any use to you whatsoever unless you have a database system that can serve as a repositiory of customer...

I don't have any trouble at all printing bar codes on Access reports using a bar code font. To see if this will work for you you could try the free code39 font from idautomation.com and see if it works for you. Just install the font on your computer then, with the report in design mode, set...

Exactly. The best way to accomplish what you want to do is to get something like Microsoft Access (Office Professional for example that comes bundled with Access/Outlook/Word etc). Access will be your repository or database of information (as much or as little as you want to collect). Not...

Thanks for the suggestions. Double Clicking the mdb directly from the windows explorer OR chosing the Open option after right clicking is agonizingly slow. The mdb's still open blazingly fast if I first choose to open Access from the Office toolbar and then open a mdb from within Access (all...

Hello all. I have several access databases on my laptop. I am running XP professional and Office 2000 professional. I am experincing very slow loading of any of the databases if I use a shortcut to the MDB on my desktop, typically, after clicking on the desktop shortcut icon, I get an...

Hello all. I have several access databases on my laptop. I am running XP professional and Office 2000 professional. I am experincing very slow loading of any of the databases if I use a shortcut to the MDB on my desktop, typically, after clicking on the desktop shortcut icon, I get an...

Hap007 (MIS) 27 Oct 04 17:25 writes: I would store the Original good (not run) Access Frontend in a folder(HoldSource). Then I would use a script, run at logon time to copy that to the user's default folder and then run that copy. Question, why would you recommend this? I have multiple users...

Using Access 2000 Have a combo box on form. Underlying data is table of numeric data. "Limit to list" set to: NO (want the user to be able to key a value not in the list). "validation rule" set as: >=0 And <=100 "validation text" set as: "You must select or enter a numeric value in...

Recently tied our network into the internet via a broadband connection. Using a Lynksys router mpdel BEFSR11 connected to a Cisco 2900 switch. Our servers are Compaq (3500r and 1600r with 500 mhz cpu's) running NT 4.0 sp6 and Terminal Server / Metaframe 1.8. We are a small shop with about 8...