Recent content by veraloopy

I understand, I read something along the same lines but the article was some years back so I was hoping things had changed. Many thanks for your help :)

I've got some code that sends emails from a specific user account in Exchange where the user doesn't need to have Outlook open. However, I also need to send a calendar invite using information from fields in my form Can anyone help with using similar but calling the calendar function to send...

What's E.T. short for?? Cause he's got little legs :)

Thanks both This worked for me: =IF(AND(J2<>"",L2<>""),L2-J2,"N/A") Thanks NVBC :)

I've been banging my head with this for a few days.. I have 2 dates, one in column J and the other in L, I need to calculate the difference between the 2 dates, however where 1 of them may be blank (this could be either / or), then I need to return "N/A" to the cell. I've tried this, but...

Quick thought, have you set any command buttons as the default button / cancel button in the properties(Other tab)? I use this to set my Exit button Cancel property as Yes, so when anyone presses Esc, it activates this button and the code attached to it

Can't open the attachment, you've attached the lock file I think

You need to put the full form name in the query as a Criteria For example, if you want to look up all record with the name SMITH, you need to put this in the criteria against the correct field that you want to search on. forms!formname!unboundfieldname For the unbound field name, look in the...

I'm looking at something similar at the moment and in testing, whether the form is visible or not, access will still run the calculations as the form is still open although you can't see it I'm doing mine so that it is always visible but only runs all the dcounts, etc upon first load into the...

In your query, where does the field INCIDENTDATE come into it as you are searching on the startdate and enddate fields?

There may be an easier way to do this but I tend to use the 'On Current' event on the form or subform and have a select code like this: Select Case me.fieldname Case Is 1 forms!mainform!subform!fieldname = "Yes" Case Is 2 forms!mainform!subform!fieldname = "No" End Select You would need to...

On the design tab (access 2007), make sure the 'Use Control Wizards' is selected (see attached image)

Check that in the properties of the form itself, you have Allow Edits set to Yes For the ?Name error, have a look at this help page: http://office.microsoft.com/en-us/access-help/i-see-name-displayed-in-a-control-HA001181447.aspx

Have you go the reference to the forms in the correct order? Should be main form then subform i.e. ssSeqNumber = [forms]![MainFormName]![SubFormName]![SequenceNumber] The only other thing is using a ! after 'Me' - should be a full stop 'Me.'

To update all your existing records, you would need to run an update query as RuralGuy mentioned. Moving forwards, I would calculate this when entering the values on a form, probably in the After Update of the Postage Fee (or whichever of the 2 values is entered last... something like...