Search results

for anyone interested there's a link I found after changing my search criteria.... And here's an alternative to DoEvents: http://www.mvps.org/access/api/api0021.htm

In the BeforeUpdate event of a form field, I'm holding open a messagebox (my own design) with DoEvents as I can't allow it to open in dialog mode. If Len(Me.ReminderTitle & vbNullString) > 0 Then strLinkCriteria = "[ReminderTitle] = " & "'" & Remtitl & "'" 'checks reminders...

Thanks Minty for your link. Now I understand my error and it's easy to see why. And thanks CJ London once again... does exactly as I need it to! You guys are awesome! Total respect in regards to your knowledge on all this stuff. It's still a minefield for me, but I'm getting there.

Hi all. I'm trying to lookup a value from another query with dates running in ASC order from qryLookup TransDate Lookup Value ----------- --------------- 20/07/2018 … zz1 20/07/2018 … xz1 21/07/2018 ... xy1 21/07/2018 ... xy2 23/07/2018 ...

Now I know it sounds stupid... But Access is aggregating a row source I don't want it to... I have two columns of data in a query one for dates and one for a running balance, but the running balance is aggregated (and I'm getting very aggravated) The chart has no resemblance of the data I...

Ideally something in VBA that'll do it on the fly... up to now I never knew Outlook also had VBA. I'll take a look into it.

Hi all. I was thinking... I'm currently using Access to delete related records in the outlook calendar, relevant to data I no longer need to keep in both. I was wondering if I could also create something in outlook and use it to delete a record on delete of the calendar item. I do have a ID No...

Plog. Thanks for you reply. I didn't realise that applying criteria in the where clause on the 2nd query undone the LEFT JOIN. I amended the query to include the criteria in the first query, and voila... it's working now exactly as I needed. Many thanks for you help and explanation, I learned...

Hi guys. A quick question... I know the title is confusing, and so is my problem. I'll try to explain as best as I can. I have a totals query called [qryActualSpend] where the dates criteria is Between [myformname]![txtstartdate] AND [MyFormName]![txtenddate] and the results are exactly as...

Thanks Arnel. Works perfectly.

Steve, given the information.. SELECT [YourTable].[Closed Date], [YourTable].[completion date], IIf([closed date]>[completion date],"Closed",IIf(IsNull([Closed date]),"Late")) AS status FROM [YourTable]; Always good to NOT to have spaces in Field Names as this can cause complications down...

Hi guys. Thanks for taking the time to read... I have a currency field, and currently its set to automatically insert a decimal point by /10 if it's notnull. Most of the inputs to this field use pence and shortens the input method. Someone has asked me if it's possible to insert trailing...

I finally got it to work. I built the code using the library reference and back wrote it. Turns out I was only referencing one Const olfoldercontacts = 10 , and not both which I also needed to include Const olcontactitem = 2 The final code (for anyone who's looking for the same is) Private...

That whole link was extremely helpful, and I've already changed a couple of pieces of VBA to reflect that. However... I still have no idea what I'm referencing to be able to delete a contacts' details from Outlook, like using olcontactsfolder = 10 etc....

Thanks Minty. Looks like exactly what I need. I'll let you know how I get on.

Hi guys. I'm using the following code (with reference to MS Outlook object library) to delete a contact from OL. Function DELOUTLOOKCTCT() On Error GoTo Err_Ctrl Dim olAppl As Outlook.Application Dim objNamespace As Outlook.NameSpace Dim objFolder As Outlook.MAPIFolder Dim olCont As...

I can get in to the macros. It's only "some" of the sub macros I can't get to. It just shows the name of the Sub.Macro in the Macro designer. There is no option to expand it, view it, edit, it, or open it. Incidentally, when I right click the name of the SubMacro in the Actions Catalog, all I...

Hi all. Macro question relating to Actions Catalog and access to the macros contained within it. I've inherited a macro only (ugh) database, and as I prefer to use VBA I'm converting said macros. However, there are sub macros run within each macro to which I can't get access. As I look in...

So I've been working on this for the last couple of days, and it's really bugging me... I know it's something really simple but... I can get the running sum of the opening balance and all account activity, but where there are days with no transactions, it's showing #Error. for instance... the...

Thanks Ranman, will give it go as soon as I'm back in the office!