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 Replies
Is it possible to import a query from Access 2003 into Visual studio 2010 (language used vb.net).
I created the queries originally for a project, then when I imported the database to visual studio I can only use the tables that i created. I have started looking at the coding to re-do these, but if I can import them would it be quicker?
i have create a software for my college which is document management. well am doing good so far up to now where i need to upgrade my database what i mean ?
in case i need to make any changes to my database i don't want to enter the database and create new table or add new fields to existing table to my current database,i would like to do that throught visual studio 2010 programaticaly. something like an additional application where i will choose my database path and the application will upgrade the database with new tables or new fields .
i would like also to ask, in order to create database,or if you already have the database and you like to just open the connection to it programaticaly and add new field ,or relate some table ,you have to work with different librarys? Like ADOX,DAO etc ? and other.?
I'm trying to create a database of all the Magic The Gathering cards I have in inventory and I'd like to have a picture preview of the card in my program. In access I've created a table and for each row I've attached an image of the card. Now I can't get the image to display in Visual Studio. The picture type is the correct format and databindings are all correct. I just can't seem to get the picture to preview as I go down the list in my datagrid.So far I haven't written any code. I've built the application in design view just dragging items from my data sources window.
View 3 RepliesAt present I have wrote an application (in-house CRM, vb .net 2010) which allows me to send emails under the selected customer & I categorised these emails.As these are categorised I can return data to display email history in my program by using search criteria:
Dim oMail As Outlook.MAPIFolder = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderSentMail)
Dim sSearch As String
sSearch = "[Categories] = '" + "[" + tAccount.Text.Trim + "]" + "(" + tShipTo.Text.Trim + ")'"
Dim oItems As Outlook.Items = oMail.Items.Restrict(sSearch)
However the limitation to the above is it only looks at sent items & no other folder.My ideal solution would be to display all email correspondence for a certain contact.
I converted my project Visual studio 2003 to 2008. and when i run may project pressing F5 this error comes
View 5 RepliesI have created some tables in 2007 and would like to use visual basic to create an interface for a database. I would like to add, edit, and view my records and maybe create reports.
Does anyone know of any online tutorials which would help me to do this or could anyone offer any guidance.
I look forward to any replies.
Public Class Form1
Dim db As New ADODB.Connection
Dim cmdcommand As New ADODB.Command
[code].....
I have a table called MEMBER with fields for mem_id, mem_name, mem_addr, mem_city,mem_state, mem_zip and another table called STATE with state_id, state_addr, state_name in Access 2007.On the Visual Studio 2008 form, there is a combo box for the state. The goal here is to display the state abbreviations, but use the state_id value for the mem_state (there is a foreign key between those two fields).The mem_state is defined as number, the state_id is autonumber. Under the mem_state definition in Access, I used the lookup wizard (on the database that is in the bin/debug folder) to set the following properties:
Display Control - combo box,
Row Source Type - Table/Query,
Row Source - SELECT [State].[state_id], [State].[state_abbr] FROM State ORDER BY
[code].....
I have a class project that supplied me with an Access 2007 DB. When in VB and go through the steps for creating a data source. When the Wizard comes up I click on Database, Next, New Connection, Data Source is Microsoft Access Dagabase File (OLE DB), Browse to Database File Name, Test Connection is successful, click on OK, then Next. A MSVS box appears "The connection selected uses a local data file that is not in the current project. "Would you lie to copy the file to your project and modify the connection?"I am supposed to click NO. When I do I get this "Wizard Form" "An unexpected error has occurred. Error Message: Cound not load type." I need to be able to go to the next part of the Configuration Wizard that says "Choose Your Database Objects" I evensaved the file as Access 2003, and it will not work.
View 4 RepliesI can launch a program from inside my program and embedded it in my program using a Visual Basic Control such as a Panel. That works well if you launch say NotePad or Calculator.However, If I want to launch a program that uses MULTIPLE forms... all that gets embedded is the Main Form... All the other forms are floating on the desktop nonconstrained... So If I minimize my program the other forms are still shown.So what I am attempting to do is to get ALL the Forms from the external program embedded into their own objects on my form.Have pieced together a program from a couple of program samples that I have seen across the internet... Here's the code so far:[code]The Main form for the program that I am attempting to embed is 384 x 347 in size.Panel1 is a Panel Control on my Main Form."MyProgram.exe" is a program that I have written myself.I have looked at Spy++ for Visual Studio 2003 and it is able to identify ALL the forms from my program.My question is how do I embed ALL the forms from my external program in the NEW Program?
View 8 RepliesWhat I have is on my form there are several text boxes. These text boxes are for user input and attached to each text box is a Private Sub txtBox1_KeyPress function. In that function I have some validation code to check that the user is inputing only what I want them to. And if it doesnt it will pop up a message box telling them so, then it is supposed to clear the text box so the user can try again. But no matter what I try, the text box does not clear it still keeps the last character typed (the invalid one).
Here is the code for one of the text boxes.
Private Sub txtLanIp_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtLanIp.KeyPress
Dim strEmpty As String = ""
If Char.IsDigit(e.KeyChar) = True Or Char.IsPunctuation(e.KeyChar) = True Or Char.IsControl(e.KeyChar) = True Then
'do nothing
[code]....
The commented methods at the bottom are some of the other things ive tried to make this work. The txtLanIp.text.clear() is what ive tried from the beginning. I have also tried setting the text to "", I even created an empty string and set the .Text value to it but no matter what it wont remove that character. I have also tried various trim(), len(), Select() functions, most either give me an 'index out of range error', a 'length cannot be less than zero' error or a general ExceptionOutOfBounds error. I am just tearing my hair out as to why the simple way doesnt work, there is no logical reason why and it gives no error it just doesn't clear the box.
I have also tried moving the validation to a _LostFocus but e.KeyChar isnt a valid method or property for that declaration, which doesn't surprise me but I wanted to try everything.I dont see how it would matter in this case but I am running Windows XP Pro SP3, though I also see the same behavior in Windows 7 64 bit ultimate sp1 and windows 7 64 bit pro.
In my VS2010 VB project I have a lot of external references to DLLs, to the point that organization has become a major headache and I'm wondering if I am going about it the wrong way. My assembly references include common redistributables (SQL Server Compact 3.5 SP1, ReportViewer 2010 SP1, DataVisualization, as well as some useful 3rd party dlls from CodeProject and CodePlex.
Currently, I am copying each DLL into a 1st level folder (/dll_lib) under my named project folder (under the solution folder), and adding the reference from that path. However, I see that Visual Studio copies the DLLs to various other locations (/bin/debug or /bin/release) in my project when I build the project or solution, and some of the 3rd party DLLs come with instructions to copy them manually to /bin.
What is the "best practice" for where to put the DLLs? Can I just put all of them under /bin and let the build event copy to /bin/debug or /bin/release as required? Should I try to force a single reference path for the dlls in the project output?
I am working on a project which was made using VB6, and my client wants to change it in VB.NET
i have to configure this projetct on windows vista ultimate..coz i cant go on with Win XP
can some one help me...
I am using visual studio 2010, in that vb.net with database as SQL. I wants to display files for the user, for that i am using webbrowser. Webbrowser display PDF file's as required but office documents of version 2007 open's separately instead of open in webbrowser. so, my question is how to open office document in webbrowser ?
View 3 RepliesI have embedded the WMP control in my Visual Studio 2010 app which works on windows 7 (Framework 4.0), but installing the app on winXP, I get the following error:
System.IO.FileNotFoundException: Could not load file or assembly 'Interop.WMPLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
File name: 'Interop.WMPLib, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'
[code]....
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].
I guess this is a reference issue, but I have added references to WMP libraries (axinterop.wmplib.dll and interop.wmplib.dll). The WMP works on the XP machine, but not when called from my application.I have searched the web now for 5 days and changed references, and reinstalled the media player on the XP machine, but nothing works.
I have recently built a website in visual studio 2008.. Now i want to convert it into a desktop application.
View 1 RepliesI am using VB 2008 & Access 2007 for windows forms application having typed datasets while creating connection to DB vb asks to store connection string so i did it now that i want to know where is the actual path of file where these connection strings are stored. b'cas after runnig a macro in Access Database i lost all these connections from Data Source Configuration Wizard Combo Box & also i am anable to create a new connection to Databases.I have tried to reinstall the entire Visual Studio couple of times .
View 17 RepliesI have multiple copies of Access dbs running varous projects on diverse workstation all over the country. Some new additions to the team have only Access 2007. Is there a way that I can use both versions without having to re-do any VBA, macros, scripts, etc.?
View 2 RepliesI am working in Windows 7 Home Premium using MS-Visual Basic 2010 Express. I am having difficulty connecting to an Access 2007 database using ADO. When I try to connect to the database I get the following error:
Error Code: -2147467259
Exception: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
Source: Microsoft OLE DB Provider for ODBC Drivers
I looked at...
[URL]
There were several reference to compiling the program using x86.
Go to Project menu -> Properties -> Compile tab -> Select "Advanced Compile Options" -> Select "x86" instead of "AnyCPU"
I followed the path and there was not any option to select x86 in VB 2010 Express.
My application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
[code].....
Am very new to programing and have never done it before.I am working on very small things at the moment like showing the time and date very basic stuff. i have some books and video's so am going over but i just need abit of code for now -
How can i display what version of windows i am running? for example.i have a button if i click it the label on my form will display the version of windows.
I'm developing a app in VB 2005 to connect to a Access 2003/2007 DB, I manage to connect to it but I can't write to it, do I have to enable something to make it work?
View 2 RepliesWhen trying to run the exe file error codes appear and back end data is missing. I loaded the 2007 runtime application.
View 4 RepliesMy application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()
When I load it onto a WinVista machine running Office 2007, I get the following error the microsoft.jet.oledb.4.0 provider is not registered I was doing a little research and I guess 2007 changed a few things? Introduced something called ACE? I tried using "Provider=Microsoft.ACE.OLEDB.12.0", etc but I get a similar error to the above...
I am trying to connect to an Access DB file when I do a drag and drop from the dataset to the form i get the following error [code]
View 1 RepliesI have created a form that does some access sql statements. Using the below code, I can run 9 different SQL statements that purge and load tables. For some reason 1 statement does not work. I do not receive any error, it just doenst load the table.
[Code]...
Is it easier to print a VB.net windows form in Visual Studio 2010?
I have been struggling with this - the PrintForm utility in the Powerpack only prints the displayed portion of the current form.
I spent a lot of time creating a process which loops through each control on my form, converts to a bitmap, and drops it on the print document, only to finally discover that the RichTextBox control (which I used extensively) does not include a functional DrawToBitmap method.
I have already researched various ways of managing this, but if VS2010 will do it without jumping through the hoops then I'll spring for it like the sucker I am.
I can do this in Access and VB6, I believe, so I don't think this is an unreasonable expectation.
i have installed visual studio 2010 32 bit on my new computer which have windows 7 64 bit. Everything seems ok. But now I try to learn how to draw some spheres with movement. I have tried to install openGL2 but it does not work or said that it does not fit with 64 bit, or it works only with VC.
Could any one, please, give me a short introduction to install and use open GL in vb.net 2010 installed on windows 7 64 bits ?
I need to convert the following code to work in a visual studio 2008 windows form application, the moment ObjectQuery, ManagementObjectSearcher, ManagementObject and ManagementObjectCollection are not valid.
im objectQuery As New ObjectQuery("SELECT * FROM Win32_NetworkAdapter WHERE NetConnectionId IS NOT NULL")
Dim searcher As New ManagementObjectSearcher(Scope, objectQuery)
[code].....
