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

...strSQL = "SELECT XREF_01.PNR, XREF_01.PEC, XREF_01.PPC, XREF_01.TITLE FROM XREF_01 " & _ " WHERE XREF_01.PNR like '" & FoundPNR & "*';" Forms![FrmMain]![FrmFamily].RecordSource = strSQL Forms![FrmMain]![FrmFamily].Visible = True As always any help will be greatly...

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

...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 produce it? anything else?? The code is (minus...

...gidata.filnr, gidata.descript" & "FROM gidata" strwhere = "WHERE" If Not IsNull(Me.txtfileNr) Then strwhere = strwhere & "(gidata.dfilnr) like '*" & me.txtfilnr & "*'" strOrder = "ORDER BY gidata.filnr;' End If Me.lstGenDetails.rowsource = strSQL & " " & strWhere & "" & strOrder Can...

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

...from anywhere in the field the code is: strwhere = "WHERE" If Not IsNull(Me.descript) Then strwhere = strwhere & " (GIData.Descript) Like '*" & _ Me.txtdescript & "*' AND" strorder = "ORDER BY GIData.Descript;" End If My question is: What is the SQL to retrieve only if the...

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