Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free Forums > Programming > Visual Basic Programming
Reload this Page

access help please!

Discuss access help please! in the Visual Basic Programming forum on ASP Free.
access help please! Visual Basic Programming forum discussing coding strategies, development and techniques. Go from prototype to product quickly using this robust platform.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old March 31st, 2005, 04:53 AM
mainy mainy is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Mar 2005
Posts: 4 mainy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 4 sec
Reputation Power: 0
access help please!
Hi, is there any way i can extract data from a list in to a query?

i have been populating list boxes using sql and vb statements but i need the data in a query, is there any way i can do this.

Thanks.

MAiny
Reply With Quote
  #2  
Old March 31st, 2005, 09:15 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
Can you explain what you need in more detail? I don't understand what you're looking to accomplish.
__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
Reply With Quote
  #3  
Old April 1st, 2005, 02:13 AM
mainy mainy is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Mar 2005
Posts: 4 mainy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 4 sec
Reputation Power: 0
Hi, i have been doing sql statements in VB querying on a query named "filterSectorNoSelect"

Code:
 
	Dim Source1 As String
 
	Source1 = "SELECT [filterSectorNoSelect].[SourceNo], [filterSectorNoSelect].[OpportunityId], [filterSectorNoSelect].[CampaignName], [filterSectorNoSelect].[SourceType] " & _
						"FROM filterSectorNoSelect " & _
						"WHERE [HorizontalNo] = " & Me.Combo100.Value
 
	Me.List98.RowSource = Source1
	Me.List98.Requery


With this statement i have been populating a list box. Now i have all the data i need in the list box is there any way i can get it all back into a query or another table using INSERT or something? As i need to do reports on all the data in the list box.

Any help would be great

Cheers,
Mainy
Reply With Quote
  #4  
Old April 4th, 2005, 09:16 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
  
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 21 h 32 m 23 sec
Reputation Power: 180
Easiest would be to use an ADO datalist that's bound to your data. Then any edits you do in the list will update your tables.

Otherwise, you'll need to write some code that looks at all the items in your list and creates an INSERT statement that will insert into another table.

You might look at the VB report generator or other VB report generators like Crystal Reports if all you need is a report.
Reply With Quote
  #5  
Old April 5th, 2005, 02:58 AM
mainy mainy is offline
Registered User
ASP Free Newbie (0 - 499 posts)
  
Join Date: Mar 2005
Posts: 4 mainy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 37 m 4 sec
Reputation Power: 0
cheers
Reply With Quote
Reply

Viewing: ASP Free Forums > Programming > Visual Basic Programming > access help please!

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway.