IDE :: DoCmd.TransferText Method?
Dec 1, 2009
I am using ms-access 2002. I have to export the data of a ms-access table in Fixed Width format.To accomplish this I am using DoCmd.TransferText method. DoCmd.TransferText acExportFixed, "schema.ini", "table_ABC", "C: estingTestData.txt"But I am getting error message: "Run time error-3625 The text file specification 'schema.ini' does not exist.You cannot import, export, or link using the specification."Here schema.ini is at same location as of text file. i.e. "C: esting" I tried with DoCmd.TransferText acExportFixed, "C: estingschema.ini", "table_ABC", C: estingTestData.txt"
View 16 Replies
ADVERTISEMENT
Oct 20, 2009
I'd like to export a table from Access to a text file (or a spreadsheet) using VB code in Excel 02. I'm using the transfertext command but my code runs through without actually doing anything or throwing up any errors. If I swap the code round and change Export to Import and move the data into the text file manually then the code will happily import the table into Access.
Sub Export()
dbfile = "C:XLSMDBTable.mdb"
Dim a As Object
Set a = CreateObject("access.application")
[code]....
View 2 Replies
Sep 30, 2011
I am using the following command "DoCmd.Outputto acOutputReport, Report Name, acFormatPDF, FileName".The report I am using legal as the page size. When the PDF is created in is created using letter size pages and the buttom of each page is cut off. I would like to find out why this is happening.Bob Gouveia
View 4 Replies
Dec 19, 2010
getting a DoCmd.RunMacro method for running macros inside EXCEL and Word?
View 1 Replies
Oct 10, 2011
I agreed to trade some code with my wife (her SQL for my .NET), but I am running to an issue on my side. I have taken some old vb that she is needing converted to .NET and made it work, but there are two lines of code:
DoCmd.SetWarnings(False)
'and
DoCmd.SetWarnings(True)
I have found out that these are objects related to using Access, but i can't figure out how to use them in .NET. It seems that, in the original code, they are used without instantiation, but I get the "Reference to a non-shared member requires an object reference" on those two lines of code. I have never worked with Access before, but it seems like it would be a simple fix if I just knew exactly what was having its warnings enabled/disabled.
View 6 Replies
Jun 12, 2012
Process: I have the below code which gets the base SQL statement and defines the working query. Based on this it then generates & exports Excel spreadsheet into a defined folder (wkfolder).
Objective: The exported workbook name is fine but the sheet-name comes up as "RunReport". I wish to change the sheetname to "UpdateData".[code]...
View 5 Replies
Oct 19, 2010
Consider a MyForm class that contains a shadowed implementation of Show(). It also contains a CreateForm() method, which accepts an instance of the form and calls the shadowed sub:
[Code]....
View 3 Replies
Nov 12, 2009
Does calling the Dispose method on a Windows.Forms.Timer call it's Stop method? Or should I stop the timer before I dispose it?
View 5 Replies
Nov 25, 2011
I have a large problem with inheritance in vb.net. The problem is the following:
I have 2 forms => frmBase and frmChild
In frmBase i want to create a method Called StartWorking() and i want frmChild to inherit this method.
But here is the tricky thing: when frmChild.StartWorking is called i would like the following => without calling MyBase.StartWorking()
I want frmBase.StartWorking() to be executed first and after a test in frmBase.StartWorking if blnValue is true then frmChild.StartWorking has to be activated. if blnValue is false that frmChild.StartWorking cannot be activated.
View 2 Replies
Dec 18, 2010
I have nine pictures that I need to animate -I need to use the ToString method and a counter to concatenate a file name into a string variable from the Image.FromFile method. Once the counter reaches its maximum value, and the last picture is displayed, the counter should be reset to zero or one depending on how the first image file has been name. Also a static counter variable should be incremented in the time routine. what I have so far -- I know what I have to do; however, I just do not know how to code this properly.. Right now I have this going thru a button procedure but it needs to go through a timer.
[code]....
View 2 Replies
Sep 16, 2010
Write an overload for every numeric type or if possible constrain a generic extension method to just numeric types.
View 2 Replies
Jun 2, 2011
I just need to know what is the slight difference between them so I know which one to use everytime.
View 5 Replies
Feb 16, 2010
I will try to explain what I need.Let's say that I have a class like this:
Public Class Example1 Public Sub ToBeCalled()
[Code]...
View 5 Replies
Jun 9, 2009
When I am loading an Assembly dynamically, then calling a method from it, I appear to be getting the method from Assembly executing before the code in the method that is calling it.It does not appear to be executing in a Serial manner as I would expect. Can anyone shine some light on why this might be happening. Below is some code to illustrate what I am seeing, the code from the some.dll assembly calls a method named PerformLookup. For testing I put a similar MessageBox type output with "PerformLookup Time: " as the text. What I end up seeing is:
First: "PerformLookup Time: 40:842"
Second: "initIndex Time: 45:873"
Imports System
[code].....
View 9 Replies
Jul 13, 2011
Why does my the declaration of my string in the code result in the following error? Is there a workaround?
Code:
<script runat="server">
Protected Sub form1_Load(sender As Object, e As System.EventArgs)
Dim x As String = "</script>"
[code]....
Error: Statement cannot appear within a method body. End of method assumed.
Note: The following page did not fix my issue and instead resulted in the string </script> being output in my page. ( VB.NET hates </script> tag in string literal )
View 1 Replies
Mar 31, 2010
I am not sure whether this is a trick question?One of the object i have has 2 boolean properties, Standing and Sitting.I have a class called student with the 2 methods stated below- Am I coorrect is assuming that the first method draw() is affected by the standing property AND not the second method?Also the way it affects is that it draws an image when the the stugent is standing?
[code]...
View 5 Replies
Jun 12, 2011
What's the equivalent method in .NET of the Picture1.Scale (0,0)-(10,10) method in 6.0?
View 2 Replies
Oct 5, 2011
Let's say I have a page Test.aspx along with test.aspx.vb.Test.aspx.vb contains a class name "TestClass". In that class I have method1(), method2() and method3()I need to be able to call one of those methods, but I can't hard code it, the method to be executed comes from a string.
I can't do
Select Case StringContainingTheNameOfTheDesiredMethod
Case "Method1"
[code]...
View 3 Replies
Jul 16, 2010
Extension methods are useful for types that you don't own and can't/don't want to derive from and extend (e.g. reference types and interfaces). Obviously, interfaces should be kept as short and to-the-point as possible, so extension methods for interfaces are particularly useful (e.g. LINQ).For classes, especially classes that you own, they're still useful - but I'm wondering how you determine what should be an extension method or what should be a method in the class itself.Personally, every time I think about it, I keep going round in circles with the following thoughts:If it's useful enough, it should be in the class.It's not part of the core responsibility of the class, it should be an extension method - but if it's useful enough, surely it should be the responsibility of the class...
View 3 Replies
Jan 29, 2012
I have a Application that Crypts all Files in a Directory and the Subdirectories
Public Shared Sub CryptAllFiles(ByVal crypt As Object)
'check if this dir exists
Dim vDirInfo As New DirectoryInfo(vPath)
If Not vDirInfo.Exists Then Exit Sub
'get all files' sizes in current path
[Code]...
View 3 Replies
Dec 11, 2011
Just playing about with some vb.net and i dont understand why when i enter Dog into the text box the label continues to say not dog?
[Code]...
View 3 Replies
Feb 4, 2011
Is there a way to choose between different methods and pass one into another method ?
Sub conditionnal_binding(ByVal list_box_reference As ListBox, ByVal list_box_final As ListBox, _
ByVal dico_source As Dictionary(Of String, List(Of String)), _
ByVal my_methode As ??? )
' DO SOMETHING
End Sub
I wrote ??? because I don't know how to call another method inside a method.
I would like to choose between different "sub-methods". Here is how I would like to use my method :
conditionnal_binding(ListBox1, ListBox3, HTML.dico_basic_attribut, best_method)
conditionnal_binding(ListBox1, ListBox3, HTML.dico_basic_attribut, some_method)
conditionnal_binding(ListBox1, ListBox3, HTML.dico_basic_attribut, another_method)
View 5 Replies
Mar 18, 2009
I'm trying to code an application that selects an appropriate delivery method from a list box. The user should be able to enter a part number consisting of numbers and either one or two letters. "MS" representing "Mail-Standard, "MP" for "MailPriority", "FS" for "FedEx-Standard", "FO" for "FedEx "Overnight" and "U" represents "UPS" I want to code it so that it does the above and displays an appropriate message when the part number contains an invalid letter or letters.
Option Explicit On
Option Strict On
Public Class MainForm
[Code]......
View 2 Replies
Mar 28, 2012
I am indifferent if you are a VB.NET or C# or other .NET developer. I have a FACTORY class like the following:
[Code]...
View 2 Replies
Mar 17, 2012
i want to which way is better when concentration is on processing speed. i want to call a method that compute some data that method is on another form in my windows form application then what you prefer is better way 1) to call that method in another form and use returned value or create similar method in form where it is required.i want to make it's processing fast.
View 3 Replies
Aug 13, 2011
I'm trying to code a class of RandomNumber. One of the class methods needs to populate a "List (Of RandomNumber)" ... which was passed as a parameter to the method ... with 10 random numbers between 1 and 50. DEAD SIMPLE :)
View 6 Replies
Oct 7, 2010
I have been using a pretty slick generic invoke method for UI updating from background threads. I forget where I copied it from (converted it to VB.NET from C#), but here it is: Public Sub InvokeControl(Of T As Control)(ByVal Control As t, ByVal Action As Action(Of t))
[Code]....
View 1 Replies
Mar 24, 2009
This is what I am talking about:
Public Shared Sub Test1()
Test2()
End Sub
[code].....
View 4 Replies
Jun 15, 2012
I don't want use old VB methods in my code and I m confused about what's the newest vb.NET method corresponding to the old CInt() VB method for example,
Dim n1 as Double : n1 = CInt(2.1111111) 'get only 2 without round it
Dim n2 as Double : n2 = CInt(2.7777777) 'get only 2 without round it
View 1 Replies
Oct 15, 2010
This code works well ... But it should not I agree that "Value.One" implements IConvertible, but:the method "ToBoolean" is a private method of Value.One Why can I expose it outside of the class ( As far as I could test, this is true for everything that implement an interface nothing can be private )
[code]...
View 8 Replies
