SELECT DISTINCTROW qryVehicleList. VehicleJobID AS VID,
qryVehicleList. Vehicle, qryVehicleList. Reclaimed AS [Reclaimed?],
qryVehicleList. VehicActive AS [Active?], qryVehicleList. Sold AS
[Sold?], qryVehicleList. ProcFee AS [My Fee],
qryVehicleList. DMVFileNumber
FROM qryVehicleList
WHERE
(((qryVehicleLi st.TowCoID)=[Forms]![frmBrowseVehicl es]![Combo0]));
Here's the expression in qryVehicleList' s [Sold] field:
Sold: IIf(IsNull([VSaleID]),False,True)
I'm unable to get anything but minus one and zero to display in the
listbox.
2  2772 
Sold: IIf(IsNull([VSaleID]),"No","Yes")
"MLH" <CR**@NorthStat e.netwrote in message
news:uu******** *************** *********@4ax.c om...
SELECT DISTINCTROW qryVehicleList. VehicleJobID AS VID,
qryVehicleList. Vehicle, qryVehicleList. Reclaimed AS [Reclaimed?],
qryVehicleList. VehicActive AS [Active?], qryVehicleList. Sold AS
[Sold?], qryVehicleList. ProcFee AS [My Fee],
qryVehicleList. DMVFileNumber
FROM qryVehicleList
WHERE
(((qryVehicleLi st.TowCoID)=[Forms]![frmBrowseVehicl es]![Combo0]));
Here's the expression in qryVehicleList' s [Sold] field:
Sold: IIf(IsNull([VSaleID]),False,True)
I'm unable to get anything but minus one and zero to display in the
listbox.
U dah man - perfect work-a-round.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Fieldmedic |
last post by:
I'm attempting to get an arraylist to display in a Listbox (listbox2). The
arraylist is created from selections in a different listbox (listbox1). The
1st listbox has a selection mode of MultiExtended. Once the selection has
been made in the 1st ListBox, the user clicks on a button to generate the
arraylist using the values selected. Then click a second button to display
the arraylist contents to ListBox2. There are no errors, but all I get...
|
by: Danny |
last post by:
Hello
I am trying to create a separate listbox and fill it with items based on
what is in another field in a database.
This field is bound to a field in the underlying database. But the data is
changed from another list box that is a pulldown of the 3 items. This way
they are forced to select one of the 3 items.
So when the field updates based on the item chosen, why doesnt it cause the
"on change event" to happen? The field has...
|
by: MLH |
last post by:
120 MyString = "How many copies of each letter do you need?"
150 MyVariant = InputBox(MyString, "How Many?", "3")
If MyVariant = "2" Then MsgBox "MyVariant equals the string '2'"
If MyVariant = 2 Then MsgBox "MyVariant also equals the value 2"
160 If MyVariant = "" Then HowManyCopies = 1
170 If Not IsNumeric(MyVariant) Then HowManyCopies = 1
MsgBox "OK. HowManyCopies has a value of " & CStr(HowManyCopies)
180 For i =...
|
by: scottyman |
last post by:
I can't make this script work properly. I've gone as far as I can with
it and the rest is out of my ability. I can do some html editing but
I'm lost in the Java world. The script at the bottom of the html page
controls the form fields that are required. It doesn't function like
it's supposed to and I can leave all the fields blank and it still
submits the form. Also I can't get it to transfer the file in the
upload section. The file name...
|
by: indhu |
last post by:
hi,
i have a list box in my form, when i click listbox field it should display corresponding value to other textbox fields.
like
listbox, these are the corresponding text flds
person by clicking this it should display other field values
| | |
by: RallyDSM |
last post by:
Pre STory - I've had a lot of problems with this program, and I just
added the last part of it (the add item code) and now an older part of
the program crashes.
Public Structure Stocks
Public stockName As String
Public numShares As Double
Public datePurchased As String
Public purchasePrice As Double
Public currentPrice As Double
|
by: jaishu |
last post by:
I am using ODBC with oracle tables..
My table has columns startdate and end date which are of type varchar(backend tables)..but when i display it in form it should display it as mm/dd/yyyy format, i tried setting format property as Short date but that doesnt work as my form is based on a query.and all the more my table stores the date as yyyymmdd -19990110, this is the way its stored in table (in varchar) so how do i do this?
i also tried...
|
by: zion4ever |
last post by:
Hello good people,
Please bear with me as this is my first post and I am relative new to ASP. I do have VB6 experience. I have a form which enables users within our company to do an intranet reservation of available resources (laptops, beamers, etc). The MySql database queries are already in place, as is the ASP administration panel. The frontend that users will see however, still needs some work. I'm really close, but since I'm no...
|
by: yltang |
last post by:
Hi experts:
When I design the input form for customers' data, I divide the address into three parts: City, Borough, and RestAddress, where City and Borough are of the listbox type. I have two tables as follows. I would like to do the following. For example, if I choose "New York City" in the City listbox, then only the corresponding boroughs (Manhattan, Bronx, and Queens) of New York City will show up in the Borough listbox.
In the design...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
