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 RepliesI 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 Repliesgetting a DoCmd.RunMacro method for running macros inside EXCEL and Word?
View 1 Repliesi can't figure out how to set the paper size to legal!. [code]
View 6 Repliesi am making a Long form and I want it to print in legal size paper. Only thing is I use printform and it does letter size only. Also it cuts off the left over labels i need to print out. I made a Database input form and an output form for printing.
View 2 RepliesI wrote a page Page method in my aspx page. in web service method I need to call FindControl method return textbox and get text box value. But my findControl will take MasterPage object to iterate.
see my code
<script type = "text/javascript">
function ShowCurrentDateTime() {
$.ajax({
[Code]....
How to pass Master Page object or Page to Page method?. So I can use in Sared method.
Is there any way I can access Textbox value directly in Page method? I need access couple of controls in Page Method.
I would like to make a form that prints the same size as a Legal Form, (8 1/2" x 14") When I check on the internet I see that the pixels can very at 75dpi the form is 637 x 1050 pixels. But at 300dpi the form is 2550 x 4200. Do I have to build the form as per the dpi ratio? I cannot make the form greater than 1612 x 1212. I have tried serching the internet for ways of expanding the form to greater pixels in the height than 1212. I am running Verion 7 of Windows and I am using Visual Basic 2010 Express.
View 5 RepliesI have a user control that checks if a certain query string and session value are present then returns a boolean based on that, if it's true I want to set the master page. The page is throwing an Object reference exception when it tries to call the method EditUser1.UserAuthorization(). Why is this happening? I imagine that the method doesn't exist at that point in the stack. Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreInit
[Code]...
For some reason I am not able to use DoCmd.OutputTo with my access object in VB.net 2005. I get the following error: 'OutputTo' is ambiguous because multiple kinds of members with this name exist in interface 'Microsoft.Office.Interop.Access.DoCmd
I am referencing the Microsoft Access 12.0 Object Library and using Imports Microsoft.Office.Interop
Dim objAccess As New Access.Application
objAccess.OpenCurrentDatabase("C:Database.mdb", False)
objAccess.DoCmd.OutputTo(
A similiar command Docmd.SendObject seems to work just fine, so I don't know why I am getting that error or how to fix it.
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.
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.
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]...
The users instead of using Vertical ScrollBar in DataGrid1 they requested for NEXT and PREV buttons for paging the display on DataGrid. I have added the NEXT Button and PREV Button but doesn't know how to create the script to perform the function of NEXT Page and PREV Page.
View 2 RepliesHow can I change the size of my tab page? I want it to be longer so that it fits across my GUI.
View 7 RepliesI want to print page with size A5 in VB2010 by one click (print page size of my printer is A4)
View 7 RepliesI am generating a grid view having column with images. I want each image to print on stock paper: Marco ITEM #A-6LI (3inch by 4inch Inserts page) using printer. What setting and code should I write? Also I want to see the print preview. i am using VB.Net, and on pop up some grid is displayed having one column with format for each user this is repeated on the whole page of pop up, but i want each of set to print on the page i mentioned above. How can i achieve this?
Basically i want to know how can i print each row of a grid on a page size of 3*6
I need to read PDF Page size of an existing PDF. I have both itextsharp and acrobat used in my project. This is what I've tried.
Dim pagesize As Rectangle
Dim reader As PdfReader = New PdfReader(formfile)
pagesize = reader.GetPageSize(1)
If pagesize.Width = "396" Then
Testing = "Y"
Else
Testing = "N"
End If
I get page size as = {Rectangle: 396x309.6 (rot: 0 degrees)}
And Testing comes out = Y
This seemed great at first, until I found that I get those exact same values regardless of how big the pdf is...so now i'm back to square one not knowing where to turn. Interesting thing to note though When I hover my mouse over reader.GetPageSize(1), nothing shows up while debugging, but pagesize does get the value stated above.
Like the title says i'd like to read an existing pdf page size with VB.Net. I've been working with Itext.Sharp, and the Acrobat.dll.
View 1 RepliesI have a vb.net application that uses 2 crystal reports to print out reports. The first report is A4 and the second is A5.
How can my code access the printer default settings and change the default paper size to A4 and A5 each time without having to do it manually.
I am trying to set custom paper size on my printer with Winspool.drv. But getting error as 'Attempted to read or write protected memory.'
Private Sub btnTest_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTest.Click
Dim hPrinter&
[Code].....
I'm writing a console application in vb.net using which i'm trying to print pdf documents from a specific directory. I'm able to print the PDF files but my problem is that the PDF files vary in Page sizes and the printer fits them to the default page size which is set to letter.
My questions is, Is there a way to enable "Choose Paper Source by PDF page size" using vb.net for the printer settings.
I am using a Report Viewer Page in a Asp Project, As my query is big i have Somany columns to be included in the Report viewer. But i am in a position that i cant increase the Page size of the Report to be Correctly fix the Entire Columns in the Report.
View 1 RepliesIm working with vb.net and microsoft word using Microsoft.Office.Interop.Word and everything is fine. My only problem is I cant find a way to change the default page size printing setting from "letter" to "A4".
This code was doing the job for Crystal reports but isnt doing it for Word
[Code]...
I am facing an amazing problem in my application. On my Developement server when I am running my application, then there is one function where I am trying to put whole stringbuilder contents in a string object. This Function is used for paging the reports.For that I am using a method of Stringbuilder.tostring() and when I chek the value of this statement (stringbuilder.tostring()) it shows no such interface is supported, which later on throws exception of system is out of memory. Here i am using .net 2.0 framework and sql server 2005 database.But when I run the application on stagging server then there is no such exception thrown.[code]
View 3 RepliesI have a button in my usercontrol. When that button is clicked I need to call a method thta is in aspx page.
View 2 RepliesIve tried searching for hours now and cannot find out why my code (aka, me.) is failing
Basically... I have a listview control which I'm passing a datatable of products (ID, Name, Description and Price columns), and im trying to make it so that when the "checkout" button is pressed, it parses through all the controls on the page, finds all the controls with the correct ID's and adds the items values to the cart.
ive checked all my ID's in the source code and they match up to the ones being requested by the FindControl method.[code]...
I put in the iframe tag as follows in my .aspx page - Now what code do I put in javascript or vb.net to make this auto resizable depending on the size of the page that comes in?
View 1 RepliesIm Trying to Set up a Create User page and a Log in page. both pages are on a different Form in Visual Basic so far i have;
Code:
Imports System.IO
Public Class SecondForm
[code].....
If Request.QueryString("ID") = "" Then
folderDirectory = Global.FileUpload.GetFolderDirectory(Request.QueryString("TFID"))
If Not File.Exists(folderDirectory + fileName) Then
If Not Directory.Exists(folderDirectory) Then
Directory.CreateDirectory(folderDirectory)
[Code]...
How do you call a codebehind/class method from a gridview in an aspx page? Also, I need to pass the value of databound column to that method.
<asp:BoundField DataField="Precision" />
<asp:BoundField DataField="MyNumber" DataFormatString="FormatHelper.Format(MyNumber, Precision)" />