Recent content by DanDarwood2004

I have found the answer in another thread: set the properties of the image layout to Behind text.

I am successfully updating fields within the header of a document using the below code: Dim myStoryRange For Each myStoryRange In objWord.StoryRanges myStoryRange.Fields.Update While Not (myStoryRange.NextStoryRange Is Nothing) Set myStoryRange = myStoryRange.NextStoryRange...

I am currently using this: http://www.mvps.org/access/api/api0001.htm to browse and open files and it does the job very well. I am wondering however if there is a way to change the folder view from "List" which appears to be the default to "Details", and then have the "Modified" date...

UNIONS did the trick thanks. Dan.

these tables aren't related to each other but as I they all have the date as a primary key I thought that I could link them in a query (if I had a global date table then they could all be linked to that I guess and all would be fine).

The thing is that I am pulling quite a few tables together in the one query so would I not need a situation like: SELECT ... FROM MyTable1, MyTable2, MyTable3, MyTable4 ... WHERE MyTable1.DateField = Date() AND MyTable2.DateField = Date() AND MyTable3.DateField = Date() AND MyTable4.DateField =...

I am trying to write a query that pulls information from a number of tables which are used as daily logs (with date as their primary key) for the current day. Not all of these tables are updated every day so I need a universal/system date to link them all together. I tired to use a query that...