Search results for query: *

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

Skip Thanks for the reply. I discovered (after much Google searching) that in Access you can do a Get External Data / Link Tables, search for files of type Exchange(), and select the Global Address List Address Book. That is much simpler than writing a routine to get the data.

Can someone provide some me with VBA code that will read thru the names in my Outlook Global Address List and get names, phone numbers, and email. Thanks

Duane I was able to get it to work by modifying the front end query as you suggested. Thanks Regarding having a separate front-end file for each user, could you explain some of the advantages of doing that? It seems like it would be a lot of extra work. If a changed is made to the front...

Duane Thanks for your quick reply. Everyone shares the same front end mdb file. They connect to a common server via remote desktop.

I'm using Access 2003. I have a report that is run with a wherecondition. The SQL in the wherecondition is rather complex. I just added a subreport that uses the same record source query. How can I get the subreport to also use the wherecondition SQL for selection? Several people can be...