I am new at VB and am working on a simple project. I am reading records in from an access db and when the user clicks on the 'create label' button, I need the record displayed to be added to the labels.txt file. When they click on the 'save & close' button, I want the file to be saved (with no dialogue box) and the app to be closed. I am struggling with getting the records into the text file and saving it. [code]
View 2 Replies
I am displaying Access database records on my form and need to be able to printpreview only the first 3 records of the database and have no idea how to code this at all. Also the printpreview is has to be on a separate form than the displayed records.
View 1 Repliesi want to take a comma delimited text file and then select all unique records based on one of the fields in the text file. should i read the text file into a data table or just use a data reader?
View 7 RepliesIn my application, I have created a text file. I want to print the text file the application just created. I have seen some code which uses command prompt and others which use notepad.exe.
View 2 Repliesim tring to get vb to print all the items in a textbox to a text file Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click For Each liststring As String In ListBox1.text liststring = liststring & vbCrLf My.Computer.FileSystem.WriteAllText("C:\sample.txt", liststring, False, System.Text.Encoding.ASCII) Next End Sub
am i going around the wrong way doing this? because this prints a selected item and also prints each letter on a new line
I am using PrintDocument to print a text file but the printer is overwriting into the same page instead of using a new page. [Code]
View 2 RepliesI am not able to print text files using the code specified in when using Windows 7 operating system. The printing works when Windows XP operating system is used
View 1 Repliesi have fill my data gridview with records using this code: this is for the 1st tab only.
Private Sub showitemsM()
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
[code]....
I having issue with my program not printing to debug all the "records" in my text file my indualvidual print record works fine but not one that prints all the records in my text file[code]....
View 3 RepliesI have a simple text file that I want to print out from my application (actually a printer spool file). I use the following code to accomplish this.
[Code]...
I have a problem with a loop that I'm writing where it is just reading and printing the first line of a text file.
ofdFile.Title = "Choose file to read"
If ofdFile.ShowDialog() <> Windows.Forms.DialogResult.Cancel Then
sr = New StreamReader(ofdFile.FileName)
End If
[code]....
Do i have the .peek set up wrong where its only doing the first line?
I'm trying to retrieve the @@IDENTITY value from an access database after I add a row to it. However, instead of using hard coded connections, I'm using the DataSet wizard. Unfortunately, due to the Jet engine, I can't do more than one command at a time. I tried to select the @@IDENTITY in a separate command but unfortunately, I guess it counts as a different command as it returns a 0 each time.My question is, is there a way I can use the GUI/IDE to retrieve the @@IDENTITY or do I have hard code the connection, command, query values and obtain the value that way.
View 1 Repliesthis is for a trivia game (form has question label at the top, four labels/radio buttons for possible answers, button to start a new game, button to submit answer, and button to exit. Also there is a label which keeps track of question number [questionsAsked int]). I've used the bindingsource.movefirst() method in my new game button to return to the first question asked, but that takes me to the second record, hence why I added the moveprevious() right afterwards. That however does not seem to make any difference.
Public Class frmTriviaGame
Private recPtrPos As Integer
Private questionsAsked As Integer = 1
[Code].....
how do I customize my Datareport? I want to group my data based on field value.This are my table fields;
SubCode, Description, Units, Grade, Year, Semester
I want to group records based on the Year value. There should be a different table for records whose Year = 1st Year, 2nd year, 3rd Year etc... (Guys this is in printing, OK?)
here is a snippet of the file,
Year 1
mandatory
COM137,Mathematics for Computing,20,2
COM140,Computer Technologies,1-2,20
COM147,Introduction to databases,1-2,20
Year 2
[Code]...
in here is where i am having the problem i don't know how to get all the information i need into one specific array element within an array.. i want to get the year and the module status added to the end of an array element
I have problems to print the records which is saved in text file. It prints whatever in between the textfile but does not print whatever contents in the textfile.
Public Class Form1
Private Sub pd_PrintPage(ByVal sender As Object, ByVal ev As Printing.PrintPageEventArgs)
[Code].....
how to update records from 1 text file into 2 different sql database.
Name of the sql Table is Payment2SQL_Success_P() & Payment2SQL_Success_E()
is the code below is on the right track.
Select Case "AGENCIES"
Case AGENCY_AV Or AGENCY_SR Or AGENCY_IP Or AGENCY_TM Or AGENCY_MS
[Code].....
I need to export data to a text file either in VB or SQL and it has to be formmatted like this. The data is in a SQL Databse[code]...
View 7 RepliesI am just trying figure out a record import program from text file into access database using Microsoft.Jet.Oledb Provider 4.0 and Vb.net. And it seems easy but my problem is different. In the text file, records are not delimited.
Format of the text file:
Field Name & Size
Date[Date,ShortDate]FirstName[20]LastName[20]Sex[1]Age[2]
[Code]....
Can I put delimiter programmatically while reading the text file using stream reader and later simply import the whole file in DB.
I basically have an application that generates reports in a .html file, I use a .html file for the ease of making tables and formatting text.Now I would like to introduce a way of printing the reports from my program. Because I use a .html file, the formatting would not the correct if I was to print it directly from my application (as far as I know). For this reason, I would like to print it just like my web browser would have in order to keep the tabular data intact and the text formatting.
View 1 RepliesI am setting up printing (to a printer or file) in my application, and it doesn't seem to print out any new lines that I specify. Here's some of my printing
' Loop through all of the text in the array
For i = 0 To 9
If i Mod 2 = 0 Then
[Code]....
When I print the output to a PDF file using PDFCreator, it stacks all of the letters onto each other rather than creating new lines at the places I've specified. I've also tried using vbNewLine instead of vbCrLf, but I haven't had any luck. I searched the web for this but couldn't find anything about it.
How do I update records in a dataset with records in a transaction file?
View 3 RepliesI'm porting an application from VB6 to VB.NET and have come across something that VB.NET doesn't like. The "Print #" function (whatever its real name is). The code is as follows:
[Code]...
I was just wondering what the equivalent of this in VB.NET is, as there is a LOT of this and I don't want to be here until the end of time.
I have to create a new program that reads to Text files. These text files are in the form of a report (with column headings). The purpose is to compare each record line by line to see if their have been any changes made. The record is based on an Account#. Over time these files will be considerably large. What is the best way to do compare records from each file. I'm thinking loading each file into an array and processing them that way.
View 7 RepliesI am working on an applictation to scan windows files to check for missing files, i have a couple questions on how to do this.I would like to use the %systemroot%system32 that way that it doesn't matter what drive letter it is, i'm not sure how to do this because when i tried it, it told me the file i was looking for didn't exist (in this case C:windowssystem32 undll32.exe) which does exist. Is there some way to use the %systemroot%?
Also, i am trying to print the resaults to a rich text box such as if rundll32.exe is missing put in the box "rundll32.exe is missing". How do I allow it to write it in the box, I tried the print command, but it didn't work.
im trying to addapt my printing code so it will print my text what ever i have selected it to be in the text editor. here is the code i have at the moment
Private Sub PrintDocument1_BeginPrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs) Handles mypdoc.BeginPrint
str = CType(Me.ActiveMdiChild, frmSplit).RTB.Text 'If this was a single text
[Code].....
How do you pick a random piece of text from a text file in this manner....
[Code]...
I need to pick a random answer, not including the question. let it be the simplest solution. I am only a beginner.
I first want my program to get the text from a text file(I know how that's done), but once it gets it, I want to somehow save it that it won't need to get the text again(for example, if you restart the application, it won't need to get the text from the file because the text is already saved).
View 1 Repliestrying to input a text file that's tab delimited that looks something like this.
2.2 5.6
3.7 9
1.2 9.1
[code].....
I have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
