Click here to Skip to main content
15,897,891 members
Home / Discussions / C#
   

C#

 
GeneralRe: Access Exif Metadata Pin
Dave Dec20217-Dec-21 17:02
Dave Dec20217-Dec-21 17:02 
GeneralRe: Access Exif Metadata Pin
Luc Pattyn7-Dec-21 17:20
sitebuilderLuc Pattyn7-Dec-21 17:20 
GeneralRe: Access Exif Metadata Pin
Dave Dec20217-Dec-21 20:51
Dave Dec20217-Dec-21 20:51 
GeneralRe: Access Exif Metadata Pin
Richard MacCutchan7-Dec-21 22:13
mveRichard MacCutchan7-Dec-21 22:13 
GeneralRe: Access Exif Metadata Pin
Richard Deeming7-Dec-21 22:17
mveRichard Deeming7-Dec-21 22:17 
QuestionCreated Access DB, now how to load a list into a single column in the newly created DB. Pin
Richard A Knox4-Dec-21 6:18
Richard A Knox4-Dec-21 6:18 
AnswerRe: Created Access DB, now how to load a list into a single column in the newly created DB. Pin
OriginalGriff4-Dec-21 6:48
mveOriginalGriff4-Dec-21 6:48 
GeneralRe: Created Access DB, now how to load a list into a single column in the newly created DB. Pin
jsc426-Dec-21 2:58
professionaljsc426-Dec-21 2:58 
I agree with @OriginalGriff but over 20 years ago I had a requirement to do what you wanted (I forget the details now), probably for a report or some such. The code that I used was ...
(This code was run in-stream as a column inside the query in MS-Access, not as 'external' C# accessing an Ms-Access table)
VBScript
Function MakeList( _
    ByVal InSQL As String, _
    Optional ByVal InColName = 0, _
    Optional ByVal InSeparator As String = ",", _
    Optional ByVal InDataBase = "" _
    ) As String
    ' Convert a column from a table into a list
    '
    ' Parameters
    '   InSQL       SQL query
    '   InColName   Optional. Column containing data to be converted to a list
    '               (either by column number or by name)
    '   InSeparator Optional. Text to separate list items
    '   InDataBase  Optional. Database to find. Can be name (string) or
    '               database object. Current DB assumed if not specified
    '
    ' Result
    '   List of data
 
    Dim DB As Database
    Dim rs ' As Recordset
    
    ' Open the recordset
    If IsObject(InDataBase) Then
        Set DB = InDataBase
    Else
        Set DB = IIf(InDataBase = "", CurrentDb, OpenDatabase(InDataBase))
    End If
    
    Set rs = DB.OpenRecordset(InSQL)
    ' rs.MoveFirst
    While Not rs.EOF
        MakeList = MakeList & InSeparator & rs(InColName)
        rs.MoveNext
    Wend
    
    ' Get the data
    rs.Close
    DB.Close
    
    MakeList = Mid(MakeList, Len(InSeparator) + 1)  ' Drop first ','
End Function    ' MakeList

QuestionPass field Pin
Luis M. Rojas3-Dec-21 2:25
Luis M. Rojas3-Dec-21 2:25 
AnswerRe: Pass field Pin
Richard Deeming3-Dec-21 2:56
mveRichard Deeming3-Dec-21 2:56 
Questionthread safety and performance Pin
Super Lloyd2-Dec-21 15:31
Super Lloyd2-Dec-21 15:31 
GeneralRe: thread safety and performance Pin
harold aptroot2-Dec-21 16:03
harold aptroot2-Dec-21 16:03 
GeneralRe: thread safety and performance Pin
Super Lloyd2-Dec-21 17:59
Super Lloyd2-Dec-21 17:59 
AnswerRe: thread safety and performance Pin
trønderen3-Dec-21 2:36
trønderen3-Dec-21 2:36 
AnswerRe: thread safety and performance Pin
trønderen3-Dec-21 3:31
trønderen3-Dec-21 3:31 
QuestionUpdate/refresh Combobox in Form1 after doing an add from Form 2 Pin
Richard A Knox2-Dec-21 5:19
Richard A Knox2-Dec-21 5:19 
AnswerRe: Update/refresh Combobox in Form1 after doing an add from Form 2 Pin
BillWoodruff2-Dec-21 5:58
professionalBillWoodruff2-Dec-21 5:58 
GeneralRe: Update/refresh Combobox in Form1 after doing an add from Form 2 Pin
Richard A Knox4-Dec-21 6:08
Richard A Knox4-Dec-21 6:08 
GeneralRe: Update/refresh Combobox in Form1 after doing an add from Form 2 Pin
Gerry Schmitz5-Dec-21 8:04
mveGerry Schmitz5-Dec-21 8:04 
QuestionReading username Pin
Luis M. Rojas1-Dec-21 4:45
Luis M. Rojas1-Dec-21 4:45 
AnswerRe: Reading username Pin
lmoelleb3-Dec-21 18:36
lmoelleb3-Dec-21 18:36 
QuestionHow can I make the timer stay active after the program is closed? Pin
Duke Jason30-Nov-21 19:34
Duke Jason30-Nov-21 19:34 
AnswerRe: How can I make the timer stay active after the program is closed? Pin
OriginalGriff30-Nov-21 20:09
mveOriginalGriff30-Nov-21 20:09 
AnswerRe: How can I make the timer stay active after the program is closed? Pin
Pete O'Hanlon30-Nov-21 21:24
mvePete O'Hanlon30-Nov-21 21:24 
AnswerRe: How can I make the timer stay active after the program is closed? Pin
Dave Kreskowiak1-Dec-21 1:20
mveDave Kreskowiak1-Dec-21 1:20 

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.