Search results for query: *

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

I need to set up a pivot chart or table that looks like the basic example below: Oct Nov Dec.........Sept Project1 SD----------ED Project2 SD-----------------ED This is similar style as a MS Project timeline, but all of the data is in an Access database. We may need this...

I found a solution to my own question, but wanted to add it to my post so that others could have the information... In order to append only changed records: I first added the initial data records from the first downloaded excel file to the actual database tables. Then I created a select query...

Since listing this post, I have designed macro/code to import each table via a data/import table created for each upload. It was fairly easy since I had already created a macro in Excel that split the information into 2 worksheets (within the same workbook) based on the Access table structure...

I am used to MSAccess, but I am new at importing data on a regular basis and then appending it to multiple tables. Each week we download a set of information into an excel spreadsheet from a larger system. I have a macro set up that limits the information in that spreadsheet to what we need to...

It worked great. Thanks! Just for future info: I put a "total count" textbox with a value of =count([ID]) in the reporter header and a "group count" textbox with a value of =1 and the running sum property set to over group in the group header. I set the "total count" visible property to No...