I programmed an app with an Access 2010 database, I installed the app and the database on a computer with office 2007. The app can't open the database. Do I need to copy some extra file on the user's PC?
View 15 RepliesI need help with the code to make it so when a form loads it will check the Access database for the user and if that user is present, then it will load their selections. Otherwise, if no user is present it will add a new row to the database and display nothing.
View 2 RepliesI'm running into a bit of a roadblock here. I have tried to search the web/forums for answer for last several hours to no avail and I'm not the expert VB Programmer.However, I was able to write an app to do the following:
1) read Outlook emails for particular emails containing xml link in which I was able to download the file and save to my hard drive.
2) opened the Excel spreadsheet to run the macro which import those XMLs into existing XLS spreadsheets to refresh the data.
3) Those XLS spreadsheets are linked in my MS Access in which I join all four XLS sheets to create one report via Query which I have created in the past prior to this app development.
I have manually done a File Export of this query via ALT+F then E and what I'd like to do is to either take control of menu commands OR alternate method of performing a File Export to a new Excel spreadsheet (version 2003).I've seen two different methods, one via DoCmd OutputtoFile and another is TransferSpreadsheet.Here's my Access coding I have in my VB 2010:
Imports Microsoft.Office.Interop
Public Class OutlookOfflineEmailExtractor
Dim wsAccessApp As Access.Application
[code]....
it's just for a program registration. i would store all of the registration codes in the access database, then export it to XML, then upload it to my web host. I would then somehow connect it to my Visual Basics login form (Which I have already made). If this can't be done, having them register through the form and having all the allowed codes on the internet (So i can easily edit them)!
View 5 RepliesI need to write from VS 2010 vb.net dataset into a newly created xlsx file.
View 2 RepliesI've made Add-in for Word 2007 in VS2005.It worked well with Word 2007 and now it works well with Word 2010 32 bit.However it doesn't work with Word 2010 64 bit. The installation is successful, but the ribbon button doesn't show up.
Do you have any experience with add-ins for Office 64 bit?
I 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 am developping a small application. I am wondering if its possible for the user not to access anything on windows while working on the application? I mean everything should be disabled for the user working.
View 2 RepliesI coded a program to access a Microsoft Access 2010 database. The program is written using Microsoft Visual Studio 2010. I get the error message that the database I'm trying to access is in an invalid format. look at the code below to see what I missed. The error is in the datasource statement.
[Code]...
quite new to database queries through VB. I have just created a DB using MS Access and I need to write data to it from my VB Application.Can anyone point me on which objects should I use to execute these write transactions?
View 6 RepliesI'm trying to ensure that a user exists in a database before the data they are logging is inserted. I have the following code;
Dim ID As String
Dim v_sqlid As String
ID = txtEmployee.Text()
[code].....
Error: The database has been placed in a state by user 'UserName' on machine 'ComputerName' that prevents it from being opened or locked.
View 5 Replieshow to connect vb.net 2010 to ms access database to get the data and display it in vb.net application that I am doing right now. My project is that I am doing dictionary application with vb.net so every time i put new word in search box, I want the vb.net to get the definition from ms access and display it in the application.
View 1 Repliesfirst of all here is the code that populates the fields when the user logs in. This code is correct and works fine.
Dim passwordrow() As Data.DataRow
passwordrow = MyDBDataSet.Tables("Customer").Select("Username = '" & txtusername.Text & "'")
'This try statement checks to see if a row has successfully been found
[Code].....
I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the database using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment. This is further confused by office 2007 and VB 2010 both of which didnt exsist the first time i did this.Connect 2010 to an access database?
View 4 Repliesi am having a issue with my database connection. I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the atabase using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment.
View 1 RepliesI'm new to Visual Basic. I came across a random number generator tutorial. Got it working fine and then I thought, Is there a way to get it to access a database Here's the thing
1. Generate the random number.
2. looks at the database and finds the corresponding id number.
3. Takes the field for that number and enters it into a text field in the program.
So for example the number generated is 32. Then the program looks at the database and looks for id number 32. then takes the text in line 32 and enters it into a textbox in the program.Now I have my database and the program. But just can't seam to figure out how to get the two connected like I want. I have looked and searched but have found nothing like it I am using Visual Basic 2010 and Access 2007.
I've tested an application (one that I'm developing) that utilizes MS Access database (.accdb) on a backup machine. And I consistently get an unhandled exception error saying 'The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I suppose I get this error because the backup machine doesn't have a driver or whatever to read the Access database file. Reading
this topic titled "How to deploy VB 2010 application as a standalone without MS Access", I understand that I can just specify a prerequisite for this component (driver or whatever...) in the project designer window in reference to this page. I wonder if there is a simpler way of delivering the database component to users? Or should I abandon the Access database and use a different one for easier accessibility?
update access database from vb 2010?
[Code]...
I just started learning VB 2010 through a book. I'm learning vb to design a program which can manage customers of a small company as a homework. It'll store data (Company Name, Phone N. and Adress) at an Access Database. (I'm using Access 2007)
I have a little background with programming but none with databases. According to the book there is no way I can delete, add or update a data from an Access Database without installing SQL Server or Express. But this program should work at a computer which may or may not have SQL server or MS Access (Any computer with Windows OS).
After a little digging only thing I could find was Walkthrough: Saving Data to a Database (Multiple Tables) from MSDN and did every step and at the end, I can delete or add rows and change values of the cells but cannot save them (when I click save, close the program and re-open it, changes are gone).
I don't get that how can I view all the data from database without SQL server but can't save changes to the database file without SQL Server.
Is there a way to do this without SQL Server? If so, can you give the right code for the MSDN Walkthrough's Save button? Or point me to a page where can i learn the right code?
I am having problems writing to my .accdb database. Here is the code, any input would be welcome. I am also trying to avoid using a pure MYSQL.
VB.net
Sub Add_to_database()
Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data
[code].....
I want to connect to a mdb file but i have never did that before. i don't know where to start. heard something about ado.net and some other things.
the file is a 2003 access file if i am not mistaken. and it is shared on network. so multiple users (not too many, max 50) will use it at same time. what is the best connection to use? i have to mention that i don't want to use data controls. i want to use sql commands to fetch data and manipulate data on the form controls myself. i know there are various connection ways like strings and adapters. not sure which one is better.
I don't know how to take input from user in sql statements, i'm learning from different sites so i don't know how to do it. Here's the code.
Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim dbProvider, dbSource, sql As String
[code].....
I got an Syntaxerror in my INSERT INTO but i cant figure out why.
[Code]...
I have a windows desktop app I'd like to release that would access data from a database on the web. Never done this before, so not sure what's needed either on the client side or the server side.
View 1 RepliesI am trying to update my access database after changing one of the values of a dataset I loaded from it..[code]I already created a dataset called "Address" using the DataAdapter.fill method. Name and ID have values assigned to them in my program and ID corresponds to the ID# in my Access database.I receive the following error:Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.I am completely new to working with databases
View 2 RepliesI have part of an application that reads from a database makes changes to the data then saves the changes to the database.
[Code]...
How it's possible to get values (string) from the database when a user connects? i use in this
[Code]...
It is my first time to code vb2010 with an application of database. I am doing my inventory system project and i do not know how to start my project. Can somebody help me to find a tutorial in visual basic 2010 and New Microsoft Office Access 2007 Database? I would like to use vb2010 and New Microsoft Office Access 2007 Database... Is this possible to use for my project?
View 10 RepliesOk, so I`ve been studying a bit of VB lately.. bought a few books and read lot`s of articles and seen hours of instructional videos, and I slightly start to get the hang of a few things.. :) I`ve recently started a fun little project, but I seem to lack a bit of knowledge to reach my goal. I`ll first try to describe my project:
[Cde]...