Like in Open Form Command

Nothing

Anyone know how to make the LIKE command work in the following OpenForm
command?

DoCmd.OpenForm "frmSearchResults", , , "[bbid#] = '" & bbid & "'"

This will work if I type the whole bid #, but if I type part of it it
will not return any results, even though I know it should.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #1

Subscribe Post Reply

6509

Douglas J. Steele

DoCmd.OpenForm "frmSearchResults", , , "[bbid#] Like '*" & bbid & "*'"
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Nothing" <me@you.com> wrote in message news:42**********@127.0.0.1...

Anyone know how to make the LIKE command work in the following OpenForm
command?

DoCmd.OpenForm "frmSearchResults", , , "[bbid#] = '" & bbid & "'"

This will work if I type the whole bid #, but if I type part of it it
will not return any results, even though I know it should.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 13 '05 #2

Bob Quintal

Nothing <me@you.com> wrote in news:42**********@127.0.0.1:

Anyone know how to make the LIKE command work in the following
OpenForm command?

DoCmd.OpenForm "frmSearchResults", , , "[bbid#] = '" & bbid &
"'"

This will work if I type the whole bid #, but if I type part
of it it will not return any results, even though I know it
should.

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

To type in the first part,
DoCmd.OpenForm "frmSearchResults", , , "[bbid#] like '" & bbid &
"'*"

To type in the last part,
DoCmd.OpenForm "frmSearchResults", , , "[bbid#] like *'" & bbid &
"'"

To type in the middle part,
DoCmd.OpenForm "frmSearchResults", , , "[bbid#] like *'" & bbid &
"'*"

Or if you want to put the wildcards manually
DoCmd.OpenForm "frmSearchResults", , , "[bbid#] like '" & bbid &
"'"

--
Bob Quintal

PA is y I've altered my email address.

Nov 13 '05 #3

by: Tom Dacon | last post by:

"Open .Net Command Window Here" context menu for Windows Explorer: The reg file described below adds a new menu item to Windows Explorer's context menu when you right-click over a folder (or the...

.NET Framework

Printout of open form in landscape format

by: P | last post by:

Hi, Access 2002. I am trying to use the PrintOut function to print the current record of the current open form in landscape format to the default Windows printer. Any suggestion on how to set...

Microsoft Access / VBA

Need to supress a open form command if the fieldto getting focus is [field1]

by: Mr. T | last post by:

Hi, I need some help here. I have a On Exit procedure on that opens a form. Whenever anyone clicks anything outside of it the form opens. No problem here. But I need it not to open if the...

Microsoft Access / VBA

How to access method in open form from another form.

by: twick10 | last post by:

Hi, I am trying to execute a control method on an open form (not with focus) from a modal dialog box. I want to increment the node selected from the dialog when a certain key is pressed. Any...

Visual Basic .NET

Open form using where clause

by: keri | last post by:

Hi, Simple version of the question..... How do I use the where clause of the open form command to show an account with a matching ID to be displayed when the form is opened? Eg. I select a...

Microsoft Access / VBA

Unwanted scroll from mouse wheel in open form.

by: Paul Brady | last post by:

First, apologies iif this is an old problem. I do read this group, but I may have missed it. When I open a form in A2K to put data into a record (or create a new record), all is well provided I...

Microsoft Access / VBA

open form multiple times

by: billa856 | last post by:

Hi, My project is in MS Access 2002. In that I want to open one form multiple times. I put one button on my main form. Now whenever I click on that button than form will be open. Now when I...

Microsoft Access / VBA

How to Open a command window automatically from Startup folder Windows XP

by: SilverGS | last post by:

I want to automatically open a Command Window from the Startup folder in Windows XP. right now after XP starts, I click on Start run, cmd and then when the command window is open I type in a bunch...

Microsoft Windows

when creating a command button in a form, I can't set the open form by specific data.

by: cheweedog | last post by:

Can't set the open form by specific data. The form fields don't appear to choose. Trying to link number to number. One form contains a field called number, but does not appear as a choice to <> to...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Similar topics