Search results for query: *

Thanks for the speedy response PHV and Roy-Vidar. It was the lack of the Form Keyword that was causing my problem. I can't tell you how grateful I am for your help. I spent most of the weekend pouring over my three ACCESS books to no avail, tried "thinking it through" and experimenting - no...

I'm using Access 2000. My users enter one of four values via a textbox, the entered value is found in the "many" table and the linking field is stored to a variable I call FoundPNR, The main form displays the data from the "many" side of the one-to-many relationship in a listbox. I want the...

Hi PH, The recordsource on the subform is FileA. What did you mean by "add a criteria on Category"? Thanks

I'm using Access 2000. I have 3 files, the strucures are: FileA: Category = primary key Mftr, Location, Address FileB: Category, SubCat, SerNr, PartNr, Model. (primary key is category & SubCat & SerNr) FileC: Category, SubCat, PartNr, Trouble, DateIn, DateOut...

Thanks bboffin, I'm understanding this stuff slowly :-)

Thanks aceman1 and bytemyzer. Both worked fine - now to decide which to use :-) Thanks guys I appreciate it. Pam

I'm using another person's mdb as a learning tool and when I run the analyzer-documenter the following code is shown at the very beginning of the code section of the documentation, but I cannot find it *anywhere* in the application. Can anyone tell me what this is, is it necessary? how would I...

I have a form where the user inputs the data they want to search for and clicks a "search" button which runs an SQL statement. The results of the SQL is the rowsource for a listbox. All is ruuning fine except I want to display a msgbox stating "No Records Found" if none were found. I cannot...

ahhh.. if it wasn't for syntax I'd be brilliant. Seriously thanks (again) PH. that was it. Pam

My Problem: When running the code below I get the "Run-Time Error 3001 - Invalid Arguement" error message when it reaches the dbs.properties.append.prp line. This code is a modified version of code that is posted in this forum. I'm using Access 2000 and just testing this so I have it attached...

Thanks so much PHV. You can't imagine how helpful this is. I can just about wrap this project up and move on to the next one. Learned a great deal about ACCESS with this project and could not have done it without this forum. Thanks again Pam

Wow, you guys are fast. Thanks PHV. So it would be: strwhere = strwhere & ( GIData.descript) like '" & Me.txtdescript & "' AND" ?? (i.e. do I need the star at the end of the argument? Thanks

sorry forgot to say - I'm using Access 2000

I have been working from the searchdb.mdb that I "found" on this forum and can't find again to give multiple stars - it's a Gem. :-) I have modified it to suit my needs and it's perfect, but I would like one more enhancement that I don't know how to do. The current SQL retrieves if the user...

Hi Tiny, Sorry I should have stated - I'm using Access 2000 and I guess there's a difference because the code you use is exactly the same as the code Access 2000 produces when creating a find record button with the Wizard, i.e. includes the replace functions. Thanks anyway, Pam

I would like to use the "Find Record" button on one of my forms, but the users that will be using it only have read-only rights. Can I disable the "Replace" portion of this button in anyway? Or, if I set the network permissions on the drive containing the data to read-only will the replace...

The background: A user selects 1 of 4 fields to search on by selecting from an Option Box, this selection opens a 2nd form, the user then enters the desired criteria into a text-box on the 2nd form and clicks a "search" button. I'm ok to this point and have the values of both forms (option and...

Thanks Larry, At least I know I'm not nuts (well.....) :-) I guess it must be a glitch - does MS put out patches for this type of thing do you know? Pam

Thanks guys: It works perfectly of course :-)

Thanks guys - this forum is simply amazing. I'll test this evening. Thanks again