Using Comboboxes To Spellcheck And Protect Bad Data?
Jun 11, 2006
I'm trying to make my database easy as possible for everyone to use while protecting against potential typos and the likes. I then had an idea and wanted to make sure if that was in line with accepted practices everywhere else. After all, just because you can do it, doesn't mean you should.
Would it be reasonable to have fields that would likely to have repeating data across various records to be a comboboxes. The fields I'm thinking of are City and ZIP code, which I would start with some more common ones, and allow users to add new ones while having the benefit of auto-expand as spell checker and reduce possiblity for bad data.
I'm not sure what ramifications that may have on forms beyond the fact that more lookup tables=slower database, especially over the network.
So would you want to make city or zip code or other similar fields combobox instead of a bound textbox?
View Replies
ADVERTISEMENT
May 9, 2006
i have a users table where i save usernames and paswords. So anyone who has access to the users table and has little know how of access can read the passwords of other users. So I have encrypted these passwords. Now no one can read eachothes passwords but if someone has acess to the database he can copy his encrypted password to someone else's password and login using other people's account.
Any solution ????
View 1 Replies
View Related
Sep 15, 2005
I created a form for project tracking. The form has a project name field in it that is a required field. The manager fills that out first, but may go back later to fill in additional data. I created a button to allow them to search for a project name, but they keep opening the form and typing in the project name they want to search for in the project name field of the first record that appears. This changes or deletes the project name for the record they typed in. Is there a way to prevent them from typing in that one field after a project name is initially entered?
View 5 Replies
View Related
Jan 23, 2015
I have 2 combo boxes on a form. The 2nd box is not visible unless the 1st box is set to a specific value (Illness). Once the specific value is set, the 2nd box appears with appropriate data for selection.
Goal #1:
I would like to have the form checked before it is closed to ensure that if the condition in box 1 is "Illness" then the 2nd box must have a value and can not be null.
Goal #2:
I am also having problems with the 2nd combo being visible when form opens or becomes current. The field is set to visible=false normally but needs to be visible when form opens if the conditions mentioned above are meet (true).
Private Sub Form_Unload()
If IsNull(Me.Incident_Classification) Then
MsgBox "Please select a type of Illness"
Me.Incident_Classification.SetFocus
]Code] .....
View 3 Replies
View Related
Jun 25, 2006
Hello, I'm trying to use information based on items selected in a combobox in the main form. Once the user selects the desired info in the comboboxes on the main form, I want the subform to display the data that matches the search criteria in the main form. For instance, if I select a job number, I want everything that matches that job number to be displayed the subform (along with the corresponding job name, version, etc.). I also want to get more specific in a search where I could select a job number, job name, and job version from the comboboxes in the main form to where all the data that matches the search criteria in the main form will be displayed in the subform.
Attached is what I have so far. The form I'm trying to perform this in is the SearchByResults form and the subform is the qryk95 form. I'm trying to populate this using the K95-Template table. I performed a query (qryk95) to select only the fields I want to display in my subform. Any help would be much appreciated.
View 6 Replies
View Related
Mar 27, 2013
I tried and failed to get this to work using a multiselect listbox..I have a list of departments in tblFunctionalArea...My main table is tblStatic..I want to be able to for each record select multiple departments affected by a record and store them in the tblStatic.After looking around i couldn't find many people successfully maanging to store listbox values in a table...
I decided to create 5 fields in tblStatic and in my form create multiple combo boxes cboFunctionalArea1, cboFunctionalArea2 etc etc which are bound to these fields.I want to be able to ensure the list for any combo box requeries and takes out any selection in the other boxes.
I have this working in a strict cascade fashion i.e. in cbo1 all dept's visible, in cbo2 it takes off whatever was selected in cbo1 etc. But if someone then jumps back and deletes the content of cbo3 then the whole thing breaks or if they amend in the wrong order it breaks
View 2 Replies
View Related
Dec 7, 2006
one form in my database?
I would like to put a password on one form; all other forms are open to see.
Can this be done?
View 1 Replies
View Related
May 25, 2005
I have a split database. BE located at a server and FE on each users workstation. There are 8 concurrent users at the most. This runs smoothly over the LAN.
Now I'm adding a new feature to the database. I'm using a wheel loader to weigh products on a weight scale. The operator in the wheel loader is going to use a laptop with wireless LAN to connect to the network.
In risk of loosing the connection which in worst case might corrupt the database, I want to make a new database with a BE/FE setup. The BE will be placed on the same server as the current db. The FE in the wheel loader. I can then link from the current db (BE) to the new db (BE).The new db will only require two linked tables from the current db.
If worst case happens, would my current db be more protected against corruption than if I linked directly to the BE on the current db. I know there's no 'right answer' to this one, but I'd really like some opinions on it though.
Thanks in advance.
View 5 Replies
View Related
Jun 17, 2005
I have an Access 2000 split into FE and BE and the client has requested the BE be password protected. I attempt set database password on BE but then when I open FE I get error msg " not a valid password". I get the same error message if FE has same password or if FE has no password.
Any ideas?
Thanks,
Jim
View 3 Replies
View Related
Dec 6, 2005
Hello,I need to know is there any way to protect a shortcut on desktop ?Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.Any idea..?With kind regards,Ashfaque
View 1 Replies
View Related
Sep 19, 2006
Hi,
Is the password property in Access secure enough to protect VBA code?
Regards,
B
View 14 Replies
View Related
Aug 28, 2007
Hi
i am wondering if it is possible to password protect a form?
I am building a DB which will hold personal information, all this info will be held in a table and displayed on a form, but I would like it so that the user has to enter their user name and password and only the form which relates to their details opens ( so like an open form and display specific field but passworded)
Any ideas?
View 3 Replies
View Related
Dec 2, 2004
hi,
Is it possible to password Protect a table in Access 97?
I need to limit who can actually go into the raw data table as even though it is hidden, a user can easily unhide if they knew how.
any ideas?
View 3 Replies
View Related
Aug 27, 2005
How I can protect the tables in a database and force the users to access them only through 'forms'. In other words the user will not be able to view or change the data in any table except through a form, when loading a form, the protection is diabled.
I need a total solution, I am not a powerful programmer. :confused:
View 2 Replies
View Related
Jan 25, 2005
Is there a way to password protect a form.
This is due to me having to send a mdb file, because i use A97 and the other end use A2000.
I tried sending the mde file but they could not convert it etc.
But i want to stop them getting into the code, you know how protective we are.
I want to hard code the password if thats any help.
Could some one please help me, thanks
View 4 Replies
View Related
Feb 3, 2005
Can someone point me in the right direction of how to protect a button using a password please
cheers
Andy
View 1 Replies
View Related
Feb 11, 2005
How can i simply prompt the user for a password when they click a button, if the password does not match the form will not open?
View 1 Replies
View Related
Feb 14, 2006
As you can tell, I am trying to password protect a report.
This works great, but if you don't type anything in, all the employees names come up. How can you prevent that.
Like [Enter Employee Name Only] & "*"
Any Ideas
View 3 Replies
View Related
Feb 3, 2005
Can someone point me in the right direction of how to protect a button using a password please
cheers
Andy
View 7 Replies
View Related
Feb 15, 2005
is there *any* way to lock down a db so that a user can't import your tables and queries? i know an .mde prevents the importing of forms, but i don't want ANYTHING to be able to be exported. i'm thinking this may not be possible.
View 1 Replies
View Related
Feb 15, 2013
1. How to protect my access database. That is can i only let my boss to use ONLY and not see the struture / table relationship?
2. That i can use access table to call file form my computer desktop outside folder. Can i set the limit time for outside folder?(for example 3 days, after 3 days then the folder will damage or not exist? can i do that?
3. can i set the password and after some days(for example 2days). they cannot go into my access database?
4. can i make my access database only for use only, cannot copy and can i set the life time for my access database (for example maybe 2 days,
the access database cannot open. )
View 4 Replies
View Related
Sep 6, 2005
Hi,
How can I hide the Database window with password protection?
For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...
Thanks for your help
View 1 Replies
View Related
May 24, 2006
Hi all!
I have some Access 2000 VBA code which opens all of the Excel 2000 spreadsheets in turn in a particular folder. However, if one of the spreadsheets is password protected I want to ignore this file and move on to the next one...is this possible?
Any help most appreciated.
Neil
View 1 Replies
View Related
Feb 20, 2007
Ive searched the forum and not found any threads relating to this. Some help would much be appreciated!
View 3 Replies
View Related
Dec 16, 2007
I finally got a chance to test the setup remotely, and it basically works with all the links I've set up.
I wanted to see how it would behaves should it disconnect or something and thus manage it gracefully.
First, I broke the network connection and tried to navigate to next record. Instead of getting a error message, Access just crashes. I'm not sure if this can even be trapped at all.
Secondly, I disconnected the connection then reconnected it. Access then tells me that the server has gone away, presuming because it's still looking to the old connection that was broken. Running the code to repair link fails also with same error. Can this be resolved with having to quit & restart Access?
Thirdly, I put a breakpoint on Form's Error Event but this doesn't seem to always to catch all errors. It does catch error if I tried to start up a form without the connection, but if it already has been started, and the connection was broken, the Error Event is never fired even though I get a dialog saying ODBC Call failed, then a zillion of dialogs saying Object no longer set or invalid. This would be extremely annoying to my end users.
Can any of those be avoided or fixed?
View 9 Replies
View Related
Oct 28, 2013
i was just wondering if it was possible to password protect a report. so for example when a user clicks on the button from a switchboard a password prompt would open up and if a user entered an incorrect password the report wouldnt open up.
View 2 Replies
View Related