Click here to Skip to main content
       

Visual Basic

 
AnswerRe: Before a Control loses focus can I detect the next focus target? [modified] PinmemberRichard Fairhurst26-Sep-12 10:32 
QuestionTelephone Tracking system through GPS Pinmemberwaner michaud26-Sep-12 8:12 
AnswerRe: Telephone Tracking system through GPS PinmemberEddy Vluggen27-Sep-12 0:16 
QuestionDatagrid row count equals zero PinmemberCesar00226-Sep-12 6:49 
AnswerRe: Datagrid row count equals zero PinmemberCesar00226-Sep-12 10:05 
QuestionRe: Datagrid row count equals zero PinmemberEddy Vluggen26-Sep-12 10:32 
AnswerRe: Datagrid row count equals zero PinmemberCesar00226-Sep-12 16:28 
QuestionTricky SQL Question Pinmemberttocsmi25-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 PinmemberMartijn Kok25-Sep-12 11:40 
GeneralRe: Tricky SQL Question Pinmemberttocsmi25-Sep-12 14:13 
GeneralRe: Tricky SQL Question PinmemberBernhard Hiller25-Sep-12 23:13 
GeneralRe: Tricky SQL Question PinmemberMartijn Kok25-Sep-12 23:27 
GeneralRe: Tricky SQL Question Pinmemberttocsmi1-Oct-12 1:56 
GeneralRe: Tricky SQL Question Pinmemberttocsmi1-Oct-12 1:51 
AnswerRe: Tricky SQL Question PinmemberBernhard Hiller25-Sep-12 23:15 
GeneralRe: Tricky SQL Question Pinmemberttocsmi1-Oct-12 2:12 
AnswerRe: Tricky SQL Question Pinmemberttocsmi1-Oct-12 4:34 
GeneralRe: Tricky SQL Question PinmemberMartijn Kok1-Oct-12 5:13 
QuestionRemote SQL server connection in visual basic /VBA Pinmemberbsjhala25-Sep-12 2:17 
AnswerRe: Remote SQL server connection in visual basic /VBA PinmemberChandraRam26-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 Pinmemberrosoftghana24-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 PinmemberEddy 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 PinmemberDavid 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 PinmvpDave 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 PinmemberEddy 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
Web04 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid