Im using VB to set default dates and times for the file names when a form is saved through InfoPath, this is what I have so far:
[code...]
This works but i need to format it to this:
ddmmyyy and hhmmss
I need zero's before single characters as if its only a single character then it only displays 1 eg if its 9 in the morning it'll display 9 rather than 09 and i need 09.
I want my program to be able to create a '.txt' file when it is run for the first time, with the date and time the program was accessed, and to be able to add new 'logs' of program history every time it is accessed. What i mean is that i want my program to be able to create a '.txt' file, and then fill in the dates and times when the program is opened.
View 7 RepliesWe have this current VBA program to help us with AutoCAD via the use of a template excel sheet.The setup we have created works well; however occasionally we have two drawings per folder, which often results in, two templates excel sheets of the same name, one overwriting the other. how I can set the active drawing name in a variable that our program uses to check for, then if not present that it creates a copy of out template and then saves it as the active drawings file name which was set as the variable
This would allow our program to locate the associated excel sheet by name then save it by the unique drawing name and prevent existing excel files being overwritten if in the same folder.
;===CODE STARTS HERE===
Option Explicit
Private Objexcel As Excel.Application
Private ObjWorkbook As Workbook
[code]....
Lets say we have an Access file in a well known path (i.e. "C:MyFolderMyFile.mdb"). That file does not have a primary key set on the table we are interested in . Is it possible to set one of the fields as a primary key (for example the "ID" field , which is also an AutoNumber data) ? And one more thing : I'd like to change the name of a field on that table . For example , lets say there is a field called "My Field 1" (note the space characters) and we want it to be renamed as "My_Field_1" . If it's possible , I'd like both these changes to be permanent in the data base file itself , not just in the imported DataSet ,
View 7 RepliesI am trying to create a small application which does mathematical calculations using dates and times. Specifically, to determine the period of time between two specific dates and times.
View 2 RepliesI am having issues with the Arabic language when trying to display dates and times. I seem to be unable to get the formatting to work on a date, or on a time, but it works on a date and time. Other languages seem to be fine. Any thoughts on why this is? (see image link below) Also, the Arabic formatted date is very different than the normal date (e.g. 8/20/2010 is showing as 10/09/31). Is this accurate?
[Code]...
I have now started posting to a MySQL database created by someone else. I have no ability to change the table structure.Two questions:
1) There is a date field and a time field that loosely tracks the last edit date and time. Both are fields set up as DateTime in the database. The date field always has the proper date but the date and time portion shows as
2011-11-27 00:00:00
However, the time field shows as
1899-12-30 23:16:58.
When I am updating with the following code
strSQLCmd.Parameters.AddWithValue("@EditDate", Date.Now)
strSQLCmd.Parameters.AddWithValue("@EditTime", TimeOfDay)
The date field displays
2011-11-27 23:40:26
and the time field displays
0001-01-01 23:40:26
I'm not sure how to format the date field without time and the time field with Dec 30 1899.Question 2) I will be adding some tables and will be wanting to track date and time of first entry as well as date and time of last edit. (this may have been better posted in the Database forum, if so, sorry)
For those of you who have done this before, would you mind sharing best practises? I am wondering why would you use two fields, one for date and one for time, when the field is a date/time field to begin with. I've seen this before in another database as well. I'm just trying to work out the logic here.
Is it just me or is it so that a DateTimePicker can only be used for entering dates or times but not both?
View 9 RepliesI have a list of File_Name, File_Date.
I need to check this list sometimes against a file name and sometimes against both a filename and a file date.
I've been doing a for each loop and checking each value, I've tried a hash table keyed on file_name which is much faster, however I also need to check to see if the file_name and File_Date combination exist.
Is it possible to have a list that I can do a quick search on using either the filename or both the filename and filedate.
I want to make a autotyper and I was wondering how would I make The words I am writing in the textbox be set to a number of times? EX.- say I want to write a word only 10 times instead of it keep repeating..
View 9 RepliesI've been trying to search out the answer to this question, but i couldnt find any. How do set the calendar component to display only certain dates, say 6 weeks from current date?
View 1 RepliesVB.Net's DataGridView supports naming columns, but I was wondering if it could somehow do the same for rows, so that we could use something like this:
With DataGridView1
.Rows.Add(4)
.Rows(0).Name = "Setting1"
[Code].....
Do you confirm that it's not possible and we must use numeric indexes to refer to row numbers?
I made project using VB.Net 2005 with multi languages, the first form is MDIParent form with MainMenu and toolbars also there is some changes in properties as righttoleft and text of forms.In my Mainmenu (Menustrip) there is opetion to change the UI Culture and I have already done but I need to change all texts in the form as mainmenu items anf form properties.My quetion is: how can I reload my form again to read the new texts names and mainmenu items names from resx file?
View 8 Replies[Code]...
and Also statment to search between 2 Times. [URL]
I am experiencing a problem when trying to convert a rather large VB6 application into a .Net 2005 application. Everytime I try to convert the project I get the following error: "Upgrade Failed: Exception occurred: Can't use character device names in file names"The weird thing is i have tried to convert the project using .Net 2003 and I do not get the error, it does convert.
View 12 RepliesI want to enlarge an image, possibly up to 32 times or 64 times bigger than original dimensions (so that the user can see each pixel) if possible. The following is a simple function that I have to enlarge an image.
Private Function xEnlarge(ByVal Source As Image, ByVal Rate As Double, Optional ByVal Quality As Drawing2D.InterpolationMode = Drawing2D.InterpolationMode.HighQualityBicubic) As Image
[Code].....
I am working on a VB Console Application that takes an Autocad drawing type DWG and converts it to a PDF using a shell command that calls a third party application. In this case, acmecadconverter.exe from www.dwgtool.com. Then the PDF that is created needs a unique watermark, so I call a second application for that called pdftk.exe from www.accesspdf.com/pdftk/.
Everything works as intended, except when I try file names that contain spaces. The file system object does not tolerate spaces in the drawing file name. For instance, the following command gives me a system.io.filenotfoundexception...
My.Computer.FileSystem.RenameFile("Test Flowchart1.dwg", "Test~Flowchart1.dwg")
It's the same problem for all of my File System commands. Either file not found or invalid arguments.
The complete script I'm using is here:
Code:
Sub Main()
Dim arrArgs() As String = Command.Split(","), _
i As Integer, folderPath As String, myPart As String, _
[Code].....
I have two dates. [code] How to print all dates between these two dates in one listbox, for example: [code]
View 8 RepliesI am using VB.net and am puzzling over an issue which cropped up.I have writen a POS application and am writing a number to a .csv file after each transaction.The problem I am having is this number is written to the file 3 times for each transaction.[code]
View 6 Repliesiwant to create an dll file for comparing two text box dates,, since in my project comparing dates is very necessry for every form,,so iwant to create an dll file,, here iam created an dll file but it was not working, here iam working with asp.net with vb.net..... here my code os given below,
Imports System
Imports Microsoft.VisualBasic
Namespace datecompare
[Code].....
I'm using Visual Studio .Net 2008 on Vista. The goal of my program is to watch a directory, get file information, then sort them by thier date, and produce a updated text file. I can't seem to get my code to generate a list of files sorted by date. The code does produce a general list of files, however presently ordered in the directory. I also tried an alternate way of sorting the files by date by creating a string, removing the date using substring, then comparing the file dates using datetime.parse but it produces a exception error. My first method using the structure follows:
[Code]...
how would it be possible to sort a text file?i have a file named "Alarms.txt" and I am using a streamwriter to save the date and time of the alarm into the file.What I want to do is everytime I insert a date and time, the text file sorts itself this is what the data inside the text file looks like (unsorted)
View 6 RepliesI've got a setup where a ComboBox displays all files in a certain directory, but it shows each files path/directory, and it also shows the files format next to the file name (i.e. "filename.txt").
View 2 Repliesi need to be able to check files in a folder to check if any has spaces in there names and then remove the spaces.
So, Aero Vista.jpg will become AeroVista.jpg
I am working on a VB Console Application that takes an Autocad drawing type DWG and converts it to a PDF using a shell command that calls a third party application. In this case, acmecadconverter.exe from [URL]. Then the PDF that is created needs a unique watermark, so I call a second application for that called pdftk.exe from [URL]
Everything works as intended, except when I try file names that contain spaces. The file system object does not tolerate spaces in the drawing file name. For instance, the following command gives me a system.io.filenotfoundexception...
My.Computer.FileSystem.RenameFile("Test Flowchart1.dwg", "Test~Flowchart1.dwg")
It's the same problem for all of my File System commands. Either file not found or invalid arguments.
The complete script I'm using is here:
Sub Main()
Dim arrArgs() As String = Command.Split(","), _
i As Integer, folderPath As String, myPart As String, _
[Code].....
I am attempting to gather a group of file names from a directory. I am able to do this. I tested the code by having the list populate into a listbox and all desired items were added to the list.
Here is my code:
Dim di As New IO.DirectoryInfo(strPath)
Dim dir1 As IO.FileInfo() = di.GetFiles("*.txt")
Dim dFiles As IO.FileInfo
ListBox.Items.Add(dFiles)
However, a listbox is not my desired output. I am attempting to write these file names to a text file for purposes of then parsing the information to a datatable to compare with another datatable. How to get my filenames written to a textfile.
I have been searching on the internet but couldn't find anything that would help me. I want my program to be able to create a '.txt' file when it is run for the first time, with the date and time the program was accessed, and to be able to add new 'logs' of program history every time it is accessed. What i mean is that i want my program to be able to create a '.txt' file, and then fill in the dates and times when the program is opened.
View 5 RepliesTrying see why this isnt working. I am need to read a bunch of text file with different dates on the end sample is "impactstats_D_0731.txt
Dim oWrite As StreamWriter
Dim line As String
Dim spath As String
Dim readFile As System.IO.TextReader = New _
StreamReader("C:\Documents and Settings\Stats_Report\impactstats_D_*.txt")
line = readFile.ReadToEnd
Say the user specifies these two dates....
Start Date: 2010-12-05
End Date: 2011-01-15
If I select December 2010 I should get the folllowing
startdate = 2010-12-05
enddate = 2010-12-31
Select January 2011 then
startdate = 2011-01-01
enddate = 2011-01-15
Should I subtract dates? How can I get the start and enddate for the current month/year based on the overall start and end date.I'm coding in vb.net.
I'm using two datetimepicker controls to set the start and end dates for a range of dates I'm searching for.I want to make sure that the start date selected is not greater than the end date. This code works, but it runs the messagebox prompt twice for some reason. I've tried to ignore it from doing this, but it's not working. Can someone tell me what's wrong?
Private Sub dtpStart_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dtpStart.ValueChanged
[Code]...