Recent content by NoSmoke

Thank you again Boyd - with that help I think I can go from here :)

Thanks Boyd but I really don't need anything further such as send history. Now that you mention it, it would be just a spreadsheet in Access so, I might be better off just doing it in Excel VBA. If however, I can figure out how to get Excel to send an email. I already have an Access program...

Do you mean the query designer has the ability to add a VBA programmed function? Or is SQL or something required?

I wish to set up a simple table that will contain: . Person's name . Person's email address . Date at which a form email should be sent to that person I want a program to check each record in the table periodically and send an email to those persons as the send date for that person...

Those who live alone, especially we older ones, who do not have regular contact with someone on a daily basis may want to have some form of automatic notification system in place to transmit a request for help in case they become incapacitated and are unable to reach or use a phone. It is with...

Sorry CJ, I should have been more specific. The statement I concocted gave a run time error message. I have since erased it as I couldn't figure out the syntax and can't recall just what the message was.

Thanks much Paul - does just what I want! You guys rock BTW. I'd be long dead without you. :D

I have a report that summarizes the record content that is contained within a form (one report line per form record). If the user wishes to view a specific record on the form, he clicks on the report control that contains a numeric value that identifies the record on the form. I can get that...

Woot! Got the full remote Access account going and uploaded the offending dbase. Same crapulence + more (functions such as Date and Left$ wouldn't compile). So, created a new dbase and imported all objects from the original. Got the "missing msdxm.tlb" message during the import process but...

Just tried the .accde version on their site. Now I get: "This database was created with the 64 bit version of Microsoft Access. Please open it with the 64 bit version of Microsoft Access." Wondering if that's a clue - I will ask their tech support... This just in: "Our version of Access is...

CJ, I'm running Win 7 SP1 & Access 2010. Just asked them and it's apparently Windows Server 2008 r2. No, it's actually mxdsm.tlb (I had to look twice too). Googled it and apparently it's a Windows Media Player library (which would explain I suppose why their tech thinks the problem is related...

Yup, needed a space :banghead: Anyhow, program runs here with Runtime w/o problems. Played around a bit with it on Access Host. Got one form which had "#Name?" in a date control to work by removing "=Date()" from Default Value property. Other more complex forms still give the ".....database...

Thanks Paul, I recall seeing that somewhere. Trouble is though I cannot figure out how to get it to work. I have tried msaccess.exe in Start-Run and it launches Access alright. But if I try msaccess.exe/runtime, all that happens is Win Explorer launches(??). If I put the file path to one of...

OK, signed up for the Access Hosting base remote desktop package trial (as claimed to work with Access dbases w/o modifications). Works, mostly, but gives an error message on launch when forms containing calculated controls are loaded: ".....database contains a missing or broken reference to...

Thanks CJ for the reply. Not sure though what you mean by "target machine" - is that the host's server or the user's PC? If the user's PC I guess I'm misunderstanding how these remote hosting services work. If the host server, would usage not be similar to using a web site where there are...