Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: Galaxiom
Forum: Modules & VBA 11-18-2019, 10:36 PM
Replies: 23
Views: 305
Posted By Galaxiom
Re: Dealing with Null value on SQL Statement

Firstly, ask yourself why are the Month() and Year() functions are not capitalised. If you pasted actual code from the VBA editor they should have been. Perhaps you are posting the code you think you...
Forum: The Watercooler 11-17-2019, 03:53 PM
Replies: 21
Views: 332
Posted By Galaxiom
Re: what's your most complex VBA code project?

With a requirement to place comments on half the lines I'm not surprised you got useless comments.

I cannot stand comments like:
' Increment counter
' Set value on variable
' Test for EOF
'...
Forum: The Watercooler 11-16-2019, 05:35 PM
Replies: 47
Views: 687
Posted By Galaxiom
Forum: Modules & VBA 11-16-2019, 04:24 AM
Replies: 23
Views: 306
Posted By Galaxiom
Re: Module needed for "random 6 string" search

If it is one alpha character of either upper or lower case, followed by five digits, the regex expression required is:
[a-zA-Z]\d{5}

However you would be better to use validation to ensure the...
Forum: The Watercooler 11-15-2019, 11:53 AM
Replies: 47
Views: 687
Posted By Galaxiom
Re: Is OOP actually useful?

There are other VB features that are supported but are obscurities in VBA.

A For Each enumeration can be added and property of a custom class can be specified as the default. However this cannot...
Forum: Tables 11-15-2019, 11:35 AM
Replies: 8
Views: 161
Posted By Galaxiom
Re: How to set a field to accept like 1/2"

The import specification designates a character to be used around values that contain the value delimiter (such as a comma) in csv.

The double quote is designated in this role by default but can...
Forum: Tables 11-15-2019, 01:54 AM
Replies: 4
Views: 86
Posted By Galaxiom
Re: Lookup table properties

The bound column is the one that is stored in the table from a bound combo or list box. It is the Value Property of the control.

To control what is displayed, increase the ColumnCount and adjust...
Forum: Tables 11-15-2019, 01:17 AM
Replies: 4
Views: 86
Posted By Galaxiom
Re: Lookup table properties

You should be storing the ID. Always the ID.

What you display is controlled by the design of the form.
Forum: The Watercooler 11-15-2019, 12:28 AM
Replies: 47
Views: 687
Posted By Galaxiom
Re: Is OOP actually useful?

AI needs to develop metacognition. It probably would eventually because it is an effective technique to improve thinking skills.

https://en.wikipedia.org/wiki/Metacognition
Forum: Queries 11-14-2019, 10:11 PM
Replies: 23
Views: 736
Posted By Galaxiom
Re: Access error -query is corrupt

Our admin had a look at the updates and said he couldn't see it affecting Runtime 2010 which most of our staff use.
Forum: The Watercooler 11-14-2019, 07:10 PM
Replies: 47
Views: 687
Posted By Galaxiom
Re: Is OOP actually useful?

Perhaps you would care to explain your understanding of AI.

Here is something explaining what I was talking about.

https://en.wikipedia.org/wiki/Genetic_programming

Feel free to edit...
Forum: The Watercooler 11-14-2019, 03:18 PM
Replies: 47
Views: 687
Posted By Galaxiom
Re: Is OOP actually useful?

Not at all. You don't understand how AI works. It is very similar to biological evolution.

Basically the process starts with sets of random routines being applied to a problem and their results...
Forum: The Watercooler 11-13-2019, 09:35 PM
Replies: 25
Views: 439
Posted By Galaxiom
Re: why do IT people insist on internet communication?

Some still wandering up and ask if they should submit a ticket. They are starting to get the picture.
Forum: The Watercooler 11-13-2019, 03:11 PM
Replies: 25
Views: 439
Posted By Galaxiom
Re: why do IT people insist on internet communication?

I have experienced exactly this. We introduced an online help system where I work and really made a difference.
Forum: Tables 11-13-2019, 03:07 PM
Replies: 18
Views: 262
Posted By Galaxiom
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

Have not seen that happen but I don't do it often. Usuaully only if I am throwing something together quickly. I always C&R before creating the runtime version.



Absolutely nothing wrong with...
Forum: The Watercooler 11-13-2019, 02:25 PM
Replies: 25
Views: 439
Posted By Galaxiom
Re: why do IT people insist on internet communication?

People in support like to keep track of the conversation.
Forum: General 11-13-2019, 02:23 PM
Replies: 6
Views: 271
Posted By Galaxiom
Access bug on Update queries

Microsoft has advised of this Access bug in the recent updates.

It affects UPDATE queries and displays an error saying the query is corrupt.
...
Forum: General 11-13-2019, 01:09 PM
Replies: 11
Views: 188
Posted By Galaxiom
Re: Grand Total shows #error

You need to post a small sample database so we can see what you actually have.

Novices almost invariably confuse "fields" (in the recordset) and "controls" (textboxes etc) in their questions and...
Forum: Tables 11-13-2019, 01:03 PM
Replies: 18
Views: 262
Posted By Galaxiom
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

Lookup fields at table level makes it impossible to see what data is is actually in the table. The Caption property of the fields in the table are worse. They make it impossible to actually see the...
Forum: General 11-12-2019, 02:20 PM
Replies: 11
Views: 188
Posted By Galaxiom
Re: Grand Total shows #error

AFAIK The Sum() function always refers to fields so there should be no ambiguity.

When an expression could refer to either where fields and controls have the same name, Access defaults to the...
Forum: General 11-12-2019, 01:30 PM
Replies: 11
Views: 188
Posted By Galaxiom
Re: Grand Total shows #error

Try this:
=Sum(Nz([Price-A1],0))+Sum(Nz([Price-A2],0))+Sum(Nz([Price-A3],0))+Sum(Nz([Price-A4],0))
Forum: Code Repository 11-12-2019, 01:59 AM
Replies: 2
Views: 91
Posted By Galaxiom
Re: Get User info that is stored in the Active Directory

The Group information is a lot more complex because it is multivalued.

I covered some of that in this thread (https://access-programmers.co.uk/forums/showthread.php?t=258768).

I have still...
Forum: The Watercooler 11-10-2019, 02:51 PM
Replies: 40
Views: 441
Posted By Galaxiom
Re: the NZ() function

Unfortunately this common misconception has been promulgated by Microsoft in their explanation of Nz().



A function does not have the facility to return a value based on the context of the...
Forum: The Watercooler 11-10-2019, 02:24 AM
Replies: 21
Views: 332
Posted By Galaxiom
Re: what's your most complex VBA code project?

An application that looked up information stored in a database about text based reports in the file system, found them and parsed them. All the work was done in a Class. The parsed data was held in...
Forum: The Watercooler 11-09-2019, 03:26 PM
Replies: 40
Views: 441
Posted By Galaxiom
Re: the NZ() function

Nz() is handy to substitute another field or display something place of Nulls. However it is best avoided in Where clauses.

WHERE filedname Is Null OR fieldname = 0

should perform better than...
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