Search results for query: *

Hi Ginger -- I'm only searching one field, a description, and there is no uniform entry in those fields, and lots of different information in there, which is what's making this difficult. Thanks though!!

Hi PHV, great - thank you! I have one question, and forgive me b/c I am not that savvy with Access, where is the AfterUpdate Event Procedure? Heres is the code: _____________________________________________________ Option Compare Database Option Explicit Private Sub txtSearch_Change() Dim...

Hello! I have a free text box that searches one field using this code: _______________ SQL = "Select [Desc] from [tblParts]" & _ " where [Desc] LIKE ""*" & Me.txtSearch.Text & "*""" _______________ The only problem, is that it if I have a record that says "Connector, 300w" and I type...

Hi Remou, thanks - I just tried that but I got a variable not defined error immediately after typing in something. I changed the [ROS_Part#] to [Desc] since that is the field from tblParts I am searching. Thanks though!

Hi there, I've got a form that has an unbound text box where you can enter in text and it will search a field, then narrow down the findings in another text box, from which you can double click a result and associated information will pop up into 3 other unbound text boxes. My problem is if...

Hey, thanks everybody, I got to the tools>startup (why I never though to check that first, we'll never know...) and it's working great! I also keep that in mind about the toolbars, so thanks again everybody! D

Hi there, I was wondering what the code was to get a form to automatically pop up when a user opens the database? I tried: "DoCmd.OpenForm "form name" " but that didnt seem to work. Any help is greatly appreciated. Thanks!!

Never mind I got it!

YOU ROCK!!!!!! Thanks soooooo much!!! That did it, but now I have one more question if it's not too much trouble. The way it is right now, I am returning one field into an unbound text box, but I need to return another one into another unbound text box. Here's the code for the first return as it...

Hi, thanks for responding so fast. Um, as for what I've tried, not sure how to explain, since I've downloaded a bunch of different templates off of various sites on the web. The thing is, that I need to be able to search the whole text box, not just the beginning letters. For instance, if I have...

I'm trying to put together a simple inventory database - the one table has 4 columns, 3 are text, and the primary key is an autonumber that is insignificant to the data. I need to have a form where you can type in a keyword or part, click a search button, and it searches one column, then...

I have QuarkXpress 6.0, and I am unable to save or save as - they are greyed out. I just got the program. Registered over the phone, not over the internet. What would cause this? Thanks! Dustin