function GetRA(str)
i = -5
Set fso = CreateObject("Scripting.FileSystemObject")
Set fil = fso.OpenTextFile(server.mappath("ra/xxxx.inc"))
Do While fil.AtEndOfStream <> True
[code]....
In my code I have an Oracle command that contains an INSERT statement. Here's a snippet from my SQL:
"'," & "To_Date('" & Format$(dtDateTime_Stamp, "MM/dd/yyyy hh:mm") & _
The value of strDateTime_Stamp is #1/19/2011 9:42:22 AM# I'm getting an error ( "ORA-01830: date format picture ends before converting entire input string") because I don't know how to correctly assign the AM/PM tag on the end -- you'll notice it just says "MM/dd/yyyy hh:mm" in my code. I've tried a bunch of different things but nothing works. I also find it odd that if I change the "MM/dd/yyyy hh:mm" to "mm/dd/yyyy hh:mm" (little m for month) it gives me a 42 for the month value, not a 1. The capital M's fix that but I'm curious to know why.how to I get it to show the AMPM on the end?
I have built an Access 2007 database with some data stored in it. I have managed to export data using VB2008 from that database to Excel 2007 and have it automatically draw charts based on this data and a query in the Visual Basic Code. One of the results looks like this:
View 3 RepliesConnecting VB with Excel 2007 & Access 2007?
View 14 RepliesI have 2 access databases in access 2007 I want to be able to up date one from the other.
View 3 RepliesI have to make a project for my IT Class which includes a login form and other stuff. I used a MS Access database. I almost finished it cuz the deadline is tomorrow but i have a single problem. I dunno how to add items to my DB. I never worked it DB btw . I looked for some tuts over the internet but i can't understand.[code]...
View 2 RepliesCan I use ADO.NET within Access 2007. If I can, which library reference would I include?
View 6 RepliesI am download a XML file comprising thousands of records. I want that XML file to convert it to MS-Access 2007 Database using ASP.Net (VB) and run further quries on it. Its worth mentioning that the conversion should be done in bulk because its very heavy file and take longer to insert one by one record. I am tired of googling code to fulfill my requirements. I am also new to ASP.Net.
[Code]...
Here i like to asking about how to making connection between vb.net 2008 and ms access 2007 in coding, such as making login part from vb.net, my coding not success, is it need to do connection from ODBC?
View 2 RepliesI have searched and cannot find out why my code will not update the database.The program stops at the mDA.Update(mDS, "temp_data") line with the following error:
System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2147217904
Message=No value given for one or more required parameters.
[code].....
How can I add an Access 2007 DB to my project? the file extension is not supported.
View 2 RepliesI have an Access 2007 database connected to SQL Server 2005. I want to use VB to create an application that will retrieve and manipulate data in our SQL database. I'm familiar with VB and I'm familiar with Access. What I don't know is how to get started creating forms in VB that's accessible through Access. Are there any books out there that will help me get started?
View 3 RepliesI have created a PowerPoint addin using the steps from this article: Using RibbonX from Visual Basic
The plugin works fine when I start the project using F5 in Visual Studio 2005. But if I try to use the installer created by the setup project that is automatically added to the solution, the plug-in won't show when I run powerpnt.exe
Is there something I missed? Do I need to make some modifications to the installer?
this is my vs:but i want to get the office 2003 and 2007 add-ins in it.i am using the professional edition of vs do i need to install some components?
View 5 Repliesmycn.ConnectionString = "provider=microsoft.jet.oledb.4.0;Data source=C:UsersAdminDesktopMyDB.accdb"
i m using this to connect to an ms access DB but it throws an exception can you help me to connect to an MS Access 2007 Database ?
I have an Excel file endowed with a macro written under Office-2007.This file can be opened by Excel-2003, but the macro can't run because 2007-objects can't be recognized.My question is: does it exist a library or some trick to allow the macro running under Office-2003?
View 1 RepliesI want to connect to ms project from vb.net and then run an ms project macro.
View 2 RepliesI have a vb 2005 app with a Access 2003 backend. I need to upgrade the the BE to 2007 file format. Changing the connection string in settings produces a "Unrecognized database format" error message. I installed Access 2007 runtime but still get the same message.
View 1 RepliesI am having issues with an update query.
i normally use SQL 2005 but for this project i am using an access 2007 database
[code]...
im making a log in for my program , using vb.net 2008 and ms access 2007.the log in table in the database has username , password , access level , and userID in it the login works but i tried adding an acces level feature to it (Admin/User access level , takes you to diferent pages)and then i got errors obviously im new to this this is the code for the login button , 2 text boxes txt_UserName and txt_Password
[Code]...
I have a access database setup which i am connecting to via ODBC, the access files already has all the required queries built and i would simple like to call them from within my application.I am using Visual Basic .NET and this is what i have tried so far..
[Code]...
I have a project that I have to finish. I have an access file with relationship to 4 tables. primary key is the birthday. It is like a address book. I have added the data set in visual basic. How can add multiple phone number for one person. will the relationship work or I have change something in vb to make it work.
View 8 RepliesI am creating a new spreadsheet from existin data. The new spreadsheet size changes based on the input data. I am using lastrow, and lastcolumn to format new valid cell raqnge. I also need to enter a predefined statement in column A of the the last row.
View 2 RepliesIs there a way, in Microsoft Word 2007, to set up a style that will highlight VB.NET keywords, just like the Visual Studio IDE does?
View 4 RepliesI am using VB 2008, then I noticed that with the Provider.Oledb.12.ACE = database.accdb whatever connection string uses the bin/debug/database.accdb file when I connect my program with a database. Suddenly, a database with the same name appeared on the lets say "WindowsApplication1" folder. Then whenever I try to debug/run, it throws an error saying that it was unable to copy the database from the "WindowsApplication1" folder to the debug folder even though VB 2008 reads through the database from the bin/debug folder. As a result, after I input values when I debug, it resets because VB 2008 copies the database from the "WindowsApplication1" folder.
View 2 RepliesI am trying to update a element from login table but it not showing any error massageor any thing execution is error free but finally whenever i check the database its notupdated.. i'm using access2007 database with vb 2008
dbprovider = "Provider=Microsoft.ACE.OLEDB.12.0;"
dbsource = "Data Source=|DataDirectory|Ex_m.accdb;" & "Persist Security Info=True;" & "Jet OLEDB:Database Password=123456"
[code].....
I recently upgraded to Excel 2010 from 2007. My ActiveX files will not work. I used to use:
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet
That does not work and most of the choices do not contain: Application, Workbook and Worksheet.
It seems that i cant update my table in access 2007. Here is my code.
Try con = new oledb.oledbConnection("Provider = Microsof.ACE.OLEDB.12.0"; data source =
|DAtaDirectory|Attendance.accdb; Persist Security Info = False;")
con.Open()
[CODE]...
--I dont received an error message when i run the codes i even dont receive an exception message. but when i check my database the record was not added.
Add new row to Access 2007 DB.I am trying to add a new row to a access db. I receive the error update requires a valid insertcommand.when passed datarow collection with new rows when Cmd.update(my_table).[code]
View 1 RepliesI wrote a program that connected to a Microsoft Access 2000/2003 mdb file and accesses the data. It works fine, but I'm wondering if there is a way to connect to Access 2007? If I change my connection string, will my program work with access 2007 or is it more complicated then that? And if it will work, can someone provide an example of an Access 2007 database?
View 2 Replies