I have a stored procedure running in SQL Server 2000 which returns a value
when I run it in SQL Server Management Studio 2008 (SMS). I have also tested
it in SQL Server 2000 Query Analyzer with the same result. However, when I
run it with VB.Net 2010 I get "nothing" as the value of the return parameter:
cmd.Parameters( "@ReturnCount") .Value.
How do I get a value back? The parameter I am testing...
58 results in 0.0050 seconds.
-
Return value from stored procedure is "nothing"
-
Based on input number Creating textboxes and lablel
Hi everyone!
i am newbie to visual basic.net, and I'm having a headache to do this. Assuming we ask the user to input a number of guests and based on that number of guests..we creating textbox or label or something to ask guests' name, guests' age.
For Example:
User will put in our textbox 2 guests so we will firt ask for the first guest what is his name, what is his age and then ask for the second guests what is his name, what... -
user form excel 2007 - method or data member not found
Dear All,
I am trying to make a simple user form in Excel 2007 to be used in my workshop. This is part of the code I've made :
If Me.txtFirstName .Value = "" Then
MsgBox "Please enter a First Name.", vbExclamation, "Customer Databases"
Me.txtFirstName .SetFocus
Exit Sub
End If
However, every time I tried to run the form, I always get an error message... -
DirectX Game Screenshot
Software: Visual Basic 2008
My problem:
I make a program for taking screenshots from the game, this is the current code that I use:
...Code:Dim bounds As Rectangle Dim screenshot As System.Drawing.Bitmap Dim graph As Graphics bounds = Screen.PrimaryScreen.Bounds screenshot = New System.Drawing.Bitmap(bounds.Width, bounds.Height, System.Drawing.Imaging.PixelFormat.Format32bppArgb) -
Compile Error: Sub or Function Not Defined
Hello all.
I am trying to use DLookup to auto-populate fields in an otherwise simple database. I am using Access 2010. I have created three different databases and the code still does not work. I think there may be glitches in this particular copy of the program. Please evaluate the details below and tell me what you think.
Table 1 has fields: Product ID, CustomerName, CustomerAddr, and ComplaintLevel.
Table... -
dsal3 started a topic item cannot be found in collection corresponding to the requested name or ordinalin Visual Basicitem cannot be found in collection corresponding to the requested name or ordinal
I am seeking help to try and fix an error that I am getting inside of my excel vba code. I am trying to import the column names of a sql table into an excel worksheet. When I run this code:
[For intCount = 0 To rsmyf.Fields.Co unt
Range("A2").Off set(intCount, 0).Value = rsmyf(intCount) .Name]
I get this error: Run-time error '3265'- Item cannot be found in the collection corresponding to the requested... -
VBA Access display label
Hello,
I have a form that is locked by default, if a user wants to make an edit they have to hit the unlock button. I want to display a label to let them know the form is locked at the top, so new users don't assume it doesn't work.
My logic is: The unlock button has a method where it enable edits to the form once clicked. My code based on that is as follows;
...Code:Private Sub lbl_unlock_MouseMove(Button
-
How can I check if my highlighted field is selected !
Hello,
I am new to VB&Access and inherited a project. I have a form with multiple buttons and if one is clicked then a few fields under the buttons are highlighted. Different fields are selected/highlighted depending on what button I click. I have managed to write VB code to throw up and error if a field is null, but that doesn't help me much because on a different button click that field might not need to be filled in.
... -
Boolean variable Help
Hi,
I'm writing a form to get numbers in order to calculate the price. if numbers and the code of business is wrong it will give me message box error.
The result will appear on a rich text box.
My professor wants me to set declare separate string variables to displaying text in the richtextbox.
MY QUESTION :For Boolean variable, assign false to Boolean variable, when user input is invalid. Display results in the richtextbox,...Last edited by Frinavale; Oct 7 '11, 07:41 PM. Reason: Added code tags and fixed the spelling of the word please...Please refrain from using leet-speak on this forum. -
Key Press on Form
Hi,
I have this form that has all these controls on it such as buttons, entry fields, lists, and combo boxes, and I've been looking around the net for a while now trying to find a way to track key presses on my form so that I can trigger a set of code. For example when the user presses Shift + W call code that moves picture box up. I have the KeyPreview set to True on the form and I have placed this code.
...Code:Private
Last edited by Meetee; Jul 20 '11, 05:11 AM. -
Speed up Excel Data Read
Hey,
I am trying to read data from an excel spread sheet then combine the data into a combo box. My code works the problem is that it is very slow because of the amount of data it has to process. Is there a way to speed up the process of extracting the data from excel. It takes about 30 seconds to load the form right now.
Thanks
...Code:Private Sub Form1_Load(ByVal sender As System.Object, -
NGram Approximate String Matching
INTRODUCTION
An ngram is the subsequence of n units from a given sequence. These units can be words, characters, etc. For example, the 2-gram, or bigram, of the phrase "Hello World" is "He", "el", "ll", "lo", "o ", " W", "Wo", "or", "rl", and "ld".
USES
NGram modeling is often used to model natural languages. It is...Last edited by Rabbit; Apr 27 '18, 05:09 PM. -
How do I create a Microsoft Access Database Search Engine with Visual Basic 2008
Hey guys,
i have been having trouble getting started with a visual basic 2008 project. I happen to be reasonably new to visual basic and am finding that it is more difficult to work out solutions than it is using javascript or php within web programming.
Anyway the project that i am working on is a small piece of software that can search different tables in a Microsoft Access 2003-2007 Database depending on the selection criteria... -
Calendar function in MS access
I got the attached database somewhere online. I do not own it. It has a great example of Calendar function which I am trying to develop. Could anyone please help me to understand the relation between tblInput and frmCalender (and other forms and reports related to it)so that I can link a table similar to tblcalendar to the calendar function.
I appreciate your response.... -
Dalia Allencher started a topic How do I a create ms access calendar schedule like Outlook calendar?in Visual BasicHow do I a create ms access calendar schedule like Outlook calendar?
I have to plan the work schedule.
For example: The process has several steps.
Steps Step 1 Step 2 Step 3
Due dates 2/5/2011 2/10/2011 2/15/2011
I want to create a calendar like Outlook where I need the steps to display in respective dates, which I can take a print out and stick to my wall.
I have some knowledge of MS acccess, but I don't know anything about coding....
