Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 9.59 seconds.
Search: Posts Made By: Galaxiom
Forum: Politics & Current Events Today, 02:11 AM
Replies: 394
Views: 22,542
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

This paragraph from the page pretty much sums it up:
Forum: Politics & Current Events Today, 12:32 AM
Replies: 394
Views: 22,542
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

You have provided a perfect example how science identified the problem and got the world to take action. Not examples of over reaction by any means.

There was every reason to be worried about what...
Forum: Forms Yesterday, 08:04 PM
Replies: 8
Views: 85
Posted By Galaxiom
Re: Nothing shows in text box

Forms should always be referred to via a Collection. If it is loaded it will be in the Forms Collection.

Forms!formnameAll forms, loaded or not, can be referred to via the all AllForms Collection....
Forum: Forms Yesterday, 07:49 PM
Replies: 8
Views: 85
Posted By Galaxiom
Re: Nothing shows in text box

Your basic error is you are referring to the form via its module. This should never be done.

A hidden instance is being opened by the module reference. The form you open with the OpenForm Method...
Forum: Theory and practice of database design 07-11-2019, 04:21 PM
Replies: 9
Views: 244
Posted By Galaxiom
Re: Machinery Component Database

What I described is a self referencing structure. It is just that the relationship information is held in a separate table that can support relationships that don't demand serializing every single...
Forum: Theory and practice of database design 07-11-2019, 04:08 PM
Replies: 9
Views: 244
Posted By Galaxiom
Re: Machinery Component Database

You have a lot of repeating data in there.

The serialization information and fundamental part record should be separated out.
Forum: SQL Server 07-07-2019, 09:08 PM
Replies: 6
Views: 238
Posted By Galaxiom
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

I also note the SQL version is only the Levenshtein Distance.

Damearu-Levenshtein is considerably better in that accounts for the reversal of two characters rather than characterizing it as two...
Forum: SQL Server 07-07-2019, 08:26 PM
Replies: 6
Views: 238
Posted By Galaxiom
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

I tested with Australian Suburb-State records. The vast majority were strings between 11 and 22 characters.

These were produced as a DISTINCT list from a cartesian product of all Suburbs where the...
Forum: SQL Server 07-07-2019, 02:08 AM
Replies: 6
Views: 238
Posted By Galaxiom
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

I'll be interested to compare performance between them.
Forum: Politics & Current Events 07-06-2019, 02:30 PM
Replies: 394
Views: 22,542
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

"Crowther emphasised that it remains vital to reverse the current trends of rising greenhouse gas emissions from fossil fuel burning and forest destruction, and bring them down to zero. He said this...
Forum: SQL Server 07-06-2019, 03:52 AM
Replies: 6
Views: 238
Posted By Galaxiom
Re: Porting Access VBA to VB.NET CLR Functions in SQL Server

I started translating Damearu-Levenshtein Distance (https://www.access-programmers.co.uk/forums/showpost.php?p=1258195&postcount=10) function to SQL then discovered TSQL doesn't have arrays which...
Forum: Modules & VBA 07-04-2019, 05:32 AM
Replies: 1
Views: 123
Posted By Galaxiom
Porting Access VBA to VB.NET CLR Functions in SQL Server

I posted this over in SQL Server section but it is relevant to Access developers interested in porting VBA functions for use in SQL Server back ends.

Best add any discussion over there.
...
Forum: SQL Server 07-04-2019, 05:27 AM
Replies: 6
Views: 238
Posted By Galaxiom
Porting Access VBA to VB.NET CLR Functions in SQL Server

Today I opened a door in SQL Server and discovered a whole extra wing of machinery, particularly useful for Access VBA developers using SQL Server back ends. Turns out it is quite easy to port VBA...
Forum: Modules & VBA 07-01-2019, 01:22 AM
Replies: 2
Views: 76
Posted By Galaxiom
Re: VBA Help

Sounds like you are trying to get very similar data from two different tables.

This generally means there should only be one table.
Forum: Queries 07-01-2019, 01:16 AM
Replies: 3
Views: 92
Posted By Galaxiom
Re: Saving data from a textbox in a query using a condition

An update query?
UPDATE Table1
SET somefield = something
WHERE [Hrs] = Forms!formname.combo1
Forum: Queries 07-01-2019, 12:34 AM
Replies: 3
Views: 92
Posted By Galaxiom
Re: Saving data from a textbox in a query using a condition

Typically a bound form would be used with Hrs as the ControlSource of the combo.

Maybe tell us more about your project so we have a better idea of the context of your question.
Forum: Modules & VBA 06-28-2019, 03:32 AM
Replies: 9
Views: 272
Posted By Galaxiom
Re: Use a variable in SQL string in my VBA

The code shows your tables have the same fields. This confirms my suspicions.

There should be one table for all the data with an extra field to record what you are currently storing by directing...
Forum: Modules & VBA 06-27-2019, 03:54 PM
Replies: 9
Views: 272
Posted By Galaxiom
Re: Use a variable in SQL string in my VBA

It might not be the case here but often a need to select different table to be involved in otherwise similar or identical processes suggest that the data structure might not be ideal.

If you have...
Forum: Code Repository 06-26-2019, 08:46 PM
Replies: 10
Views: 1,471
Posted By Galaxiom
Re: use a textbox as a resizeable and colourful checkbox

I implemented a similar idea as a Class a few years ago. I intended to get it fully developed and post it but it dropped below the radar and I forgot about it until I just saw this thread.

The...
Forum: General 06-26-2019, 03:54 AM
Replies: 7
Views: 145
Posted By Galaxiom
Re: Optimization

Can be many different things. Missing indexes are likely when queries start to slow down as the data grows. If you have views on the server they can benefit from just being forced to rebuild their...
Forum: Modules & VBA 06-26-2019, 03:40 AM
Replies: 10
Views: 285
Posted By Galaxiom
Re: VBA as a language, how "deep" can we go?

That is more about ODBC. Basically anyone who wants their database platform to be widely relevant needs to include an ODBC driver for it.
Forum: Modules & VBA 06-26-2019, 03:21 AM
Replies: 10
Views: 285
Posted By Galaxiom
Re: VBA as a language, how "deep" can we go?

And those that aren't simple often behave very strangely and run like syrup on a cold day.
Forum: Politics & Current Events 06-26-2019, 03:14 AM
Replies: 394
Views: 22,542
Posted By Galaxiom
Forum: Politics & Current Events 06-26-2019, 03:13 AM
Replies: 394
Views: 22,542
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

That simplistic analysis shows culpable naivety about the transmission of radiation through a gas. The CO2 saturation myth is easily debunked by anyone who has any comprehension of the subject....
Forum: Politics & Current Events 06-25-2019, 11:13 PM
Replies: 394
Views: 22,542
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

The tobacco denialists involved a tiny fraction of scientists whose unsubstantiated opinions were in conflict with the established research. They had been bought by the tobacco industry.

Several...
Showing results 1 to 25 of 500

 
Forum Jump



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