Is it possible to check the Application Type(Console Application, Windows Forms Application) at run-time.I have been looking for 2 days, most of the happy application info has been made available with my.application.info but where is the application type?
View 1 RepliesI am using attempting to create a connection to an Oracle database via entity framework in Visual Studio 2008. I am running 64 bit Vista Ultimate.At first, I had difficulty even making a connection to the db through Visual Studio, but eventually got things working by installing 10204_ vista_ w2k8_x64_production_db AND ODTwithODAC1110720, but only the minimal parts needed to interface via Visual Studio.I am completely new to this setup, so it's likely I have already made a mistake, but installing both packages is the only way I could create a connection via Visual Studio.I made the connection, and used the wizard to create a . edmx file. The model and associations were created perfectly, and I thought things were going to work well. I used the default name "Entities" as the reference name.[code]How is it that I can connect to the oracle db at every point except when I'm running the application?
View 2 RepliesWe are working on an ASP.Net/VB.Net application using Enterprise Library for our data access (DAAB).
We are trying to store DateTime values in an Oracle Date field. However, the precision is being lost. Currently only the year, month, and date are being stored. We need better precision than this.
Oracle Dates are supposed to "includes not just the month, day, and year, but also
the hour, minute, and second. "
This is probably a pretty novice design question. I'm trying to work my way through a number of requirements and give the users the experience they're looking for.I've written a tool that does big calcluation-type things. It currently consists of a class library and command line tool (separate .NET projects.) We're using an Access database format as the file type because it can keep all the various tables together in one file. A few other items about the application: There are not many users. There are no concerns with scalability. There are not great concerns with updates. Desktop is desired. Not web.Using VB and .NET 3.5 SP1
I now need to develop a GUI front end that will allow typical File/Open and File/Save type operations.Users expect that they can open a file, edit it some, then either choose to save it or close it unsaved without any changes being written back to the file. Saving it would obviously save all changes affecting all tables back to the file.
Does it then make sense to use a temp file for something like a proxy then? To, when a user "opens" a file, copy the source Access file to a local temp file and then use that for the editing session? Then, if the user "saves", copy the local temp file back to the source path?
Update: [tagged with ms-access tag too] Also, I omitted the fact that users would expect typical File / Save As functionality too. I think the design I've put in question in this post is what is traditionally called the Proxy design pattern. Has anyone tried this (successfully!) with Access database files before? Words of caution or advice?
I have a MDI Parent form.
In that form, I show people another form which has a richtextbox.
All I need to know is how would I allow people to print the text in richtextbox and also how to save the text in the richtextbox as a txt file.
I dont get this. I use code from one project that works and paste into anther and now its full of errors.
I have no clue how to solve this (See attached image).All of the errors have to do with Excel and Outlook applications.The info for "Imports" section is the same as my other project and all the "Dims" are the same as well. (These are two separate projects).Basically, I copied a form from one app and made a stand alone app for that form.
I am trying to open access report in visual basic. I am using visual basic 2008 express and access 2010 (beta) version. I have following reference added.
1. Microsoft Access 14.0 Object Library
2. Microsoft.Office.Core
3. ADODB
Here is my code
Dim olapp As access.application
olapp = new access.application
I am getting error "Type Access.application not defined"
I am getting the following error in my application: Quote:
System.IO.IOException was unhandled Message=The process cannot access the file 'C:UsersSimonDocuments3Categories.wsp' because it is being used by another process.I understand what it means, but am not sure why it is happening. It happens after I open a file and try to save it to the same name. Here is my
[code]...
I have a vb.net 2005 application that connects to an access database. I use Access Database Engine 2007 to connect to to this database.
Everything worked fine until i install MS Office 2010. After this, the application started to crash, returning the error 'application has stopped working'.
I've a Windows Seven Enterprise SP1 32bits.
When i debug the application, visual studio also crashes. I get the following error, closing an OleDbConnection: 'vshost.exe stopped working'.
I decided to run some tests. I installed my application on 2 virtual machines: a windows xp sp3 and a windows 7. When i installed ACE 2007 everything worked fine, but when i installed ACE 2010, thats when the problems began. This behavior ocurred on both machines.
I am writing a program for a class and it needs to read/write to an Access 2007 database. Right now I am referring to it's absolute path when I use it in connection strings, something like:
Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersMeDocumentsVisual StudioProjectsProject1Database.accdb")
This is going to be a problem when I turn it in obviously, because the professor isn't going to have the same path. So I want to somehow include it into my project and then refer to it with a relative path or something so that it will work on his machine. When I imported it through the Data Sources it had an option at the end to copy the database into the project which I agreed to. It put the Database where all of the source files are on my computer, so I tried using Application.StartupPath(
I'm having a problem with converting from one source type to a destination type. I have a form with 2 buttons (button 2 uses the OpenFileDialog to have the user open an excel file set to NewFile),(button 1 takes the contents from specific cells in NewFile and arranges them how I need into oXLApp1).
The error I get is "Unable to cast object of type 'System.IO.FileStream' to type 'Excel.Application'." in line 14 of the code below.
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]....
If I create a windows app which I link to an MS Access databse file that already exists..will I need to have MS Office installed on every computer at which I want to use the app? If not then how do I go about making a standalone windows app that will store information in a database of some form or another ?
View 1 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 RepliesWhen I close my form without saving I want to check if the data on my form has changed since the last time I saved the data.This peace of code, which I included at the bottom always worked fine.Except when I compade a DateTimePicker with a null value in the db.Than I get the error "Conversion from type 'DBNull' to type 'Date' is not valid."Probably on this peace of
Me.dtpVrijeDatum01.Value.Date <> CDate(reader("VrijDatumVeld01")).Date Or
Me.dtpVrijeDatum02.Value.Date <> CDate(reader("VrijDatumVeld02")).Date Or
Me.dtpVrijeDatum03.Value.Date <> CDate(reader("VrijDatumVeld03")).Date Or
Me.dtpVrijeDatum04.Value.Date <> CDate(reader("VrijDatumVeld04")).Date Or
Me.dtpVrijeDatum05.Value.Date <> CDate(reader("VrijDatumVeld05")).Date Or
The total code to check the changes is:
Private Sub CheckForChanges()
LeesCheckboxWaarde(Me.chkFacAdrIsBezAdr, intCheckFacAdresIsBez)
LeesCheckboxWaarde(Me.chkPosAdrIsBezAdr, intCheckPosAdresIsBez)
[code]....
I get the error: Conversion from type 'FileInfo' to type 'String' is not valid. This happens in between try and end try
Private Sub CopyNotes()
Dim NotesBase As String
Dim NotesTgt As String
[Code].....
I'm storing dates intoa table like:vb.net "INSERT INTO myTable (datum) VALUES ('" & Convert.ToDateTime(dgvrow.Cells(0).Value).ToString("yyyy/MM/dd hh:mm:ss") & "'" & ")", conn) This works perfectly. After storing the dates I need to load /show them into a MonthCalendar. This is where the error occurs.
[Code]...
I have the following code to use Words spellcheck feature on a RTB. Once you pick the correct word in the spellcheck box and press change I get the error on th efollwoing line
strResult = Left(objDoc.Content, Len(objDoc.Content) - 1)
I tried to use CType() but still complains.
If (Len(t.Text) = 0) Then
'nahhhhhhhhhhh
Else
[Code]....
I'v designed a ms access database table with one field having Datetime datatype. I can Insert data into it from vb.net front end by trns_dt DateTime.Now.DateBut when I fetch records from the tableand assign the dataset datasource as da, it shows datatype mismatch error.
daleDbDataAdapter("SelectDaily_Transactiondtp_from_dt.value dtp_To.value con)
dsDataSet
[code].....
I'm using VS 2010, and I did a project using VB and a database in Access. The problem is that when I try to put that "application" on other computers, sometimes, is not working. I thought it can be because on these computers they don't have access, but on one computer, is running another app which is using Access and there is no Access installed. How can I check if my application requires Access to be installed or not?
Here is a example of how I did the connection:
Public AccessOLEDBConnString= "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & myfullpath & ";Jet OLEDB:Database Password=password"
Function getConnection() As OleDb.OleDbConnection
[CODE]...
And when I want to have access at the data I'm doing like this:
dim conn as Oledb.OledbConnection
dim sql as string
dim ds as Dataset
[CODE]...
My project worked a first and now its giving me a problem.The error
Quote:
Unable to cast object of type 'System.Windows.Forms.MouseEventArgs' to type 'System.ComponentModel.RunWorkerCompletedEventArgs'.
I recently downloaded VB 2010 Express so i am quite new to the language, but i have worked with dark basic, which seems to b very similar.Anyway, my problem is that i cannot seem to correctly set out my array of a custom type/class. i am trying to create two arrays, one of available entities and another of selected entities of which the user selects the entities to be dealt with in irrelevant ways. i have creates a button (called test) which adds some entities to the available list and all the entities come back the same value but they shouldnt be as you'll c in the code. i have run the step into command a found that "available.item(#).Name = " will change all of the entity's names.As of current i am working with lists as the array kept asking for a 'new' statement but i couldnt figure out where to put it.[code]
View 7 RepliesMy boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form. How can I achieve this?
View 2 RepliesMy boss gave me an MS Access application that was developed by our former colleague. He wants me to convert that application to VB.Net Windows form application. I went through the MS Access Application. It contains tables, queries, forms, reports and macros. I could not find the programming (Where is the code written in MS Access?). My boss wants the windows application to be same as the MS Access Application (both in design and logic). I don't how will i develop the windows form.
View 4 RepliesSo I have a WCF Service that has service methods. One of the methods needs to be called from the application that is hosting the service. I am using a ServiceHost to host it. [code]...
View 1 RepliesI'm wondering if this is possible. In my Test function below I want to
Check if T is of type BaseClass; throw an error if it's not.
Get the value of SomeText property of BaseClass.
Class BaseClass
[code].....
Is it possible to access Application Properties of my applicaiton in run time ? Please refer the below attached image (I want to access the Title and Category properties in my application)
View 5 RepliesI've just finished installing VS2010 on my computer. I have a project I built in 2003 that I'm trying to open in 2010. It went through the conversion process and generated this error: System.SystemException - The type library importer encountered an error during type verification. Try importing without class members. : System.MissingMethodException - Method not found: 'Void
[Code]...
How can I get information what data type a certain column is. (Integer, string, memo,...)
View 1 RepliesIs there a way for a property to access its own name and type at runtime using reflection? I want to access this info without hard coding the name or index of the property in the class.
Simple Example Code:
Private ReadOnly Property MyProperyName() As String
Get
Console.WriteLine((Get Current Property Info).Type.ToString)
Console.WriteLine((Get Current Property Info).Name)
[code]....
I want to import an xls file to access by using the following code. My xls file has some numeric and some text cells when data be imported to the access table, the text cells won't be imported correctly.[code]
View 1 Replies