I'm new but will most certainly be hanging around and maybe even answer some posts in other sections. I have the following issue: I have a vb.net web page that places data into an access database. If I leave one of the fieldS blank, (even though Access has a default value of '0' instead of null) when I click to view the results in another page, the page fails with an error.
"System.InvalidOperationException: The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value. etc etc" IF I put any figure in the blank field, even if it's 0, the page functions and works. Baffling. So, the data input page really needs to check, 'if nothing has been entered, automatically append the database with 0. Here's some of the page code: (Standard Record Insertion Wizard within DW cs3, plus Validation)
How to access standard icons, like the "back", "forward", open and stuff? i want to put then in my menus, the save etc can be accessed by inserting standard items but the IE "back"? any eternal free sites?
I've run into an issue with Access Key in either Visual Basic or C#... also happens whether on my windows 7 64 but laptop or my Windows Vista 32 bit laptop - in Visual Studio 2010 professional... I create an Access Key (for example E&xit)... while the underline under the x shows up in the development area, it does NOT show up when I run the application NOR does it work... for example, press alt-x does not run the code associated with the exit (nor does a break into that code show it gets into that code).When I try it in a menu, it is a little different at first the underline under the access key does not show up but then after I access something by hand, it sometimes shows up and is usable.
I build program to launch application(launch application can as local profile or can as network credentials) using Advapi32 "Create Process WithLogonW".but I got the problem, I can't capture message of standard output(Stdout) and Standard Error(stderr).could everyone help me how to capture message and the code?
I usually use standard button and do the settings like causevalidation etc if required.
i decided to use toolstrip and inserted some buttons but end up that it doesn't do the validation for control and also doesn't call leave event of textbox control.
so my question is, anyway to use regular button functionality for toolstripbutton or there is a way to add regular button on toolstrip.
how to proceed. One of our customers is going to be sending me a flat file (ASCII-Text) that I have to break down and scan. Every line ends in a CrLf - So I know I can use StreamReader and ReadLine(). I did get it to work on one of the test files they sent.(A very Short file) However, the file is not delimited at all and every field is padded to the full length they specified. Here's the format of the file:
Now, I want to extract each of the <td>...</td> group. How shoud I do this?I tried to use xml to do this. However, since xml doesn't support < and & in the content area and I can't guarantee there is no such two characters.
What is the standard method for accessing back end data, which logon should you use? For example we have applications that require the user to login but then use an admin account to access the data from the backend.But there are also applications that require the user to login and use those credentials to access the backend data.We are in the process of creating an application that will require the user to login and would like to implement the more common method(standard practice) of accessing data.If there are alternatives those are also welcome.This will be made in ASP.Net 3.5 or higher and may include Windows Applications(VB.Net) as well.I dont want to have two sets of credentials. What I am asking is which credentials are normally used to access the Database. For example one one application may access 2 or more database's. Now would you use the same credentials they used to login to the application or would you use the admin account to access the data?Maybe this should be a seperate question but if I ended up using integrated security to access the database would the user be able to simply connect to the database using his AD account? Either through an ODBC connection and MS Access or equiv.
I am making a new vb.net project . And 1 thing i have noticed many times is The software that i make in high resoltion computer lloks crap in computers with monitor resoluton of 800 by 600.Is there any way we can create software in standard form which has a higher probability to run in all pc's...I can think of 1 way i guess using monitor height and monitor width from properties and then adjusting form size relative to that
In VBA you can have a Userform implement a custom interface and only the properties defined in the interface will show in the VBA Intellisense for the Userform. I tried to duplicate this functionality in VB.Net (2010) and all the base Form properties still show.[code]...
When I select a standard windows form at design time, then in the toolbox, under the "general" section, there are ellipse, line, and rectangle, but they are all gray and so can't be used and I can't find any way to make them not gray and thus usable. What am I missing? The help system tells how to USE them but nothing about how to make them accessible, it just assumes they are.
I have no problem drawing a line on a form at run-time but I want to drop one on at design time and can't find any way that's my real problem.I'm not a heavy user of VB.NET so I figure there's probably something simple that I'm overlooking.
The basic setup is this: VB.NET application, using Windows.Forms, a parent form is shown and the user interacts with that. Now, I want to show a child form, modally, configure that form with data from the parent and have the user interact with that child form and then return information to the parent code.Here is one approach that I have used, but it is a bit awkward. Parent has this code:
Dim cf as Child_Form Dim initdata(3) As Byte ' Set up initdata[code].....
I have been using an Access Database with no problems, using a form (with a sub-form) to input all of the data. Recently the data on the sub-form is not saving to the tables/reports. I enter the data, save and close the form and re-open the record and it is not there. Previously I have been able to save all data using the form and have not altered the form.
I haven't done any VB coding since school (15 years ago) but currently have a need to run what "sounds" a fairly simple app at work. I'm hoping some of you might be able to give me some pointers as to whether or not my idea is possible, and if it is, how best to approach it.
I work for a company where we send a number of standard emails to potential clients asking them to contribute to our magazine . if no response we then send a number of follow up emails. each and every time I send a new email to a new prospect I'm editing one of our template emails, putting their name and email address into outlook and manually sending emails. Then for every reminder I'm going back into outlook, clicking reply all and then c&p'ing our second or third reminder emails in each and every time. needless to say at least 2-3 hours of my day are spent editing and resending the same emails on outlook.
I am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click Dim SearchPatient As String = txtNPatientID.Text
I'm reading data from a .mdb access database to a form in my app. However the text is sometimes becoming scrambled as shown belowDatabase:Quote:The resistance of a 2.5mmonductor of length 8m and resistivity p = 1.72
I am creating a small program which has a few texboxes which i want to saved in a access database.My problem is i have no clue what code belongs to such button.I have added the database to my datasources, and linked the fields from the database to the textboxes.But thats all i got so far,.Being searching around the net for a few days to figure this out, but no luck.in my access db i got the fields firstname, surename, address1, address2, postcode, phone, email.Each are linked to their matching textbox on the form.
i dont know how to show the data in the ms access through visual basic, this is the form, if the details that are entered are correct, the password must popup i want it to show in the visual basic and here is my query, i dont know if this is correct, if you enter the "Question, and Qans" correctly, the password must popup
Dim retrieve = Me.LoginTableAdapter1.ForgotPasswordString(TextBox5.Text, TextBox6.Text) If retrieve Is Nothing Then MsgBox("Please the Correct Statement")
I have two tables in one to many relationship in an access 2003 database.I am using vb6 and visual studio 2008.I want a data entry form (in grid view) for child table. I want to display & add, Update, delete child records accordingly with parent.
i.e. What I require is One combo box displaying a parent field and corresponding child entries will be shown in grid view. Data entry form for parent table may be on separate form.Is there a full sample source code for above mentioned theme.
I have a program in which I want to have the user enter two percentages and display the data matching the criteria on a new form. The query would be:
Select * From Corrosion Where corrpct1 >= {column in database} OR corrpct2 >= {column in database}
The way I currently have it written is to display only one row of data. I need to display any number of rows that meet this criteria. My current code is:
Private Sub btnDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDetails.Click Dim form As New frmDetails() Me.Hide()
[code]....
1. How can I do my query to incorporate the user entered criteria (in the where statement)?
2. How can I display ALL of the data instead of just one line?
i have a access database with two tables, one for customer and one for booking.
I then have a form application i made in VS 2008 which lets a user enter details such as their name phone number ect into text boxes.
All of the information the person enters thoughout the program is shown via labels at the end, all on one form.
Would it be possible to then have a button that when clicked saves all of this information into the access tables into the correct columns, im sure it must be possible i just don't really know where to start.