Search results

I have a filtered form with a button which uses “DoCmd.RunCommand acCmdAdvancedFilterSort” to open a query. This code is in the form’s button on click event. When the query opens, how do I save it for example as QueryX. In addition, with each new filtered records I want to use the button to...

Anyone have code to hide an individual 2010 navigation tab until a password is accepted? Thanks, Tedward

I would like to use a control button and an UnBound field on a form to obtain a unique record number in Access 2010 starting with 00001. The number will be incremented by 1 each time the control button is selected. The difficulty is on Oct 1st of every year the record count has to auto reset and...

I have an access 2010 table which has several hundred items. I use a control button when I need to delete any of the items from a table titled MainTable. However, instead of deleting the item(s) I would like a control button to remove the item(s) from the MainTable and place it in a new table I...

Example 1: 2011-1 ....... 2011-3893 etc. Currently I have an Access form which produces a new unique number to identify each new record created. To do this I use the unique ID autonumber from a table to identify the new records. I would like to change from this simple...

How might i allow users to change their user login password access 2007. Following is the simple code that I use for the ctrl button. Private Sub Command2_Click() If Me.Text0 = "named password" Then DoCmd.OpenForm "Form name" DoCmd.Close acForm, "frmpassword" Else MsgBox...