Yeah I meant access. Yes I have tried substituting the name of the actual table. It still gives the same error. I can confirm the table was created because it shows up in my table list and when I look at it, it has the correct data in it.
Some else had a similar problem, but I couldn't find a...
I am using .txt, atleast I'm trying to.
DoCmd.TransferText acExportFixed, "T_INFO_Text Export Specification", TableName, "C:\Temp\" & TableName & ".txt"
I've also tried
DoCmd.TransferText acExportFixed, "T_INFO_Text Export Specification", TableName, "C:\Temp\filename.txt"
and for whatever...
I get the same error. It says:
Error Number: 3011 Message: The Microsoft Office Access database engine could not find the object 'C041581438#txt'. Make sure the object exists and that you spell its name and the path name correctly.
Thanks, but thats actually a editing error on my part. I simplified my code to reduce a bunch of fields for posting and accidently left an extra double quote.
The application is erroring on
DoCmd.TransferText acExportFixed, "T_INFO_Text Export Specification", TableName, "C:\Temp\" & TableName...
Here is code snippet
*REQUESTNO is passed in as a 9 digit character
Dim TableName As String
Dim strRequestno As String
TableName = "C" & REQUESTNO
RetValue = SysCmd(acSysCmdSetStatus, "Drop existing export table...")
DoCmd.DeleteObject acTable, TableName
RetValue = SysCmd(acSysCmdSetStatus...
I'm modifying a existing Access App someone else made to add additional fields to the application.
The application imports a spreadsheet and formats the fields into an text export file.
One line of code is giving me problems:
DoCmd.TransferText acExportFixed, "T_INFO_Text Export...
I think I have an idea of how I'm going to do it. I just wanted to post it in the correct forum this time and maybe get some more advice.
I plan on getting the names out of the objects and using the compareTo() function.
This sort of got put on the back burner for me though.
I would like to sort some class objects alphabetically and want to know if there is an easy way to do it.
I have classes like Person.class which has variables like:
int id
String name
(Getters and setters for both)
Then I have a hashSet of Person.class objects and I want to return them sorted...
I would like to sort some class objects alphabetically and want to know if there is an easy way to do it.
I have classes like Person.class which has variables like:
int id
String name
(Getters and setters for both)
Then I have a hashSet of Person.class objects and I want to return them sorted...
could you do it like this
public class HelloWorldApp1 {
private int grade1;
//delaring constructor
public HelloWorldApp1()
{
grade1=7;
}
public void printstuff() {
System.out.print(grade1);
}
}
I'm trying to make a form in JSP. Similar to a automotive form.
I have a drop down list for "Makes" (honda, toyota,etc)
and once a "make" is selected I want to generate the items in drop down list for "models" like (civic, s2000, pilot, etc)
Similar to how autotrader.com works.
My question is...
Hey I made an HTML email but I'm having trouble using it in an email. Does anyone know how to create a outlook 2004 template with html or even just send an html email with outlook 2004?
So I have a method that randomly places pieces on a board. The method uses the rejection method where it will create a random number to place the piece on the board, but if the place is already taken it will try again. The problem with this method is that if I have a lot of pieces to place it is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.