Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / February 2006

Tip: Looking for answers? Try searching our database.

Dynamically changing background HELP

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SIMON GARE - 24 Feb 2006 16:50 GMT
Hi,

I have a table with dynamic values form the a recordset, one matches upto
the other and sets the background images accordingly and everything is
working ok to a point.

Problem is that there are more than 2 options (i.e. types of vehicle) I need
4 options, types of vehicle are

Standard
Executive
MPV
Estate

The snippet below only returns 2 values and need 2 more.

<td width="80" <%
Record3 = Recordset1.Fields.Item("VEHICLE_TYPE").Value
Record4 = Recordset3.Fields.Item("vehicle").Value
If Record3 = Record4 Then
 strbackground="images/VTypeStandard.gif"
Else
 strbackground="images/VTypeExec.gif"
End If
%> Background="<%=strbackground%>">

Thanks in advance

Simon
Sylvain Lafontaine - 24 Feb 2006 21:35 GMT
The official newsgroups for ASP and databases are
microsoft.public.inetserver.asp.general and
microsoft.public.inetserver.asp.db

In your case, you have to add some statements to your IF block; however I
really don't understand your use of the comparaison "If Record3 = Record4
Then" so I cannot help you more on this.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hi,
>
[quoted text clipped - 26 lines]
>
> Simon
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.