Search results

Might be easier if I explain what the form does! When a date is entered into a control source (this is the date of an incident occurring), 9 other control sources are populated with dates via VBA - these are deadlines by which a task must be completed (such as a report sent, a meeting held, and...

Ahar, yes I hadn't noticed the outlook reference wasn't ticked also! Thanks :) Now trying to figure out how to use the data from different forms within a text entry (as in, within the appointment title or within the text for the reminder) as simply using the Forms!formname.control just prints...

Yep I have the reference to Microsoft CDO 1.21 Library ticked and it doesn't say missing - same file path as stated in the posting :|

Tried implementing this but I am getting the following error: Compile Error: User defined type not defined on the following line in modOutlookAppts: Dim outMail As Outlook.AppointmentItem

Nigel, Is there a way of grabbing certain content from a form? I want to add the appointment by clicking on a command button (or maybe running on an afterupdate feature for a text box - haven't decided yet), and want it to grab certain features from the form and incorporate these into the...

I definitely agree - This module started out life as code for the actual form, but then I started to think about how I could use it elsewhere in the database for these fields, hence attempting to figure out what modules actually are and how to use them properly! Ruth

Aha!!!! I had used that before but it wasn't working for the first one, so now using the two in conjunction seems to be working as intended :) Thanks for your help! Ruth

Bob, Thanks for pointing out what to you probably seems like an obvious fact, but to us mere mortals who are just teetering into the world of VBA, may not be quite so blatent if not explicitly stated as such. It now works, to some extent, but doesn't work! It's not giving the error, but I'm...

I tried it with this, and with the original Option Compare Database Option Explicit Public Function ColourFeatures() Dim MyForm As Form Set MyForm = Screen.ActiveForm And neither get around that error (that it requires a form to be the active window)

OK I've commented out some lines and played around, one part of the problem seems to be that the first time the form loads I get Runtime error 2475: You entered an expression that requires a form to be the active window. I assume this is because the "procedure" in the module is using the...

As my sig says .. i'm a noobie learning quickly. Hopefully its possible to get the gist from my apparent poor terminology. :) Ruth

When I call it on form_current I get the error Procedure declaration does not match description of event or procedure having the same name The VBA is: Private Sub Form_Current() Call ColourFeatures End Sub and the module is as follows: Option Compare Database Option Explicit Public...

Thanks for that, I hadn't thought about afterupdate but will incorporate that also :) Ruth

Think I might have found the solution to one part - using On Current - using the explanations of events here: http://www.blueclaw-db.com/access_event_programming/ Is this the best way of achieving it? Ruth

Hi all, I wonder if you can suggest what event I should use to call a module on? I've been using beforeupdate but this doesn't seem to be working as I intended. Basically my module runs through a series of dates, and if those dates are within a certain number of days from today it'll change...

If you read through the post it is somewhat evident? It does what it says on the tin, creates an audit trail of records being changed by user/PC/date/field changed etc.

I'm also now getting the compile error: invalid use of property - any ideas what's going on? I even get it if I remove (Me.Form, [RecordID]) [NB this is using the table method of storing the data] I did have this working OK but now it seems to be bombing out :| On another note, is it possible...

I would suggest your resume/CV be purely text, maximum of 1-2 sides, but if you desperately want to show them examples of your work then you compile a professional "Portfolio" which evidences key areas of learning - e.g. database design, VBA, etc. Ruth

I got irish634's code working on my form perfectly - it's worth mentioning that the primary key of your table needs to be called RecordID for it to work, and this needs to be on the form you're using. I have it as a hidden field, but the field was called SUIID so it didn't work initially! Now...

Figured it out - I had a box which I was going to use for decoration purposes - the controls whcih were within the box didn't work! I deleted the box, deleted those text boxes and re-made them and it works fine now :) Ruth