Click here to Skip to main content
15,901,283 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionRe: Problem with check box Pin
nazimghori21-Mar-09 23:11
nazimghori21-Mar-09 23:11 
AnswerRe: Problem with check box Pin
DaveAuld21-Mar-09 23:52
professionalDaveAuld21-Mar-09 23:52 
AnswerRe: Problem with check box Pin
Henry Minute23-Mar-09 10:57
Henry Minute23-Mar-09 10:57 
QuestionRe: Problem with check box Pin
Leinad_3021-Dec-10 12:08
Leinad_3021-Dec-10 12:08 
Questionvb.net pass paraqmeters to crystal reports Pin
jazzgirl20-Mar-09 19:57
jazzgirl20-Mar-09 19:57 
QuestionHow do i handle Group Hierarchy? Pin
r_mohd20-Mar-09 18:18
r_mohd20-Mar-09 18:18 
AnswerRe: How do i handle Group Hierarchy? Pin
Henry Minute21-Mar-09 9:57
Henry Minute21-Mar-09 9:57 
QuestionUsing functions in Access Modules using OLEDb ExecuteNonQuery Pin
Rob Beckinsale20-Mar-09 6:23
Rob Beckinsale20-Mar-09 6:23 
I have an application that does maintenence tasks on the Access database.
Most of the functionality works fine but when I want to use a function that resides in one of the module of the database the query does not find the function.

All dates on the source tables of the database are held as YYYYMMDD. I have a function called fromsysdate('YYYYMMDD') which converts this into date format for users to view.

Here is an example of the code that I'm submitting using ExecuteNonQuery through a OLEDb connection.

"Select forename, surname, fromsysdate(dob) as dateofbirth
into birthdays from main "

The same functions also are included in my VB app. I wondered about exporting the access functions to a DLL and then adding the DLL back int ot he database - would it be recognised then? Or is this all just a syntax thing?

Cheers for any thoughts...

rob
AnswerRe: Using functions in Access Modules using OLEDb ExecuteNonQuery Pin
Eddy Vluggen21-Mar-09 0:22
professionalEddy Vluggen21-Mar-09 0:22 
GeneralRe: Using functions in Access Modules using OLEDb ExecuteNonQuery Pin
Rob Beckinsale21-Mar-09 1:13
Rob Beckinsale21-Mar-09 1:13 
QuestionVB??????? Pin
jackjames1548620-Mar-09 6:18
jackjames1548620-Mar-09 6:18 
AnswerRe: VB??????? Pin
Jon_Boy20-Mar-09 7:24
Jon_Boy20-Mar-09 7:24 
AnswerRe: VB??????? Pin
Dave Kreskowiak20-Mar-09 10:21
mveDave Kreskowiak20-Mar-09 10:21 
AnswerRe: VB??????? Pin
Christian Graus20-Mar-09 11:08
protectorChristian Graus20-Mar-09 11:08 
Questiondll function and arguments Pin
Member 300016220-Mar-09 4:42
Member 300016220-Mar-09 4:42 
AnswerRe: dll function and arguments Pin
Dave Kreskowiak20-Mar-09 4:58
mveDave Kreskowiak20-Mar-09 4:58 
GeneralRe: dll function and arguments Pin
Jon_Boy20-Mar-09 5:07
Jon_Boy20-Mar-09 5:07 
GeneralRe: dll function and arguments Pin
Member 300016220-Mar-09 10:53
Member 300016220-Mar-09 10:53 
QuestionCOM Exception in VB6 to VB.NET conversion [modified] Pin
BREdwards20-Mar-09 2:37
BREdwards20-Mar-09 2:37 
QuestionHow do i capture httprequest or header? Pin
milansolanki19-Mar-09 23:53
milansolanki19-Mar-09 23:53 
AnswerRe: How do i capture httprequest or header? Pin
Dave Kreskowiak20-Mar-09 5:00
mveDave Kreskowiak20-Mar-09 5:00 
AnswerRe: How do i capture httprequest or header? Pin
tech60320-Mar-09 17:48
tech60320-Mar-09 17:48 
QuestionVB call to SAP Remote Functions Pin
yog211219-Mar-09 23:47
yog211219-Mar-09 23:47 
AnswerRe: VB call to SAP Remote Functions Pin
Vimalsoft(Pty) Ltd20-Mar-09 2:27
professionalVimalsoft(Pty) Ltd20-Mar-09 2:27 
GeneralRe: VB call to SAP Remote Functions Pin
yog211220-Mar-09 6:28
yog211220-Mar-09 6:28 

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.