Search results

Hi, the crux of your problem I believe is retrieving the entryid (a huge UID for Outlook appointments.) with your appointment object you can retrieve as follows. myID = olApt.EntryID Ok, now you have your EntryID you can then subsequently re-retrieve the appointment object like such... Dim...

You're correct Brian, my code doesnt have the space. Thanks for trying it out. I remain equally frustraited... the function returns everything for me... :confused:

this is mad... :confused: am trying to write a function to return the first cell in a filtered list... but while developing it I came across this problem... these two pieces of code are exactly the same, except one is in a function... you'll noticed ive commented the line out that 'should'...

Hi there, Is it possible to exicute Access macros from outside access? I have, for example, a macro that exicutes a subroutine to export parts of a call log as an excel sheet and send it via an email attachment. I would love to do this without having to log into the access application. Maybe...

Basically the data (a flat table of results [CPM Results FY05]) is not normalised. The fields of interest in this table are GID (can be duplicate) Outlet name (Can be duplicate) Cat 1 Result Cat 2 Result etc. . . . The form [frm_Audit Result] in which the subform resides has no 'record...

Yes. After update does have a Form.Refresh in its event procedure. I was fumbling around trying to get the damn thing to refresh once the textbox had a number copied to it and that seemed to work but only once i change the number. So i know the form works, its just I cant get it to...

Hmm... my problem maybe that I dont have any Linked child or link master fields as I dont want to show any one record. I want to show the results of a query based on a GID copied from the original form as a table (not a form as their maybe more than 1 result) Am sure it would work if the...

Hi there, I hope someone can help... and i hope i can explain this properly. Some background... I have a form which has a Global ID as one of the fields. From this form another audit results form can be opened (on the click of a button) that shows the results of Audits based on this ID. The...

I am doing this at the moment. However while it accomplishes what I originally wanted it occured to me that I needed more functionality and now I wish to be able to add a new record to the table that is the control for the subform. I have a combo box in my main form (an incident form) that...

Hi, thanks for your persistance... yes. I load the main form on startup. So it must try and re-establish the links at startup using the spec. Why? I dont know... because if i didnt use a spec am guessing it wouldnt matter and access would just use the data as is, i.e. as specified when it...

Thanks for the advice. Straight after I log into the DB it gives me the error. So, am not sure what event I can hook it to. The error is before my form opens... cheers,

Hi there, Am hoping someone can shine a light on my problem as this has me ripping my hair out. first off I've set up a subform in my main form to display a query using a linked table as the data(a excel exported csv file). nothing special. however, I have had to use a link specification to...