Search results

Fantastic! Thank you very much Wayne.

Hi Wayne, Thank you for your response. I've just found that when I changed acFormatXLS to acFormatRTF, it will proceed to bring up the Outlook. There is a free Microsoft ScriptIT tool which I plan to use to automatically select the 'Yes' button for sending the email. (There is an article...

New discovery. It only works if acFormatXLS is removed from the SendObject statement. However, doing this will require human intervention to select a format to send. if I've selected Excel 97-2002 format, and cllick on the OK button to send, it activates Outlook and a window with the...

Hi Harry, I've done as you've suggested, but when I tried to run the Macro, Macro failed to run and a message window is displayed: Macro Name: AutoRun Condition: True Action Name: RunCode Arguments: AutoUsageBilling() How should I fix this problem? Thanks for helping...

I need help! I have to send out access report as Excel file on the 15th of every month to several users from my access application automatically without human intervention. My plan is to create a VBA code and then create a shortcut for this code and place it on the PC, then I'll use Windows'...

Just to add from experience that if your system.mdw file is placed in a server and your PC has network connection problem to the server, Access will automatically switch the security file to point to the default security file in: C:\Documents and Settings\Administrator\Application...

Hi Autoeng, Please ignore my earlier reply in another thread regarding the change of user password. I've used your code here in this thread. Thank you. It works great, just what I wanted.

Hi Autoeng, The link is now broken, do you know of any other link regarding the issue of letting users changing password by themselves? Thanks...

Ok, correction on my earlier discovery. The error code 3251 appears because of the lookup fields linked from another table. My solution is to rename the controls of all the lookup fields. eg. Lookup1, Lookup2,... Then slight modification is made to the AuditTrail function as shown below to...

Thank you Pat for highlighting.

Thanks. I shall spend sometime to explore the forms in Outlook.

Thank you Calvin.

Hi Tom, My problem has been resolved by adding this line: DoCmd.FindRecord Forms!ufmContract.[ContractNo], , True, , True Thank you for your help.

Hi Tom, I think the problem with my form (aLookup) is that each tab has a subform which refers to a table different from the rest of the tabs. Therefore when I use the code generated from the button wizard, it is not able to locate the specific record I'm looking for. Is there any other VBA...

I read somewhere that Access performs well when concurrent users on Access database is less than 10 users. will this limitation be resolved if I upsize my 'be' database to SQL Server?

Hi Tom, Thank you for your reply. When the line is added to the last line, error is displayed: The object 'User Record' isn't open. I've therefore attempted to open the form by adding another line above it: DoCmd.OpenForm "User Record" but the problem is that it brings up just the User...

I would like to be able to allow user to click on a button, say "User Record" from a form based on the current record (say Contract) the user is editing. However, the User record form is in one of the tabs in a lookup form. How can I program the button so that it goes directly to the record...

Hi Pat, When you mention creating an Outlook form, do you mean to create it from MS Access or create it from Outlook? How to go about doing it? Thanks...

I've discovered that in a parent-child form setup, when the Before Update event is set to call AuditTrail subroutine, it causes 'error 3251 - Operation is not supported for this type of object' to be displayed when I try to move to an adjacent record after having edited a record. Has anyone...

On the Properties of the search field, Format->Visible and set it to No.