Search results

Thanks for your response modest....here's what's happened now: For Each obj In con.UserProperties Select Case obj.Name Case "AuditNumber" If obj = rst!AuditNumber Then con.UserProperties("AuditDate") = rst!AuditDate End If End Select Next...

What's wrong with this code please. I have an appointment in outlook and I want to use the following code to update the access tables with the custom fields in outlook. The variables are showing the correct data as is in the outlook form, however it is picking up only the first record in the...

See above Hey modest! I've made some progress with this now...posted above...due partly to the link you posted so thanks for that. I spent a while browsing through the info and came across a link to MS that showed how to change the appointment item to a meeting item. I guess appointments...

Got part of it! OK...I've managed to write the code to add the appointment to my calendar and invite the attendee. I needed to change the appointment type to meeting...see code in red. Dim objOutlook As Outlook.Application Dim objAppt As Outlook.AppointmentItem Set objOutlook =...

Hmm not quite right Have had a look at this code and it would appear that this sends an email to remind the person but doesn't actually add the appointment to their calendar. You know when you create an appointment in outlook and add attendees it sends an email which, if the attendee accepts...

Thanks Thanks modest...that helps a bit. My current thinking is that if I could create a template appointment in outlook I could perhaps use outlook vba to programme the update of the access db. Looks like I have embarked on a bit of an adventure! Jo

Firstly does anyone know if this scenario is possible within Office XP? I have a database that amongst other things can be used to record the date and duration of audits. Using the code from MS KB I have successfully managed to create a button that adds the audit to my calendar. What I want...

Perfect! Thank you very much....this is perfect for me. Have got it working and storing the result in my table. :D :D :D :D

Thank you I'll give this a go now in my DB. I'll get back to you and let you know if this works for me.

OK guys....nearly there with this DB of mine, however the customer is now asking for things that are miles over my head. I need to programmatically retrieve the first two words of my memo field (before the record is created) so that they can be added to a table. I haven't the first clue where...

Thank you I think I've got it now. My subform control got it's data from the query. I've created another form which has data from the query and made my subform control reference this. I can now manipulate my subform properly. I didn't realise I had to have another actual form. Thanks for...

Sorry that doesn't work Thanks for your replies. I have messed about with this some more and given it some more thought and I think the problem is that I only have two events to choose from in my subform: enter and exit. I have created a subprocedure for the enter event which is why I can...

Hi, I have a main form that is unbound. On that main form is a subform which is bound to a query and displays the results in datasheet format. There is nothing else to the subform. My users want to be able to click on a record in the subform and have the corresponding data displayed in the...

Thanks I've got it fixed now....thanks :)

Hi there :) , I have written this code to check for an entry in my table and return an error if the entry already exists....this works for the first entry in each case but not for subsequent entries.....why? Private Sub cmdAddToAudit_Click() If IsNull(Me.txtAuditNumber) Then MsgBox "You must...

Fantastic Thanks for your quick response. This does exactly what I want :D Jo

Is this possible and if so how? I have two fields in the same table. I want to combine these so that they are formatted in a particular way. For example, if the first field has the value 21 and the second has the value 24 I want my resulting field to show 21/24...the forward slash is very...

Thanks I'll bear that in mind :) Jo

Perfect Thank you so much....that is miles better than what I had....I wish I had a better grasp of VB :( I guess it'll come to me in time. Jo

What have I done wrong? Ok...I tried SJ's code and it still adds the data to the table and doesn't display the error message....here's my code can you see where it has gone wrong please? Private Sub cmdAddToAudit_Click() Dim ctl As Control For Each ctl In Me If ctl.Tag = "*" Then...