srj115
Last Activity: Jul 29 '09, 11:22 PM
Joined: Sep 20 '07
Location:
-
32-bit... My mistake. Thank you!... -
VBA overflow of long data type
I've been messing with an Access database recently. I'm trying to assign a 14-digit number to a long variable, and I keep getting an overflow message!
I don't get the overflow when using a double, but later I'm going to convert the value into a string. (I can't have that goofy "+E18" value at the end.)Code:Dim lng as Long lng = 20081008095613#
Why does VBA automatically add that "#"... -
It's always obvious when you get good advice. Thank you!...Leave a comment:
-
VB.NET 2008 Refresh System.Graphics.DrawString
I have a form that periodically updates an image, which in turn is supposed to update a caption. However, each time the form updates the picture, the caption remains the same as the first picture's caption. The captions are stored in an ArrayList, and I'm positive that the index is being updated appropriately. For instance, I can MsgBox(arrCapti ons(intArrIndex )) and get the correct caption, but the new caption never replaces the first caption... -
Well, I thought I had it. Instead, when I go to access the list items, each item just contains the data of the very last item. For instance, when I run the StoreFamilies Sub, the message boxes just repeat the last set of data entered. Like, (if it reiterated only 3 times) I could enter "Mabel and Jenny", "Herbert and Joey", "Frank and Bobby", but the message boxes will just repeat "Frank and Bobby". Any...Leave a comment:
-
Excellent! Thank you much.Leave a comment:
-
VB.NET 2008 global multidimensional dynamic array
I have a text file containing 2 dimensions (parents,childr en). There are an indeterminite number of parents, and each parent has an indeterminite of children (ie, both dynamic). I have no problems reading the data from the file. I've tried reading the file to obtain the bounds of each dimension, but I can't seem to get ReDim to work. All I want to do is get this data into a global 2-D array, so that all functions in my class have access to it.... -
Can you display a subdatasheet in a DataGridView in VS.NET 2005?
I'm building a VB form with a DataGridView in it, and I'd like it to show a subdatasheet of a related table. For instance, in Access 2003 I have a "Tasks" table, and it has a one-to-many relationship with the "SubTasks" table. Opening the Tasks table in Access will show a "+" sign next to each record, which can be expanded to show all subtasks related to the Tasks record. However, I am unable to get the "+"... -
Updating database table from datagridview VB.NET 2005
This is just something that had me tearing out my nose hairs in frustration... hypothetically. I must have spent 7 or 8 hours trying to get this to work before I smelled the coffee (so to speak). Now, all I'm missing is my pride.
The issue: Debugging my form to get the bound datagridview to update the backend database table. After running the app in the debugger, none of the changes I made to the table in the datagridview were...
No activity results to display
Leave a comment: