Recent content by WrHn85

OK, I see where I went wrong re: that reference detail. With the new engine selected that line of code no longer fails. Thanks for also explaining the why of it and the x64/x32 options, very much appreciated!

Thanks to both of you. I did try removing the 'DAO.' part of the code, which it didn't like, and also checked to see if Microsoft Access 15.0 Object Library is checked, which it is. Same error occurs when clicking either Merge all records or Merge single record, this line fails: Dim OneField...

Thanks! I had checked that in the previous versions but clearly missed it in my new blank db. But it won't allow me to add it. I found it in "c:\Program Files (x86)\common files\microsoft shared\dao\dao360.dll" and also tried Allan Browne's tip to unregister & re-register it, but still says...

Hi, Can someone help me figure out what in the heck is going wrong with my Super easy word merge??? I've used it successfully for 8 yrs in an Access2003 db. However, now we're on Access 2013 and I can't get it to work.All the same objects and modules have been copied over to my new blank db...

Hi, I don't know if you follow this forum often but I'm stuck with the super easy word merge now that we're in Access 2013. I'm posting a new message now: Kallal Word Merge in Access 2013. Thanks for everything you're doing to help!

We couldn't turn Sandbox off even by resetting the macro security like the MS article instructed. What we could get into is one thing but what we could do without getting shot is another (government office, eh). Turned out the PC had Jet 4.0 SP8 installed but the user's ID was missing this...

Hi, GHudson, Thanks for the reply. I found your posts very instructive and helpful. In this situation we can't get into any system settings (hope I've understood your post correctly) and have no ability to change anything, so I'm trying to find out if there's any way to reverse out of this...

OK, it was bound to happen eventually... New user of Access 2003 has inadvertently clicked "yes" to "Block Unsafe Expressions" and now can't even click a simple command button to print a report. :confused: Db has not a single macro, nothing fancy, mostly wizard code. Other folks logging onto...

Sorry for the fuzzy response John - yours was exactly suited to our needs and elegant as always...:cool: thanks very much!

Also wanna say thanks - this solution is saving us tons of time sending repetitive emails every day. Much appreciated!

Adeptus, I tried your code out on some unbound combos and set it to send the result to another textbox, which is bound to the table. It seems to change all the combos (continuous form) but can get them to go back to "" on Current, so data entry folks aren't confused. So it works great and...

Hey, Adeptus, thanks for the suggestion. Unfortunately, we can't use ActiveX or OCX here and I was planning to try a non-OCX version found on the net. The phone staff have to log all offers made to contractors by date/time and often the entries are only a minute or so apart. So in this case...

Bodhisathva, Your reply set me wondering: If a date/time were broken up into 5 comboboxes cboMonth, cboDay, cboHour, cboMinute, cboAMPM plus txtYear(default=CurrentYr) to facilitate quick data entry, how would you combine them together again to get an actual date/time value into your...

Thanks for your reply, Dave. I have a few situations like that in the db so I'll make them all outer joins. The other thing about these queries is that most of them so far have large numbers of fields for comprehensive reports or for merge letters. So I've got some big honking queries in...

Cheers, Pat! That's what I was kinda hoping was the case. Thanks. Kay:D