Recent content by Vittles

MS Access 2003 Report VBA coding that looped through the report and assigned a number based on a single field to add a table of content page numbers to first page (report header) doesn't fully load/activate unless the user switches to design view and then back to print view. I am having IT...

I have a report with a Table of Contents created in the Report Header. Then the page numbers for the actual data sections should start after the report header/TOC section. This would be easy if the TOC always took up one page, but depending on the amount of data, it can fill more than that...

Thanks for cleaning it up for me. I am just starting to play around with running excel macro code through access, so it is really nice to see the ways to shorten it. It works really nice for end users as they don't need to do anything but download the original file & then click a button on an...

At the end of the day, this is the code that seems to be working - open for any ideas for easier ways/shorter coding: Dim strFileName As String Dim xlApp As Excel.Application Set xlApp = New Excel.Application xlApp.Visible = True xlApp.Workbooks.Open Me.Admin_Link For Each c In...

I have a database form that is set up as an interface for importing data from an excel worksheet (the worksheet is generated from a different/larger system with a lot of data I do not want imported). When the user selects the appropriate file (me.admin_link) and clicks an 'import data' button...

I have the following code in place: Sub FileNew() SendKeys ("%2") Dialogs(wdDialogFileNew).Show End Sub Is this what you are taking about or ? I use VBA in Access, but don't have as much experience with MSWord. I am open to any ideas that would make viewing a large number of...

We want to use the Workgroup Templates Option in Word to set up a forms directory (so our staff doesn't open/re-save master forms) and our IT dept. may not want to delete the standard tabs/templates. Is there a way to set the sort order of the tabs on the File New Dialog Box/change the...

Thanks for responding. I am not sure I know what you are asking...but here are more specifics. I am using Access 2003. I have tried putting the control source of: ="{Insert Reviewer Last Name First Initial[AU] } AND (2003 [DP] OR 2004 [DP] OR 2005 [DP] OR 2006 [DP] OR 2007[DP]) AND (" &...

I have a form with a multi-select list box that I use to filter several reports. If nothing is selected and the button for a report is clicked, all of the data is given, otherwise, if one or more people's names are selected only the data related to the selected individuals is shown. So far I...

This variation doesn't work - is it correct? Also, wouldn't the IsNull(Inst Name]) criteria put those that are null first in line not at the end? If Forms![Main Review Form]![View Type Subform].Form!View = True Then Me.OrderBy = "IIf(IsNull([Inst Name]), "1", "2" & [Inst Name])" Me.OrderByOn =...

I have a form that has a toggle button in a subform that changes which subform shows up and the related sort order (among a bunch of other formatting options). The orderby section (form open event) looks like this: If Forms![Main Review Form]![View Type Subform].Form!View = True Then Me.OrderBy...

Thanks! I did make that change, as seen in the revised section code below (in case anyone else has this issue). In order for the report to not list the other timelinebars at all, I also had to make the 3 timelinebar text boxes contain an IIF(IsNull(Receipt Date), Null, [Project Title])...

Thanks to Duane Hookom's example database I was able to set up a simple timeline report that worked great. However, when I modified the code so that I would use it for a series of dates attached to one project (each project can have up to 3 spans using 6 total data fields from an external...

Thanks Duane! I will have to play with that & see how it works with my data. Trying to learn visual basic as I set these up, so examples like that are great!

Thanks for your response! I was wondering about doing a visible and backcolor property variation of coding instead where there would be 12 textboxes (12 months) across a page and then based on the value of the start date or end date I would make the box visible and contain a date, colored in...