Click here to Skip to main content
15,888,401 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: NEED 1 VB PROGRAMMER TO DEVELEP SOME SAMLL PROGRAMES FOR MY BUSINESS Pin
Jon_Boy13-Mar-09 9:36
Jon_Boy13-Mar-09 9:36 
AnswerRe: NEED 1 VB PROGRAMMER TO DEVELEP SOME SAMLL PROGRAMES FOR MY BUSINESS Pin
EliottA14-Mar-09 6:04
EliottA14-Mar-09 6:04 
AnswerRe: NEED 1 VB PROGRAMMER TO DEVELEP SOME SAMLL PROGRAMES FOR MY BUSINESS Pin
Christian Graus14-Mar-09 8:34
protectorChristian Graus14-Mar-09 8:34 
GeneralRe: NEED 1 VB PROGRAMMER TO DEVELEP SOME SAMLL PROGRAMES FOR MY BUSINESS Pin
0x3c015-Mar-09 6:39
0x3c015-Mar-09 6:39 
AnswerRe: NEED 1 VB PROGRAMMER TO DEVELEP SOME SAMLL PROGRAMES FOR MY BUSINESS Pin
Thomas Krojer16-Mar-09 5:31
Thomas Krojer16-Mar-09 5:31 
Questionado connection to access mdb file. Pin
udikantz13-Mar-09 4:29
udikantz13-Mar-09 4:29 
AnswerRe: ado connection to access mdb file. Pin
Dave Kreskowiak13-Mar-09 5:25
mveDave Kreskowiak13-Mar-09 5:25 
GeneralRe: ado connection to access mdb file. Pin
udikantz13-Mar-09 5:42
udikantz13-Mar-09 5:42 
yes,
in the command line the Query works
im executing the following query:

CurrentProject.Connection.Execute "ALTER TABLE Holiday ADD CONSTRAINT CalendarHoliday FOREIGN KEY ([calendarid]) REFERENCES Calendar ([id]) ON DELETE CASCADE"


although in the SQL designer window of access 2007
the following query wont work:

ALTER TABLE Holiday ADD CONSTRAINT CalendarHoliday FOREIGN KEY ([calendarid]) REFERENCES Calendar ([id]) 


generate same error as i get in the oleDB connector withing the .net framework:

syntax error in constrain calause

i dont know how to set a connection to the file so this query will work as it works in the immidiate window

Net

GeneralRe: ado connection to access mdb file. Pin
udikantz13-Mar-09 5:47
udikantz13-Mar-09 5:47 
AnswerRe: ado connection to access mdb file. Pin
paas13-Mar-09 6:11
paas13-Mar-09 6:11 
GeneralRe: ado connection to access mdb file. Pin
udikantz13-Mar-09 7:02
udikantz13-Mar-09 7:02 
GeneralRe: ado connection to access mdb file. Pin
udikantz13-Mar-09 23:07
udikantz13-Mar-09 23:07 
AnswerRe: ado connection to access mdb file. Pin
udikantz13-Mar-09 23:32
udikantz13-Mar-09 23:32 
QuestionAccessing Value from 2 class. Pin
Nanda_MR13-Mar-09 2:34
Nanda_MR13-Mar-09 2:34 
AnswerRe: Accessing Value from 2 class. Pin
dan!sh 13-Mar-09 2:42
professional dan!sh 13-Mar-09 2:42 
GeneralRe: Accessing Value from 2 class. Pin
Nanda_MR13-Mar-09 18:08
Nanda_MR13-Mar-09 18:08 
Questionvb.net 3.5 + serialport cotnrol + Threads = help Pin
ktheos13-Mar-09 2:23
ktheos13-Mar-09 2:23 
AnswerRe: vb.net 3.5 + serialport cotnrol + Threads = help Pin
Bharat Jain13-Mar-09 3:19
Bharat Jain13-Mar-09 3:19 
AnswerRe: vb.net 3.5 + serialport cotnrol + Threads = help Pin
Dave Kreskowiak13-Mar-09 4:51
mveDave Kreskowiak13-Mar-09 4:51 
QuestionHow to set text property of a ComponentControl Pin
popalzai13-Mar-09 1:16
popalzai13-Mar-09 1:16 
AnswerRe: How to set text property of a ComponentControl Pin
Dave Kreskowiak13-Mar-09 1:18
mveDave Kreskowiak13-Mar-09 1:18 
GeneralRe: How to set text property of a ComponentControl Pin
popalzai13-Mar-09 3:45
popalzai13-Mar-09 3:45 
GeneralRe: How to set text property of a ComponentControl Pin
Dave Kreskowiak13-Mar-09 4:45
mveDave Kreskowiak13-Mar-09 4:45 
GeneralRe: How to set text property of a ComponentControl Pin
popalzai13-Mar-09 6:02
popalzai13-Mar-09 6:02 
Questionhow to insert multi image in SQL an display it Pin
ngoctuan160812-Mar-09 23:52
ngoctuan160812-Mar-09 23:52 

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.