I have a VB6 application that is accessing an sql server 2008 database using odbc. The application also accesses an ACCESS database. How can I create a temporary table in my ACCESS database using a table from the SQL database. I have tried the following:
SELECT GLTransaction.* INTO TempAPEntry0 In C:DOCUME~1DONNPS~1.000LOCALS~1TempCSAReport2564.MDB FROM GLTransaction WHERE GLTRSource = 641;
for the first time i am havin this kind of issue, i tried some google'in Private Sub frmMain_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
[Code]...
Trying to select an integer from an Access Database using an SQL statement in VB[code]...
View 5 RepliesUsing 'SELECT from' with value from a text box in vb.net with access database
View 11 Repliesi want to allow user to select or find access database file when the software is executed/opened for the first time. after user selects the file and as he clicks open the software shows the full path of the file and then stores it with the provider and datasource in a txt file for future use.
View 3 RepliesI am using VB 2008 Express to connect to an Access 2007 database. I have a combo box called SelectYearMonth that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum. I need to know how to do the same operation in VB 2008 Express using the SelectedIndexChanged event of the combo box.
When I made a report in Access using VBA I coded my calculation as:
Me.ExactReprintTextbox = DSum("Pages", "HBELP_FINAL_Q", "YEARMONTH = " & [SelectYearMonth] & " AND JOBTYPE = 'E'")
While this works great with Access VBA, this syntax does not work in VB 2008 Express. How do I code this in VB 2008 Express?
I need to calculate the sum of all "Pages" of a particular "JOBTYPE" in the Access database for the YEARMONTH selected in the combobox. I have a query in Access called "JobTypeExact_Query" that contains all the pages of that particular JOBTYPE that I need. What I need to do is limit the calculation results to the YEARMONTH selected in the combobox.
I am using VB 2008 Express to connect to an Access 2007 database. I have a combo box that is populated by the database. When I used the Access report VBA, I used the AfterUpdate() event to calculate a sum and place the results in a text box. I need to know how to do the same operation in VB 2008 Express using the SelectedIndexChanged event of the combo box.
The combo box is called "cboYearMonth" and is populated by my database, this is working correctly.
The text box that I want the calculated results to appear in is called "ExactPagesTextbox"
I have a query in Access called "JobTypeExact_Query" that contains all the pages that I need. What I need to do is calculate the total number of "Pages" limited to the YEARMONTH selected in the combo box. YEARMONTH is a value in every record in this query.
I don't know if this is the best way to do it or not but here goes.I have an access database and a datagridview and they link via a SELECT statement at runtime.I want to total one column named LNLMTS and display the result.I am looking at using SELECT Sum LNLMTS FROM tblProduction WHERE SO=@so AND DATE=@date
View 8 Repliesi have a problem to retreive whole rows of a datagridview and transfer to my new access database in vb environment anyone can give me advice or examples of how to do it ? for example my datagridview colums have JOB_NO, ERR_DESC , REMARK
now i would to post all row (not selected datagridrow) from this datagridview to my new database .. i search at google using row count may do the job but i still fail on ...
I am looking to select all the tables from a microsoft access database. I just need the SQL statement i think, i can connect to the database that is needed.
View 4 RepliesI have an access database that has columns where the data is a tickbox, i would like to select all the ticks from one row. Erm i'll try and be more descriptive: The database has the family of aircraft in the first column and then each subsequent column is to do with a calculation and i want to assign boolean variables the value of true if the tick box is checked and false if it isnt. How can i assign the values of the tick box to a variable?
I have this query:
CODE:
Where accessConn is the connection to the database and cmbFamily.Text is the row in the column family that i want to select all the KG_IFP values from.If you're not living on the edge, you're taking up too much room
I use this code to populate info from Access DB to txtBox[code]...
View 1 Repliesthis code links to the access database but but I just get only the first row in each combobox...
and I want also cboBox3 depend from cboBox2 depends from cboBox1, how can I do it?
Imports System.Data
Imports System.Data.OleDb
Public Class frm
Dim objConnection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = DBSOURCEDB.mdb;Jet OLEDB:Database Password=pass;")
[Code]...
I am trying to retrieve information from one row that has four columns(name,company,address,phone) so that once it is displayed in 4 different textboxes, I can transfer to a word document.
View 2 Repliesam developing a project and i am trying to use this code with my table which is under microsoft access 2010
View 3 Repliesim trying to save data (0 or 1) from vb2010 to SQL2008.
How can I do it inside vb2010? In class or form? which 1 is recommended?
The following is I write in form class:
If Trim(CChar(cElectrical)) = CheckState.Checked Then
loDataAdpr.InsertCommand.Parameters.Add("@scopee", OleDbType.Char).Value = "1"
Else
loDataAdpr.InsertCommand.Parameters.Add("@scopee", OleDbType.Char).Value = "0"
End If
I have a problem writing dates from VB2010 into SQL2008.
I am forming DateofBirth from Comboboxes using DateSerial, so far so good.
DateOfBirth=DateSerial(DobYear, DobMonth, DobDay)
MsgBox(DateofBirth) displays the date as DD/MM/YYYY, as I would expect in the UK.
But, SQL is expecting the date in MM/DD/YYYY format. When the DD is below 12 the variable writes in the database, albeit with DD and MM the wrong way round. As soon as DD goes above 12, the program halts with an SQLException, obviously because SQL knows that MM can't be higher than 12.
I am going round in circles trying to work out the method to ensure that the date variable in the SQL INSERT statement is in the right format.
I'm using VS2010 and SQLServer 2008. I'm trying to test for DBNull in datafields, but every formulation of a test I have imagined (or found) throws an error. Specifically,"The value for column 'ColumnName' in table 'TableName' is DBNull." (system.data.strongTypingException).Well, not too helpful. I know it's DBNull, and I want VB to recognize this.Here is what I've tried so far (all with the same result).
[code]...
I got a SQL statement where am selecting from an access database in vb but I get this error; "syntax error in query expression select sum(brought_qtty)" when I run my program. I imagine am doing the right thing but seems am not. How can I adjust this select? The code is below:
"select distinct(brought_price) as [Price], select sum(brought_qtty) as [Ordinary] from brought_coffee where " & _"coffee_grade=O, select sum(brought_qtty) as [Premium] from brought_coffee where" & _"coffee_grade=P, sum(brought_qtty) as [Total Qtty]" & _", sum(brought_paid) as [paid], " & _"sum(brought_bal) as [Balance]" & _"from brought_coffee, farmer where brought_date=#" & dtc.Text.Trim & "# and farmer_centre='" & cc.Text.Trim & _"' and farmer.farmer_num=brought_coffee.farmer_num"
I am currently creating an application to track timekeeping (a clock in/out system) and I am trying to work out the best way to do this.
I have a Main Form which contains buttons to ;
- Log in
- Out for Break
- In from Break
- Log out
When a user presses the "log in" button the logon form appears, the user then enters their username and password. What happens next is where I would like the help.
Process is as follows:Click Logon Enter Username/Password Check Logon Form for errors (eg no password etc) Check User is in Database (using SQL query) If user is in DB and username and pass are ok then refer back to the main form to perform Stored Procedure for what the user wants to do (eg logon or or out for break etc). Set label on main form to show user as logged on My question is should I be using a public variable and calling the main form again or in the user logon form having 4 options and using an IF ELSE to select the appropriate Stored Procedure?
I would like to pull a set of records in a SQL sproc by passing in a list of system.guid and also by passing in a list of integer keys.I can put the guids ihto a string, of course, but the question is - how do I quote the test values so they are recognized as UIDs by SQLIn essence I was to DECLARE @pklist AS VARCHAR(1000)-- This would look like "'45F4AE2A-D27C-D711-83FD-0008C7FA9683','EC824D02-D37C-D711-83FD-0008C7FA9683','BA8E4D02-D37C-D711-83FD-0008C7FA9683'" coming out of the execsql from vb .net - I think :-) but it seems it needs to look likeSET @pklist = '45F4AE2A-D27C-D711-83FD-0008C7FA9683,EC824D02-D37C-D711-83FD-0008C7FA9683,BA8E4D02-D37C-D711-83FD-0008C7FA9683'SELECT * from dbo.members WHERE members.cpk IN (@pklist)This only returns the record matching the first UID in the string. Is there something I can wrap a t-sql VARCHAR string with so each guid will be seen distinctly?In trying to do this with a list of integer keys, the problem is the value is seen as part of a string and is not cast to an integerIt would seem creating a table from a parsed version of the string passed in and then doing a JOIN would accomplish what I need as well, but struggling with the T-SQL syntax for that.
View 1 RepliesI'm looking for a walkthrough to help me design/develope a simple Blog that has the following parameters:Logon Screen Authentication Membership --> Email Lost Password.Simple Treeview like structure Topic-> Multiple Posts (2) levels deep only Historic calendar in right banner or someplace.Search Feature By (Topic, Username, Entry Date...etc)Does anybody know where I can find guidance otherwise left to my own devices this could take me a while, be nice to have at least a solid starting point in the correct direction.
View 2 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 RepliesI have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 Replieshave a table with following fields
Emp_id varchar(50)
Emp_Name varchar(50)
Emp_surname varchar(50)
[code].....
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
View 1 RepliesI am trying to import data from an access database to a access database that my project uses I am having problems with combo box fields in the database with the data. I want to import what is displayed instead of the numerical key value. Example: The combo box displays employee names but the value stored is the key value from the employee table so instead of importing John Doe it imports 2 is there a way to make the actual name instead of the number?
View 4 RepliesI have a table which contains a list of products for a company. They input data about how much stock they have and also the level at which they want to be reminded that they need to order new stock.
[Code]...
I want to list all the true results in a form which the user is then able to navigate through. What would be the best way to go about doing this?
I am making a window based application in vb.net. Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 1 RepliesI am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003.
The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery()
I am using the following code:
Dim conn1 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:Sample.mdb")
Dim conn2 As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data source=C:db2.mdb")
conn1.Open()
conn2.Open()
[Code]...
Question: What is it that I am not doing. I opened both connections, stated my two SQL statements, yet it is still not working. I really need to get this application working. Please Help.........