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!

Register Log in
  • Congratulations strongm 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. swykpisz

    If statement execution

    What would the code be if I wanted to execute a condition if a query was null? I have something like If "qryData" = Null Then Msgbox "No Data" Else Msgbox "There is Data" End if The part I'm confused at is what command do I use to check if query qryData is Null?
  2. swykpisz

    DoCmd.OutputTo

    I've tried changing the format of the font in C:\template.html but this does not change the format of the output. Is there a certain template or content in the template that needs to be there?
  3. swykpisz

    DoCmd.OutputTo

    So I've gotten this far but not sure what the template would be, like the coding. I tried to make a template to enlarge the font. This is what I have; DoCmd.OutputTo acOutputQuery, "Messages", acFormatHTML, "C:\MessagesForAssociates2.html", 0, "C:\template.html" The html code for the template...
  4. swykpisz

    DoCmd.TransferText acExportHTML

    So I've gotten this far but not sure what the template would be, like the coding. I tried to make a template to enlarge the font. This is what I have; DoCmd.OutputTo acOutputQuery, "Messages", acFormatHTML, "C:\MessagesForAssociates2.html", 0, "C:\template.html" The html code for the template...
  5. swykpisz

    DoCmd.TransferText acExportHTML

    When using this command above, is there a way to determine the font size of the final product? I'm exporting a query but need the font size of the information bigger like 24 font
  6. swykpisz

    Password protect one field.

    Is there anyway someone can post the VB code you used to protect the field within the form?

Part and Inventory Search

Back
Top