Search results for query: *

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

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

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

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

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

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

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

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

I have a table with 15 to 20 records in it. Only one field. I use the table for a combobox drop down list. I need the entries to appear in the order I enter them into the table, therefore no querries, sorting etc. At times, I need to insert a new list item for example between the 12th and...

Hi all, Is there a way to programatically 'fill in' a label or text box in a report? In the following code (which I got from Spenny and modified slightly): strDocName = "Status Actualis-UnitBatch" DoCmd.OpenReport strDocName, acViewDesign Set rpt = Reports(strDocName)...

I have 2 reports. Same report, same query data source. One report I need ordered by last name, the other I need ordered by date. The reports are called up with a button. The button opens a form into which the user enters a number of parameters. The base query gets these parameters (i.e...

In Access 2007 in the Sort & Filter box, under Advanced, there is an option to clear all filters that becomes enabled as soon as you filter anything on the form. In not only does not apply the filter, it eliminates it. I have a couple of reports that pick up the form filter (.ME filter). Once...

In Word 2007, I have set as the default to save as MSWord 2003 documents. When I open and modify any password protected document (all of mine were created in MSWord 2002) upon attempting to SAVE, I always get a dialogue asking if I want to save as XML format, that it is a more secure...

I know that the Ribbon and the right click provides a "clear all filters" option. But, I want to add a button to a form that will do this. It is not one of the options available in the Control Wizard. Thanks for any help you can give. McLigs

I have a new Dell 9400 Inspiron running XP Pro SP2. I have Office Pro 2007 and Front Page 2002 installed. Both are working fine. In Windows Explorer, I am trying to open an html and/or htm file with FrontPage. When I highlight and right click the file and select "open with", Front Page is...

A fellow worker has developed an mdb database. However, it will only run on his computer. He wants to share it with others in the company but does not know how or why it is restricted. When I open it on my computer, I get a dialouge box stating that I do not have read/write permissions. He...

Hi Everyone and Happy Holidays! Apoligies. I had posted this question previously in the wrong forum. I need to create a button on a form that will export a query (MyQuery) in Excel 97 - 2002 format. The name of the new Excel File is not that important, although it would be good if it was...