Search results

the problem with your example is the extra spaces and the string inside the string Nz(txtContract, " '' ") should simply be Nz(txtContract, "") > constructing an SQL string in code so maybe Nz(txtContract, """") or Nz(txtContract, '') inside a string delimited with double quotes, if you want...

ps, @mastermithi, adding on Here are a couple videos about Access reports that might be helpful for you: Create a Grouped Report using the Wizard in Access, then Modify it Polish Reports in Microsoft Access

hi @mastermithi the wizard is limited. To get more controls containing fields, you need to modify what the wizard creates -- or just make a custom report to begin with

ps, @GUIDO22 As for records in tables, the dates stored in MSysObjects and the tabledefs collection are for when design changes were made, not when records were added or changed. To track that, it's helpful to add these 2 fields to every table: dtmAdd, date/time, default value = Now(), when...

hi @GUIDO22 While MSysObjects does store DateUpdate, I seem to recall that using DAO (as mentioned by @CJ_London) gets a different value ... here's a free tool with source code that may be helpful for you: Analyzer for Microsoft Access http://msaccessgurus.com/tool/Analyzer.htm

@JohnPapa, if the files are images, maybe better would be to use an image format such as JPG or PNG instead of PDF? Then you can store the images as shared resources. Here's a link but it's not very helpful: https://docs.microsoft.com/en-us/office/vba/api/access.sharedresources Peter Cole...

you're welcome David! I generally use early binding to develop and then change to late binding once it works :) With late binding, you can remove the library reference.

ps, David, this statement: Set O = New Outlook.Application requires early binding, which means the correct version of the Outlook library must be referenced. If you're writing code to use in any version and want to use late binding instead, you can use dim O as Object 'Outlook.Application...

welcome, David, look forward to more posts from you, and wishing you great success with Access

I wouldn't have thought to even try it that way, thanks for testing @allen675 (is your name "Allen"?)

oh, interesting and good to know! thanks, @allen675

thanks, @allen675 does it pick up signature if it is after Display?

hi @allen675 let me know when you test ... could be different code is needed to add the signature ... good idea though!

hi @allen675 > Would moving this piece of code ahead of display and removing . HTMLBody from the end pick up the signature? good question -- I actually don't know ... I would think that siggy would be a different object. Question: Does it WORK to assign the body after the display?

you're welcome, @allen675 ~ happy to help actually, this required HTML, not VBA knowledge -- lucky to know both ;) ... and, by the way, Access can link to local Outlook mailboxes ... much better way to find things in your email (smile)

pps, @allen675 assign HTMLBody before Display ;) EDIT: maybe not ... if you wait, adds signature! and if you're creating a new email, would there already be an HTMLBody ?? I'm assuming not ... but perhaps there's a template kicking in?

ps, @allen675, welcome to AWF!

hi @allen675 to add a line BReak using HTML, use <BR> or you can also use <BR /> to indicate there is no closing tag. Use 2 <BR /> if you want 2 blank lines. Case doesn't matter, so you can also use <br /><br /> or <br><br> <p> could do it too -- but the paragraph tag is like parentheses --...

@Danick -- please note: I modified my previous post about being able to sort a form by the column of a combobox ... my notes were almost right -- you CAN do it! Now Post #9 shows you how to sort a form by any column of a combobox, not just the first visible column as the macro method with...

Word Automation Deep Dive Word Automation from Access VBA Deep Dive Here is the video from the presentation. Thanks to those of you who were there live :) Just as the title suggests, this is a deep dive into automating Word from Access. Understand key concepts in Word such as Application...