Recent content by BitZero

Here's a "divide and conquer" approach. First, create a query named qry_cfattrib_FY that looks like this: SELECT a.*, [Fiscal Year] FROM sysadm_ps_x_s_m_cfattrib AS a WHERE a.effdt between cdate("7/1/" & [Fiscal Year]) and cdate("6/30/" & ([Fiscal Year] + 1)); This query uses the [Fiscal...

Thanks for the quick replies. I don't think .InsertFile will work in my case because I'm not copying from a File but a Document object, but I will definitely remember that one. Looks like I'm stuck with the copy/paste, although my code is now a little simpler.

I have some VBA code that copies the contents of one word document to the end of another. The code looks like this: dim obj_Work_Doc as Word.Document dim obj_Output_Doc as Word.Document obj_Work_Doc.Activate obj_Work_Doc.Application.Selection.WholeStory...

Here is some code that shows processing for multiple tabs (or sheets) in a spreadsheet. This code is simplified to show an example of handling multiple tabs. It doesn't have error handling or the actual code to copy data into a table. When working with spreadsheets, there are 3 levels of...

I periodically download (large) zip files from a website, and I would like to automate the process in VBA. The website url is of the form http://xxxxx/xxxx/xxxx.asp, and then I click on a link that displays a File Download window with Open, Save and Cancel buttons. I click on Save and save it...

Thanks - I appreciate your help.

Thank you! That removed everything from the File tab, including the Privacy Options. Is there also a way to make the red "File" at the top left go away?

I'm using Access 2010. Is there a way to turn off the "Backstage" (i.e. "File") tab at the top?

Sorry - I'm still confused. InlineShapes is a property of a range object. What property do I use for "text wrapping options"?

Thanks Skip and Andy One more question Skip: how do I position the text to the top right of the page? The code above puts the text under the picture.

Hi Skip This code is from the macro recorder. How do I control exactly where the picture and text are placed? Selection.MoveUp Unit:=wdLine, Count:=9 Selection.InlineShapes.AddPicture FileName:= _ "c:\MyStuff\Logo_Acme_Bolts.png", LinkToFile:= _ False...

I'm trying to do the following with VBA code: Open an existing word document Insert a picture (company logo) from a jpg file at the top left of page 1 Insert text (company name and address) at the top right of page 1 Format the text (bold, font, etc) What is the command to move to the...

Yes - compact and repair didn't help.

I'm using Access 2003, and I have a program that gives me this message every other time it is opened: "The document xxxx.mdb caused a serious error the last time it was opened. Would you like to continue opening it?" I don't know what triggered this message. I've tried going to Help /...

I have an Access 2003 database, and a little vbs program that runs every night to refresh a table from the mainframe. The vbs program looks like this: dim objAccess set objAccess = createObject("Access.Application") objAccess.OpenCurrentDataBase "c:\myDir\myProg.mdb" objAccess.Run...