Click here to Skip to main content
11,703,617 members (66,529 online)

Visual Basic

 
AnswerRe: Before a Control loses focus can I detect the next focus target? Pin
Richard Fairhurst26-Sep-12 10:32
memberRichard Fairhurst26-Sep-12 10:32 
QuestionTelephone Tracking system through GPS Pin
waner michaud26-Sep-12 8:12
memberwaner michaud26-Sep-12 8:12 
AnswerRe: Telephone Tracking system through GPS Pin
Eddy Vluggen27-Sep-12 0:16
memberEddy Vluggen27-Sep-12 0:16 
QuestionDatagrid row count equals zero Pin
Cesar00226-Sep-12 6:49
memberCesar00226-Sep-12 6:49 
AnswerRe: Datagrid row count equals zero Pin
Cesar00226-Sep-12 10:05
memberCesar00226-Sep-12 10:05 
QuestionRe: Datagrid row count equals zero Pin
Eddy Vluggen26-Sep-12 10:32
memberEddy Vluggen26-Sep-12 10:32 
AnswerRe: Datagrid row count equals zero Pin
Cesar00226-Sep-12 16:28
memberCesar00226-Sep-12 16:28 
QuestionTricky SQL Question Pin
ttocsmi25-Sep-12 10:42
memberttocsmi25-Sep-12 10:42 
I have an Access database for which I'm trying to write a query based on a request from the users.

I have a table of data related to artwork, with three columns: ArtworkId, DescriptionText, and CalloutNumber. Each piece of artwork can have more than one DescriptionText value.

What would be a good way to write an SQL query to return, for example, all ArtworkId records having both DescriptionText = "Start Switch" and DescriptionText = "Stop Switch" records?

ArtworkID / DescriptionText
123 / Motor
234 / Fuse
234 / Start Switch
456 / Stop Switch
789 / Start Switch
789 / Stop Switch
789 / Light

Result = ArtworkID 789

Any assistance will be greatly appreciated. Thanks!
AnswerRe: Tricky SQL Question Pin
Martijn Kok25-Sep-12 11:40
memberMartijn Kok25-Sep-12 11:40 
GeneralRe: Tricky SQL Question Pin
ttocsmi25-Sep-12 14:13
memberttocsmi25-Sep-12 14:13 
GeneralRe: Tricky SQL Question Pin
Bernhard Hiller25-Sep-12 23:13
memberBernhard Hiller25-Sep-12 23:13 
GeneralRe: Tricky SQL Question Pin
Martijn Kok25-Sep-12 23:27
memberMartijn Kok25-Sep-12 23:27 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 1:56
memberttocsmi1-Oct-12 1:56 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 1:51
memberttocsmi1-Oct-12 1:51 
AnswerRe: Tricky SQL Question Pin
Bernhard Hiller25-Sep-12 23:15
memberBernhard Hiller25-Sep-12 23:15 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 2:12
memberttocsmi1-Oct-12 2:12 
AnswerRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 4:34
memberttocsmi1-Oct-12 4:34 
GeneralRe: Tricky SQL Question Pin
Martijn Kok1-Oct-12 5:13
memberMartijn Kok1-Oct-12 5:13 
QuestionRemote SQL server connection in visual basic /VBA Pin
bsjhala25-Sep-12 2:17
memberbsjhala25-Sep-12 2:17 
AnswerRe: Remote SQL server connection in visual basic /VBA Pin
ChandraRam26-Sep-12 3:04
memberChandraRam26-Sep-12 3:04 
Questionin the project i want to build, i already have a school results system and students should be able to request their results via sms.thus by sending their stud. id to the system number(gsm modem number) and the system automatically reading the message Pin
rosoftghana24-Sep-12 23:05
memberrosoftghana24-Sep-12 23:05 
AnswerRe: in the project i want to build, i already have a school results system and students should be able to request their results via sms.thus by sending their stud. id to the system number(gsm modem number) and the system automatically reading the mes Pin
Eddy Vluggen25-Sep-12 0:17
memberEddy Vluggen25-Sep-12 0:17 
GeneralRe: in the project i want to build, i already have a school results system and students should be able to request their results via sms.thus by sending their stud. id to the system number(gsm modem number) and the system automatically reading the mes Pin
David Mujica25-Sep-12 4:17
memberDavid Mujica25-Sep-12 4:17 
GeneralRe: in the project i want to build, i already have a school results system and students should be able to request their results via sms.thus by sending their stud. id to the system number(gsm modem number) and the system automatically reading the mes Pin
Dave Kreskowiak25-Sep-12 4:32
mvpDave Kreskowiak25-Sep-12 4:32 
GeneralRe: in the project i want to build, i already have a school results system and students should be able to request their results via sms.thus by sending their stud. id to the system number(gsm modem number) and the system automatically reading the mes Pin
Eddy Vluggen25-Sep-12 4:41
memberEddy Vluggen25-Sep-12 4:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 26 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid