Search results for query: *

I created two seperate macros, one that adds the images as header/footer and sets the margins accordingly, and another that removes them. Works like a charm and achieves what I was after. Thanks very much for your help!

Well, that explains that! Thanks for the insightful article. Would you recommend instead using a macro to set the header/footer as opposed to applying a new template? Is this easily achieved?

Hi all! I have a simple VBA macro in Word 2010 that is designed to apply a template to an existing document. The template is simple and contains only a .jpg image in both the header and footer (to mimic the client's letterhead). However, when I apply the template to an existing document, the...

Doh! That did it. Thanks for your help dhookom!

Hi everyone, I have a simple block of code that reformats the text in a specific field after importing an Excel spreadsheet. I set it up as a sub accepting 2 variables, but I when I try to launch the sub using the following: formatlocations("Inventory_Snapshot", "Location") I get "Compile...

Hi everyone, I am wondering if there is such a thing as a graphical control that shows how much offset you have between a center value. Kind of a like a progress bar that starts in the middle of the control and fills either left or right of the line depending on the value feeding the control...

Hi everyone, I have a report that contains a chart built off of a saved query. The x-axis of this chart is a list of dates. What I would like to do is give the user an option based on a set of radio buttons as to how they would like to group the dates: daily, weekly or monthly. How would I...

It doesn't recognize the "DisplayFieldList" property. Is there a reference I need to add before that is available?

I would prefer to keep the application as self-contained as possible for ease-of-use, so any suggestions on manipulating the pivot chart via VBA would be extremely helpful.

Hi everyone, I have created a pivot chart in my database to help users more easily analyze data. When this form loads, however, the pivot chart field list defaults to being not visible. Could someone let me know the command I can use in VBA to set the field list to visible when the form...

I am using the docmd.transferdatabase method to move a table from one Access database to another. I want the new table to import and amend an existing table, but instead it keeps creating a new table (so instead of amending "mytable" as I indicate in the code it creates "mytable1"). Does...

Thanks very much lameid. I'll look into what you suggested and post back how I make out!

Hi everyone, I am just wondering if it is possible to open a Word or PDF document from Access and have it display a specific page based on criteria from within the code? So if the code specifies that page 30 should be opened, can it launch the appropriate application and display page 30...

Hey guys, I need VBA to compact a database for me but first I need to make sure the database is not in use by the front-end application. Is there a quick way to disconnect from the back-end to ensure the compact will go smoothly? Regards...

Worked like a charm. I just had to add a .requery line in front of it to make the #DELETED records were cleaned up. Thanks very much!

Hi all, I have some code that needs to skip to a certain line if a recordset contains no information. Is there a simple command to check if a table has any information written to it or not? I tried the .recordcount property, but since it checks for records accessed it isn't returning a 0 or...

Fantastic! Thanks very much Remou!

I think I like the option of utilizing the keydown option from the form properties. Would it be possible to get a simple code example of the syntax to use this function?

Hi everyone, This is probably more basic than I think it is, but I would like to do is enable a form to recognize a combination of keystrokes in order to trigger an event (ie. ctrl+j fires a VBA subroutine). Is there an easy way to go about this? Thanks in advance!

Hi guys, I'm trying to use VBA in Access to shell out to an Explorer window and move the cursor of a mainframe style interface to a specific set of coordinates. The shell I have working no problem (AppActivate "Window",True) but I don't know what the VBA command is to set the specific cursor...