exporting query to text file [help!]

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • alessia

    exporting query to text file [help!]

    hi,
    I have a query that visualizes me, according to some criterions from
    me inserted, name , Surname , Address , phone
    ok..

    Now, through a button, positioned in a Form,
    I have to only export from this query the field telephone in a text
    file
    the name of the text file I would like to choose me...

    the text file example:

    345368998756
    345894614542
    168416616464
    165445648250



    they will have to appear a telephone number on every line without any
    ; or "
    as in the example that I have done here above..
    can someone help me? some example of code?
    thanks
    alexia
    i'm access newbie.....
    [I am desperate]



  • Fletcher Arnold

    #2
    Re: exporting query to text file [help!]

    "alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
    news:gv9bovc4sr drvj1scr3nah75n ica18lc9e@4ax.c om...[color=blue]
    > hi,
    > I have a query that visualizes me, according to some criterions from
    > me inserted, name , Surname , Address , phone
    > ok..
    >
    > Now, through a button, positioned in a Form,
    > I have to only export from this query the field telephone in a text
    > file
    > the name of the text file I would like to choose me...
    >
    > the text file example:
    >
    > 345368998756
    > 345894614542
    > 168416616464
    > 165445648250
    >
    >
    >
    > they will have to appear a telephone number on every line without any
    > ; or "
    > as in the example that I have done here above..
    > can someone help me? some example of code?
    > thanks
    > alexia
    > i'm access newbie.....
    > [I am desperate][/color]



    Create a new query "qryExport" which is based on your first query but
    selects only the phone number. Then, if the button on your form is named
    'cmdExport' the code might be as shown below. Note that if you need a
    better way to select the export file path, then there is code for this too.

    Private Sub cmdExport_Click ()

    On Error GoTo Err_Handler

    Dim strPath As String

    strPath = InputBox("Enter file path", , "C:\Shared\Test .txt")

    If Len(strPath) = 0 Then Exit Sub

    DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath

    MsgBox "Done", vbInformation

    Exit_Handler:
    Exit Sub

    Err_Handler:
    MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
    Resume Exit_Handler

    End Sub



    Comment

    • alessia

      #3
      Re: exporting query to text file [help!]

      Il Fri, 10 Oct 2003 08:06:24 +0000 (UTC), "Fletcher Arnold"
      <fletch@home.co m> ha scritto:
      [color=blue]
      >"alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
      >news:gv9bovc4s rdrvj1scr3nah75 nica18lc9e@4ax. com...[color=green]
      >> hi,
      >> I have a query that visualizes me, according to some criterions from
      >> me inserted, name , Surname , Address , phone
      >> ok..
      >>
      >> Now, through a button, positioned in a Form,
      >> I have to only export from this query the field telephone in a text
      >> file
      >> the name of the text file I would like to choose me...
      >>
      >> the text file example:
      >>
      >> 345368998756
      >> 345894614542
      >> 168416616464
      >> 165445648250
      >>
      >>
      >>
      >> they will have to appear a telephone number on every line without any
      >> ; or "
      >> as in the example that I have done here above..
      >> can someone help me? some example of code?
      >> thanks
      >> alexia
      >> i'm access newbie.....
      >> [I am desperate][/color]
      >
      >
      >
      >Create a new query "qryExport" which is based on your first query but
      >selects only the phone number. Then, if the button on your form is named
      >'cmdExport' the code might be as shown below. Note that if you need a
      >better way to select the export file path, then there is code for this too.
      >
      >Private Sub cmdExport_Click ()
      >
      > On Error GoTo Err_Handler
      >
      > Dim strPath As String
      >
      > strPath = InputBox("Enter file path", , "C:\Shared\Test .txt")
      >
      > If Len(strPath) = 0 Then Exit Sub
      >
      > DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath
      >
      > MsgBox "Done", vbInformation
      >
      >Exit_Handler :
      > Exit Sub
      >
      >Err_Handler:
      > MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
      > Resume Exit_Handler
      >
      >End Sub
      >
      >[/color]

      thanks! you are kind.. I immediately try the code that you have given
      me...
      it excuses my bad English... I am Italian
      good day

      Comment

      • alessia

        #4
        Re: exporting query to text file [help!]

        Il Sat, 11 Oct 2003 08:48:59 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
        ha scritto:

        [color=blue][color=green]
        >>Create a new query "qryExport" which is based on your first query but
        >>selects only the phone number. Then, if the button on your form is named
        >>'cmdExport' the code might be as shown below. Note that if you need a
        >>better way to select the export file path, then there is code for this too.
        >>
        >>Private Sub cmdExport_Click ()
        >>
        >> On Error GoTo Err_Handler
        >>
        >> Dim strPath As String
        >>
        >> strPath = InputBox("Enter file path", , "C:\Shared\Test .txt")
        >>
        >> If Len(strPath) = 0 Then Exit Sub
        >>
        >> DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath
        >>
        >> MsgBox "Done", vbInformation
        >>
        >>Exit_Handle r:
        >> Exit Sub
        >>
        >>Err_Handler :
        >> MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
        >> Resume Exit_Handler
        >>
        >>End Sub
        >>[/color][/color]

        OK, work! great! thanks Fletcher!

        however when I open the created text file
        the telephone numbers come me this way

        "33323214154163 85"
        "51564684815654 84"

        how do I do for eliminating the " "??

        I would like only the telephone number in this way

        1515645166544
        1454468468154

        have a good day!


        Comment

        • Fletcher Arnold

          #5
          Re: exporting query to text file [help!]

          "alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
          news:k2pfovcheq ptom11ec90c69f9 hjd7kfn07@4ax.c om...[color=blue]
          > Il Sat, 11 Oct 2003 08:48:59 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
          > ha scritto:
          >
          >[color=green][color=darkred]
          > >>Create a new query "qryExport" which is based on your first query but
          > >>selects only the phone number. Then, if the button on your form is[/color][/color][/color]
          named[color=blue][color=green][color=darkred]
          > >>'cmdExport' the code might be as shown below. Note that if you need a
          > >>better way to select the export file path, then there is code for this[/color][/color][/color]
          too.[color=blue][color=green][color=darkred]
          > >>
          > >>Private Sub cmdExport_Click ()
          > >>
          > >> On Error GoTo Err_Handler
          > >>
          > >> Dim strPath As String
          > >>
          > >> strPath = InputBox("Enter file path", , "C:\Shared\Test .txt")
          > >>
          > >> If Len(strPath) = 0 Then Exit Sub
          > >>
          > >> DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath
          > >>
          > >> MsgBox "Done", vbInformation
          > >>
          > >>Exit_Handle r:
          > >> Exit Sub
          > >>
          > >>Err_Handler :
          > >> MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
          > >> Resume Exit_Handler
          > >>
          > >>End Sub
          > >>[/color][/color]
          >
          > OK, work! great! thanks Fletcher!
          >
          > however when I open the created text file
          > the telephone numbers come me this way
          >
          > "33323214154163 85"
          > "51564684815654 84"
          >
          > how do I do for eliminating the " "??
          >
          > I would like only the telephone number in this way
          >
          > 1515645166544
          > 1454468468154
          >
          > have a good day![/color]



          There are a number of ways to do this. Perhaps the easiest is:

          1. Select qryExport in the database window.
          2. From the menu at the top choose File>Export
          3. Select filename and type = text then press Export
          4. On this screen you can press "Advanced"
          5. Set up your options here - especially change text qualifier from " to
          none
          6. Choose Save as ..."QryExport Export Specification"
          7. Finish export

          You can now change the code from:
          DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath
          to:
          DoCmd.TransferT ext acExportDelim, "QryExport Export Specification",
          "qryExport" , strPath


          If this is too difficult I could write some code to do this for you.


          Fletcher


          Comment

          • alessia

            #6
            Re: exporting query to text file [help!]

            Il Sat, 11 Oct 2003 12:19:58 +0000 (UTC), "Fletcher Arnold"
            <fletch@home.co m> ha scritto:
            [color=blue]
            >"alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
            >news:k2pfovche qptom11ec90c69f 9hjd7kfn07@4ax. com...[color=green]
            >> Il Sat, 11 Oct 2003 08:48:59 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
            >> ha scritto:
            >>
            >>[color=darkred]
            >> >>Create a new query "qryExport" which is based on your first query but
            >> >>selects only the phone number. Then, if the button on your form is[/color][/color]
            >named[color=green][color=darkred]
            >> >>'cmdExport' the code might be as shown below. Note that if you need a
            >> >>better way to select the export file path, then there is code for this[/color][/color]
            >too.[color=green][color=darkred]
            >> >>
            >> >>Private Sub cmdExport_Click ()
            >> >>
            >> >> On Error GoTo Err_Handler
            >> >>
            >> >> Dim strPath As String
            >> >>
            >> >> strPath = InputBox("Enter file path", , "C:\Shared\Test .txt")
            >> >>
            >> >> If Len(strPath) = 0 Then Exit Sub
            >> >>
            >> >> DoCmd.TransferT ext acExportDelim, , "qryExport" , strPath
            >> >>
            >> >> MsgBox "Done", vbInformation
            >> >>
            >> >>Exit_Handle r:
            >> >> Exit Sub
            >> >>
            >> >>Err_Handler :
            >> >> MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
            >> >> Resume Exit_Handler
            >> >>
            >> >>End Sub
            >> >>[/color]
            >>
            >> OK, work! great! thanks Fletcher!
            >>
            >> however when I open the created text file
            >> the telephone numbers come me this way
            >>
            >> "33323214154163 85"
            >> "51564684815654 84"
            >>
            >> how do I do for eliminating the " "??
            >>
            >> I would like only the telephone number in this way
            >>
            >> 1515645166544
            >> 1454468468154
            >>
            >> have a good day![/color]
            >
            >
            >
            >There are a number of ways to do this. Perhaps the easiest is:
            >
            >1. Select qryExport in the database window.
            >2. From the menu at the top choose File>Export
            >3. Select filename and type = text then press Export
            >4. On this screen you can press "Advanced"
            >5. Set up your options here - especially change text qualifier from " to
            >none
            >6. Choose Save as ..."QryExport Export Specification"
            >7. Finish export
            >
            >You can now change the code from:
            >DoCmd.Transfer Text acExportDelim, , "qryExport" , strPath
            >to:
            >DoCmd.Transfer Text acExportDelim, "QryExport Export Specification",
            >"qryExport" , strPath
            >
            >
            >If this is too difficult I could write some code to do this for you.
            >
            >
            >Fletcher
            >[/color]

            thanks Fletcher! very much!

            have a nice day!

            Alessia.

            Comment

            • alessia

              #7
              Re: exporting query to text file [help!]

              Il Sat, 11 Oct 2003 22:50:16 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
              ha scritto:
              [color=blue]
              >If this is too difficult I could write some code to do this for you.[/color]

              I have tried what you have suggested me you, Fletcher, but I would
              prefer to serve everything as code... I would not like to disturb too
              much, and if you have of the of leisure time to write the code, I
              would be thankful of it... if it doesn't find you possible...don' t
              worry you...I thank you... you have been kind indeed.
              [i'm sorry my bad english...I hope is understood ]

              alessia

              Comment

              • Fletcher Arnold

                #8
                Re: exporting query to text file [help!]


                "alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
                news:ti1iov8ftv 0635lft6q5jle73 1mebg5um1@4ax.c om...[color=blue]
                > Il Sat, 11 Oct 2003 22:50:16 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
                > ha scritto:
                >[color=green]
                > >If this is too difficult I could write some code to do this for you.[/color]
                >
                > I have tried what you have suggested me you, Fletcher, but I would
                > prefer to serve everything as code... I would not like to disturb too
                > much, and if you have of the of leisure time to write the code, I
                > would be thankful of it... if it doesn't find you possible...don' t
                > worry you...I thank you... you have been kind indeed.
                > [i'm sorry my bad english...I hope is understood ]
                >
                > alessia[/color]

                Hi Alessia
                I am glad that you got the code to work. Don't worry about your English -
                its fine, and very polite!
                The following code is one possible version. It assumes your query is
                "qryExport" which contains the field "Tel" - if not change the lines:
                Set rst = dbs.OpenRecords et("qryExport" ...
                and
                Print #intFile, Nz(rst!Tel, "")

                When you paste the new code in, make sure you compile the code -
                Debug>Compile. If it does not compile, check Tools>Reference s and make sure
                the box Microsoft DAO 3.6 Object Library is checked.

                Good Luck

                Fletcher


                Private Sub cmdExport_Click ()

                On Error GoTo Err_Handler

                Dim strPath As String
                Dim intFile As Integer
                Dim strLine As String
                Dim dbs As DAO.Database
                Dim rst As DAO.Recordset

                strPath = InputBox("Enter file path", _
                "Export", _
                "C:\Shared\Test .txt")

                If Len(strPath) = 0 Then Exit Sub

                If Len(Dir(strPath )) > 0 Then
                If MsgBox("This file already exists" & vbCrLf & _
                "Would you like to overwrite it?", _
                vbExclamation Or vbYesNoCancel, _
                "Export") <> vbYes Then Exit Sub
                End If

                intFile = FreeFile

                Open strPath For Output As #intFile

                Set dbs = CurrentDb

                Set rst = dbs.OpenRecords et("qryExport" , dbOpenForwardOn ly)

                While Not rst.EOF
                Print #intFile, Nz(rst!Tel, "")
                rst.MoveNext
                Wend

                MsgBox "Export routine complete", _
                vbInformation, "Export"

                Exit_Handler:

                On Error Resume Next

                If Not rst Is Nothing Then
                rst.Close
                Set rst = Nothing
                End If

                If Not dbs Is Nothing Then
                Set dbs = Nothing
                End If

                Close #intFile

                Exit Sub

                Err_Handler:
                MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
                Resume Exit_Handler

                End Sub




                Comment

                • alessia

                  #9
                  Re: exporting query to text file [help!]

                  Il Sun, 12 Oct 2003 20:15:58 +0000 (UTC), "Fletcher Arnold"
                  <fletch@home.co m> ha scritto:

                  [color=blue]
                  >Hi Alessia
                  >I am glad that you got the code to work. Don't worry about your English -
                  >its fine, and very polite!
                  >The following code is one possible version. It assumes your query is
                  >"qryExport" which contains the field "Tel" - if not change the lines:
                  >Set rst = dbs.OpenRecords et("qryExport" ...
                  >and
                  >Print #intFile, Nz(rst!Tel, "")
                  >
                  >When you paste the new code in, make sure you compile the code -
                  >Debug>Compil e. If it does not compile, check Tools>Reference s and make sure
                  >the box Microsoft DAO 3.6 Object Library is checked.
                  >
                  >Good Luck
                  >
                  >Fletcher
                  >
                  >
                  >Private Sub cmdExport_Click ()
                  >
                  > On Error GoTo Err_Handler
                  >
                  > Dim strPath As String
                  > Dim intFile As Integer
                  > Dim strLine As String
                  > Dim dbs As DAO.Database
                  > Dim rst As DAO.Recordset
                  >
                  > strPath = InputBox("Enter file path", _
                  > "Export", _
                  > "C:\Shared\Test .txt")
                  >
                  > If Len(strPath) = 0 Then Exit Sub
                  >
                  > If Len(Dir(strPath )) > 0 Then
                  > If MsgBox("This file already exists" & vbCrLf & _
                  > "Would you like to overwrite it?", _
                  > vbExclamation Or vbYesNoCancel, _
                  > "Export") <> vbYes Then Exit Sub
                  > End If
                  >
                  > intFile = FreeFile
                  >
                  > Open strPath For Output As #intFile
                  >
                  > Set dbs = CurrentDb
                  >
                  > Set rst = dbs.OpenRecords et("qryExport" , dbOpenForwardOn ly)
                  >
                  > While Not rst.EOF
                  > Print #intFile, Nz(rst!Tel, "")
                  > rst.MoveNext
                  > Wend
                  >
                  > MsgBox "Export routine complete", _
                  > vbInformation, "Export"
                  >
                  >Exit_Handler :
                  >
                  > On Error Resume Next
                  >
                  > If Not rst Is Nothing Then
                  > rst.Close
                  > Set rst = Nothing
                  > End If
                  >
                  > If Not dbs Is Nothing Then
                  > Set dbs = Nothing
                  > End If
                  >
                  > Close #intFile
                  >
                  > Exit Sub
                  >
                  >Err_Handler:
                  > MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
                  > Resume Exit_Handler
                  >
                  >End Sub
                  >
                  >
                  >[/color]

                  Ciao Super - Fletcher
                  I mind giving you so much trouble, I have copied the code that you
                  have given me, I have modified the interested lines, I have compiled
                  the program...I press the button, I insert the path and the name of
                  the file, and this error signals me...

                  Error No: 3061
                  non enough parameters. 3
                  [I hope both corrected the translation]

                  the file test.txt has been created... but it is empty..

                  I have modified only these lines

                  Set rst = dbs.OpenRecords et("query_fuori orario_cell",
                  dbOpenForwardOn ly)


                  and


                  Print #intFile, Nz(rst!cell, "")


                  query_fuori_ora rio : it's my export query
                  cell : it's a field of query_fuori_ora rio


                  according to you, as can I resolve this error??

                  I don't so finally disturb still you...

                  thx, Fletcher....

                  where r u from Fletcher?

                  i live in venice...

                  have a nice day!



                  Comment

                  • Fletcher Arnold

                    #10
                    Re: exporting query to text file [help!]

                    "alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
                    news:0ihjovckg3 iq49ghiohg5dvq3 iq1qag4gr@4ax.c om...[color=blue]
                    > Il Sun, 12 Oct 2003 20:15:58 +0000 (UTC), "Fletcher Arnold"
                    > <fletch@home.co m> ha scritto:
                    >
                    >[color=green]
                    > >Hi Alessia
                    > >I am glad that you got the code to work. Don't worry about your[/color][/color]
                    English -[color=blue][color=green]
                    > >its fine, and very polite!
                    > >The following code is one possible version. It assumes your query is
                    > >"qryExport" which contains the field "Tel" - if not change the lines:
                    > >Set rst = dbs.OpenRecords et("qryExport" ...
                    > >and
                    > >Print #intFile, Nz(rst!Tel, "")
                    > >
                    > >When you paste the new code in, make sure you compile the code -
                    > >Debug>Compil e. If it does not compile, check Tools>Reference s and make[/color][/color]
                    sure[color=blue][color=green]
                    > >the box Microsoft DAO 3.6 Object Library is checked.
                    > >
                    > >Good Luck
                    > >
                    > >Fletcher
                    > >
                    > >
                    > >Private Sub cmdExport_Click ()
                    > >
                    > > On Error GoTo Err_Handler
                    > >
                    > > Dim strPath As String
                    > > Dim intFile As Integer
                    > > Dim strLine As String
                    > > Dim dbs As DAO.Database
                    > > Dim rst As DAO.Recordset
                    > >
                    > > strPath = InputBox("Enter file path", _
                    > > "Export", _
                    > > "C:\Shared\Test .txt")
                    > >
                    > > If Len(strPath) = 0 Then Exit Sub
                    > >
                    > > If Len(Dir(strPath )) > 0 Then
                    > > If MsgBox("This file already exists" & vbCrLf & _
                    > > "Would you like to overwrite it?", _
                    > > vbExclamation Or vbYesNoCancel, _
                    > > "Export") <> vbYes Then Exit Sub
                    > > End If
                    > >
                    > > intFile = FreeFile
                    > >
                    > > Open strPath For Output As #intFile
                    > >
                    > > Set dbs = CurrentDb
                    > >
                    > > Set rst = dbs.OpenRecords et("qryExport" , dbOpenForwardOn ly)
                    > >
                    > > While Not rst.EOF
                    > > Print #intFile, Nz(rst!Tel, "")
                    > > rst.MoveNext
                    > > Wend
                    > >
                    > > MsgBox "Export routine complete", _
                    > > vbInformation, "Export"
                    > >
                    > >Exit_Handler :
                    > >
                    > > On Error Resume Next
                    > >
                    > > If Not rst Is Nothing Then
                    > > rst.Close
                    > > Set rst = Nothing
                    > > End If
                    > >
                    > > If Not dbs Is Nothing Then
                    > > Set dbs = Nothing
                    > > End If
                    > >
                    > > Close #intFile
                    > >
                    > > Exit Sub
                    > >
                    > >Err_Handler:
                    > > MsgBox Err.Description , vbExclamation, "Error No: " & Err.Number
                    > > Resume Exit_Handler
                    > >
                    > >End Sub
                    > >
                    > >
                    > >[/color]
                    >
                    > Ciao Super - Fletcher
                    > I mind giving you so much trouble, I have copied the code that you
                    > have given me, I have modified the interested lines, I have compiled
                    > the program...I press the button, I insert the path and the name of
                    > the file, and this error signals me...
                    >
                    > Error No: 3061
                    > non enough parameters. 3
                    > [I hope both corrected the translation]
                    >
                    > the file test.txt has been created... but it is empty..
                    >
                    > I have modified only these lines
                    >
                    > Set rst = dbs.OpenRecords et("query_fuori orario_cell",
                    > dbOpenForwardOn ly)
                    >
                    >
                    > and
                    >
                    >
                    > Print #intFile, Nz(rst!cell, "")
                    >
                    >
                    > query_fuori_ora rio : it's my export query
                    > cell : it's a field of query_fuori_ora rio
                    >
                    >
                    > according to you, as can I resolve this error??
                    >
                    > I don't so finally disturb still you...
                    >
                    > thx, Fletcher....
                    >
                    > where r u from Fletcher?
                    >
                    > i live in venice...
                    >
                    > have a nice day![/color]


                    Error 3061 is caused by the query. I don't know what the SQL for
                    "query_fuoriora rio_cell" looks like, but if you had:

                    SELECT TelNumber
                    FROM tblNumbers
                    WHERE SomeDate=[Forms]![frm1].[txtSomeDate]

                    Then the query would produce this error. It cannot work out this bit
                    [Forms]![frm1].[txtSomeDate].

                    The solution to this is to build up the sql string separately - but this can
                    be quite complicated. If you would like me to have a look at the database
                    for you then just create a copy, delete any private data and e-mail it to
                    me. (I''ve copied this message to your e-mail)


                    Comment

                    • alessia

                      #11
                      Re: exporting query to text file [help!]


                      cut[color=blue]
                      >
                      >Error 3061 is caused by the query. I don't know what the SQL for
                      >"query_fuorior ario_cell" looks like, but if you had:
                      >
                      >SELECT TelNumber
                      >FROM tblNumbers
                      >WHERE SomeDate=[Forms]![frm1].[txtSomeDate]
                      >
                      >Then the query would produce this error. It cannot work out this bit
                      >[Forms]![frm1].[txtSomeDate].
                      >
                      >The solution to this is to build up the sql string separately - but this can
                      >be quite complicated. If you would like me to have a look at the database
                      >for you then just create a copy, delete any private data and e-mail it to
                      >me. (I''ve copied this message to your e-mail)
                      >[/color]

                      thanks Fletcher!

                      I send you a copy of my database

                      send me your e-mail address in my private box

                      panteresemperNO SPAM@yahoo.it

                      you remove SPAM of the address

                      how can I reciprocate your kind help??

                      have a good day

                      Comment

                      • alessia

                        #12
                        Re: exporting query to text file [help!]

                        Il Mon, 13 Oct 2003 15:38:15 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
                        ha scritto:
                        [color=blue]
                        >
                        >cut[color=green]
                        >>
                        >>Error 3061 is caused by the query. I don't know what the SQL for
                        >>"query_fuorio rario_cell" looks like, but if you had:
                        >>
                        >>SELECT TelNumber
                        >>FROM tblNumbers
                        >>WHERE SomeDate=[Forms]![frm1].[txtSomeDate]
                        >>
                        >>Then the query would produce this error. It cannot work out this bit
                        >>[Forms]![frm1].[txtSomeDate].
                        >>
                        >>The solution to this is to build up the sql string separately - but this can
                        >>be quite complicated. If you would like me to have a look at the database
                        >>for you then just create a copy, delete any private data and e-mail it to
                        >>me. (I''ve copied this message to your e-mail)
                        >>[/color]
                        >
                        >thanks Fletcher!
                        >
                        >I send you a copy of my database
                        >
                        >send me your e-mail address in my private box
                        >
                        >panteresemperN OSPAM@yahoo.it
                        >
                        >you remove SPAM of the address
                        >
                        >how can I reciprocate your kind help??
                        >
                        >have a good day[/color]


                        opps....remove NOSPAM of the address...

                        panteresemperNO SPAM@yahoo.it


                        have a nice day!
                        ciao Fletcher!

                        Comment

                        • Fletcher Arnold

                          #13
                          Re: exporting query to text file [help!]

                          "alessia" <alex71_pnNOSPA M@yahoo.it> wrote in message
                          news:unhlovo1m4 6rlerl5dfqb84kh al2bpjjjf@4ax.c om...[color=blue]
                          > Il Mon, 13 Oct 2003 15:38:15 GMT, alessia <alex71_pnNOSPA M@yahoo.it>
                          > ha scritto:
                          >[color=green]
                          > >
                          > >cut[color=darkred]
                          > >>
                          > >>Error 3061 is caused by the query. I don't know what the SQL for
                          > >>"query_fuorio rario_cell" looks like, but if you had:
                          > >>
                          > >>SELECT TelNumber
                          > >>FROM tblNumbers
                          > >>WHERE SomeDate=[Forms]![frm1].[txtSomeDate]
                          > >>
                          > >>Then the query would produce this error. It cannot work out this bit
                          > >>[Forms]![frm1].[txtSomeDate].
                          > >>
                          > >>The solution to this is to build up the sql string separately - but this[/color][/color][/color]
                          can[color=blue][color=green][color=darkred]
                          > >>be quite complicated. If you would like me to have a look at the[/color][/color][/color]
                          database[color=blue][color=green][color=darkred]
                          > >>for you then just create a copy, delete any private data and e-mail it[/color][/color][/color]
                          to[color=blue][color=green][color=darkred]
                          > >>me. (I''ve copied this message to your e-mail)
                          > >>[/color]
                          > >
                          > >thanks Fletcher!
                          > >
                          > >I send you a copy of my database
                          > >
                          > >send me your e-mail address in my private box
                          > >
                          > >panteresemperN OSPAM@yahoo.it
                          > >
                          > >you remove SPAM of the address
                          > >
                          > >how can I reciprocate your kind help??
                          > >
                          > >have a good day[/color]
                          >
                          >
                          > opps....remove NOSPAM of the address...
                          >
                          > panteresemperNO SPAM@yahoo.it
                          >
                          >
                          > have a nice day!
                          > ciao Fletcher![/color]


                          Sent e-mail
                          Hope to hear from you soon

                          Fletcher


                          Comment

                          Working...