Search results

ok so when i put that in the search terms i think it pretty much tells me why i am getting the problem... based on the search term you type in it identifies that record... but there are MANY other records that may contain the term that you used.. for example you type in "fred's steel works"" --...

yeah same problem as before, the one you had quoted above.. i just tried to send the zip again.. it is about 230k and was denied. im gonna run that diagnostic code you mentioned

rural guy, i am still having the same issue that i was having about a week ago with this search form and was wondering if you could help me out. i tried to send it off to you but the email would not go through as your server kept denying it.. curious to see if you had any thoughts. i...

i tried that suggestion earlier that you had on changing the query conditions without any luck... im gonna keep trying at it today and perhaps send you an email later today with some thoughts if i cant get this ironed out. im on windows xp, running access 2000

ok i take that back slightly.... this perhaps better explains the problem: when i type in a search command "x" it will return results matching "x." lets say there are 18 records returned in the window as search results. now, lets say i want to edit the information contained in the 14th...

i think the difference is that the one that i sent to you has a significantly reduced number of records and therefore when i populated my version with the the thousands more i run in to problems --- the association between what is typed in to the search box and how that language is associated...

is there a way that you know of to make the association between what is typed in in the search box, the search results and then the information that is displayed in the text boxes below the search results more precise in their query? i think that what is happening is when you type in a search...

crap, now im having troubles in that when you highlight the one individual row in the search results the data that shows up in the other portion of the form doesnt change when you click a different record in the search results... thinking it has something to do with the way that the query...

wow...that was a pretty dumb mistake on my part :) all set now! truly appreciate all of your help!

"Now you need to bind the form to Query1 or RecordSetClone blows up. The way you have it there is no RecordSet to reference. I'm still working out a few problems but that will get you started." apologies, but can you elaborate a bit here?

got it to post i abbreviated the file size and got it to post so as to avoid clogging your inbox.. let me know what you think, and i appreciate so much your help.

hmm too big of a file.. do you have a gmail account or something? i am having trouble uploading...

[name] is a column in the main table of the database

dont know if this is restating the obvious but my problem is getting the two areas of the search form to work in sync.. at the moment, the portion of the form that allows you to edit the records will not use the main table as its control source, however, the search function of the other part...

Option Compare Database Option Explicit Private Sub ClearIt_Click() On Error GoTo Err_ClearIt Me.Search = "" Me.Search2 = "" Me.QuickSearch.Requery Me.QuickSearch.SetFocus Exit_ClearIt_Click: Exit Sub Err_ClearIt: MsgBox Err.Description Resume Exit_ClearIt_Click End Sub...

thanks! that takes care of that problem... now i get type mismatch error? arrrr

using the same application i get an error that reads: Run time error "91" object variable or with block variable not set using this code: Option Compare Database Option Explicit Private Sub ClearIt_Click() On Error GoTo Err_ClearIt Me.Search = "" Me.Search2 = "" Me.QuickSearch.Requery...

and as another question relating to this, is there a way for the user to select the range for the data in the spreadsheet to be imported in to the access table? otherwise you get the standard 60,000 or so cells imported.

all apologies... but elaborate on this portion of your statement please: "Your code in the OnClick event should be coded to append one table and the user should know which button to click to update a specifc table." i would like the user to be able to upload an excel spreadsheet that they...

but with TransferSpreadsheet is there a way to allow the user to specify the table that they want to import to the main table each time the command is run as opposed to specifying it in the code? with TransferSpreadsheet the file name of the spreadsheet to import is a required argument i...