Recent content by tedward

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

And Sir you are exactly right. You have solved my issue for which I greately appreciate. I have put the program through its paces and it works flawless. Changing YearDate to a number was all that was necessary. :)

My table has the following fields: YearDate as text, ID as Number, and the name of my table is "tblYearDate" I am using before update for my code. When I substitute ID for Unique Number and YearDate for Fiscal year I receive the following error: Data type mismatch in criteria expression. Any...

I can change the year at the start of the new fiscal year and add leading zeros without any problem. Resetting the records to one (1) to start over at the new fiscal year is the problem. This seem to be a very difficult problem to solve. The logic is difficult to solve with Access VBA...

I plan to keep the records which will be tied to a year date. For instance 2012-00001, etc. This is for historical reasons. Thank you for replying.

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...

How might this code be changed to reset at the end of th fiscal year, Sept. 30th. instead of the calendar year' Thanks, Tedward If IsNull(Me![BaseID]) Then Me![BaseID] = Format(Nz(DMax("[BaseID]", "[tblTest]", "[YearID]='" & Year(Date) & "'"), 0) + 1) End If Me![CustID] = [FormatID] & [YearID]...

How do I: ‘This code increments a number starting with one Me.VMD.Value = Nz(Me.VMD.Value, 0) + 1 ‘This code changes the year in my table after Sep. 30th of each year StartDate = 2012 If Date > DateSerial(StartDate, 10, 0) Then YearDate = Year(Date) + 1 If Date <...

Me.Text0.Value = Nz(Me.Text0.Value, 0) + 1 This works absolutely great but how does one create a records of each number generated in a table. Thanks, Tedward

Thank You. I will see if I am experienced enough to make this work. I deleted the extra post.

Thanks for the reply. I will see if this will work. Both tables will contain the same data.

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...