Open Several Databases At Same Time?
Mar 23, 2009
I have a database created in MS Access 2007. I have put the database as a mdb-file in a server to make many computers able to use the database.The problem is that, the database can only be open at once, in one computer.I'm able to connect to the server and see the database, but when I click to open it again, nothing happens. Not even an error message.Does anyone know how I can get several computer to be able to work on the database at the same time?
View 1 Replies
ADVERTISEMENT
May 11, 2012
Private Sub cmdBuy_Click()
Set rs = New ADODB.Recordset
Dim temp As String
[Code]....
I want to save the Change data in Table1 in table2.. Example: I want to Transact the 1Stock to be decrease, then I save the Remaining stocks , The quantity Decrease(ADD or Decreases) and Date etc.
View 2 Replies
Mar 25, 2010
simple coding procedure or recommend a resource for switching between two or more open Microsoft Access databases within a VB.net program, while keeping the same indexed place in each database? The purpose is to iterate through the databases conducting comparative analyses of field values, and writing the results of the analysis to the same databases or another database.
View 7 Replies
Oct 21, 2009
In my program, I have a timer with a inteval set to 1000ms. The timer is executing a MySQL-command, and right now I'm opening and closing the connection each time.
View 5 Replies
Feb 23, 2009
How I Can open the same form in my application one time only can not open the form tow time in same time
View 5 Replies
Feb 4, 2010
I have a project with various forms all of the same size. Is there a way of getting them to appear in, for example the middle of the screen each time they load, in the same position
View 2 Replies
Jul 6, 2010
Are there code can open and close forms in particular Time (reference is computer clock)..?
Example: in 08:00:00 open form1 and in 08:45:00 close it
And can I let the user enter the time to open and close the forms in the Basic Form?
View 13 Replies
Apr 20, 2010
with two fields each and write the results to a third Access database as part of a data mining program with finance applications.Here is the code in question:
Imports System.Data.OleDb
Partial Class Form1
Dim DMDatabase01 As OleDbConnection = New
[code].....
View 6 Replies
Aug 21, 2010
Is it possible to create a program to run a program in another time?I mean you can run a program and give it a different time, such as three hours against the program (only by that program) say that one hour is?
View 12 Replies
Oct 8, 2010
I have a Window with a Grid that is making a select from myql, and using the .Show() function insted of ShowDialog() I can open the same window a second time to have two instances of the same window.
Now, when i open the second instance the grid populates with the new selection also in the first window....how can i make the window to open the second time without refresing the grid in it again...in the first one?
View 2 Replies
May 17, 2011
I want my dialog to display for five seconds then open another dialog.
View 2 Replies
Jun 29, 2009
I'm saving my settings like this...
[Code]....
View 9 Replies
Oct 13, 2009
Well it would appear that you need to close IO.StreamReader every time you try and open a new document. So I have tried to do this a variety of ways, with no success. I am open to the option of having it check the same document for the Username, Password, and HWID. (Yes, I know that this is not in any way a secure method to gather data but their is a reason for my madness) Anyways onto the code, I removed the URL (Yes, I did check to make sure they were all valid and worked).
VB Dim wc As New Net.WebClient 'Downloading the list..
Dim hread As New IO.StreamReader(wc.OpenRead("myurl")) 'URL to the list
Dim uread As New IO.StreamReader(wc.OpenRead("myurl")) 'URL to the list
[CODE]...
View 8 Replies
May 10, 2012
How to comment and uncomment codes at multiple place within my project at the same time?I am using VS 2010 trial version to develop a VB application.Some of functions only should be showed to developer, not to users. So I must comment them and uncomment them many times during the process of development. please note that those codes are located in many locations and many VB files within my project.
Can I do this in a conveninent way, just clicking a button, or just defining a const or "#define something", something like that?
View 1 Replies
Feb 25, 2011
I have a VB application that uses databases and writes information onto an Excel-file. I have the Excel-file in my Project folder(Visual Studio 2008ProjectsProjectXProjectXExcel objektitListy.xls)Every time I open up my project I get the following error:[code]The thing is, I don't know why the error starts up in the first place. Why is the VS 'unable to open the module file' even though it exists in that folder and can be opened normally?Also, why does the error disappear when the file is opened manually from the containing folder?
View 5 Replies
Aug 1, 2011
i have developed an application using OPEN XML SDK Tool 2.0 which generates Excel file. I have Data table of 100000 row and 30 columns and i want to generate excel file with these 100000 rows and 30 columns but it takes about 2 minutes of time to generate excel file. What can i do to reduce this time.
View 3 Replies
Feb 1, 2010
I've got a VB.Net form application that dynamically loads user controls based on which navigation link the user clicks on. I'd like to make it easier to use at Design time by putting a link of some sort to open the User Control at design time. The link would go onto the form in the space where the User Control will be going. This just saves a little time from having to browse through the files to open the correct file.
View 2 Replies
Jan 18, 2012
i am making a program that has a lot of forms. one part in particular has about 30 buttons that each open a different form. i need a way to only allow one of these forms to be open at a time.only allow one form with the prefix "Helmet_" to be open at a time you would be a god.
Public Class Helmets
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Helmet_AmazonHelmet.Show()
End Sub
[code]....
View 16 Replies
Sep 6, 2009
I have an ASP.NET application with a SQL Server back end. I am storing all my dates in UTC format and doing the appropriate conversions to the local time zone of the browser viewing it. One of the pages asks for a start date and end date (no times).
I am taking the start date and setting the time to 00:00:00 hours (midnight) and I'm taking the End time and adding a time of 23:59:59, so that the date range covers the whole day. Now what I'm trying to do is do a SQL query to do a search for records in this date range. The problem is, the data in SQL is in UTC time and the user is typing their dates and times in their local date and times. My quickest solution was to convert the date and time to UTC, then search the records. However, by doing this, I am to believe ASP.NET converts the given time and date to UTC based on the server time zone. How can I convert a date and time to UTC time based on the time zone of the user?
View 5 Replies
Apr 2, 2012
i've been doing ADO.NET for a while but I would like to know if its posssible to use dao recordsets in VB.Net 2010 and where I can get tutorials and code samples to do database stuff like insert etc. I've tried to google but most of the code available is for vb6 I was going through some stuff on this link [URL]../bb243801%28v=office.12%29.aspx and i'd like to know if it works for vb.net 2010 or maybe theres something i'm missing. because the moment I put "Dim dbmyDB As dao.database" its been giving me the wavy blue line and i am now doubting if it works or maybe i'm missing some other code
View 1 Replies
Sep 9, 2009
If you are using an sql database with a vb.net application, does the user need to have anything extra other than the .net framework installed for the program to run? Meaning, if I simply compile the application, are there any extra steps I need to take to make this work?
View 1 Replies
Feb 20, 2011
Ok, so I am on my last book of course material for college and this weekend I started making my own personal applications, stuff I can really use in everyday life, these projects also serve as a port folio for future employers
View 1 Replies
Mar 14, 2010
I recently moved over to a Windows 7 computer and I can't get databases to work with VB.net.Before I moved I used to do an Access database and connect it to VB through the ODBC thing. However, I don't have Access on this computer (open office) so I'm not sure how to create a database and connect it.I have tried to use the SQL Compact Edition that comes with Visual Studio but I not sure how to get it to work. Also would something like mySQL work with VB? I have looked at the mySQL workbench and like it, what else would I need to download to be able to use the databases created with it in Visual Studio?
View 2 Replies
Dec 14, 2010
I am trying to carry out a synchronisation of two databases: one on the server and the other on a local machine. So that even when they are not connected on the network, the local database can carry on accepting data but when the network is back on, the local database can update the server and the server can also update the local machine with data it accepted during the time when the network was off. by first comparing two tables in two databases and then if they are any differences the updating begins and i've since been stuck.
Private Sub btnCompareTables_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCompareTables.Click
'dont know which arguments to put when calling this function
'How do i tell the computer which databases to compare
Comparing()
[code]....
View 1 Replies
Jun 7, 2011
I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file (two different tables SQLtableOrders & SQLtableCustomerA))
datasetOrders.Tables("Orders") >>> the first column "orderID" is a primary unique key. Its structure is details below :
OrderID----OrderName----OrderCost--------Date
1----------A---------------54------------11/11/2010
[Code].....
note that I had already made this by getting the data by SQL Statement "Select SQLtableOrders.* , SQLtableCustomerA.orderID FROM SQLtableOrders, SQLtableCustomerA WHERE SQLtableOrders.orderID = SQLtableCustomerA.orderID" It is really working fine , but the problem that it takes time to get data from the SQL server each time I disply orders. I already have the datasetOrders.Tables("Orders") data on the client PC , I need only to make the client PC extract which orders are assinged to a ceratin customers. I can do it by For... Next , but I guess it will take time , specially if "orders" data contains many data .
View 8 Replies
Feb 5, 2010
What control(s) do I need to use and how do I use them? I am ,looking for tutorials and sample code too.
I'm working on a trivia game where the admin can remove and add questions to a database. [code]...
View 2 Replies
Apr 21, 2012
I am fairly new to programming, and even more new to using database objects. I am creating a program that will calculate a user's BMI, and that will let the user know how many calories are in a food that they choose. I found a database that has a bunch of foods, and each of their calories, so I am using that. I have the program set up so that the user selects each food from a drop down list. The user then adds each of the food to a list box after pressing a button. The program is then suppose to calculate all of the calories after the user presses another button to come up with the total calories. I got all the foods on the drop down list no problem, but now, I'm stuck on figuring out how to get the program to add all the calories for each cooresponding food. I have no idea where to start with it. I know that I'm going to have to create a variable to hold the total calories, but I just don't know how to get the calories from each food.
View 8 Replies
Feb 22, 2010
I am looking to add a local database file (.sdf) into my .Net Project, so i go right click on my project, click "Add" -> "New Item", select "Local Database" and rename it to what i want.I then click the "Add" button and get the following error."The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet assosciated with the file will not be generated."I am using Visual Studio 2008 .Net Framework 3.5.
View 4 Replies
Aug 22, 2010
I have read many articles on multithreading over the past few days and so far I'm fairly comfortable with how it works. I am now working on my actual application, and have come across a few design issues that I'm hoping somebody has experience with.The basic premise of the application is simple. A database filled with files names and a "converted" field that has a 1 or a 2 in it (1 for unconverted, 2 for converted). The application loops through every record where "converted" = 1, retrieve the file and convert it.
My single threaded application works fine, except its far too slow. Due to the huge amount of rows in the database (4 million+) and the time constraints on the project, I have decided to run as many threads as the hardware can allow to cut down on the timings.So, the dilemma is accessing database records and which threads should grab which record and how.
View 3 Replies
Apr 29, 2010
Well my project will basically involve a database of the sports info of students in my school. It has to work with about 1000 profiles, each containing a personal info record (basically an address book) and a Sports Info record which has some simple information like what sport they do for winter and summer but it also has some records like "Training Info" which will contain a some 10 fields. It'll wind up something like an array of records of records of records.
One of the key points for assessment is that we employ search and sort functionality explicitly using algorithms that have been provided to us. Essentially we'll have to write up our own subs for binary searches and stuff like that.
Now this is group work and I was put in charge of making the database, one thing I'm unsure of is what I should use. Most of the other groups are using .txt files to store their databases as they've been told that these are easier than Access files. However their databases don't appear to be quite as complex as the one my group's planning. Another random titbit of info I heard was that using our own search functions to search an Access file would not only be slower than using the inbuilt ones (another random something gleaned from conversation) [does it have inbuilt search functions?? I heard somewhere else it didn't] but also that it'd be slower than searching a .txt file with a similar sub.
I'm not sure of the veracity of those statements, however I still want to ask if you guys have any recommendations for what I should use to make the database with. The only ones I know of are CSV text files and MS Access, I'd be very grateful if you could point me in the of a good "thing" to use with VB.net for this kind of project.
View 2 Replies
