Search results

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

I just tested @LarryE's method and RunCommand acCmdSortAscending sorts a form by the first visible column of the combo or listbox. Therefore, @Danick, there is no need not to use the AutoNumber primary key and Long Integer foreign key. If you want to sort by multiple fields, do them in reverse...

hi @Danick according to my notes, you can sort a form by the column of a combo that's not in the RecordSource using this for Order By: [Lookup_ControlName].[ColumnName] isn't Access totally amazing? EDIT 13 July corrected the reference WHERE ControlName is the Name property of the control...

hi @dobseh > 150 fields wow! That definitely indicates a structure that could benefit by being normalized! I suspect many of the tables were created by importing. The import wizard is OLD! And doesn't set (or not set) properties that are good to use now. Best to examine the table design and...

adding on ... while you can use duct tape and bailing wire to get what you want, do you always want to jump through hoops? question: do you have control over the data structure?

hi @dobseh > I inherited this database from someone while that is the case, doesn't mean you need to keep the same bad structure. Normalizing will reduce development time down the road and make everything in the future go a lot smoother. To convert data: 1. create cross-reference table 2...