Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 85
Search took 0.08 seconds.
Search: Posts Made By: Galaxiom
Forum: Politics & Current Events 04-04-2019, 07:47 AM
Replies: 339
Views: 16,524
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Doc

I watched the You Tube video till the end thinking that perhaps there might be some value in it.
After all you said it speaks for itself. Unfortunately not.
I really did not

The few...
Forum: Politics & Current Events 01-29-2019, 10:06 AM
Replies: 339
Views: 16,524
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Doc
Thanks for responding this time.

Like you I am a scientist though in my case Physics with Maths rather than Chemistry.
Like you I have no formal qualifications in climatology but I also...
Forum: Queries 01-11-2019, 03:06 AM
Replies: 17
Views: 781
Posted By CJ_London
Re: Syntax problem on building SQL using wildcard * on a numeric field

At one time you could not use leading wildcards in ADO recordsets, but I believe you can now.

As with other responders I avoid leading wildcards like the plague (although I accept there are...
Forum: Politics & Current Events 01-07-2019, 07:41 AM
Replies: 339
Views: 16,524
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Doc

I did watch the last two videos you posted / discussed here & at the Mind Tavern. IIRC, the first was an interview on Fox with a scientist who had worked all his life for organisations such as...
Forum: General 01-02-2019, 04:06 PM
Replies: 2
Views: 1,512
Posted By Uncle Gizmo
Invalid Bracketing

I see many beginners with MS Access using field names with spaces in. Access can handle this, it puts square brackets around these "Offensive" objects!

I say "offensive" because they offend me!...
Forum: Queries 12-05-2018, 03:01 PM
Replies: 14
Views: 464
Posted By isladogs
Re: Save query count to variable

I ran both tests on queries as well as tables
The queries did include an indexed field.

Just for info I redid both sets of tests on the PK field itself.

That had the effect of speeding up the...
Forum: Politics & Current Events 11-28-2018, 11:15 AM
Replies: 339
Views: 16,524
Posted By isladogs
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

It did indeed - I didn't mention that word though I do have some sympathy with that viewpoint.

My take on the video was that it was at best a selective interpretation of the evidence available...
Forum: Code Repository 11-03-2018, 08:15 AM
Replies: 3
Views: 939
Posted By isladogs
Show Plan - Run Faster

I have recently been running a series of speed tests to compare the efficiency of different approaches to the same task. These tests are located in various locations across this forum or can all be...
Forum: Code Repository 11-02-2018, 03:18 PM
Replies: 0
Views: 765
Posted By isladogs
Another Mythbuster - Speed Tests - Conditional Updates

Following on from this thread, Help with multiple IIF statements (https://www.access-programmers.co.uk/forums/showthread.php?t=30222), Iíve done another speed test to compare the different ways of...
Forum: Code Repository 11-01-2018, 03:07 PM
Replies: 16
Views: 1,968
Posted By CJ_London
Re: Speed Comparison Tests - Having vs Where

Like you, I've always believed WHERE provides a better optimisation than HAVING, but according to this thread, the execution plan is the same
...
Forum: Code Repository 11-01-2018, 02:33 PM
Replies: 16
Views: 1,968
Posted By isladogs
Mythbusters - Speed Comparison Tests - Having vs Where

This is a follow up to a recent thread Desperate-Count Help Needed https://www.access-programmers.co.uk/forums/showpost.php?p=1597549&postcount=8

Part of this included discussion of the...
Forum: Modules & VBA 09-24-2018, 11:39 PM
Replies: 24
Views: 379
Posted By isladogs
Re: Changing a query Dynamically

Galaxiom
It would indeed be helpful if you could report back exactly what protection adding a digital signature provides for the MDB/MDE format.

It is worth mentioning that, though otherwise more...
Forum: Theory and practice of database design 09-24-2018, 12:58 PM
Replies: 2
Views: 1,875
Posted By isladogs
Access File Security : MDB / MDE vs ACCDB / ACCDE

I’ve been going on about security in Access databases for some time.

Whilst there are many things that developers can do to improve the security of their applications (both design & data), no...
Forum: Modules & VBA 09-23-2018, 04:42 AM
Replies: 24
Views: 340
Posted By sonic8
Re: Assign Global Variable to TextBox Control Source

The icon in the title bar of the windows gives it away.
Forum: General 09-19-2018, 02:09 AM
Replies: 12
Views: 420
Posted By isladogs
Re: Access FE and SQL Server BE, security

In an ACCDB you can see the full connection path (including user name and password) using a Hex editor.
...
Forum: Modules & VBA 09-12-2018, 10:49 AM
Replies: 2
Views: 109
Posted By CJ_London
Re: Open Report when clicking label for Text Box

you can use the click event on a label providing it is unbound. If it is bound to a control, then it will take its events from the control it is bound to.

to unbind a label, select it and delete...
Forum: Modules & VBA 08-19-2018, 11:58 PM
Replies: 10
Views: 304
Posted By CJ_London
Re: Proper >= And < Where Condition in VBA

suggest simpler to add a day and use <
Forum: General 05-22-2018, 06:04 AM
Replies: 11
Views: 1,959
Posted By The_Doc_Man
Re: Microsoft User Voice - I've suggested increasing Max File Size from 2GB

The reason you have a 2 GB limit at all is hardware-model & structural, for the 32-bit version of Access, and probably compatibility for the 64-bit version.

The standard structure of any Windows...
Forum: Queries 04-22-2018, 05:45 AM
Replies: 10
Views: 627
Posted By plog
Re: Show the first record

Seriously, this needs to stop.

It's as if you slightly glance at the original posters post, totally miss other's valid responses and immediately fire up a module to solve everything via code.
...
Forum: General 04-10-2018, 11:46 AM
Replies: 13
Views: 1,251
Posted By NauticalGent
Re: Evolution an the Access User

Now that is a profound statement from a magician of the first order!



And I am a card-carrying member of that club, not fun looking in the mirror but it sure is a hoot earning my membership!
...
Forum: General 04-10-2018, 01:07 AM
Replies: 13
Views: 1,251
Posted By Lightwave
Re: Evolution an the Access User

NG - really great idea

I try to practice humility not because I enjoy it but because I selfishly believe that it is the best way of getting better. I am a strong believer in the idea of...
Forum: General 04-07-2018, 09:09 PM
Replies: 13
Views: 1,251
Posted By NauticalGent
Evolution an the Access User

As is normal to human behavior, I tend to classify people by their attributes and pidgin-hole them (it has gotten me into some minor trouble in the past) accordingly.

Since joining this forum...
Forum: General 03-14-2018, 04:50 PM
Replies: 14
Views: 526
Posted By MarkK
Galaxiom made a typo, it should be.... ...

Galaxiom made a typo, it should be....
Forms!Invoices.InvoiceSearch_AfterUpdate
You are referencing a named member of the global Forms collection.

This is incorrect...

...because if the form...
Forum: The Watercooler 02-10-2018, 06:48 AM
Replies: 6,024
Views: 549,749
Posted By The_Doc_Man
Re: Are you an atheist?

G - agree that religion can be insidious. Aziz and I went around the mulberry bush many times over his quotes from the Qur'an and I could not make him realize that his reading of the raw words had...
Forum: Queries 12-30-2017, 07:29 AM
Replies: 7
Views: 561
Posted By isladogs
TIP How to show rank order in a query

Its easy to create a rank order in Access reports but not so easy in queries
If you Google you will find several methods of doing so, but this is the easiest method I'm aware of

Attached is a...
Showing results 1 to 25 of 85

 
Forum Jump



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