I'm using Access 2007-2010.
I want to export Query to PIPE delimited text file.
I don't know how to write code.
External Data tab Exports to Excel or txt file just fine. But I'm not seeing a way, (such as an Advanced checkbox), to specify the delimiter.
Is there a way to export the Query results and specify the delimiter?
Paul Howarth
Last Activity: Apr 15 '16, 03:01 AM
Joined: Dec 29 '10
Location:
-
Export Query to PIPE delimited text file
-
The Control for Due Date is a text box. -
Can't format Date in Report
In my invoice report, I would like to format DueDate the same way I am formatting InvoiceDate. See example in attached picture.
In Design View, the Report's InvoiceDate is formatted as Medium Date and the Report's DueDate cannot be formatted because the formatting tool is greyed out.
InvoiceDate comes from an existing date field of an existing table.
In the Query, if another field (State) =... -
Report Errors when running Crosstab Query w Parameter
Hopefully I am replying to your request for add'l info in the correct way....
I am using Access 2010 from Office 2010. My issue in the design view of the report has never happened to me in any of the dozens of reports I have created - including reports that rely on crosstab queries.
Hopefully I am about to insert the SQL code from the...Last edited by zmbd; Feb 22 '13, 04:16 AM. Reason: [Z{Stepped the SQL for Better Read}{inserted attached jpg inline}]Leave a comment:
-
Report Errors when running Crosstab Query with Parameter
I posted this question....
http://bytes.com/topic/access/answer...cess-error-msg
...and was provided with the following support link which completely resolved the error message I was getting when running the Query:
http://support.microsoft.com/?id=209778
Now that the Query is running just fine, I have a new problem when running the Report which... -
When I open the Query after setting the StartDate and EndDate parameters, it prompts me once for StartDate and EndDate and displays the data just fine.
When I open the Report that uses the same Query, I am prompted multiple times for StartDate and EndDate. Wierd.
Any suggestions?
(For now, my dumb workaround is to press "Cancel" for the first 3 StartDate prompts and then to input StartDate and EndDate just...Leave a comment:
-
That link provides the solution.
Thanks!Leave a comment:
-
Are Crosstab Queries responsible this Access Error Msg?
I have no problem when I use the following date filter with a Simple Query:
Between [StartDate] And [EndDate]
But I am running into an impasse when I have a query which is referencing a Crosstab query.
I want to filter the results between two dates.
For example, the following works just fine - even when a Crosstab Query is involved:
Between #1/1/2012# And #3/1/201... -
Exporting Date() to a Text File without exporting the time too
I am exporting a Query to a Text File. One of my fields is the current Date. F1:Date()
When I look at the text file, my date is displaying the System Date which includes the time.
Example: 10-29-2012 0:00:00
I only want to export the date portion but can't figure out how to get rid of the time portion.
Desired Result: 10-29-2012
In the query, I did try playing with the Field Properties... -
Hi Twinnyfo,
My initial reaction to your question was "no". But after spending several hours testing different things, I realized that I had used the =Upper function in Excel to convert all the mailing addresses to Upper Case. This was followed by a Paste-Values onto my original Named Range which is what gets appended into my Access Mailing Table.
Sure enough, there must be some invisible gremlins that crept...Leave a comment:
-
Append Named Range from Excel into Access 2010 Table
My Access 2010 database is suddenly not appending Named Ranges from Excel into and Existing Access 2010 Table. I have not written any code. I simply right-click the Table-Import-Excel and follow the prompts to Append the Excel Named Range (ML) to the Access Table (Mailing List).
I'm stumped. Normally when Access is unable to append all the data, it will indicate the number of records lost due to key violations. But for some reason... -
Paul Howarth started a topic Error: Database engine does not recognize... as a valid field name or expressionin AccessError: Database engine does not recognize... as a valid field name or expression
Question from a Novice:
I have a Query which is based on a Crosstab Query. One of the fields in the Query is "Client". I can "hardcode" a Criteria for the "Client" field and the Query works fine. For example: Left([Client],1)="A", or "AMG" both return all the rows where Client = "AMG".
Obviously, I would prefer to use a variable for the Criteria such as [TempVars]![ClientName].... -
Discussion: What does "Not Trusted" Mean for SetValue in a Macro?
I'm a novice and have 2 questions:
1. I notice that "SetValue" is considered to be "not trusted". Since "SetValue" is provided by Access AND considered by Access to be "not trusted", in what sense is it "not trusted".
2. I was able to use "SetValue" and "SetTempVar s" interchangeably in a Macro - either way accomplished my purpose. What are some distinctive... -
VERTICALLY Aligning Text in a Text Box
I have a rather large text box in a report. Sometimes the Control Source is one sentence. Sometimes the Control Source is a paragraph.
I want to keep "Can Grow" and "Can Shrink" both set to "No".
Given this, is there a way to VERTICALLY align the text in the text box? Excel calls this "Middle Align".
[imgnothumb]http://bytes.com/attachments/attachment/6097d1329340320/exce... -
Quotation Mark Differences
I am getting different Query results depending upon whether I type directly into Access or whether I type first in Word and paste into Access.
Typed Directly into Access Query
Query Datasheet view shows the word "Hello"Code:Test1: "Hello"
Pasted Into Access Query from Word
Access adds brackets to what I have pasted and changes my paste to Test2:[“Hello”]...Code:Test2: “Hello”
Last edited by NeoPa; Feb 14 '12, 12:05 AM. Reason: Made pic viewable and added [CODE] tags for easier viewing of problem -
Effect of Memo Field on Access File Size
I am planning on replacing four 35-character txt fields with 1 Memo field. A Memo field can handle about 65,000 characters.
Is the Access file size based on the number of characters in each Memo field?
Or does the mere existence of a Memo field automatically increase the file size by 65,000 characters for each Record with the Memo field - even though each Memo field may be Null? -
Are Lookup Fields in Tables Evil?
Because I'm a novice, I can't reconcile a Recommendation to always avoid using Lookup Fields in Tables, and the Requirement to use Lookup Fields for a Published Access database. (Sources pasted below.)
If Lookup Fields in Tables are a bad idea, then does that mean using Access to publish a database to the web is a bad idea too?
RECOMMENDATION
Thou shalt abhor the use of "Lookup Fields" which... -
Access default FILENAME for Report ExportWithFormatting
I am using ExportWithForma tting in a Macro to print a Report to PDF.
The default PDF Filename is the name of the report (in my example "rptNODGLal l".
Is there a way to make Access set the PDF Filename as something other than the Report name?
Since I am always manually naming the exported PDF to the Client_ID which is contained within the report, I'd like to have the ExportWithForma tting routine to... -
Thanks. That did the trick. Like I said, I'm a novice. Your solution also taught me that it must be poor practice to name Table fields with a Number... like "1", or 2. I've changed those field names to "One" and "Two". I wasn't able to apply your solution until I renamed the field "1" to "One".Leave a comment:
-
Numbering Items in a Report
Novice User Here.....
How do I "Number" my query results in the Detail section of a Report?
For example, if my query return 3 records...
Instead of the Report showing this way:
Paul
Charlie
Michael
I would like the Report to show it this way:
1 Paul
2 Charlie
3 Michael
No activity results to display
Leave a comment: