corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Simple VB/DB help


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Simple VB/DB help
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
4th Nov 08 at 11:32   View Garage View User's Profile U2U Member Reply With Quote

I've dusted off an MS access DB I started on a couple of years ago and I'm just trying to tidy it up and fix some bugs before putting it into use at work.

I'm trying to assign a variable a value at the minute as follows:

dim ref as string

ref = Me.lstServices.Column(1, lstServices.Value) & (Me.txtalias.Text)


Lets say for example the txtalias.text = "corsasport"

and

lstservices.column = "football live"

As it looks at the minute, ref is displayed as "football livecorsasport"

I want it to display as "football live (corsasport)"

Schoolboy stuff I know, but I really can't remember how to do this



[Edited on 04-11-2008 by Kyle T]


Lotus Elise 111R

Impreza WRX STi
Kyle T
Premium Member

Avatar

Registered: 11th Sep 04
Location: Selby, North Yorkshire
User status: Offline
4th Nov 08 at 11:46   View Garage View User's Profile U2U Member Reply With Quote

I'm being a moron, I figured it out

ref = Me.lstServices.Column(1, lstServices.Value) & " (" & (Me.txtalias.Text) & ") "


Lotus Elise 111R

Impreza WRX STi

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
CS @ PV 2003 - Pics of our show cars :) Trotty General Chat 166 7367
19th Apr 03 at 12:41
by Trotty
 
Opinions on site... MikeLamb Geek Day 4 158
4th May 06 at 18:41
by MikeLamb
 
website design Greg_M Geek Day 14 1338
17th May 06 at 22:21
by Jodi_the_g
 
Registration Plates! again Hoddo Help Zone, Modification and ICE Advice 10 154
7th Dec 06 at 19:09
by Hoddo
 

Corsa Sport » Message Board » Off Day » Geek Day » Simple VB/DB help 30 database queries in 0.0101311 seconds