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]
Nov 12 '05
12 7532
cut 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)
thanks Fletcher!
I send you a copy of my database
send me your e-mail address in my private box pa************* ****@yahoo.it
you remove SPAM of the address
how can I reciprocate your kind help??
have a good day
Il Mon, 13 Oct 2003 15:38:15 GMT, alessia <al************ *@yahoo.it>
ha scritto: cut 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)
thanks Fletcher!
I send you a copy of my database
send me your e-mail address in my private box
pa************ *****@yahoo.it
you remove SPAM of the address
how can I reciprocate your kind help??
have a good day
opps....remove NOSPAM of the address... pa************* ****@yahoo.it
have a nice day!
ciao Fletcher!
"alessia" <al************ *@yahoo.it> wrote in message
news:un******** *************** *********@4ax.c om... Il Mon, 13 Oct 2003 15:38:15 GMT, alessia <al************ *@yahoo.it> ha scritto:
cut 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
canbe quite complicated. If you would like me to have a look at the
databasefor you then just create a copy, delete any private data and e-mail it
tome. (I''ve copied this message to your e-mail)
thanks Fletcher!
I send you a copy of my database
send me your e-mail address in my private box
pa************ *****@yahoo.it
you remove SPAM of the address
how can I reciprocate your kind help??
have a good day
opps....remove NOSPAM of the address...
pa************* ****@yahoo.it
have a nice day! ciao Fletcher!
Sent e-mail
Hope to hear from you soon
Fletcher This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Roy Riddex |
last post by:
I have a text file which holds data for 30 cars in the following way:
CarRegistration CarType CarClass Available
I'm trying to display the full contents of this text file in a list box so
the user can see the total car fleet, my problem is that I want everything
to line up. So far what I'm getting is something like:
R296RKV Ford Mondeo Large On Hire
TUVWXYZ ...
|
by: nunYa |
last post by:
I am trying to use the DoCmd.TransferText method to export an access table
to
a Tab Delimited Text File. I have put the code behind the onclick event of
a button
and keep getting the error "Run-time error '32027': Cannot update. Database
or object is read-only"
Code I using is:
Private Sub ExportButton_Click()
|
by: Marcelo |
last post by:
Hi,
I have to do the following, and would like you suggestions
on how I could achieve it the best way:
I have a text file in the following format:
12345 54321 98765 56789
(3 spaces between numbers)
|
by: Hexman |
last post by:
Code below ----
I'm trying to save some specific web pages to disk as text files. I searched the Internet and found a basic example which I changed to fit my needs.
I tested it out first on a single URL and it worked fine. Now when I incorporate an array of URL's, it fails to work. The first "responseFromServer"
properly retrieves and displays "http://finance.yahoo.com" (or any other valid URL for the first webrequest.create), but when I...
|
by: ETOPSA346 |
last post by:
Hello,
I am trying to write a program that will analyse a text file and do the following:
1. Count the number of characters.
2. Count the number of spaces.
3. Count the number of words.
4. Count the number of sentences.
5. Count the number of lines.
6. Ensure the 1st non-blank character in a sentence is capitalized. (I think this is done using a C function?)
| |
by: garth.waring |
last post by:
Hi all
I have seen the In Clause used to remotely query a text file done but
cannot find the right syntax
The example below is for an excel file :
SELECT *
FROM
IN 'C:\Reports\1620-1630_extract.xls ';
|
by: tariq103 |
last post by:
I am having trouble with a normally simple function, I am trying to read a text file and output what is in the file:
#include <iostream>
#include <cmath>
#include <iomanip>
#include <fstream> // To access a disk file (both input and output)
#include <string> // To use a sequence of characters
#include "Header.h"
using namespace std;
|
by: grumpydadtl |
last post by:
I am exporting a text file from Access that will be fed into a mainframe application (third party - not something I manage). The file contains a header record, body - which is the variable number of records to be imported into the mainframe, and a trailer record.
Upon export, Access automatically places a hard return after the trailer record - creating a new line after the trailer - albeit with no data on that line.
How can I create the...
|
by: CD Tom |
last post by:
This is driving me nuts!!! I have a table that one of the columns is set as Double, Fixed, 3 digits. I try and export this to a .txt file for a backup using the docmd.transfertext command but when I look at the file I only have 2 digits. What am I doing wrong and how can I get this to export 3 digits.
Hopefully come one can give me an answer.
Thanks for all your help.
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |