Search results

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

Hi Nate @naterook Welcome to AWF. I'm self-taught too, having learned Access many years ago when it still came with books (which I read cover-to-cover) I've learned much more though, from participating in forums! ... because someone else had a better solution than the one I proposed. We get...

hi @gemma-the-husky for manipulating image files with Access, I like Irfanview since it has switches you can end to the end of the command line to change things. Here's an example using VBA to use Irfanview to resize http://msaccessgurus.com/VBA/Code/Irfanview_ResizeImage.htm ... and in...

thanks, Colin @isladogs -- great examples too ... very creative! Good teaching and fantastic food for thought

hi @access2010 (what is your name?) I just happened to see your post -- next time you want me too look at something, tag me not sure what you want us to look at. I downloaded your db and looked at code behind the find combo... first, before moving to another record, save the current record if...

hi @ekje most important to remember is that, because data takes time to bring down, only bring down what you need. On forms, RecordSource should be limited to show record you want to edit. For populating RowSources, use pass-through queries It took about a week to build an Access app -- then...

delete rst_PDF! -- you only need Me.txtLocation if that contains the full path and filename

you're welcome. Does that mean you changed it and now it works? or is the issue that Exit Sub is there? If so, put a Stop statement in, temporarily, before the Exit Sub to verify it actually isn't working. My guess is that code isn't going to that statement. Is it inside an IF block?

@A380b747 as long as you're browsing for the file anyway, why not just copy it into a Files folder under the back-end database and store the path\filename? You can also include the initials of the person who added the file to make it easier to see all of their files ~

hi @A380b747 > other users need to have access is your database split into Front-End and Back-End? If shared filed are placed in a folder under the back-end location, maybe called 'Files', then a relative path can be stored that is different for each user but still points to the same place.

hi @A380b747 echoing @theDBguy's comment ... best not to store external files IN the database. Better to store path\filename and render with Image control if pictures or maybe Web Browser control for other types of files. I like to put all files referenced by the database in a folder under...