Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.18 seconds.
Search: Posts Made By: isladogs
Forum: Politics & Current Events Yesterday, 02:10 PM
Replies: 266
Views: 14,207
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Thanks for responding to my first question. If it wasn't obvious I was playing the innocent .the correct answer is of course that its nothing to do with the party in charge but with how the system...
Forum: Politics & Current Events Yesterday, 12:04 PM
Replies: 266
Views: 14,207
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Excuse my ignorance of US voting patterns, but do the statistics in the Wikipedia article indicate that % achieving success at each level is higher in states voting predominately for one of the two...
Forum: Politics & Current Events Yesterday, 10:29 AM
Replies: 266
Views: 14,207
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

AB
I think you may have misunderstood the point I was making.

Thank you for that information in your last reply to me.
However, without wishing to sound rude, your background, education, voting...
Forum: Politics & Current Events Yesterday, 05:56 AM
Replies: 266
Views: 14,207
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

As I said, all that supposed indoctrination was completely wasted on you.
You've emerged arguing the exact opposite of all that brainwashing.
Anything special about your ability to 'think for...
Forum: Politics & Current Events Yesterday, 05:37 AM
Replies: 266
Views: 14,207
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Its so good to know that you were able to think for yourself and ignore all the 'rhetoric' with which you believe all students are being force fed.
Forum: Theory and practice of database design 03-24-2019, 10:29 AM
Replies: 1
Views: 115
Posted By isladogs
Performance Tips to speed up your Access database

The link is to an extended article written by Luke Chung from FMS....
Forum: Queries 03-24-2019, 09:23 AM
Replies: 7
Views: 107
Posted By isladogs
Re: combine multiple fields into a query

You might be interested in this family tree example app http://www.accessforums.net/showthread.php?t=75300&p=419601#post419601
Forum: Forms 03-24-2019, 07:56 AM
Replies: 4
Views: 103
Posted By isladogs
Re: Web browser and tab control

OK I just did a test and replicated your result with a web browser on a tab control page. I didn't try your second test

However, if the web browser control is in a subform on the tab control page,...
Forum: Forms 03-24-2019, 03:30 AM
Replies: 5
Views: 10,397
Posted By isladogs
Re: [TIP] Expand/Collapse a Subform or a Section of your form/page

Hi araffa

Welcome to the forum and thank you for your contribution
In fact, you could combine your code into one button:

Private Sub cmdCollapseExpand_Click()

If cmdCollapseExpand.Caption =...
Forum: Code Repository 03-23-2019, 12:54 PM
Replies: 6
Views: 674
Posted By isladogs
Re: Mythbusters - Make Table vs Append Query

Attached is an updated version of the DBGuy's bloat test utility which I have already forwarded to him

The original version used GetFileSize to measure the size of the current file.
To get this...
Forum: Sample Databases 03-23-2019, 10:27 AM
Replies: 3
Views: 3,990
Posted By isladogs
Re: CDO EMail Tester

Following an question via PM by AWF member ellenr, I've discovered a new issue sending email using CDO using a GMail account
Google has added additional security which effectively blocks email sent...
Forum: Reports 03-23-2019, 04:00 AM
Replies: 9
Views: 159
Posted By isladogs
Re: Report support!

Cross posted at http://www.accessforums.net/showthread.php?t=76205 and https://www.utteraccess.com/forum/index.php?showtopic=2053114&hl=
Forum: Queries 03-22-2019, 07:52 AM
Replies: 8
Views: 103
Posted By isladogs
Re: Reset Rank column in MS Access query every year

All you appear to have done is reposted what you had in post #1.
Did you look at the two links I suggested?
Forum: Modules & VBA 03-22-2019, 01:58 AM
Replies: 10
Views: 123
Posted By isladogs
Re: Selecting email from a table

Always test issues like this with a Debug line
You need to add delimiters e.g. for text field

DLookup("[email]", "[tblSupplierDetails]", "SupplierNumber = ' " &...
Forum: Queries 03-22-2019, 01:50 AM
Replies: 8
Views: 103
Posted By isladogs
Re: Reset Rank column in MS Access query every year

Have a look at the method described here using the Serialize function:
http://www.mendipdatasystems.co.uk/rank-order-queries/4594424063

Or try the subquery approach in the link from there to...
Forum: Queries 03-22-2019, 01:12 AM
Replies: 5
Views: 131
Posted By isladogs
Re: Cannot Use Query Criteria From text Box?

The last post was moderated. Posting now to trigger email notifications

I also added code tags to make it more readable
Forum: Sample Databases 03-21-2019, 02:07 PM
Replies: 1
Views: 158
Posted By isladogs
Re: Securing Your Databases - A Tutorial

Many thanks are due to Frothingslosh for informing me of an error related to disabling the Shift Bypass key.

I have updated both the example application and the PDF to version 1.3 to fix that...
Forum: Forms 03-21-2019, 09:08 AM
Replies: 22
Views: 284
Posted By isladogs
Re: Get name of opening form and pass as variable

It was just for tidying up.
If you call the variable again from another form the value is automatically overwritten. But if you don't its hanging around in memory.
That will only be an issue if you...
Forum: Forms 03-21-2019, 08:55 AM
Replies: 22
Views: 284
Posted By isladogs
Re: Get name of opening form and pass as variable

On behalf of all of us, you're welcome.
Its always good seeing a variety of solutions

As you've gone for my approach, you might want to add the line strFormName = "".
The easiest way would be...
Forum: Forms 03-21-2019, 06:48 AM
Replies: 22
Views: 284
Posted By isladogs
Re: Get name of opening form and pass as variable

In a standard module, create a public string variable strFormName or similar.
In your 3 calling forms, add a line strFormName =Me.Name just before you open the called form.
Then replace the...
Forum: General 03-21-2019, 06:17 AM
Replies: 1
Views: 100
Posted By isladogs
Re: hide password

Either use a masked input box http://www.mendipdatasystems.co.uk/masked-input-box/4594462216 or create your own form with a password mask
Forum: Forms 03-21-2019, 06:15 AM
Replies: 3
Views: 100
Posted By isladogs
Forum: Modules & VBA 03-21-2019, 05:13 AM
Replies: 25
Views: 331
Posted By isladogs
Re: ORDER BY will not work in report's Me.RecordSource

The sort behaviour has been the same for many versions. Probably since version 1. I could check that later today!

Whilst frustrating when you first experience it, there is a major advantage in...
Forum: Reports 03-21-2019, 03:32 AM
Replies: 4
Views: 102
Posted By isladogs
Re: Put duplicated data in a report

You could use button event code so that it automatically prints two copies or if emailing use code to send to customer with copy to store. No need to depend on end user remembering to do so.
With...
Forum: Reports 03-21-2019, 01:03 AM
Replies: 16
Views: 180
Posted By isladogs
Re: Bank Statemant

One last try.
1. The balance should be negative when you are overdrawn so put a minus sign on that expression.
2. The balance shown on each row should be the balance after that transaction has...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:47 AM.


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