Recent content by McLiguori

Thanks Chunter33, In 2010 when you insert a button and the wizard comes up, and you choose any operation, i.e. Record Operations, open, add new, delete, etc., or any other thing and you let the wizard do its thing, it generates an embedded macro. In 2003 and (I believe 2007) it would generate...

When I use a control button wizard to create an action button, e.g. Add New Record, Access 2010 outputs an embedded macro which I later have to convert into VBA code. Is there a setting I can use to have the control button wizards output code instead of embedded macros? Can you please tell me...

I have a password protected Access database created in 2007. I then later upgraded and am now usind Access 2010 Professional on Windows 7. I am trying to remove the password protection with: 1. Open db in exclusive 2. go to info 3. The next instruction MS gives is to click on decrypt...

I have a report based on a members table. The report contains a sub report based on an 'activities' table listing the activity date and type of activity. The report gives member name and some member info, then a listing of the 'activities' relating to that member. All this works fine. The...

Thanks Tony.... That did it!!!!! McLigs

Hi all, When one creates a footnote in 2007 Word, a short line is automatically inserted dividing the footnotes from the text. However, if you have a long footnote that spills over into the next page, the dividing line that appears on the second page is no longer short. It goes the width of...

Thank you very much Ed2020. As I have limited knowledge of Access coding, can you tell me where I would insert the code given in the link you provided. Where would it go in relation to the code I provided in my original post? Does my code need to be included somewhere in the code provided in...

I have a database in which I have included a button to backup the database using the following code: Private Sub Comand58_Click() filename = "c:\Database\Journals.mdb" Set fso = CreateObject("Scripting.FileSystemObject") Set mainfile = fso.GetFile(filename) mainfile.Copy "I:\BACKUP of Journals"...

THANKS PHV! WORKED PERFECTLY!

Thanks PHV. I have an OOPS in my original post. I did try what u suggested: Me.FilterOn= False Me.Filter = "" I mistyped the second line of code as: Me.FilterOn = "" Sorry! Your suggestion clears for the session, but leaves the filter saved in the filter property of the form (under the data...

Using Access 2007. When I apply a filter to my db, if I save and close, the next time I open the db, the filter is still present. If I select Clear All Filters from the ribbon, this does not happen. The filter is completely cleared and the db reopens with no filters applied. I want to...

Thanks Remou. It worked like a charm!

I have a form in which I want one of my controls (a date control) to default to 31-Dec-Current Year. I have managed to do this and it works well. In the control's properties I have: Default Value: 31 & "-" & "Dec-" & DatePart("yyyy",Now()) Input Mask: 00\->L<LL\-0000;0;_ Format...

Thanks Duane, I couldn't get your suggestion to work (probably doing something wrong!), but it gave me the lead I needed. I ended up making the record source of the module the same as the personnel form. Then in the module's 'open report' button I included the following: Me.Filter =...

I am using Access 2007. I have a form 'Personnel' on which I have buttons to print reports. The buttons open up a modular form, i.e. ageinstructios, in which the user fill in some of the parameters fo the report, i.e. date to which to calculate the age, status, and group. On the modular form...