Click here to Skip to main content
15,891,136 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Making some columns of datagrids uneditable Pin
hsprasain12-Jul-07 17:54
hsprasain12-Jul-07 17:54 
QuestionView and Review my looping code Pin
steve_rm5-Jul-07 7:27
steve_rm5-Jul-07 7:27 
AnswerRe: View and Review my looping code Pin
Christian Graus5-Jul-07 7:33
protectorChristian Graus5-Jul-07 7:33 
AnswerRe: View and Review my looping code Pin
kubben5-Jul-07 7:33
kubben5-Jul-07 7:33 
QuestionVisual Basic to Access Pin
Ronak0855-Jul-07 6:49
Ronak0855-Jul-07 6:49 
AnswerRe: Visual Basic to Access Pin
Christian Graus5-Jul-07 7:19
protectorChristian Graus5-Jul-07 7:19 
GeneralRe: Visual Basic to Access Pin
Ronak0856-Jul-07 1:21
Ronak0856-Jul-07 1:21 
AnswerRe: Visual Basic to Access Pin
jonathan155-Jul-07 7:52
jonathan155-Jul-07 7:52 
Am i correct in thinking Application_contact is a field name and AC.[text] is the text within a textbox named AC?

If i am correct then the SQL code is wrong. This part
Ronak085 wrote:
VALUES (AC.[text])


will do nothing. For example if you wanted to insert the text 'AC.[text]' then the code would need to look like:

VALUES ('AC.[text]') (note a string literal must be enclosed '')

if AC.[text] is a variable (which i think it is) it needs to be:

VALUES ( '" & AC.[text] & "')

string variables must be enclosed '" & & "'
Numerics are " & & "
and with Access dates are #" & & "#

#EDIT#
And before anyone else nags me about it.
I know parameterized queries are better.
Jon
GeneralRe: Visual Basic to Access Pin
Ronak0856-Jul-07 1:33
Ronak0856-Jul-07 1:33 
AnswerRe: Visual Basic to Access Pin
haggenx5-Jul-07 10:51
haggenx5-Jul-07 10:51 
QuestionUndo not working after Worksheet_Change Sub Routine in Excel Pin
reegan415-Jul-07 6:41
reegan415-Jul-07 6:41 
QuestionTopMost isnt working for me Pin
uk_nbb5-Jul-07 5:59
uk_nbb5-Jul-07 5:59 
AnswerRe: TopMost isnt working for me Pin
Christian Graus5-Jul-07 6:21
protectorChristian Graus5-Jul-07 6:21 
GeneralRe: TopMost isnt working for me Pin
uk_nbb5-Jul-07 6:36
uk_nbb5-Jul-07 6:36 
GeneralRe: TopMost isnt working for me Pin
Dave Kreskowiak5-Jul-07 15:45
mveDave Kreskowiak5-Jul-07 15:45 
AnswerRe: TopMost isnt working for me Pin
cutequencher5-Jul-07 6:22
cutequencher5-Jul-07 6:22 
AnswerRe: TopMost isnt working for me Pin
Luc Pattyn5-Jul-07 6:25
sitebuilderLuc Pattyn5-Jul-07 6:25 
GeneralRe: TopMost isnt working for me Pin
uk_nbb5-Jul-07 6:56
uk_nbb5-Jul-07 6:56 
Questiontextbox that accepts numbers only. urgent! Pin
cutequencher5-Jul-07 5:58
cutequencher5-Jul-07 5:58 
AnswerRe: textbox that accepts numbers only. urgent! Pin
cutequencher5-Jul-07 6:20
cutequencher5-Jul-07 6:20 
GeneralRe: textbox that accepts numbers only. urgent! Pin
Christian Graus5-Jul-07 6:22
protectorChristian Graus5-Jul-07 6:22 
GeneralRe: textbox that accepts numbers only. urgent! Pin
cutequencher5-Jul-07 6:28
cutequencher5-Jul-07 6:28 
QuestionCrystal Reports XI (Release 2) deployment Pin
manisghouri5-Jul-07 5:09
manisghouri5-Jul-07 5:09 
AnswerRe: Crystal Reports XI (Release 2) deployment Pin
kubben5-Jul-07 7:30
kubben5-Jul-07 7:30 
GeneralRe: Crystal Reports XI (Release 2) deployment Pin
manisghouri5-Jul-07 7:50
manisghouri5-Jul-07 7:50 

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.