DB/Reporting :: Add Data-entry Capability To My App Using Password-protection User-access
Mar 8, 2009
I'm presently creating an application which uses Access2007 as the database. No problem there. But Since most use Excel for data-entry, i've created two tables in access linked to excel source file. Any change in excel will reflect in Access database and subsequently in my Application . Until now my application only reads the database and displays records in DataGridView. These records, i then export to excel along with other formatting for direct printing as a report as I have no idea how to make report. Now i want to add data-entry capability to my app using password-protection user-access. So i can directly add new record to source file. Also need to know if There's any way of eliminating Access from the picture entirely....
View 1 Replies
ADVERTISEMENT
Apr 16, 2012
CODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
View 2 Replies
Jun 23, 2009
I am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
View 3 Replies
Apr 19, 2008
I included a MicrosoftReportViewer to my project:
Code:
Private Sub Report_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
View 2 Replies
Feb 10, 2009
How do you get a textbox being using for password entry to display the black circle that you often see in web forms, on the iphone etc etc?
I can change the PasswordChar property to an asterisk no problem and even copying and pasting symbols inserted into Word seemed to work - just couldn't find a symbol that looked like a bullet point!
Can this actually be achieved for a standalone exe, or is it something unique to web forms? Surely copying and pasting symbols from Word isn't actually the answer?
View 6 Replies
Jan 7, 2009
I need to open a password protected Access database from VB and I'm trying to use the Process.Start method and have had no luck. I have tried this seversal different ways and can't seem to get it to work. Here is an example of my closes attempt:
[Code]...
View 2 Replies
Feb 14, 2011
I'm making a login screen but i couldnt find a way to make textboxes invicebel but useable so i used labels but now the password label doesnt show password protection is there anyway i can give the label ******* pasword protection?
View 18 Replies
Apr 8, 2010
set password for a folder using vb.net source code
View 3 Replies
Jun 18, 2009
i'm trying to create a program that enables a user log into the program using a username and password, first he/she must first create an account with some vital information incase the password is forgotten so it can be retrieved
View 2 Replies
Apr 10, 2010
how can i put a password protection on my program
View 15 Replies
Jul 9, 2009
I have already a projet and now I wanted to protect this exe as after 60 of days of installation it should ask password to unprtect the exe.
View 1 Replies
May 11, 2009
I am making an program that stores most of my text files in it. So I need a secure password protection to protect my information's. I was told that MD5 will get the job done, so I used an MD5 protection to see if it'll be good. I gave the test program to a guy I know and he manage to get my password within a minute. (I am still a bit new to VB so which encryption to use...)
View 21 Replies
May 24, 2012
I am trying to figure out a way to implement password protection on documents that a program I am working on creates. They should remain with the document regardless of where it is copied to or sent.Here is a rough sequence of events:
1. Application Opens (no document loaded).
2. User opens document with extension registered to application.(could also be # 1 if they clicked on the document directly)
3. Application Security checks document for security and prompts if necessary.
4. If prompted, user enters password.
5. Application checks password.
6. If passed, document opens, otherwise user is notified of failure.
View 4 Replies
Dec 25, 2011
how to save data (for example some text that user type [as password etc]) and save that password on same location where is application. After saving I want to have also Load option so we can load saved data.
View 7 Replies
Sep 15, 2009
I would like to use only one user name and password to access two server. My sample codes as follow. re correct the codes
codes:
Imports System.Data
Public Class AlertControl
Public Shared Function LoginToAlert(ByVal alertUsername As String, ByVal alertPassword As String, ByVal testNumber As String) As String
[Code].....
View 1 Replies
Jan 5, 2011
I have two tables in one to many relationship in an access 2003 database.I am using vb6 and visual studio 2008.I want a data entry form (in grid view) for child table. I want to display & add, Update, delete child records accordingly with parent.
i.e. What I require is One combo box displaying a parent field and corresponding child entries will be shown in grid view. Data entry form for parent table may be on separate form.Is there a full sample source code for above mentioned theme.
View 2 Replies
Apr 20, 2010
I want to desing a form using Ms-access & Oledb connection Provider for data entry having following buttons:
1. Add
2. Edit/modify
3. View
4. delete
5. Exit
6. First record
7. Next record
8. previous Record
9. Last Record
10.Save
11. Cancel
12. find/Search
I want to desing a form using Ms-access & Oledb connection Provider for data entry having following buttons:
1. Add
2. Edit/modify
3. View
4. delete
5. Exit
6. First record
7. Next record
8. previous Record
9. Last Record
10.Save
11. Cancel
12. find/Search
View 2 Replies
Apr 21, 2006
i have been asked to make a form password entry but cant use a text box as it's opened from an MDI parent form so no main screen to speak of as such, my problem is at current the password works fine as shown below its basic stuff.
If InputBox("Please Enter Administration Password." _
, "Password Entry", "") = "trafficlight" Then
'Close current frmMDIChild and set the new form
[code]....
i want the input box to mask the characters been entered i know i could create my own input box and call that but is there a way to use the Default inputbox to mask the character input maybe watch the key presses saving input to a variable and displaying the asterix in its place? or am i overthinking it and there is a very easy solution like an inputbox that already masks input by a user.
View 4 Replies
Mar 19, 2010
I need to create a program that requires password entry. I was thinking of having a form that the user uses to set the password that only opens once (unless a button on the main form is clicked to reset the password.) once the password has been set, the form closes and another opens to enter the password and for each and every time the program is run. Another thing is that if the password has been entered wrong 3 times, the program gives a message box and closes on the ok button.
View 7 Replies
Sep 25, 2010
i dont know how to show the data in the ms access through visual basic, this is the form, if the details that are entered are correct, the password must popup i want it to show in the visual basic and here is my query, i dont know if this is correct, if you enter the "Question, and Qans" correctly, the password must popup
Dim retrieve = Me.LoginTableAdapter1.ForgotPasswordString(TextBox5.Text, TextBox6.Text)
If retrieve Is Nothing Then
MsgBox("Please the Correct Statement")
[code]....
View 7 Replies
Aug 18, 2009
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code:
Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
OpenFileDialog1.FileName = ""
OpenFileDialog1.Title = "C# Corner Open File Dialog"
[code]....
View 4 Replies
Jul 18, 2011
i want to check the validity by select data from access and then chek1-select data with (there are error)
Dim result
As
Object
[code].....
View 10 Replies
May 19, 2009
I'm trying to remember how to insert data in to a table. Here is my code
Code:
I get the error
Quote:
Number of query values and destination fields are not the same.
I also get some error about the Insert INTO part not being right somewhere. Am I doing this how you would do it, or how would you do something like this?
View 1 Replies
Oct 7, 2008
Using Access I created a few Data Access Pages. These web pages, once opened, work fine to manipulate data as intended, but they keep generating annoying warning messages.There are two messages that pop up every time the web page is accessed. Before the page opens the first message that pops up states: "This website uses a data provider that may be unsafe. If you trust the website, click OK, otherwise click cancel."After pressing OK on the first, the second message pops up and states:"This website is using your identity to access a data source. If you trust the website, click OK, otherwise click cancel."After pressing OK on both messages the page functionality works just fine.I've tried adding password protection to the database and even signing the project with a digital certificate, but I still get the warning messages. This would be fine except there are multiple end users for the access pages and I am trying to avoid the additional confusion this will create, especially since IT has restricted many of the users from editing the internet options.
View 1 Replies
May 19, 2008
See our Posting Guidelines for our policy on archived threads.I am confused as to where to place the following code snippet in my code. I put the function above my load event and the same exception still occurs:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
[code].....
View 1 Replies
Jun 21, 2008
I'm using XP and access 2003 and visual studio 2005. I created a project and connect this project with database access file. and I created some textboxes and command button on the form. Is possible to modify and add a new record to the database without using the navigation toolbar by insert a code in the command button.
View 1 Replies
Dec 22, 2008
I am new convert from VB6 and needs some help developing a stand alone application in VB 2008 that needs access to stored data values.All applications I have developed so far have been for computers that have either SQL Express or Access installed locally on the computer. This has made development really easy since I could use ADO to access and query the data.
The application I am now developing will be installed on a computer that does not have any of the MS office applications and I do not want to install SQL Express on the computer. But I still would like to use an 'ADO type' functionality to access, query and modify the data stored in the system.I started looking into using XML, but I was unable to find much information on querying and modifying individual elements.
View 12 Replies
Jul 15, 2009
I am looking to create a simple password box that will ask the user for a username and pass, if the user is validated against the usernames and passwords in an .ini file the login box will close and launch a program also stated in the .ini file. I would also like to be able to launch different programs for different users.
View 16 Replies
Jul 23, 2008
the access data are not getting reflected on the DataGridView unless the form is reloaded again. I am acessing the MSAcess data for back end processing (SELECT,DELETE)using odbc connection and displayin on .NET form using DataGridVew
View 2 Replies
Jun 8, 2009
I have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
View 1 Replies