Found For Making And Access Based Phonebook App?
May 16, 2010Toying around with a tutorial I found for making and Access based phonebook app, but running into issues.
[Code]...
Toying around with a tutorial I found for making and Access based phonebook app, but running into issues.
[Code]...
i need a simple phonebook program using vb.net 2008 and access 2007 using ado.net with add , edit , delete buttons
View 2 RepliesI am making a window based application in vb.net.Now i have work in two sql databases, so i when the window opens it will show two databases..when i select first db then i can work in that particular db only..if select 2nd db then i can work in second db only..how to do that?
View 4 RepliesI want to build a phonebook application, with some extras.My problem is that I don't know which is the best file to save my data.I started with binary, but I wonder if there is good search capability in these files.Which do you think I should use?
View 2 RepliesHere is what I have but it only works when clicking on the row. I have tried a For Each and it still only does it when clicking on the row and not every time.Basically, I am trying to get a button to change the way it looks or if it even appears and them making a picture box appear or not.
If DataRepeater1.CurrentItem.Controls("TRANSPORT_SUFFIXLabel1").Text = "A" Or DataRepeater1.CurrentItem.Controls("TRANSPORT_SUFFIXLabel1").Text = "B" Then
DataRepeater1.CurrentItem.Controls("Edit_Checklist_Btn").Enabled = True[code]....
is there a tutorial for making a Text Based Game In Visual Basic?
View 2 RepliesSo I have a TreeView and it has about 7 parent nodes that have 3-5 children each. All of these children nodes when click navigate to a URL. What I would like to do is have one parent node auto-expand based on the URL and the other parent nodes to collapse.
[Code]...
I want a context menu strip to have 4 specific items. For testing purposes, we call them Item1, Item2, Item3, and Item4.I've set up a context menu strip like this, and I am using it for about 20 different controls. I want these four items to do different things based on what control the user right clicks. The only way I could think of doing this, was to make 20 context menu strips and create a click event for each item. This obviously, seems like a really bad way of doing it.Does anyone have any suggestions or another way of making the click events for the individual Items based on what control is right clicked?
View 6 RepliesI'm working with a connection to a Access db. I noticed that when the mdb file is not found in the location it should be, an exception OleDbException is thrown. I would like to create some kind of form where the user specify the new position of the Access mdb file to continue to work. Then, it would be useful to save the new location as well I suppose. But, where do I have to handle that exception?
View 6 RepliesI recently upgraded my system to Windows 7 64bit and ever since then I have had nothing but issues with my code attempting to access an Oracle database. I was using msdaora for my connection string however that does not work in 64bit. I changed over to OraOLEDB.Oracle which everything I can find on Google says to use however it fails every time. I have installed Oracle 11g 2 times now and even tried reinstalling VB.net 2010 and still no luck.
Here is my connection string....
Code:
MyConn.ConnectionString = "Provider=OraOLEDB.Oracle;Server=emsp.grhq.XXXX.com;Data Source=emsp;User Id=XXXX;password=XXXX"
And I am inporting....
Code:
Imports System.Data.OracleClient
Yet when I try it says...
Quote:
Provider cannot be found. It may not be properly installed.
Today i finish my "Crystal PhoneBook"Reason of my this Thread Giveme advise And Upgrade me
Visit my Webpage of "Crystal Phonebook" you can also download to here[URL]..Uploading in Download.com is in Progress Dont Scared With My Silly Example.
I have created my own quiz for my aplication, but, a lot of people asked me , why can't the programe count right or wrong answers and one of them told me can you make a quiz that randomly selects questions?ok, I told them its all posible to make , but I actually coulndt make it working.So, usualy for a classic quiz I got the code to make a button go red if the answer is wrong, but I need the code line for the random question selection and the counting.I found some code but it didn't work,
View 3 RepliesWe have an VB.net application that is being moved from one box to another. It runs great on the old box. The new box is configured the same as the old one but is on newer hardware. When I run the application on the new server it complains that the adobe toolkit that we use can not be found.
View 2 Repliesconverting a speadsheet into a proper data source. I have imported it in to a table called "B" in access 2007. The problem is that the data is spead out of multible columns and rows, looks like a crosstab query. I need to convert it back to its data. I could do it with UNION Queries but this would be unpractical due to the number of columns.I have created a public function in my module. But I am not sure on how to call it. I get the error:
Quote:
Circular reference caused by 'BOut'.
on this line:
Code: Set rstout = CurrentDb.OpenRecordset("BOut", dbOpenDynaset)
Here is my first try:I have a table called "B":
Quote:
InvoiceCode,XXX001,XXX002,XXX003,...
A,$10,$15,$20,...
B,$1,$2,3$,...
[code]....
I have made a project(made a new data set and forms made by dragging data set entries to form ) in vb.net in which i used ms access as database and now i created a setup file for it but when i run is its giving error regarding some connection to database.?
View 3 RepliesPublic Class HotelReservation
Dim currRec As Integer
Dim totalRec As Integer
Dim dt As New DataTable
Dim cmd As New OleDb.OleDbCommand("SELECT * from Reservation", conn)
Dim da As New OleDb.OleDbDataAdapter(cmd)
Dim ds As New DataSet
[Code]...
WIth vb 2010 beta2, is it possible to use a Microsoft access save file instead of sql server (with no reduced functionality)?
View 2 RepliesI am using VB6 for a (ADODB Connection & Record set) database program by connecting MS Access file (MDB). Can I make same program in Visual Studio 2010 by ADODB connection with MS Access (MDB)?
View 1 RepliesNot sure if this is the right Forum to post this question. If not guide me where to post... I have an Access database that I would like to be able to share with Multiple user cuncurently... I have seen it is being done but I am not sure how? Or may be I should be using SQL Express.
View 1 RepliesIn my Microsoft access database I have a table called Picture and 3 fields: ID, Name, Image. I was wondering if it was possible to get all the images from the field 'Image' and display them into SlideShowExtender.
View 2 RepliesI have a class which has various methods that I need to make public to only 1 other class. Is this possible? I don't want to make them public for everybody, just that 1 class.
View 1 RepliesIm new on this forum here, i have already browsed many topics but i really didnt found a answer on my question.
I want to connect to a web-based linux SQL server. Is there a way to do that? Or do you have to use the Microsoft SQL server?
I am writing in VS2005 what, on the face if it, should be a relatively simple DLL, which will allow me to build a list of custom objects when called from within Excel 2007. To do this I have a Column and Columns class. As implied, Columns is a list of Column objects. The relevant classes are defined as follows:
[Code]...
I have an ASP.Net portal like application with multiple roles. I have placed the subpages of that role in its own directory adding a web config with an authorization allowing only that role. I have css and javascript in the root directory that can not get access inside the protected role folders. How can I allow these folders css/js to have access to all roles. Sorry if this is easy question I have searched but I am rather new to ASP.NET
View 1 RepliesI have an MS Access database that has a field called DeletedDate. I want to use a Delete statement that will delete the record(s) when DeleteDate is 30 days old or older. I have tried several different Delete statements but none seem to work properly. They will always delete some of the records, but will leave some records where either DeleteDate is older than 30 days or will delete recored where DeleteDate is not yet 30 days old. I have tried these using DeleteDate as a Text field and as a Date/Time field. Which should I use? These are the Delete Statements that I have used:
'sComm = "DELETE from Agents WHERE Deleted = 'Y' AND DeletedDate < " & System.DateTime.Now.Date.AddDays(-30) & "
sComm =
[Code]....
I am required to send MS-Access table to SQL Server Database, based on fields Selected in Listview.
1)Till now i am able to get Access table names and their field in List view.
2)I am able to check whether database exists and Whether table exists in SQL Server with same name from VB.Net.Now i don't know how to insert Access Tables based in Fields Selected in ListView to SQL Server.
I have the membership provider setup and its currently pointing to a SQL database on my machine. The role based access works and I have a menu that is security trimmed. The user can only get to pages that they have access to.When an anonymous user tries to get to a page that they dont have access to it brings them to a login page so that they can login. That is fine. But when a logged in user tries to get to a page they dont have access to(Usually by typing in a URL) it brings them to the login page again asking them to login(except there already logged in. I'd like to either take them to a different page or somehow tell them they don't have access.
View 1 RepliesI've been working on an application for awhile that, basically, allows the viewing and printing of a maintenance database. It allows the user to view basic information for the object and then view the maintenance history. My approach for the maintenance history is simply to have unique tables per object since a history has to be kept for each, however, I'm running into a problem in the application that allows the user to view the general information from one DB and the Maintenance history from the other DB.
Say you have Object ID BG1. I can enter the object ID into a search field, pull the data from the general DB and display the data, but I also need it to pull the information from the maintenance history and display. If maintenance history for this object is not found, then create a new table within the DB, fill the columns with the required fields and allow for the user to edit the history.
I want to make different levels of access for a vb.net program i'm writing.I have a database called "stratocast". I want to show a specific form for entries in this table with "IsManager" checked and another specific form for those with "IsAdmin" checked.Im using MySql server and visual basic 2010 express
EDIT:To clear up any misconceptions about my post, ill explain further: In my vb.net application i have a login form with two textboxes; One for the username and one for password. I also have three other forms, one is called "frmAdmin", another called "frmManager" and another one called "frmEmployee".
On my database i have a table called "employee" with columns called "name", "title", "IsManager", "IsAdmin", "Username" and "Password".
IsManager and IsAdmin are both Boolean columns
This means that their values can only be 0 or 1 and the result is displayed as a checkbox.When the employee logs into this applcation i want it to check whether or not the employee is a manager, an administrator, or just a regular employee with no additional rights. If the employee is a manager, i want to show "frmManager". If the employee is an Administrator i want to show "frmAdmin". And if the employee has no additional rights then i want to show "frmEmployee".
I'd like to keep the configuration for access level checking confined to the one table but if it's better to have separate tables for each level of access (ie: tables called Admin,Manager, and Employee) then ill consider that too.
Occasionally I encountered this exception message while trying to download file from a server using System.Net.FtpWebRequest and System.Net.FtpWebResponse Object.
Download a file.ftpRequest_DL.Method = WebRequestMethods.Ftp.DownloadFile get the response object
Dim ftpResponse_DL As FtpWebResponse = CType(ftpRequest_DL.GetResponse, FtpWebResponse)
[Code]...