|
My dataset binds to a textbox to display a particular record when I click a select button.
I clear the textboxes by clicking my clear button.
I receive an error that two bindings cannot be done on the same object whenever I tried to select a new record without closing the form.
Pls how should I bind the textbox to the dataset such that I will not have to close and open the form to select subsequents record.
Fikunmi Feyijin
Hicad Systems
Nigeria
|
|
|
|
|
I am having a problem with the VB 2005 ListView control using the Details view. I am basically using the ListView to display information from a database table.
The problem I am having is that one of the columns is concatenating the string that is being passed to it for one of the subitems, and not showing all of the text.
My questions would be, 1) Is there a property that I am not seeing that will keep the text from being cut short, and 2) Does the ListView support a multi-lined item that can wrap?
|
|
|
|
|
1.) try to check your declared length for the corresponding fields .....
nothing is impossible.....
|
|
|
|
|
Hi,
I need the VB 2005 code to check the email and domain verification and username testing using smtp. Even an idea will do. Please help me...
Regards,
CHandan
|
|
|
|
|
Is this the solution to the answer....I need to develop a code which checks the email provided for the email address and domain verification.........huh
|
|
|
|
|
The only way to see if an address is legitimate is to send an email to it with some kind of link that the receiver clicks on to tell you that they got it. The user clicks on that specially formed link and brings up a website that you supply. This site takes information from the link and uses it to determine who that user is and that the address that the email was sent to was good. There is no other method of determining, with ANY kind of reliability if an email address is good or not.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I need to develop some code to check the header type of a file attachment to determine the file extension. This will be a picture file attachment, so I need to determine whether this is a .jpeg or bitmap etc. Can someone give me some idea how to code this ?
|
|
|
|
|
Search google for "file formats for programmers", and you'll find excellent results on this topic
|
|
|
|
|
Ok, so basically i am trying to use a DataGrid, VB, and an Access database to keep track of some information. But I cant remember or i guess figure out how to make the information i want to go from a label, to display in a cell in the datagrid, and also some where in there update the database. Im figuring that the easiest and best way to do that would be to Update the database then redisplay it in the datagrid, but i just cant get the right code for it. Any help, MUCH Appreciated.
|
|
|
|
|
DataGrid's have been upgraded in VS 2005 to DataGridViews. This new object has a ton of new stuff. Here are a few links to help you with them.
Overview[^]
List of How tos[^]
How this helps.
|
|
|
|
|
I am writing a function to check for invalid characters in a file befor written to db but when I run the project I get the following error: Conversion from string "06110-001-000" to type 'Boolean' is not valid.
Here is the code I have.
Function:
Public Function InvalidCharacterCheck(ByVal StringToCheck As String)
Dim InvalidChars As String() = {",", ".", "'"}
Dim B As String
For Each B In InvalidChars
If InStr(StringToCheck, B) Then
Return True
End If
Next B
Return False
End Function
Code to handle function:
If InvalidCharacterCheck(row("PartNumber") = True Or InvalidCharacterCheck(row("mostforwardpartnumber"))) = True Then
ErrorLog("Not Valid partnumber or Supercede partnumber: " & row("PartNumber"))
Else
Any suggestions?
jds1207
|
|
|
|
|
jds1207 wrote: If InvalidCharacterCheck(row("PartNumber") = True Or InvalidCharacterCheck(row("mostforwardpartnumber"))) = True Then
i think it needs to be like this
If InvalidCharacterCheck(row("PartNumber")) = True OrElse InvalidCharacterCheck(row("mostforwardpartnumber")) = True Then
|
|
|
|
|
Does anyone have a Screensaver app in vb.net 2.0 that I could use as a starter? I am looking for one that will just cycle through jpg's in a shared folder. I don't mind buying one for a few bucks but it would be nice to be able to have the code to customize it myself.
|
|
|
|
|
I think Visual Basic express edition comes with a starter pack that includes a screen saver.
|
|
|
|
|
Hello,
I am trying to make a scheduling application so I have a UI with checkboxes for every weekday and save the values in the DB. When the user wishes to make a new schedule, I don't want to allow conflicts,i.e 2 schedules running on a weekday at the same time. So if the previous schedule is for Monday, Tue, and Wed and the current is for some other days(maybe includes Wed, Mon, and Tue maybe doesn't). Problem is how do I check this, how can I verify that the schedule is not conflicting. I am first comparing the times before the days as if the time is not the same there will be no conflict.
Remember I only have to check the checked days against the stored checkdays in DB, or Do I?
Thanks b4 hand
Yoshimitsu
|
|
|
|
|
When your user logins to the application, you should probably pull their schedule from the database and put it into a DataTable. This will enable you to quickly evaluate their selections against their pre-existing database content without having to make round-trips back and forth to the database.
Secondly, when the application begins running, you might want to enumerate all of your checkboxes against the DataTable, to find out which ones should be selected and which ones should not be selected, according to the database information stored in the DataTable.
Next, when a CheckBox event Checked is raised, you can take the arguments and pass them to the dataTable to see if they conflict with any data on file. If not, then write to your datatable the new data.
Just be sure to update the DataSource from your DataTable with a DataAdapter once you're finished.
Jonathan Sampson
www.SampsonResume.com
|
|
|
|
|
Thanks a bunch. I just had to keep going because of time constraint and somehow managed to do it. I was actually saving the contents in an arraylist so I didn't have to make round trips.
Thanks once again.
Yoshimitsu
|
|
|
|
|
So, my foray into VBA continues. Under Excel, I am developing a financial application. This is my first time using VBA, so I am a little clueless on certain (simple) things. The problem I have is the following:
I have data stored in an array that I write to a column in Excel. The length of the array can vary from calculation to calculation. Thus, I write the data from the array to the A column on the spreadsheet. Let's say the length of the array is n. So I write n elements to column A on the Excel spreadsheet. Now, I am trying to get excel to automatically plot the data in column A on a graph, but n is variable. So in one instance n may be 100. In another n may be 233, for example. The problem is that I don't know how to automatically determine the length of the column so that I can plot the data on an Excel chart. Any assistance would be appreciated.
Thanks in advance.
|
|
|
|
|
Use the Chart object, as in the following sample:
Dim MyArray(4) As Long
MyArray(0) = -5: MyArray(1) = 1: MyArray(2) = 2: MyArray(3) = 4: MyArray(4) = 7
With Worksheets(1)
Set a = .ChartObjects(1).Chart
.ChartObjects(1).Chart.SeriesCollection(1).Values = MyArray
End With
Hope that's useful 
|
|
|
|
|
Chapter 6 "Using Excel's Range and Chart Objects" of Microsoft Office 2000 Visual Basic for Applicatio - fundamentals - might help. I will send the text of "Using Excel's Range and Chart Objects" to by e-mail via CP.
modified 1-Aug-19 21:02pm.
|
|
|
|
|
Richard A. Abbott wrote: Chapter 6 "Using Excel's Range and Chart Objects" of Microsoft Office 2000 Visual Basic for Applicatio - fundamentals - might help. I will send the text of "Using Excel's Range and Chart Objects" to by e-mail via CP.
Ah, that would be great, thanks. I don't have any reference books handy! (As you can probably tell...)
|
|
|
|
|
When my application runs on a certain HP computer the last letter on each label on the form is cut off making the labels illegable. On all other computers we installed the application on the labels look fine. Why doesn't the HP computer display the labels correctly?
|
|
|
|
|
I think its a problem with the resolution on that computer
|
|
|
|
|
Your label boxes are being cut off because your form's layout doesn't allow for different DPI settings or resolutions. I'd direct you to the documentation and some articles on MSDN on the subject, but the MSDN site isn't responding right now.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks.
I changed the AutoResizeMode = dpi
This fixed everthing except for some of the label controls. The code defines the location of some of the labels on the form at runtime. The code bases the locations on a 96dpi but if the app runs on a computer with a different dpi the labels are put in the wrong spot. I think I need to know the computer's dpi when calculating the locations of these labels. How can I get that?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
