Search results for query: *

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

AceMan! THANKS!!! Worked perfectly!!!

I am using Access 2007. I have a table in which the various individuals are classified as to the 'group' to which they belong, e.g. AG = Action Group; BC = Best Chance, etc. I am trying to use a combo box to allow the user to filter the records by the group {GR} they want to see. I created...

In my input form, I have a control for Email. I have set it as a hyperlink, and entered the desired email address. I set it to display as hyperlink. I want to include this field in a report that I am printing, but I get something like the following when I try and print it: John...

Thanks so much Lilliabeth! Worked like a charm. McLigs

In working on a design for business cards using MS Word 2007, I sent the company logo behind the text. Now, I cannot find a way to select the image so I can modify it, move it, etc. I then tried the same thing with Word 2003 and had the same problem. How does one select an image once it has...