Writing VB/Access Apps Fast?
Nov 23, 2010
At my company we build a lot of small, administrative type databases generally used by a dozen or less users. We have thus far done them entirely in Access. I've been doing VB forever and would like to write nicer, rich UI apps using a VB front-end to and Access database instead, as I find Access apps clumsy to use; VB apps look better and have more UI options.
I've started to play around with building Data Sources, Binding Sources, etc. and dropping them on forms, trying to create something useful with as little code as possible. I'm just wondering what folks generally think of using this approach. Remember this is for small, not complicated db apps with few users.
I know in the VB6 world bound controls took some heat for being not worth the effort it saved you.Also, is there a good book on the subject that concentrates on creating VB/Access apps with minimal code?
View 4 Replies
ADVERTISEMENT
Jul 22, 2011
Which one of these two do you suggest for writing simple windows form applications?Visual C++ is too complicated for my small to medium applications and the proccess of creating seems to be longer when compared with C# or VB.NET.
View 5 Replies
Jun 19, 2011
How to create Key access for that fast array in VB.NET [code] waiting for any sample, this sample fastest for me work, but retrieve by key not only by number.
View 6 Replies
Feb 19, 2006
I've been trying to mess around with image recognition in C# for some time now. But to do that, I need acces to all the pixels in the bitmap individually. At the moment, I'm using getPixel and setPixel. It works, but it's VERY slow. Is there any faster way to acces pixels in a bitmap? Unsafe code maybe?
View 6 Replies
Jul 14, 2011
When you need to do random access to the lines of a text file, the regular solution is to put those lines in a list and access them in that list.But doing this if the text file is large creates a large memory overhead and may cause some memory stress on the application.This class maps the file and provide the ability to read any particular line in the file at a random position, without the need to read or put in memory any other line but the desired line. The only memory overhead involve is the 1024 bytes buffer of the base stream.Even if the file mapping can be a process that consume a noticable amount of time if the file is very large ( ~ 5 seconds for each 100,000,000 caracteres) , once the mapping is done the access to a particular line becomes instantaneous regardless of the size of the file. (The file mapping can always be done at a convenient time (ex when the process load) and can be done on a worker thread The class is base on a StreamReader to support the differents Text Encodings Example uf usage ( As I say, if the file is very large, dont do it like that, but declare the class at a convenient time)
Imports Reader = System.IO.MyStreams
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code]....
View 11 Replies
Aug 13, 2009
I'm not looking for a solution, rather I just want to know if this is possible or not with VB.NET (which I'm still just a beginner on).What I'm looking to develop is a WinForm application that allows users within the company network to share files and other information.
View 4 Replies
Nov 20, 2009
I am using VB 2008 to develop apps working with Access. With this IDE I can compile my apps as x86 . Then runs fine under 64 bits Windows 7 and Vista Systems.
First question:but if I run this app under XP 64 bits, will run fine too?
second question:the apps developed with VB 2003 (these work with access too ..."jet oledb"). How I can compile as x86? I have not seen this option like VB2008.
View 1 Replies
Jun 1, 2012
[i][b]I have always developed apps for desktops with an access database on one server for one company or sql server. I had one connection string. Now I am in a situation with multiple clients using my software on their own server. This means different connection strings can anyone suggest an efficient way to do this without changing connection strings for each server throughout the application?[/b][/i]
View 1 Replies
Jun 15, 2009
I am trying to Read a text file from vb.net and then write it to microsoft access. The following is the codes that i have written for this project.
However, there are errors stated:
1. error in inserting record
2. Warning 1 Variable 'DoCmd' is used before it has been assigned a value. A null reference exception could result at runtime. C:Documents and Settings�74958XDesktop6jun[updated]6junForm1.vb 63 9 6jun[code]....
View 12 Replies
Feb 22, 2009
[code]i want to write Delta_r(i) in access data and then i want to connect that file to Crystal report for plotting.
View 4 Replies
Sep 10, 2011
What i've written opens an Access database and one can read and write into it (on a table called Journal)It does indeed work for newly made Access files. However it doesnt work with a specific Microsoft Access database (again .mdb) which was made with a very old Access, like Access 2000 or something.The error message is: Syntax error in INSERT INTO statement.Inside the zipped file below you will find the source code of the program, along with an access file that the program CAN read, and the one access file that i NEED the program to reed but it cannot!
To see what i mean run the program one, try to add a new line to the database. you get an error!now rename the Journal.mdb to "journal.bak.mdb. And the journal_working.mdb to Journal.mdb try to add a new line to the database again without altering the source code at all. it succeeds now!!
NOTE: the program can READ data from both files. but it CANT write data to the old access file
this is the code:
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables("AddressBook").NewRow()
dsNewRow.Item(1) = txtFirstName.Text 'or .Item(1) =
[code]....
View 3 Replies
Mar 25, 2009
I am having trouble writing information to a 2007 access database. I just want to write a numeric value into a data base. My table name is KW and my field is also referred to as Kw.
Dim theOleDbConnection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=C:\Documents and Settings\HP_Administrator\My Documents\value.accdb")
Dim theOleDbCommand As New OleDbCommand("INSERT INTO[KW] (Kw)VALUES (@P1)")
theOleDbCommand.Connection = theOleDbConnection
[code]....
View 2 Replies
Jun 24, 2010
im having an issue writing to an access database via vb.net 2008 i can read form it but not write?
View 4 Replies
Jun 21, 2010
what WPF based apps are?Is it an application that runs under Silverlight? If so, how?I know; Windows Forms based apps,console apps,DLL _ Class Library Projectsand I've had an introduction to ASP.Net.What I mostly want to know is, if WPF apps are for Silverlight then do they also run in a server based fashion like anASP.NET website would when you create ASP.Net webpages?Is it a way of creating what looks like a FORMS BASED application but it runs in a browser instead or what?Please enlighten me a bit further as I have no idea what WPF is all about.
View 3 Replies
May 16, 2009
I have searched all over the forums and not found an answer to my question. My question is how do i write to an access database at runtime. The database is also created at runtime. I have a dataset loaded with a table that i needs to be written to the database. how would i write each row of my dataset to my database? Sorry if this sounds a little jumbled together it is late and i am tired. If it is unclear you can ask me and i will answer any questions you have about my question.
View 14 Replies
Dec 15, 2011
I have limited experience with Visual Studio and have a question about Querying an Access database. I have created a Visual Studio application that displays and modifies an access database. I have use datagridview and detailed view to insert data and view data in the Access database. I am now trying to figure out the best way to query the data in the database. I have tried right clicking a table in the database explorer and creating a new query. Everything works and I can view the data but I am unsure how to display this query result in datagridview. So my question is how do I view this result in datagrid view?
View 9 Replies
Jul 19, 2010
I use Visual Basic in Access, and I have no problem writing data directly to a cell in a database table. But I can not figure out how to write the code for Visual Basic 2008. For example I would
use Me![cust_Cost] = 20 to input 20 in the database table.
I have purchased two different Books on Visual Basic 2008 and not one of them show how to input data manually.
View 3 Replies
Aug 18, 2010
I am writing an app in VB2010. My code parses a text file, assigns data to variables My??, and then attempts to store this data in an access 2010 (actually access 2007 format) table. Yet, whenever my code gets to MyRow.Item("Artist") = MyArtist I get an error 5 'Artist' does not belong to Table MyTable, but the field/column does exist in the table as do all the others.
01Dim tbl As DataTable = New DataTable(MyTable)
02tbl.Rows.Add()
03Dim lastRow As Integer = tbl.Rows.Count - 1
[Code].....
View 8 Replies
Mar 30, 2009
I want my program to be able to edit a values within a registry key that resides in 'HKEY_LOCAL_MACHINE'
My.Computer.Registry.SetValue("HKEY_LOCAL_MACHINESOFTWAREXYZ", "MyValue", "MyData")
The above works fine in Windows XP, but throws an UnauthorizedAccessException in Vista.
View 3 Replies
Sep 19, 2009
I'm running Windows Vista with admin privilege and UAC is disabled but still unable to write to windows registry!
My.Computer.Registry.SetValue _
("HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionRun", _
"Test", "C:Test.exe", Microsoft.Win32.RegistryValueKind.String)
I'm getting error "Unauthorized Access Exception was unhandled."
"Access to the registry key 'HKEY_LOCAL_MACHINE....' is denied."
I've googled the net and found that registry permission elevation is required for admin tasks, Is there away to take registry key ownership through VB.Net code??
View 2 Replies
Sep 24, 2009
I am creating a form which has the customer information entered by the user.When the user clicks submit the row need to be inserted into table "customer".writing the code to connect to the access database and insert the new row?
View 3 Replies
Nov 2, 2010
How can I change the delimiter when writing my Access table to a text file? I was hoping it would be as easy as adding a similar option like we do for HDR=No; maybe Delimiter=|
Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|mydatabase.mdb")
AccessConn.Open()Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO[Text;HDR=No;DATABASE=" & userPath & "].[" & fileName & "] FROM tblMyTable", AccessConn)
AccessCommand.ExecuteNonQuery()
AccessConn.Close()
View 2 Replies
Nov 28, 2010
I've been doing some more experiments and have summarized the query as below: I've created the simplest application. A project with a plain form, which writes text file within its application directory. Simple as that.Supposing this was my application which I want to distribute on the world web. I've created a basic installer for this using NSIS installer. The Installer installs my application in a folder created inside Program Files. The OS is Windows7 and UAC is enabled.Now I know many people have been facing difficulties in accessing files inside the Program Files folder. My app is simply creating a plain text file, nothing more, and within its own application directory. It is giving Access Denied error. But if I right-click on the EXE and run it as Administrator, then it works ok.The only solution thats available is not to write in the application folder, and write text file in some other folder which is not protected. My question is that other programs that are installed on my system are also doing it. I have a temperature monitoring software called SpeedFan on my system, it creates log files within its app directory. All other softwares create log files within their app directories, why cant I?I just have to make a small log file for my application and Win7+UAC is not letting me do it. I don't want to write the small file in any other folder. How are the other softwares accomplishing this ?
View 5 Replies
Jul 12, 2009
My application creates a file by writing to System.AppDomain.CurrentDomain.BaseDirectory() & "data/" & filename...Now this works fine usually, but I just added a setup utility to the app, so now it installs to the program files directory. It installs correctly and creates the data folder, however when it tries to write the file it gets an exception "unauthorized access".
View 3 Replies
Jul 4, 2011
I am having a windows application. That downloads files from server and write into the local directory. It works fine. When we try the same appliication in Windows 7. IT shows an error Access to the path denied (While writing to the local directory).
View 1 Replies
May 22, 2012
Ok I know this question has been asked to death but I still have not seen a good answer. I have created an application in VS2010 using VB.NET. In my application I have an error log that is an XML file located in the Public gstLocalErrorLogLocation As String = Application.StartupPath & "ErrorLog"that gets written to in the event of an error so I can trouble shoot application easier. My application also downloads files from our FTP site and puts the files in Public gstLocalDownloadLocation As String = Application.StartupPath & "download"So I have files that get read and written to as well and created and deleted all in the Application.StartupPath which is either "c:Program Files(Application Directory)(Some Directory)(Some File)" or "c:Program Files (x86)(Application Directory)(Some Directory)(Some File)" depending on 32bit or 64bit Windows 7.
After creating the setup I install it on my test machine that have both Windows 7 32bit and 64bit.Everything in the application works great till I have to write to, delete or creat a file in those directories above. I know it is an access issue and the UAC. This will get installed on numerous systems so the options I have seen to change file or folder permission on the computers manually is not an option.What has to happen is after I install the application it just works like when you install it on XP. Some post have suggested that you us a user with administrator privilages or group which is all fine and dandy but the user I have used to test the application has all of that.
So what I am asking is how do you create an application with VS2010 in VB.NET that after creating a setup package and installing on Windows 7 will just work with out "Access to the path c:Program Files(Application Directory)(Some Directory)(Some File) is denied." If I have to install this on 100 Windows 7 computers it has to be a concreate no manually doing anything just install and work like when we installed on XP.
View 5 Replies
Feb 7, 2011
I've been developing a simple virus scanner and it works by reading the hex code of a file and comparing it to signatures from a database. Anyway, the only thing slowing it down is how it reads the hex. This is the hex reading part of my code so far:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoadFile.Click
Dim ArrayHold() As Byte
Dim Index As Integer = 0
Dim Str As New StringBuilder
[code]....
View 1 Replies
May 17, 2010
What I need is to highlight multiple matches within some portion of text as the user types a search pattern. Right now I'm using a RichTextBox to highlight text. The highlighting takes place if a user changes the search pattern and naturally it happens with each key press. It works, but I'm experiencing a performance issues. If the text is large enough the highlighting takes too long (up to several seconds).
Facing that I tried to launch the highlighting procedure in a different thread aborting it and launching it again if the search pattern was changed during the highlighting but still I'm not satisfied with performance. Now I'm asking if there some other control I could use to speed up the process?
View 6 Replies
May 13, 2011
Following is the code I used for reading the files and folders from a drive etc.
Public Class LoadingBox
Public counter As ULong
Public OpenRecords As New Dictionary(Of String, MainWindow.records)
[code].....
View 2 Replies
Aug 11, 2009
OK. I am making application for copying. Problem is that every time application wants to write it first tries to write via fast IO and get response that it isn't allowed and then it writes a file (i am assuming without fast i/o). I have no idea what fast i/o is (i know io is input output -> read write). So I can assume that it is handled by class that I am using to write. I am using System.IO.FileStream and its functions Read and Write. Is there any other class that I can use witch will allow Fast IO or disable trying it in first place (I would like the first solution)? Or should I do something else?
View 6 Replies
