Access A String From Another Form
Oct 22, 2010Is 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.
View 3 Replies
ADVERTISEMENT
Access String From Another Form?
Nov 12, 2008I thought I knew the answer to this but it doesn't seem to be working in my app.In form1 I've declared a string. Example:
Code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
Declare Operator As String And Insert Into Access Database Form
Feb 10, 2011i 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 &
"', '"
[Code]....
Check If String, Which Receive Via A Serial Port Matches To A String In A Database (access)?
Jun 22, 2010I 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
View 1 RepliesVB - Access - Registration Form That Connects To Access Database And Inserts Values In Table
Mar 14, 2011I'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.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
Insert Data From An Access Unbounds Form To An Access Table
Jun 9, 2009I'm trying to insert data from an Access unbounds form to an Access Table using the follwoing code:
View 2 Replies.net With Access - Login Form Using Access Database?
Feb 9, 2010[code]
Imports System.Data.OleDb
Imports System.Data.SqlClient
Imports System.Configuration
[code]....
I don't know if these can connect with Access, anyway, I got ERROR on the com.Connection.Open()?
Search For A String In A Textbox On Form And If String Found?
Mar 20, 2010how can I search a textbox for a string within a string and if certain word (string) found enable a timer?
View 3 RepliesAccess A Component In Form From A Thread Created In A Different Form?
Jun 18, 2011I 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?
View 6 RepliesC# - Access A Value That Is Entered Into A Child Form From A Parent Form?
Jan 10, 2011Communication 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.
View 1 RepliesDisplaying Contents Of Ms Access Database Form On A Form Using .net?
Sep 16, 2011How to display contents of ms access database form on a form using vb .net...in visual studio
View 7 RepliesThreading - Access A Value Of A Control Within A Form Outside Of The Form Class
Jun 3, 2009What 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.
[Code]...
Have A Modal Form But Be Able To Access Another Already Open Form
Jul 20, 2010I 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.
View 10 Replies[2008] VB Form Based On Access Form?
Feb 28, 2009below 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.
View 7 RepliesVS 2005 Moving Rich Text Box String From Form To Form?
Apr 15, 2009simple 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
Access A String (index) In .Net 1.1?
Dec 1, 2009I have converted this existing C# .NET 2.0 code (which appears to take in a string with any characters and return only the numbers in that string):
private static string StripMIN(string min)
{
string result = string.Empty;
int digit = 0;
[code]....
I am getting an error message on line 6 of the VB.Net code at min(i). The error message reads:
"Expression is not an array or a method, and cannot have an argument list"
Connection String For Access?
Dec 9, 2009i 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
View 9 RepliesGet A String From An Access Database?
Jun 14, 2011I'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)
[code].....
Getting A String From A Child Form To A Parent Form
Feb 27, 2009I 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:
[Code]...
.net Connection String For Ms Access Database?
Oct 20, 2011What is the connection string for connecting MS Access 2010 (.accdb) database in VB.net.
View 3 RepliesAccess A Class Property By String Value?
Nov 16, 2010I 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)
{
[code]....
Access A Control Using Built Up String?
Apr 2, 2009Is it possble in VB.Net to accress a control or object using a built up string?[code]...
View 2 RepliesC# - Connection String For Ms Access Database?
Sep 3, 2009My 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
Connection String To Access Database
Sep 10, 2011My 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).
View 1 RepliesFormat Date String In Access?
Oct 17, 2011I have a where clause in an old dusty vb.net application [code]...
View 1 RepliesHow To Connect String To An Access Database
Jun 25, 2010I 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...]
View 3 RepliesSplit String To Access Integer Within It?
Feb 19, 2012I 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?
View 5 RepliesVB 2005 Access Connection String
May 12, 2011I used the wizard in VB 2005 to add my database. Under the "Applications Settings" area in VB my string is currently set to:
[Code]...
VS 2005 Connection String For Access
Sep 30, 2009what is the connection string for Access for connecting Access Database with ADO.NET (For win app).
View 1 RepliesVS 2010 Access A Control From The Value Of A String?
May 13, 2012Lets 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.