Nope, that download did not help. Anyone got any suggestions?
Thanks,
Jason
Shataken
Last Activity: Mar 13 '08, 04:03 PM
Joined: Jun 14 '07
Location:
-
I will give that a try, but it says it is for non office software that want to read access 2007 files. The database I am trying to read is version 2003, but the computer that my client is using has office 2007 installed and has never had office 2003 installed.
Thanks,
JasonLeave a comment:
-
Jet 4.0 problem with office 2007
I have an application that I wrote and it works fine on machines that have or have had office 2003 installed. But on machines that have never had office 2003 installed and have office 2007 installed, I get the error : "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
"
The access database is version 2003 and the connection string looks like this:
"Provider=Micro soft.Jet.OLEDB. 4.0;Data... -
vb.net autocomplete wildcards?
I have a combo box on a binding control. It is bound to a name column in my dataset. It works like it should, but I need the autocomplet to be able to find names by either first name or last name. For example, if I have two names in the name column,
John Smith and
Bob Jones
My user then types in "Jo", I need the dropdown to have both John Smith and Bob Jones listed. Because J and O are the first characters... -
error when clicking setup.exe after a build
I have been developing a piece of software for a while now, and have not had any problems with the setup.exe that is generated when I deploy my app.
Today, I deployed it and wanted to test the setup before I sent it to my client to install. I click it and about 1 second later I get a message box with a red X icon and an OK button...no message. Behind that is a messagebox that has the icon of a box with a cd in front of it..also... -
Updating Access table from datagridview
I have an application that allows the user to select a table name from a combobox. Once the table is selected it fills in a DataGridView with the info from that table. I need to let them make any changes then update the info back into access. Below is my code to get the data into the DGV:
...Code:Private Function LoadTableData() As Boolean Try Dim cmd As New OleDb.OleDbCommand("SELECT * FROM -
That solved it. Thanks, I didn't know about that command. Will come in handy in the future.Leave a comment:
-
invalid use of null
I have the following line of code that is giving me "Invalid use of null" when it executes.
TotUsage = DSum("[WAT12]", "[T_USAGE]", "[ACCNT] = " & ACCNT & " AND not isnull([MeterExt]) and [Active] = 'Y' and [LoadRoute] = 'Y'")
WAT12 has numeric data in it. The problem has to be with isnull([MeterExt]) becasue it DOES contain a null, but I need to make sure I... -
Got another one. It has to be something to do with ANSII standards, but I hve tried both % and * in the LIKE statement.
cmbLoadNum.text = "BRP572-A"
This is how the SQL command looks in my code :
strSQL = "INSERT INTO Statements ( MachineID, AssetNum, SerialNum, ModelNum, PONumber, MachineSalesOrd erNum, OutgoingLoadNum , ShippingMachNum , ShipDate, InvoicedDate, InvoiceTxnID, StatementNum,...Leave a comment:
-
It turned out to be the password field. I changed the name to UserPassword and it worked. Still don't know why it woeks in access, but not when sent as a SQL string from vb.net.Leave a comment:
-
insert into error
I have the following code in vb.net aplication. It is simply trying to save user info into a table :
strSQL = "insert into Users (UserName,Passw ord,SecurityLev el,Active) Values ('jasontest','s erewrwf',2,Yes) "
rs = cn.Execute(strS QL)
I get an error saying that I have a syntax error when I run it from vb.net application, but it works fine if I run it in access???
Any suggestions?
... -
SQL nightmare
I am trying to convert an application writtten in Access to vb.net. Alot of the SQL statements are long. Can someone take a look at the following Access SQL statemnt and tell me what SQL statement would look like? This statement works in Access, but the INSERT INTO and FROM tables are the same???
BTW,, A load number looks like this "########-A" or "########-B" etc.
[CODE=sql]
INSERT INTO Statements... -
That was it. Replacing the % with * solved it...man, that caused me about 5 handfulls of hair....Leave a comment:
-
login buttons do not work when xp themes are enabled
I have developed an app on a computer that is set to windows classic as it's theme (XP pro machine). When I publish the app it works fine on machines with the theme set to windows classic, but if they have it set to XP default the login/cancel buttons do not work on the MS created login form. I can fix it by disabeling the "Allow xp themes" checkbox on theproject form. The buttons will show the orange border when the mouse hovers over... -
SQL Join problems
I have two tables that I need data from.
The table1 has a field that has a number in it (InComment is the field name). The number in the InComment field is the key in table2. I need to select all the data in table1, then pull in the field in the other table that corresponds to the value in the comment field in table1.
For example.
Table1(Machines ) InComment value = 34
Table2(Comments ) CommentID =...
No activity results to display
Leave a comment: