I have a VB.NET program that uses an Access database. I need to be able to put this on other MS Windows XP computers so users can run this. Can anyone please give me instructions on how to do this.
Weird that my VB books and classes never covered this.
Thank you,
Devo
sirdevo
Last Activity: Dec 30 '10, 08:00 PM
Joined: Nov 12 '09
Location: Oklahoma City
-
Create Stand alone programs for other machines
-
Put VBA If -Then-Else Block in the BeforeUpdate event of the textbox.
Private Sub YourTextBox_Bef oreUpdate(Cance l As Integer)
If DateValue("11/25/2007") = DateValue(txtRe portDate) Then
cohort = 1
ElseIf DateValue("01/30/2009") < DateValue(txtRe portDate) Then
cohort = 2
Else
cohort = 3
End If
End Sub
... -
You can use the Mod operator. This will give you the remainder of the division of any two numbers.
intRemainder will now be holding 20 which is the remainder of the calculation.Code:dim intRemainder as Integer dim intIntegerPart as Integer intRemainder = 12100 Mod 40 intIntegerPart = 12100 \ 40
intIntegerPart will then be holding 302 which is the integer part of the answer, make sure you use the...Last edited by Frinavale; Dec 4 '09, 05:16 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.Leave a comment:
-
Thanks Chip,
The whole string does come through in the msgbox, so it must be a limitation of the editor. I was wanting to check it since it was an UPDATE statement and would have hated to change the whole table with a bad statement. It showed the whole message when I put the String into a messagebox.
Thank you again,
DevoLeave a comment:
-
Creating a breakpoint and then checking the locals screen.
DevoLeave a comment:
-
Does String Datatype in VBA hold more than 255 characters?
I'm trying to use a SQL statement that is longer than 255 characters in Access VBA 2007. When I look at the local variable it cuts the rest of the string variable off. Code I used was this in VBA.
dim myStr as String
myStr = "String Holds more than 255 characters"
I've tried using a couple of differnt strings to see if my syntax of the string in the variable was wrong but it still cuts off at... -
I just found out how to disable the subform. I used this code in main form.
Me.Report_Soil_ Series_Subform1 .Enabled = False
DevoLeave a comment:
-
Need help disabling a combobox on subform or disable subform
There is one combobox on a subform named Report Soil Series Subform1. The combobox is named cboSoilSeries. I need to disable this so the user can't enter values. I could also disable the whole subform since this is the only control on the subform. I've tried this line of code but it says you can't disable the control while it has focus.
Forms![Survey Report]![Report Soil Series Subform1].Form.cboSoilSe ries.Enabled = False
... -
Thank you, this helped me too
I had a couple of textboxes I needed to change the .text property on, but when I would setfocus to update the textbox it would cause problems by activating all my events I had placed on those textboxes. It allows me to change the values without causing events to trigger.
Sir DevoLeave a comment:
No activity results to display
Leave a comment: