Search results for query: *

Hi Drew,<br><br>Hadn't thought of the formatting issue.&nbsp;&nbsp;I played around with your idea and finally did get results with only minor modifications.&nbsp;&nbsp;Here's what works:<br>strCriteria = &quot;VendPartNum = &quot; & conQuote & Left(ctlTextbox, 6) & Right(ctlTextbox, 2) &...

Hi<br><br>I've got a problem searching a recordset using a text field as criteria. The field I need to search on is a number appended by a dash to another number, like so:&nbsp;&nbsp;100238-11.&nbsp;&nbsp;When I use filter by form, the criteria appears as: &quot;100023811&quot; with the quotes...

Hi Jim,<br><br>I tried the changes you suggested and got a message that complained of an invalid use of Null.&nbsp;&nbsp;I don't understand why since I thought an empty string was completely different from a null.&nbsp;&nbsp;However, changing the 3rd argument to ctlText as Control in the...

I've written the following routine which I call from the click event of an OK button on a custom dialog form:<br><br>Function UseDialog(strNameDialog As String, ctlText As Control)<br><br>'This procedure insures that the user has entered a project<br>'number into the text box named...

Hi Walt and Doug, I'm basically just trying to save form real estate.&nbsp;&nbsp;I've got a combo box with two columns.&nbsp;&nbsp;The bound column is an autonumber field from the lookup table and it's hidden in the combo box.&nbsp;&nbsp;The visible field is text.&nbsp;&nbsp;The user can choose...

I have a Combo Box with two columns, an autonumber field(hidden) and a text field, which is bound on the autonumber field.&nbsp;&nbsp;There are six items to choose from in the list.&nbsp;&nbsp;If the 1st item is chosen, a dialog box opens to accept user input to replace what is in the text field...

cantwellt,<br><br>If you've got a little money to spend, you might check out <A HREF="http://www.appdev.com.&nbsp" TARGET="_new">www.appdev.com.&nbsp</A>;&nbsp;They have excellent tutorials on Access97, Access2000, and VBA.&nbsp;&nbsp;The courses are available on disk, video, and as self-study...

Thanks Elizabeth,<br><br>You've helped me zero in on part of the solution.&nbsp;&nbsp;Just requiring the part number before revealing its location wouldn't be enough since the technicians now have that information, but aren't complying.&nbsp;&nbsp;However, I can require that a &quot;lab&quot...

I'm designing a database to control an inventory of calibrated parts.&nbsp;&nbsp;The physical inventory is stored in drawers with compartments, each having a unique location number. I need to document where parts are used and when they need to be restocked.&nbsp;&nbsp;In the past, parts have...