Is there a way that i can access a string from another form. I wrote it like "Dim Text As String" on form2 and i want to access that string fro form1 but it wont let me.
i have problem using insert into query for values = "Import With Pre.Tariff (Asean,Cept,C'wealth)" it keeps saying
Syntax error (missing operator) in query expression ''Import With Pre.Tariff (Asean,Cept,C'wealth'.
it seems is it cannot reads ) and show missing operator but this is a string not operator for "Import With Pre.Tariff (Asean,Cept,C'wealth)" this whole thing is sting from datagridview .. any how to make it insert into database without system prompt missing operator problem ???
which is apostrophere problem i used single quote but system read like dat
''Import With Pre.Tariff (Asean,Cept,C'wealth'.. it drops ')' G3_select = "insert into tblrk1stt (JOB_NO, [COUNTER], RES_CODE, ERR_DESC, REMARK, LINE_NO) VALUES ('" & G3_value4 & "', '"
I got an app, which receives data via a R232 port, convert it to a string and on the other side I got a database, where the strings are saved. How can I find a way to compare the string with all strings in one database column and get back the another stringform the same row in this database. I never programmed a database
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
I have 2 forms main_frm and copying_frm. In main_frm, there is a list view that is populated with file names. The user then clicks save and all the files in the list are copied to a folder that they choose using a folder browser dialog. When this happens, I do copying_frm.ShowDialog() to display the copying_frm. The copying_frm contains a progress bar and a cancel button. I can get the progress bar to indicate how much has been copied. But that freezes up the application. To get around this, I create a new thread (called copyingThread) that copies the files. When that thread runs though, it can't access the waitingList_lvw in main_frm. For example, in the function that the copyingThread executes, if I have this line of code: MsgBox(main_frm.waitingList_lvw.Items.Count.ToString()) the result is 0. Also, I don't get any errors and no files are copied. How do I access waitingList_lvw in main_frm from a thread called copyThread that was created in copying_frm?
Communication between form can be done in many ways using constructor using delegates etc in .net but my question is how can i access a value that is entered into a child form from a parent form or can a two way communication is possible between windows forms.
What is the best way to access a value of a control within a form outside of the form class. I have a lot of functions defined in a module, one of these functions requires a series of values from controls in my main form such as the FolderBrowserDialog.SelectedPath element. I understand that these cannot be accessed in the format form.FolderBrowserDialog1.SelectedPath and that they need to be accessed using a delegate. This is the part I am stuck with.
I have designed my app for multiple gridviews. When a user double clicks a row it opens up the data in a modal form and when they commit changes the row gets updated.While they have that modal window open they can not go back to the grid.But I have a alerts/messages window always running (like outlook tasks). As soon as I open the modal window I can not access that tasks window. (Default behaviour)How can I open the modal form and still let the user access/view the tasks window while they work on the modal window.(I tried creating it in a differant thread, but got a lot of cross thread errors so decided to abandon that approach.I thought that 2 modal form can run at the same time as long as they have differant parents. But aparently the main GUI thread pauses as soon as you open a modal window on it.
below i have the form which i made in access, its BIG, REALLY BIGI am going to try and recreate this form using VB and MySQL, the question is how?The purpose of this form is to display all locations ready for someone to enter in information into them, normally the first field in each table has a unique name (which is set as the default value for that field), in the morning, the only field which is altered is a sign on field, which in access, the user clicks and the time is entered.
simple problem Basically in form1 i have a line of SQL code in a rich text box called rtb_select
what i would like..This code to run under a connection string called strSQLSelectQuery in form2
I have been told someting like strSQLselectQuery = rtb_select.text would work however because rtb_select is in a different form in the same project it does not recognise rtb_Select
i have the connection string cn = New OleDbConnection("Provider=Microsoft.Ace.OLEDB.12.0; Persist Security Info = False;" & _ "Data Source=C:printtest2.accdb;")which works fine but my database is in the server in a network what additional details do i need for the connection string The server name is as follows "Prntsvr-Test.auhbr.ctrixa.ad"how do i use the connection string
I've been handed an Access database with 3 columns: Name, category, e-mail. What I'm trying to do is get out, as strings, all of the e-mails that match a given category. I have a slight understanding SQL as I'm in the process of learning it. I've managed to churn out this bit of code, which populates a visual grid with the first names
Dim comm As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=.AddressBook.mdb") Dim addda As New OleDbDataAdapter("SELECT FirstName FROM Contacts", comm)
I am fairly new to visualbasic. A little background from me, I've programmed before in C++, Java, and PHP so I know programming. But I am new when it comes to GUI development too. My question is that I have a main form and I've created another small form. In the main form I show the small form when they click a button, like this:
I have a function that updates a Client in the database. A client object is passed in, along with a string array of fields/properties that should be updated. I need a way of accessing each property in the client object, based on what is in the array. Basically, I am looking for the VB .NET equivalent to this javascript:
var fields = ["Firstname","Lastname","DOB"]; for(field in fields) {
My Ms-Access .mdb file is on my website. It is in the App_Data Folder
The current connection string is:
OleDbDataAdapter Da = new OleDbDataAdapter("Select * from SerialNo", new OleDbConnection(@"provider=microsoft.jet.oledb.4.0; data source=ftp://ftp.WebsiteName.com/App_Data/SerialNo.mdb"));
Where am I making a mistake in above connection string?
Note: CRs added in the code for better readability
My query is not the straightforward connection to MS Access.I am using a third application that places all data in an Access database BUT recently they changed the database so that it doesn't end in '.mdb', instead in another suffix: '.accdb'.The database is still an Access database but I cannot connect to it using the connection strings:[code]Previously I was able to use the second connection when the database name ended in '.mdb' (Database Name.mdb).
I have been using VB6 for many years and have recenty decided to migrate to .net 2008 im slowly getting the hang of it but the problem i face now is the connection string to an access database, below is the code i used in VB6 is there a way to convert it for .net.[code...]
I have a string "<PinX F='53mm'></PinX>", I want to access the 53 within the string and do some addition to it and then add the answer back into that string. I've been thinking about this and wasn't sure whether this can be done with regular expression or not?
Lets say I have a combo box that contains the values "alpha", "bravo", "charlie", etc.
When the user selects a value from the combo box, then that value will be written to a string variable, like...
Dim ComboSelection As String = combobox1.SelectedValue
Now, lets say I have a bunch of panels on my form, which have names corresponding to each combo box value. For example...
pnl_alpha pnl_bravo pnl_charlie etc etc.
So what I would like to do is use the value of ComboSelection to access the appropriate panel (instead of using conditional statements or select case statements).
For example, whichever value the user selects from the combo box, I want to change the corresponding panel's background color to blue. So in the combo box's click event, I want to do something like this...
Dim ComboSelection As String = combobox1.SelectedValue Dim PanelName As String = "pnl_" & ComboSelection PanelName.BackColor = Color.Blue
Is it possible to do something like this? Again, I realize that I could easily use conditional statements to accomplish this task, but I am curious if it is possible to do it this way instead, as I would have many uses for this functionality.