Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DanDarwood2004

    Updating header fields deletes image

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

    Updating header fields deletes image

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

    API File Open/Save dialog box; folder view settings

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

    query multiple tables using the current date

    UNIONS did the trick thanks. Dan.
  5. DanDarwood2004

    query multiple tables using the current date

    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).
  6. DanDarwood2004

    query multiple tables using the current date

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

    query multiple tables using the current date

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

Part and Inventory Search

Back
Top