Search results

Do you mean that you are entering the date + 60 days manually yourself? If yes, search for the DateAdd() function or simply try NewField: DateFieldName+60

that's what i thought but when going to the properties of the outlook icon, the target is dimmed i.e. disabled and it has written "Microsoft Office Professional Edition 2003"

Hi Minkey, Many thanks for your reply. Actually I had already tried your first suggestion but in my office 2003 it just works for 1 folder. The link you offered me is extremely useful (thanks) and the switch did the trick. However, is there a way how can i include that switch on the outlook...

When you are about to create a database which will store personal data but for different entities for example Customers and Employees do you normally create two tables i.e. tblCustomers and tblEmployees or you create a single table tblContacts and you add an additional field to store the type of...

be very cautious that you know exactly what you are doing when using the access user level security. check out here for a thorough guide how to implement the security features in access

try searching for Access Runtime version as this topic has been discussed several times. here is a link from microsoft's site for the runtime version.

Hi, Thank you for the link i think it should solve the issue :) On the other pcs which have outlook configured i do get that message ... is there an easy way to hide it ? Thank You

you're welcome

I'm afraid you're out of luck as your request is not possible. No, however, you can distribute the runtime version of access

you can try using the openargs in your DoCmd.OpenForm or if you want to open the form and move to a particular record in your Contacts form, you can use the "Where" argument

Thx for your reply. Further to that, should i find no other solution and will configure outlook ... is there an easy way to hide the warning produced by outlook stating that an application is trying to send an email and to click No if you think it's a virus. Thanks

Hi, I have a pc which although it has outlook installed this is not configured, as the only mail sent from this pc are web based. Therefore is it possible to send email from an access database using the SendObject without having an email client installed? Thanks

try removing the quotes between clientrecord and null

Thank You :)

Hi Bob, Is the difference between your code and the DoCmd.OpenQuery only that the .Execute suppresses the query default warnings (for action queries) or there are other advantages as well? Thank You

Congrats Stopher :)

that's a very useful link Banana, i remember myself reading that pdf long time ago Make sure you read it more than once, so that you don't end up locking yourself out from all of your databases.

it seems you do not have the mdw file on the client pc.

if you do not want to change the actual data, create an unbound text and then use a case statement to update the value of the unbound text box eg. Select Case Me.FieldName Case "R" Me.UnboundBoxName = "SFD" Case etc End Select

well you will only be entering the WorkID (not all the other fields related to the Work). Moreover, you can use a subform in your mainform and that way the WorkID will already be there for you.