Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253

    Steve,

    You are the man. I have been going many different ways with this and I think I was getting close. You fixed everything I was having trouble with, very much appreciated. I have been struggling with the simple things you found for a couple of weeks now.

    I am not sure what you mean by deleting the first record. A real QRCode does not have any headers. I greatly appreciate all you did for this project.

  2. #17
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Great! I hope you understand what changes I made.


    this is why I asked about deleting the first record. Your code has
    Code:
    Private Sub QRStrToTable(Qstr As String)
    
        Dim sRec, sFld As String
        Dim sqlstr, tblstr As String
        Dim i, i2, iRec, iFld As Integer
    
        iRec = 1
        i = InStr(QRCode, "*")
        If i > 0 Then
            sRec = Left(QRCode, i - 1)    'get next record in string
            sRec = sRec & ";"
            MsgBox (sRec)
            QRCode = Mid(QRCode, i + 1)    'remove first record
            MsgBox (QRCode)
    
            tblstr = ""
            iFld = 1
    Doesn't really matter now, as long as you are happy with the results......


    Good luck with your project.

  3. #18
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    I understood the changes you made after i studied it for a little bit.

    As far as deleting the first record, I wasn't trying to delete it. I was just trying to parse one record off the front of the string and then parse the fields in that record. Then repeat for the rest of the records.

    I am very happy with what you did. Now i can move on to the next part of developing this database.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 09-09-2015, 12:10 PM
  2. Linking a table to a 3GB text file?
    By kestefon in forum Access
    Replies: 2
    Last Post: 12-20-2013, 05:50 PM
  3. writing to text file (array set)
    By pradeep.sands in forum Forms
    Replies: 5
    Last Post: 08-02-2013, 02:37 PM
  4. Replies: 2
    Last Post: 12-27-2012, 09:37 AM
  5. Writing text to log file.
    By winsonlee in forum Programming
    Replies: 2
    Last Post: 08-05-2011, 12:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums