Click here to Skip to main content
15,892,746 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Before a Control loses focus can I detect the next focus target? Pin
Richard Fairhurst26-Sep-12 10:32
Richard Fairhurst26-Sep-12 10:32 
QuestionTelephone Tracking system through GPS Pin
waner michaud26-Sep-12 8:12
waner michaud26-Sep-12 8:12 
AnswerRe: Telephone Tracking system through GPS Pin
Eddy Vluggen27-Sep-12 0:16
professionalEddy Vluggen27-Sep-12 0:16 
QuestionDatagrid row count equals zero Pin
Cesar00226-Sep-12 6:49
Cesar00226-Sep-12 6:49 
AnswerRe: Datagrid row count equals zero Pin
Cesar00226-Sep-12 10:05
Cesar00226-Sep-12 10:05 
QuestionRe: Datagrid row count equals zero Pin
Eddy Vluggen26-Sep-12 10:32
professionalEddy Vluggen26-Sep-12 10:32 
AnswerRe: Datagrid row count equals zero Pin
Cesar00226-Sep-12 16:28
Cesar00226-Sep-12 16:28 
QuestionTricky SQL Question Pin
ttocsmi25-Sep-12 10:42
ttocsmi25-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
Martijn Kok25-Sep-12 11:40 
GeneralRe: Tricky SQL Question Pin
ttocsmi25-Sep-12 14:13
ttocsmi25-Sep-12 14:13 
GeneralRe: Tricky SQL Question Pin
Bernhard Hiller25-Sep-12 23:13
Bernhard Hiller25-Sep-12 23:13 
GeneralRe: Tricky SQL Question Pin
Martijn Kok25-Sep-12 23:27
Martijn Kok25-Sep-12 23:27 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 1:56
ttocsmi1-Oct-12 1:56 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 1:51
ttocsmi1-Oct-12 1:51 
AnswerRe: Tricky SQL Question Pin
Bernhard Hiller25-Sep-12 23:15
Bernhard Hiller25-Sep-12 23:15 
GeneralRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 2:12
ttocsmi1-Oct-12 2:12 
AnswerRe: Tricky SQL Question Pin
ttocsmi1-Oct-12 4:34
ttocsmi1-Oct-12 4:34 
GeneralRe: Tricky SQL Question Pin
Martijn Kok1-Oct-12 5:13
Martijn Kok1-Oct-12 5:13 
QuestionRemote SQL server connection in visual basic /VBA Pin
bsjhala25-Sep-12 2:17
bsjhala25-Sep-12 2:17 
AnswerRe: Remote SQL server connection in visual basic /VBA Pin
ChandraRam26-Sep-12 3:04
ChandraRam26-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
wizy@202024-Sep-12 23:05
wizy@202024-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
professionalEddy 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
David 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
mveDave 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
professionalEddy Vluggen25-Sep-12 4:41 

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

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