Search results

I got it! thanks! I used the code from pbaldy via the link! thanks so much!

The name of the subform is HistorySubForm and its source is named HistoryForm The field I am trying to update control source and name is User thanks

Is there something wrong with the way I call-out the subform? Set Value Item = [Forms]![MasterForm]![history_subform].[Form]![LastUser] nothing seems to work

I just tried currentuser and get this error You tired to run a vb procedure that improperly references a property or method of an object?

Hi, I am using Access 2010 and Windows XP. I have a form named MasterForm and a subform linked into the MasterForm named history_subform I am tring to get this to work like in 2003 Set Value Item = [Forms]![MasterForm]![history_subform].[Form]![LastUser] Expression = GetUser() Gives me an...

thanks again, no luck as I tried all

yes, error msg send object isn't available at this time yes this is the only piece of code that stopped working to date I believe I have tried every tip I could find on net... thanks

thanks, but this did not solver the issue... any other ideas is appreciated...

We have recently upgraded to Access 2010 and have a DB developed in 2003. The email send object does not work anymore? Any ideas? thanks

I have been running an Access database since 2007 that emails results to users invoking the send object commend in access. I have been using access 2010 and opening the db in a 2003 version. Ever since my PC was changed to a newer pc I cannot email anything form access anymore. It states send...

I am sorry, it does work! thanks!!!!!

I got the mde to work, thanks but, now users cannot run file extracts tha call out vba modules that transfer files...I would need these to still work....

access was unable to create the mde file is what I get for a msg...

thanks, but disable menus etc does not limit access to QAT

We finally converted and have an Access 2003 database we use. Before, when users when into a form we restricted them to form or datasheet view and now they can go to quick access toolbar and add design view and change the DB and delete records from it... not good... any easy solutions?

We finally converted and have an Access 2003 database we still use in the old version due to the amount of macros and VBA used in it.\ We have had 2 issues. Before, when users when into a form we restricted them to form or datasheet view and now they can go to quick access toolbar and add...

here is what I have so far, if I could ajust auto paste when groupwise appears I would be all set... Function Macro2() On Error GoTo Macro2_Err DoCmd.SetWarnings False DoCmd.OpenQuery "email_list_new", acViewNormal, acEdit DoCmd.RunCommand acCmdSelectAllRecords DoCmd.RunCommand...

I dont really follow the code. I actually used run commands to copy the email list then open the new email message in groupwise and the user has to click on the bcc field to paste the emails... any additonal tips especially on paste into the groupwise email would be great. thanks

I just want a blank new email message screen but the email addresses populated in the bcc: line, I would think it would be a couple of lines of code....

is there an easier way? my vba is not that great... so I am a little confused reading it