Search results

Problem with this is that to do this you'd have to check EACH row for an InString for each row.. aka #rows * #rows so if you have 300 rows, your looking at 90000 InStr functions, now strings are typically mutable (or is the term immutable) anyways, it means when you manipulate strings it...

Can you post what that looks like in your data file: eg: 1|2|3 Because that information is kinda needed...

Hrm, looks interesting... Tried SQL Appregation combined with your domain appregation? might work... otherwise I cannot think of anything.

On a side note: MMax might be better for you ^_^ talk to Mile-O-Phile for that one.

Sorry to be unhelpful but summary: ADODB = t3h suck

Try: If panelName = "" Then ... Else ... End If

A man walks into a bar.... Ouch.

Try putting it in the "OnChange" event.

Here, try looking at this sample database i wrote for another topic. It may show you a thing or two.

Something makes me think he's talking about he wants his database to be able to search for something. So these options arent really helping (cept the first one) Which is what one should do if they want thier users to be able to search for things in that fassion.

You could try his way, looks interesting, but I've use the method I described here at my workplace and it works wonderfully.

Yeah well, that's about all you can expect out of Micro$oft *cough*cough* did i say that... ??? ¬.¬

In the form that's loading, build an event (code event) on the _Load event put this code: Me.Top = 200 Me.Left = 200 now the form *should* start 200 pixels from the top and 200 pixels from the left *HOWEVER* this MAY be relative to the MS Access window, i have not tested this.. Give it a try.

Off topic: I think ill keep a counter on how many times people spell my nick wrong, even when it's right in front of them... On these boards.. so far 4 times...

Open a new database, import all your tables into it. Save it on the shared drive. Open your original database (make a backup copy too) and delete all the tables. Now right click and choose "link tables..." When you have doen this, enter in the absolue path to the shared drive: aka...

That is truly odd.... really is, well im out of ideas, i wonder if anyone else knows what to do.

Try this, it should help you out.

Odd, help file for access seems to outline the function thoughoughly... Um, try it without that line.

1) Dates are stored in the database simply as a number, the x amount of days from some date way back that i cannot remember (sorry, cant grab it off the top of my heat at the moment) so, what this means is you can treat dates as a number (sorta). You can do greater than (>), less than (<)...

No Problem, glad it helped.