I have a database with confidential data (to be used internally only). I do not want a person opening the database to get access to the tables or other elements.
All of the security setting on all computers are set to disable macros. So anyone who opens the application now has access to seeing the table eve though I have set all the ribbons, right click, etc so no user can get to them.
Is there a way to override the security alert so I can show it in a popup prior to load?
I created the .accde to distribute only the compiled file. But I have a problem. When you open the file .accde there is this problem of security: You can not determine whether the content is from a trusted source. Leave off the contents, unless they provide essential capabilities and the source is considered reliable. Open the file or cancel the operation? How Can I avoid the visualization of this security alert?
I have a user that has to enable the security everytime he opens a database I have. What would cause this? No one else has any issues and this user has all the permissions he needs.
My user opens frm_ENTRY. Which is pulling data from tbl_TEMP. They clean up a few fields on the form. Then click a button which executes an append query which appends the data to tbl_MAIN.
My problem is sometimes when it appends the data it is overriding older data. It is not creating a new line each time. It simply overrides an existing record. Does this make any sense at all?
There are many other forms, queries, tables and macros in this DB. If that matters at all. I think it has something to do with a bound form that is connected to a drop down from a query, but I have no way of trouble shooting this? Where do I start?
I need to alert the user of the database in case he/she enters a record that already exists in the database. If a person enters a key type and a serial number combination that already exists in the system and has status "issued", I need a pop up message to show up.
Am I missing some quotation marks somewhere in that DCount?
Private Sub SerialNumber_AfterUpdate() If DCount("*", "tblIssuedKeys", "KeyType = '" & Me.KeyType & "' And "Status = 'Issued'" And SerialNumber = '" & Me.SerialNumber & "'") > 0 Then MsgBox "This key has already been issued" Cancel = True End If End Sub
I have a form where I have buttons that apply filter to a certain column.How do I enable multiple filters where I can click more than 1 filter button and it keeps the filters?
First filter button:
Private Sub Command1_Click() DoCmd.ApplyFilter "Filter1", "[MyQuery]![Checkbox1]=Yes", "" End Sub
Second filter button:
Private Sub Command2_Click() DoCmd.ApplyFilter "Filter2", "[MyQuery]![Checkbox2]=Yes", "" End Sub
Third filter button:
Private Sub Command3_Click() DoCmd.ApplyFilter "Filter3", "[MyQuery]![Checkbox3]=Yes", "" End Sub
It works well, but one by one. How can each next filter be added to previous filters by clicking filter button on a form?
I have a button on a form that when I press it, I want it to validate a user's Windows Login ID in a text box on the current form against a table before allowing them access to a form.
If the Login ID in the text box does not match any value in the table I have defined, I wanted a MsgBox displayed saying invalid credentials. Of course if the ID exists in the table, I'd like it to open the next form.
I have a simple listbox (single column, no multi-selection).I want to enable a command button when the user selects an item in the listbox / disable it if no items are selected.I'm using the AfterUpdate event of the listbox, as follows :
Code:
Private Sub lstOptions_AfterUpdate() Select Case Me.lstOptions.ItemsSelected.Count Case 0 Me.comConfirm.Enabled = False Case Else Me.comConfirm.Enabled = True End Select End Sub
But when I select an item from the listbox, and debug the code, the Count is always zero? Even though I can see the item selected??
I have written code to look up a value in a table that then enables or disables a subform in my main form. The code works, but I know it is now as efficient as it can be. The main problem is that I have multiple values that determine if the subform should be enabled or disabled. I would like to use an IN statement but I'm pretty sure this doesn't work for Dlookup. Below is an example of the code I currently have:
Code: Sub enablecontrols(setting As Boolean) Inv_subform.Enabled = setting End Sub Private Sub Form_Current()
[Code] ....
Like I said, this works fine, but I am concerned if I need to add more items to look up and the stability of the code in general.
I'm new to access , and i need one of the common security in access , for example i create a new project and all the data has been secure but when open the database in start up that Security warning is appear.
However , now i want to disable that message box using vba or modules ...
User Security Levels and what users with those levels should be able to edit: 1. Admin - No tab restrictions 2. Test Bay - TabUnitInformation, TabLabelChecklist, TabTestBay 3. Returns - TabUnitInformation, TabReturns, TabDemoStock 4. Label - TabUnitInformation, TabLabelChecklist 5. Sales - TabUnitInformation, TabUnitHistory, TabDemoStock 6. User - TabUnitInformation 7. Technical - TabUnitInformation, TabUnitHistory
The code I have written ( which works for whichever tab control I list, but not sure how to write in more than one):
Private Sub Form_Load() Dim Security As Integer Me.TxtUserLogin = Environ("USERNAME") If IsNull(DLookup("UserSecurity", "TblEmployees", "[UserLogin] = '" & Me.TxtUserLogin & "'")) Then MsgBox "No UserSecurity set up for this user. Please contact Administrator", vbOKOnly, "LoginInfo"
On my form frmEmployeeDetails I have a text field that is named SSN for social security numbers. I have used the mask on it so it automatically inputs dashes. I am attempting to hide all but the last four digits of the ssn. This is on the on current event of my form.
Code:
'Hide SSN Dim strLSSN, strSSN As String strLSSN = Right(SSN, 4) strSSN = ("***-**-" & strLSSN) Me.SSN = strSSN
I am developing a database for our fleet of company vehicles. What I'd like to know is is it possible to set up some kind of alert where a dialog box appears (like the sort of thing in Outlook with reminders).
What I'd like is, for example, if a vehicle requires a service a pop up would appear, a couple of weeks before, when the database is opened to alert the user that it will be required soon.
If anyone knows how to do this it would be greatly appreciated.
I've read and gone though quite a few of the scrips and examples for creating logins and security and i'm getting to the stage when i need to have good understanding of the different methods.
Some of the examples whilst create a user login do not really allow for security within the database whilst the build in security wizard would appear to offer that functionality.
I am thinking that I will use the Workgroup file and that method. My question is am i able to utilise the fact that if a person 'AdamA' logs onto the database which is built into the workgroup security file. am I then able to take 'AdamA' to populate a table which records actions by a user? (I can't seem to find any thread or book reference to doing this)
I have a button on a form, when it is clicked it opens a video file located in a folder on the local computer. Each time the button is clicked a security pop up appears that says "Opening file://C:lahblahyadayadaFile.mp4 Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?" options are open or cancel. How can these messages be turned off?
I have already played around in the trust center of Access 2010 and changed the "trusted documents", "trusted locations", and "message Bar" tabs with no results. Do I have to play with regedit in windows to get rid of these pop ups? Or can I somehow use VBA code to disable them?They are just a nescience.
When I start my database, I would like a field to be checked for todays date. If the condition is true, I would like it to use an alert to tell me that the condition is met. Any ideas?
I have a form with a sub form. On the sub form I have #Ordered, #Supplied & #Used. These fields calculate to give the user the # in stock. This figure is displayed on the form. On the form I also have the Reorder level which is set by the user.
I would like to be able to make a message alert pop up when the database is opened or when any of these records show the # in stock is lower than the Reorder level, ensuring that we do not run out of stock.
My knowledge of access is pretty limited. Can anyone help me with this problem. I have some due dates entered into the database via a form. Is it possible to send an email alert say 1 month and then 1 week before the due date?
I have a screen that has 8 different buttons and clicking on any of these buttons generates an appropriate letter and once the button was clicked in also inserts a date, today's date.
Private Sub btnSecondReport_Click() On Error GoTo Err_btnSecondReport_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 '* Call the standard letter printing routine for this form.
Call StandardLetterVariables("Bd$50paid.doc")
btnFirstReport.SetFocus [DTSecondLetterSent] = Date
So I would like to create an alert that looks at this date and 14 days from that date will alert, remind whatever I want to do. I am thinking it wouldn't be too hard to create a reminder that pops up when the record is opened but I am sure users will want to be reminded without having to go into the record.
My question: can I and is it hard to create a reminder that will take care of paying attention when and who needs to be reminded or should I just create a report and let them run this.
I hope this makes sense and sombody has done this.
In my form I have a combo box. The combo box has several selections. I want a message box to appear after any but one of the selections within the combo box are selected. Thanks.
I have what is probably a simple question for regular Access users. Before I ask the question, here is a simplified version of the tables involved:
Structure of EMPLOYEE ===================== EmplID Name
Structure of TRAINING ===================== EmplID CourseID CourseName DateTaken
Data in EMPLOYEE ================ EmplID----Name 1234------John Smith 5678------Mike Smith
Data in TRAINING ================ EmplID------CourseID----Course------DateTaken 1234--------NS01--------HeatStreet--06/15/2000 1234--------NS01--------HeatStreet--07/11/2001 1234--------NS01--------HeatStreet--02/07/2002 1234--------NS01--------HeatStreet--08/22/2004 1234--------NS01--------HeatStreet--01/28/2006 1234--------NS27--------Lockout-----01/06/2002 1234--------NS27--------Lockout-----01/27/2004
Its easy enough to join the two tables in the query and return ALL 9 training records, but I would like to find a way to display only the most recent occurance of each employee taking a course. ie, the max date for each unique EmplID-Name-CourseID-Course combination:
I thought maybe "GroupBy" on EmplID, Name, CourseID and Course and "Max" on DateTaken would do the trick, but apparently not. Is there a way to do this without code?
I've been searching the threads, but to no avail! (be gentle - a curious beginner in a crazy world of demands!)
My database (table) has a date field, when this date is 'now()' I need to send a reminder email to a 1 collegue and 'cc' 2 others. And automatically change the background colour of the date field; say to red.
A step by step guide would be great, or a nudge in the direction of a good example would help,
