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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.