Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 175
Search took 0.02 seconds.
Search: Posts Made By: MackMan
Forum: Modules & VBA 04-06-2019, 08:01 PM
Replies: 2
Views: 131
Posted By MackMan
Re: DoEvents alternative

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
Forum: Modules & VBA 04-06-2019, 07:56 PM
Replies: 2
Views: 131
Posted By MackMan
DoEvents alternative

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...
Forum: Queries 07-25-2018, 04:41 AM
Replies: 4
Views: 179
Posted By MackMan
Re: Find Last date & value, before today with empty dates

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...
Forum: Queries 07-25-2018, 12:31 AM
Replies: 4
Views: 179
Posted By MackMan
Find Last date & value, before today with empty dates

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 ...
Forum: Reports 07-20-2018, 05:48 PM
Replies: 4
Views: 262
Posted By MackMan
Un-Agregate a non aggregated chart...

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...
Forum: General 07-20-2018, 05:02 PM
Replies: 3
Views: 2,054
Posted By MackMan
Re: Use Outlook to delete Record

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.
Forum: General 07-18-2018, 02:02 AM
Replies: 3
Views: 2,054
Posted By MackMan
Use Outlook to delete Record

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...
Forum: Queries 07-12-2018, 12:38 PM
Replies: 2
Views: 164
Posted By MackMan
Re: Show all dates <between> or if no records show all records

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...
Forum: Queries 07-12-2018, 10:17 AM
Replies: 2
Views: 164
Posted By MackMan
Show all dates <between> or if no records show all records

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...
Forum: Modules & VBA 06-27-2018, 05:41 AM
Replies: 3
Views: 133
Posted By MackMan
Re: Automatically insert decimal IF....

Thanks Arnel. Works perfectly.
Forum: General 06-27-2018, 12:22 AM
Replies: 18
Views: 2,358
Posted By MackMan
Re: Query

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...
Forum: Modules & VBA 06-27-2018, 12:00 AM
Replies: 3
Views: 133
Posted By MackMan
Automatically insert decimal IF....

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...
Forum: Modules & VBA 07-10-2017, 10:28 AM
Replies: 5
Views: 323
Posted By MackMan
Re: Delete OL Contact using Late Binding

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...
Forum: Modules & VBA 07-10-2017, 05:35 AM
Replies: 5
Views: 323
Posted By MackMan
Re: Delete OL Contact using Late Binding

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'...
Forum: Modules & VBA 07-10-2017, 02:49 AM
Replies: 5
Views: 323
Posted By MackMan
Re: Delete OL Contact using Late Binding

Thanks Minty. Looks like exactly what I need.

I'll let you know how I get on.
Forum: Modules & VBA 07-10-2017, 02:29 AM
Replies: 5
Views: 323
Posted By MackMan
Delete OL Contact using Late Binding

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...
Forum: Macros 07-06-2017, 11:09 PM
Replies: 2
Views: 1,124
Posted By MackMan
Re: Sub Macro (Action Catalog) view

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...
Forum: Macros 07-06-2017, 12:37 PM
Replies: 2
Views: 1,124
Posted By MackMan
Sub Macro (Action Catalog) view

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...
Forum: Queries 09-20-2016, 02:13 AM
Replies: 6
Views: 482
Posted By MackMan
Re: Invoice populate previous total if date empty...

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...
Forum: Queries 09-12-2016, 05:11 AM
Replies: 6
Views: 482
Posted By MackMan
Re: Invoice populate previous total if date empty...

Thanks Ranman, will give it go as soon as I'm back in the office!
Forum: Queries 09-12-2016, 05:10 AM
Replies: 6
Views: 482
Posted By MackMan
Re: Invoice populate previous total if date empty...

Customer wants a monthly invoice by all dates to show any activity or not... They pay the bills... so...
Forum: Queries 09-12-2016, 03:06 AM
Replies: 6
Views: 482
Posted By MackMan
Invoice populate previous total if date empty...

Hi all. I've done a search for what I'm trying to achieve below, but there's nothing to give me an idea how I'd go about tackling this.

Basically, I have a couple of clients who've asked to show...
Forum: Forms 08-30-2016, 04:59 AM
Replies: 3
Views: 697
Posted By MackMan
Re: Is a subform Control not a subform control if...

Glaxiom. Thank you. I've been trying all sorts, and the solution was much more simple. That makes much more sense. Once again, thank you!"!
Forum: Forms 08-30-2016, 01:07 AM
Replies: 3
Views: 697
Posted By MackMan
Is a subform Control not a subform control if...

Morning all. I have a Main form "frmREPORTS" and within it contains a sub form control "SFControl". I'm using a subform control so I can call its recordsource through VBA to view various continuous...
Forum: Modules & VBA 08-20-2016, 02:18 AM
Replies: 4
Views: 438
Posted By MackMan
Re: One date while entering data, then check if it falls between all on a tbl/qry.

Arne & Sneu, thank you! Both worked. Sneu, I was on the right track originally, and I had something quite similar I was working on... but would have taken me a week to get there.

Arne, I didn't...
Showing results 1 to 25 of 175

 
Forum Jump



All times are GMT -8. The time now is 02:21 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World