|
sorry for the cheesy topic name....
Anyway, i have project with a fairly low data-volume. I am running it off of an access database at the moment.
I believe this makes it less portable as the user must have access to use it that way (right???). would i be better off just using a flat file? we're talking about three small tables with a an average of about 6-7 complete records.
thanks
serenity now, insanity later - lloyd braun
|
|
|
|
|
Hi there. Access .mdb files are actually very good for low volume, desktop (i.e. non-shared) databases. Your code just needs the Jet provider installed on the client machine - which is a standard part of MDAC (as opposed to a full copy of Access). So you're probably just fine using it.
Of course, with only six or seven complete records you may do just fine to use an XML file to store your data. If you're using .Net, you could read the file into an XmlDataDocument and treat it as either an XML document or a DataSet.
|
|
|
|
|
Another place to look is the "Quality of Service" layer in Windows.
If "to err is human", programmers must be superhuman...
|
|
|
|
|
OOPS... Wrong thread! (See thread above)
If "to err is human", programmers must be superhuman...
|
|
|
|
|
How do I open the Dos window and run a batch file within a VB6 application. I have found code that runs batch files, but it does not show the Dos prompt. I need to somehow in VB6 open the Dos console and run a batch file where they have a chance to enter a password for sftp. Anyone have any ideas?
I am using OpenSSH sftp and so far have built a batch file they have to access from their desktop and enter a password and run a whole bunch of other commands. It is very confusing to them because they do not have much computer experience.
-Garrett
|
|
|
|
|
Ask for the "Username" and "Password" in your VB program. You would shell your BAT file with the Username and Password as command arguments. In the BAT file run the DOS program and pipe the command arguments (%1 and %2) to the console to supply the signon. It's been way too long since I did a batch file so I have forgotten the syntax, just remember you can do it.
If you can use HTTPS, you can do it all from within VB using the Inet OCX control in VB 6 Pro.
If "to err is human", programmers must be superhuman...
|
|
|
|
|
I initially had pictures that acted as buttons to move forward and backwards within a list of pictures that I have contained in an arrayList. The code that I had on the picture click events worked, but then removed the pictures and used buttons instead and can no longer get the screen to refresh.
This is what I had before for the picture click events
<br />
If currentPage > 0 Then<br />
currentPage -= 1<br />
Me.frmMain_Paint(Me, New System.windows.Forms.PaintEventArgs(Me.CreateGraphics, New Rectangle(0, 0, 0, 0)))<br />
End If<br />
This is probably not a good way of doing it, but it worked
Does anyone know how to do the same with buttons. Thanks
|
|
|
|
|
Public Sub CalcDaysWorked()
Dim I, X As Integer
For I = 41 To 1 Step -1
If (FrmCalendar.TxtDate(I).Text = "1") Or ((FrmCalendar.TxtDate(I).Text = "2") Or (FrmCalendar.TxtDate(I).Text = "3") Or _
(FrmCalendar.TxtDate(I).Text = "7")) Then
FrmCalendar.TxtDaysWrkd.Text = (Val(X))
Exit Sub
Else
If FrmCalendar.TxtDate(I).Text = "W" Then
X = (X + 1)
Else
If (FrmCalendar.TxtDate(I).Text <> "1") Or ((FrmCalendar.TxtDate(I).Text <> "2") Or _
(FrmCalendar.TxtDate(I).Text <> "3") Or (FrmCalendar.TxtDate(I).Text <> "7")) Then 'IGNORE IT
I = (I - 1)
End If
End If
End If
Next I
FrmCalendar.TxtDaysWrkd.Text = (Val(X))
FrmCalendar.TxtDaysWrkd.Refresh
End Sub
BAsically this is part of an employees attendance/work record it keeps track of points(1,2,3 or 7)
days worked"w"
and some misc info that need not be tracked for this calculation
thus the I=I-1 'to ignore the entry
I need to calculate the days worked (my w's) after the last occurance of an infraction(1,2,3 or 7)
My code works 100% however i forsee an error if a "w" is enetered on the last day of the month
This is because the x values is only calulating on ever other loop through the code
The problem is in the above code..When I debug it it gets called on correctly everytime but the "x" value is not incrementing by 1 every time!
Greg S
|
|
|
|
|
I have one form. There is one datagrid in that. When I click on a button to add data, one form will show. I want when I click on Close button on Form 2, datagrid value of Form 1 will change. How I can refresh datagrid source from the other form ? Please help me. Thanks
|
|
|
|
|
Well the problem I am having right now is as follows:
I am building a MDI application. In my application there are one mother (MDIContainer form) and two other children forms. The first child form has a listview control with checkboxes in which rows of a specific table (rows with status flag = 0) are shown and a button. The user checks a row and then presses the button. The second child form shows and display detailed information of the selected row. There is also a button to approve this record. Once the user presses the approve button the status flag of this row is set to 1.
What I want to do is the following:
Once the user presses on the approve button of the second child form and then if he switches to the first child form through selecting its name form the window menu of the mother form I want to show him the updated list (i.e. the approved row to be excluded).
How can I do that? I really appreciate your help.
Many thanks.
|
|
|
|
|
There are two ways you could try to do that. The first would be to declare all the controls on both child forms as Public. Then, you could access controls from the other form.
Your second option would be to create a module that would contain variables, and depending on the variables, the listview would update.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
ive been wondering along time.
does anyone know how to use MIDI instruments, etc, to create notes for output to speakers, in VB.net?
it seems impossible, no one has said anything about it.
------------------------
Jordan.
III
|
|
|
|
|
Nadroj wrote:
it seems impossible, no one has said anything about it.
I'm sure someone knows how to do it, but not me. Have you tried searching MSDN or Google?
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
iv been searching online for quite a while then gave up. i can only find examples in vs.net for like c++, c#, not vb.net
anyways, thanks alot for your input!
------------------------
Jordan.
III
|
|
|
|
|
Nadroj wrote:
for like c++, c#, not vb.net
Use the C# stuff and convert it over. Should not be that hard.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
Ray Cassick wrote:
Use the C# stuff and convert it over. Should not be that hard.
This is true. I never really learned C#, but I know JavaScript (the syntax is very similar).
All you have to remember when converting from C# to VB.Net, is that you declare the data type defore the variable.
Examples:
(dim i as integer) in VB.Net is (int i = 5) in C#
(sub hello(byval world as string)) in Vb.Net is (void hello(string world)) in C#.
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
Because I am a lazy programmer (there is an oxymoron right?) If the code is long and I am crunched for time I always start out with a quick conversion tool. It atleast gets me 90% there most of the time.
Try this one out[^]
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
Jörgen Sigvardsson wrote:
If the physicists find a universal theory describing the laws of universe, I'm sure the a**hole constant will be an integral part of that theory.
|
|
|
|
|
Yes, C# to VB.Net converters can usually convert a good amount of code decently. There are still some things that are not converted correctly (attaching events, single line if...then, etc.) but converters are a good time saver. Especially if you are a lazy programmer like Ray or me 
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
|
Looking for code to pass information from Form2.textbox1 back to Form1.label1
Process - Press Form1.button1 to show Form2,
Enter information into Form2.textbox1,
Press Form2.button1 to display information from Form2.textbox1 to Form1.label1.
Thnaks in Advance!
Form1 consists of <Startup Form>
Label1
Button1
For2 consist of
textbox1
Button1
|
|
|
|
|
The simplest way is to set the access modifier of the textbox to public or friend, then set
label1.text = textbox1.text
"if you vote me down, I shall become more powerful than you can possibly imagine" - Michael P. Butler.
Support Bone
It's a weird Life
|
|
|
|
|
just a thought..dont u hav to use inheritance to do this sorta thing?...I'm actully looking to do same thing as well but with no luk so far..
rubdub 
|
|
|
|
|
Here it is -
Some background info for you that was given to me in the C# area
[Google on "Mediator pattern" and "MVC" (or "Model-View-Controller"). If you learn how to use these patterns, you'll never get stuck like this again; your code won't need tricks like passing a form to another form. I recommend "Design Patterns" by the Gang of Four.]
I just went to Microsoft ans sought out "Model-View-Controller"
As for the code. A no brainer once you do it, Key words "once you do it"
Once you have placed this very generic code in the forms and "Shared" class, go to project properties and
set the startup object to "Global" - this is you shared class, you can use this class or whatgever class you use for application prep, tracings and logs.
Option Strict On
Option Explicit On
Public Class Form1
Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Global.postF2()
End Sub
End Class
Option Strict On
Option Explicit On
Public Class Form2
Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Me.Hide()
Global.postF1(TextBox1.Text)
End Sub
End Class
Option Strict On
Option Explicit On
Public Class Global
Public Shared f1 As Form1
Public Shared f2 As Form2
Public Shared Sub main()
f1 = New Form1
Application.Run(f1)
End Sub
Public Shared Function postF2() As String
f2 = New Form2
f2.Show()
End Function
Public Shared Function postF1(ByVal post As String) As String
f1.Label1.Text = post
End Function
|
|
|
|
|
create a fillschema a dataset
I create a SYBASECOMMANDBUILDER (from DDTEK Sybase Driver)
I create a row from the dataset
I fill the row with data
I add the row back to the datatable
[rowstate is now UNCHANGED]
I make a change to the newly added row
[rowstate is still UNCHANGED]
Of course the following update command returns zero, since there are no rows that do not have a status of "UNCHANGED". Can someone explain to me what I did wrong? datarow adds and changes should change the rowstate to Added and Modified respectively. Thanks in advance
Have a blessed day in Messiah EYAWHOOSHUA!
|
|
|
|
|
I dont know how to do that. Directly in the Keypress event. Someone can help me ?
I am a newbie
|
|
|
|
|
Your definition of what you need is lacking. However, if I understand correctly, in a KeyPress event, you want to take the key that was pressed and convert it to uppercase. If this is your goal, try this in your sub
<br />
Dim key As Char = UCase(e.KeyChar)<br />
Hope this helps
Aaron Eldreth
TheCollective4.com
My Articles
While much is too strange to be believed,
Nothing is too strange to have happened.
- T. Hardy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
