Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: isladogs
Forum: Politics & Current Events Today, 12:13 AM
Replies: 407
Views: 22,788
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

The harmful effects of aircraft con trails on the atmosphere have been known about for decades. Damage to the ozone layer is one such effect. In fact this was covered in detail in one of my final...
Forum: General Yesterday, 11:59 PM
Replies: 1
Views: 40
Posted By isladogs
Re: create password without code vba

That's a standard Access feature. Do you have a question about it?
Forum: Introduce Yourself Yesterday, 11:52 PM
Replies: 1
Views: 20
Posted By isladogs
Re: G'day!

Welcome to AWF
Forum: Reports Yesterday, 11:39 PM
Replies: 3
Views: 35
Posted By isladogs
Re: Export multiple PDF reports with recordset loop VBA

The thread was moderated. Posting here to trigger email notifications.
I also added code tags to make the code easier to read.
For future posts, please use the code tag button (#) on the toolbar.
Forum: Modules & VBA Yesterday, 10:39 PM
Replies: 15
Views: 170
Posted By isladogs
Re: Keep Access Application Minimized

in the example app there are separate buttons to restore the application window, navigation pane and ribbon individually.
However, the new code does seem to be interfering with the ribbon being...
Forum: Forms Yesterday, 02:19 PM
Replies: 4
Views: 59
Posted By isladogs
Re: displaying data from an xml file on a form

Research using the Split function.
As a first step, see https://www.techonthenet.com/access/functions/string/split.php
Use raw_text> as your delimiter
Forum: Politics & Current Events Yesterday, 02:01 PM
Replies: 407
Views: 22,788
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Almost all of the last reply is incorrect.
Nobody involved in climate change research stated that 'we only have 12 years to live' 20 years ago nor is anyone saying it now ... other than those...
Forum: Politics & Current Events Yesterday, 11:29 AM
Replies: 407
Views: 22,788
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Hmm. "Junior scientist" is another one of your pejorative statements. I am a scientist by training and taught science for almost 40 years. When will I stop being 'junior' in your expert view?

When...
Forum: Politics & Current Events Yesterday, 10:01 AM
Replies: 407
Views: 22,788
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I asked because you are 100% negative every time you comment on science related issues. It is the science you slate, not the scientists. Moreover, you do so with little or no evidence to back up a...
Forum: Reports Yesterday, 08:22 AM
Replies: 11
Views: 107
Posted By isladogs
Re: background color value

OK then - like this ? I hope so! ;)

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=75601&stc=1&d=1563553102

I've removed the previous conditional formatting from v2
To...
Forum: Modules & VBA Yesterday, 08:08 AM
Replies: 15
Views: 170
Posted By isladogs
Re: Keep Access Application Minimized

Good news. I've just successfully tested the updated version of my app in 64-bit Access and have uploaded it to sample databases: ...
Forum: Sample Databases Yesterday, 08:04 AM
Replies: 13
Views: 10,581
Posted By isladogs
Re: Show/hide application window, navigation pane, ribbon, taskbar

Updated once again to v3.4
The new version fixes a long standing issue that has been requested several times.
It has been tested in both 32-bit and 64-bit Access
Previously if the app was open but...
Forum: Reports Yesterday, 07:28 AM
Replies: 11
Views: 107
Posted By isladogs
Re: background color value

Is the attached what you want? If so black text may be better when the background is yellow.
I used conditional formatting as previously suggested by others.

Strongly recommend your field names...
Forum: Modules & VBA Yesterday, 06:59 AM
Replies: 15
Views: 170
Posted By isladogs
Re: Keep Access Application Minimized

I'll test it in 64-bit later today and let you know
Forum: Modules & VBA Yesterday, 04:03 AM
Replies: 7
Views: 116
Posted By isladogs
Re: Dlookup with two criteria

I only said that Name was a reserved word. Whatever you call it an age field is a bad choice fora different reason as previously explained
Forum: Modules & VBA Yesterday, 03:46 AM
Replies: 15
Views: 170
Posted By isladogs
Re: Keep Access Application Minimized

I have a newer version that fixes that. Iíve only tested it in 32-bit Access so far.
Can post this evening UK time when Iím back home
Forum: Queries Yesterday, 12:43 AM
Replies: 6
Views: 97
Posted By isladogs
Re: Delete duplicates from table based on Find duplicates query

Jacek
You may have already solved your issue but as you haven't yet replied to my last post I'll go ahead with an example which I prepared earlier (rather than reinvent the wheel) ;)

The attached...
Forum: Forms Yesterday, 12:25 AM
Replies: 16
Views: 287
Posted By isladogs
Forum: Modules & VBA 07-18-2019, 11:50 PM
Replies: 7
Views: 116
Posted By isladogs
Re: Dlookup with two criteria

So what happened when you tried DBG's suggestion?

Two other things
1. Name is a reserved word in Access so shouldn't be used as a field name. That's why DBG enclosed it in []
2. Age should never...
Forum: Politics & Current Events 07-18-2019, 11:19 PM
Replies: 407
Views: 22,788
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

AB
Has there been any worthwhile Science in your opinion since the laws of gravity or has it all been downhill from then on? :rolleyes:
Forum: General 07-18-2019, 10:49 PM
Replies: 26
Views: 329
Posted By isladogs
Re: Validation Key for DB - hash email and exp date

I agree completely with your comments about security being only as good as the weakest link. In fact it was partly what I was referring to in my initial reply (post #9?)
Forum: Forms 07-18-2019, 10:45 PM
Replies: 16
Views: 287
Posted By isladogs
Re: Form for entering grades for children

Glad to hear you're making progress. What changes did you make to do so?
If you have linked your subforms to the main form, navigating on the main form should automatically apply to the subforms as...
Forum: General 07-18-2019, 02:22 PM
Replies: 26
Views: 329
Posted By isladogs
Re: Validation Key for DB - hash email and exp date

Hi arnel
As you say, the OP wants to keep it simple. I've expressed my views but that's not what he wants to do.
However, I do wonder whether there is any point protecting database licensing...
Forum: Queries 07-18-2019, 10:22 AM
Replies: 3
Views: 53
Posted By isladogs
Re: Query to create index not working - Resources exceeded

The sequence you've described seems very strange.
Why delete existing records? Why delete the index then reinstate it?
The only logical reason would seem to be that the imported data has...
Forum: General 07-18-2019, 10:16 AM
Replies: 17
Views: 308
Posted By isladogs
Re: Scaling Down Form

That's very good news. Glad I could help
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:02 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