hi all,
i found this forum recently and always seem to find my answers on it, this is the first time i havent.. so. firstly i am using access '97 (work is soon to upgrade to 2003 - finally).
my problem is
i'm trying to export a query to txt file, which i'm doing by
the eParcelSpec i had to make via importing a text file, then on import text wizard, chose advanced, setup my field dilemeter to * and text dilemeter to none. this is saved and i can open it up going through the above process.
however when my docmd runs i still get the standard output with "fieldvalue" , "fieldvalue2". instead of the * and no comma
its important for this to be the other delimeters, as the exported file is going to be used in a posting company's program that requires a certain format to import shipping address information.
also, is there anyway to add lines to before the data is exported? i need to have a start of file and end of file characters before any data and after the data.
I run a query that I export out to a tab delimited file. This text file is used for another application. The problem I am having is if I select "skip field" in my text "export specification" it still exports out that piece of data, even though I have selected "Skip Field". The data type on this field is a number and field size is integer.
I thought I read in another access newsgroup that this is a known bug? Is that true? Is there a fix? I am anxious to fix this because, I have 90 query's that I export to text and I would hate to have to go to each query and select "Not Show" that field.
Ok, I'm new to a particular access database that is having problems. Basically, it is using transfertext to transfer a database to another file, at least as far as I know. Unfortunately, it's hanging, and as best as I can guess, its because something in the export specification file is not quite right. Can anyone offer me an explanation of how to edit an import or export specification file? The MS help seems to indicate that it stored in the database, but I haven't been able to locate the file that is specified in the vba code. Nor did I see it elsewhere in the folder where the database is stored.
How to generate an export specification file by using Access 2007. Many instructions says click on "Advance" while exporting a text file manually but unfortunately i can not find that "Advanced" option in my access software.
Am hoping someone can shine a light on my problem as this has me ripping my hair out.
first off I've set up a subform in my main form to display a query using a linked table as the data(a excel exported csv file). nothing special.
however, I have had to use a link specification to determine how the table is linked. i.e. what fields should be defined as double (as access treats them as integers for some reason even though the numbers are too big!) and which fields need renaming. without this link specification, the data will not be handled correctly. ok no problem. I've had this working. The table links fine.
When i came to roll out the database, I set up the security in order that multiple resources can use it at the same time.
Now when I log in and use the form I get the following error.
'Text file specification <filename> does not exist. You cannot import, export or link using the specification'
Arrgh. :confused: I used the specificition to link the table in the first place! I've tried refreshing the link using the Link Manager, I've tried re-linking it and I've also tried linking the table and creating new specifications, all with no luck. I get the same message each time.
My next step is to import the data instead(again I'd need to use a link specification). But I'd really like to solve this as I can see no reason why it shouldnt work.
I have a database that gets updated twice per week. Using ASP, I am "publishing" this database to our company website to enable anyone within the company (here or aboad) to see the status of various tests. The problem I am having is: I am trying to get only "active" tests to show up (which I have working correctly) or tests that have been stopped or completed within the past 5 days. I have tried using: DateAdd("d",-5,Now()), DateAdd("d",-5,Date()), and neither have worked. Any suggestions on how to get this to work? I can't use a specific date to subtract from, because it may be a few days between the time I update and the time everyone has seen it.
if I create an Import Specification, how do I add an extra field in the middle of the field list? All I can see to do is re-enter all fields from the new field downward.
I have a pop up window that maximizes and the need to format a Memo Field to users specification.
Unfortunately the Mini Popup Bar that comes up when you select text is very shy and annoying when it doesn't show up. It's Completely Unreliable.
So I thought I'll make the Controls on the form for Bold,Italic... etc but I can't seem to get the code to work.
My TextField is a Memo and I have changed the TextFormat to RichText, but I cannot use any of the commands like .SelBold or .SelColor etc.. It gives me a Compile Error: Member or Data Member Not found.
I don't understand why? Is there a Add In/Reference that I need to include?
Hello, Does anyone knows how can I export the export/import specifications (which file/directory) and how can I import/export the specifications between different versions of Access. Thanks!
This may be a real dumb question but is there any way to view/edit an existing export specification for the transfer text macro? I'm reviewing someone else's database and can't figure out how to view it.
When I export a query to xml (MS Access) then the name of the query equals the tagname in xml. Example: when the queryname is ‘qryRegions’, the xml result is:
Hi: I want to automate the XML export function of Access and not sure if it is possible or how to do it. In going through the menu bar (File ->Export) interface, I must choose the root table, and then subsequent tabbed windows allow one to select what tables to be exported, if I want the schema to be generated, the target filename, etc. Instead of having to go through this large selection process, I'd like to write a script that I can run consistently over the same tables, produce the same file name, etc. Can anybody provide a suggestion/code/pointer on how to accomplish this? Thanks in advance. John
I have one workstation that errors when code get to a line where I try to export a report to an rtf file. The error message says something like 'Cannot execute export command'. It works on other workstations and I can even manually export the report to an rtf file - Any ideas?
Hey all, I'm working on an invoice system in Access and I had just wondered if there was a way I could export a form to a format I could distribute to clients? (pdf, html...etc) thanks!
Ok I am exporting some data to a plain text file and one of the fields I am outputing can vary in the number of characters and I need they to have the same number of characters all the time.
Ex: 123.00 => 000012300 456789.00 => 045678900
I had heard of a command, but I can't remember what it was...I could do a loop till LEN() = 9 but that would cause undue clock cycles (aka performance hit) on the machine when running through the export routine.
I'm trying to find a way to export the structure of a table in my Access database.
I created a new table and I want to put it in the database on my website. However, my site is constantly being used so I have no way of downloading the database, modifying it, and then uploading it again without losing some data.
I do have a database editor on my website that allows me to run queries. So If I can get a query with all of the CREATE TABLE information (all the fields, whether they are Allow Zero Length, etc.) then I can just use that.
I can't seem to find a way in Access 2000 to export the structure of the table.
I would like to output them into a text file as "A0010", "N0103", "C0123"
Background is that I have set up a DB that connects to an Oracle DB and where we have an email address for a client it emails a PDF file to that client.
Prior to this emailing we used Crystal and we will continue to do so for those without email, the format above is Crystal Filter and I can copy paste the above straight into a filter blocking them from creating a printed statement.
Ok forgive me I'm a newb. I curently have a query in access that I'm trying to make a button to automatically send the results of this query to excell. When I run the code (below) it gives me a compile error saying user defined type not found on the highlighted portion
Private Sub ExporttoX_Click() On Error GoTo Err_ExporttoX_Click
Dim db As DAO.Database Dim rs As DAO.Recordset 'Set db = DAO.DBEngine.Workspaces(0).OpenDatabase( _ "C:database.mdb") Set db = CurrentDb Set rs = db.OpenRecordset("qbpexcel", dbOpenSnapshot)
'Start a new workbook in Excel
Dim oApp As New Excel.Application Dim oBook As Excel.Workbook Dim oSheet As Excel.Worksheet
Set oBook = oApp.Workbooks.Add Set oSheet = oBook.Worksheets(1)
'Add the field names in row 1 Dim i As Integer Dim iNumCols As Integer iNumCols = rs.Fields.Count For i = 1 To iNumCols oSheet.Cells(1, i).Value = rs.Fields(i - 1).Name Next
'Add the data starting at cell A2 oSheet.Range("A2").CopyFromRecordset rs
'Format the header row as bold and autofit the columns With oSheet.Range("a1").Resize(1, iNumCols) .Font.Bold = True .EntireColumn.AutoFit End With
oApp.Visible = True oApp.UserControl = True
'Close the Database and Recordset rs.Close db.Close
I have searched the forums for similar problem but I was unable to find it.
I have some buttons that export the data from a form into a Word Document. It generally works but there are some issues.
I have Access 2003 but the people using it only use the runtime version of Access and the environment is Office 2000.
I have copied code from other examples and maybe missing something that is causing the issues.
1. When I export the record it is causing problems with the Normal.dot template. When I try to close Word it keeps asking me that I have modified that template. After pressing Cancel button twice it the save box disappears. 2. When I leave the code Dim objWord As word.Application I get an error message about a compile error User defined Type not defined. 2. When the users try to export a record to the specific word template I created and a required field is empty an error message is displayed and then closes the application.
Any help will be appreciated. I am a newbie when it comes to code.
Sample code is below. Private Sub Command1079_Click() Dim objWord As word.Application 'Start Microsoft Word 2000. Set objWord = CreateObject("Word.Application")
With objWord 'Make the application visible. .Visible = False
'path and name of the template your are using. ' objWord.Documents.Add ("U:Asset Strategy and Commercial PropertyCommercial PropertyTaskmasterletterofobjection.dot") .Documents.Open ("C:Documents and SettingsDadMy DocumentsWorkTaskmasterletterofobjection.dot")
'This is for the bookmark that you created in the template
Print_Reconsideration_Err: 'If a field on the form is empty, remove the bookmark text, and 'continue. If Err.Number = 94 Then .Selection.Text = "" Resume Next
End If objWord.Application.Options.PrintBackground = False objWord.Application.ActiveDocument.PrintOut
I am having problems export a queries results. That is, all I am trying to do in use the File, Export function manually, BUT I am not able to select it. ANy thoughts?
I need to export ms access table to dbase III format. When I use export something is missing and the file format is just not good.When I try to open dbf file with program Dbase I get message "not a dbase database". I find out that excel do the same, so if anybody know how to export to dbase III using ms access or ms excel please help.Ms access help is to install borland database, I downloaded some from Internet but I don't know what to do with it. PS: Even when I import dbase III file and try to export it back there is a problem. Please, please help.
I have a table of applications (200 applications), with the following columns for each application:
AppName Description BusCrit BU NumUsers
I need to export this to an excel spreadsheet into specific rows and columns and then save the spreadsheet, with it named for the application (ie, App1.xls) which it should get from the AppName column in the table. How would I do this?
