Databases
StackOverflow2013
Usersdbo
USMike
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USMike
    primarykey
    data
    text
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. POHow do I search a column for any cells with dates earlier than a specific date and highlight them?
      singulars
      1. PTQuestion
    1. POHow do I copy specific text from a document in edit mode and add it to the subject line?
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COAfter trying your suggestion of using .htmlbody, I like this approach even better than the find/replace approach I posted below, as the code is much simpler. Unlike the find/replace approach, this doesn't let you undo the change it makes when you run it... I first thought that was a bug, but I now realize it's a feature. If I add that code to the end of the macro that opens my template, it quickly adds the dates without letting me undo anything, so it looks like the dates were part of the template all along. I still don't know how to get the workday number of today, but this a great start.
      singulars
      1. PO
      1. USMike
    2. COIf you take a look at the answer I just posted, I think I solved the first issue using a different find/replace method, so the formatting is no longer an issue. For the date, I know what you're talking about, but I can't figure out how to write that code. More specifically, I don't know how to get the workday number of today.
      singulars
      1. PO
      1. USMike
    3. COI've had years of experience with Word VBA, but I'm really a beginner at Outlook, so I really can't answer your question about why I did something like using `SendKeys`, other than to say I found the example online and made tweaks to it. As far as the code for generating the email, it's really nothing special. I just created an email with some text, tables, and my signature, and saved it as a template. The macro simply opens that template, so that I can manually fill in the blanks and hit Send.
      singulars
      1. POHow do I set up an email template with dynamic dates or alternatively, create a macro to insert a date?
      1. USMike
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload