Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 82
Search took 0.03 seconds.
Search: Posts Made By: Frothingslosh
Forum: Politics & Current Events 09-03-2019, 03:35 PM
Replies: 433
Views: 25,072
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Willie Soon's papers have been widely and thoroughly discredited as nonsense.

From 2005 to 2015, Soon had received over $1.2 million from the fossil fuel industry, while failing to disclose that...
Forum: General 03-31-2019, 06:37 PM
Replies: 45
Views: 1,097
Posted By MajP
Re: Matching logic

Here is an intersting demo employing the three functions: SoundEx, Leveshtein, Simil.

On the left is a list of 2000 full names. Find a name in the list and misspell it. The soundex works will...
Forum: Modules & VBA 03-12-2019, 08:31 AM
Replies: 4
Views: 210
Posted By Minty
Re: Weird Adobe Export Error

Hmmm. I think I've read your tests correctly.

What if you juggle the null PO position or have nulls in all three...
Or don't have nulls anywhere....
Same issue?
Forum: Code Repository 02-24-2019, 01:50 PM
Replies: 1
Views: 763
Posted By isladogs
Timer Comparison Tests

Over the years, I have used various functions to measure time intervals: Timer, GetSystemTime, GetTickCount.

Each of these can give times to millisecond precision though I normally round to 2 d.p....
Forum: Politics & Current Events 01-19-2019, 04:53 PM
Replies: 433
Views: 25,072
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Coleman has no academic credentials in the field. He was a television weatherman.



https://en.wikipedia.org/wiki/John_Coleman_(meteorologist)
Forum: General 01-03-2019, 01:27 PM
Replies: 18
Views: 831
Posted By The_Doc_Man
Re: Combo Box Length Limit?

Did a follow-up search, found this article:

https://bytes.com/topic/access/answers/630271-display-more-than-255-char-field-combo-box

It is from 2007, so this is not a new issue. Maybe it will...
Forum: General 01-03-2019, 12:03 PM
Replies: 18
Views: 831
Posted By theDBguy
Re: Combo Box Length Limit?

Hi. My humble opinion is you might consider using another method besides a combobox. For example, maybe you can use a continuous form. You might be able to construct it to mimic a combobox.
Forum: General 12-13-2018, 07:00 AM
Replies: 0
Views: 156
Posted By isladogs
Office Account security breach fixed

A very simple security breach in Microsoft accounts has now been fixed by Microsoft 'ONLY' 4 months after being reported to them. It could have affected anyone with an MS account including all those...
Forum: Modules & VBA 10-23-2018, 02:16 PM
Replies: 3
Views: 319
Posted By CJ_London
Re: Fixing #DELETED# After Data Change

I have seen this behaviour before (quite some time ago) and if I remember correctly, there was an error in the data. It wasn't apparent unless you happened to come across the incorrect data whilst...
Forum: Modules & VBA 10-10-2018, 04:06 PM
Replies: 19
Views: 1,010
Posted By JHB
Re: Error 'Constant Expression Required' For Constant

I know you've solved it in a way, so ...
What happen if you create a new database and put the code you provide here (+ what is missing) and then change the parameters, do you get a compiler error...
Forum: Modules & VBA 10-10-2018, 01:33 PM
Replies: 19
Views: 1,010
Posted By The_Doc_Man
Re: Error 'Constant Expression Required' For Constant

OK, looking at the syntax and context, you were declaring a private constant and allowing VBA to decide the type for you. In the past, I've had issues by declaring constants after declaring anything...
Forum: Modules & VBA 10-10-2018, 10:52 AM
Replies: 19
Views: 1,010
Posted By Cronk
Re: Error 'Constant Expression Required' For Constant

Bit of corruption somewhere? Tried importing everything into a blank accdb?


Post your code. I'm sure any number of us would try to emulate your problem.
Forum: Code Repository 09-08-2018, 08:42 PM
Replies: 0
Views: 1,510
Posted By NauticalGent
Changing Saved Import XML

The need for Access and Outlook to talk to each other is inevitable. There are plenty examples on the web if all you are doing is working with your own e-mail account, but when you need to work with...
Forum: Modules & VBA 08-25-2018, 06:11 PM
Replies: 41
Views: 1,487
Posted By The_Doc_Man
Re: dbEngine(0)(0) vs Currentdb

I will step in for one related but slightly tangential comment.

The difference between DbEngine.Idle dbRefreshCache and DoEvents is that the former is a DBEngine-only event, whereas DoEvents...
Forum: Gaming 06-25-2018, 02:44 PM
Replies: 33
Views: 7,415
Posted By Vassago
Re: Elder Scrolls Online

By copying the address of the uploaded attachment? (Serious question. I've never tried, but I just linked to your profile pic.)

EDIT: Yep, that's how it's done. They copy/paste the address of...
Forum: Modules & VBA 06-06-2018, 11:58 AM
Replies: 4
Views: 189
Posted By JHB
Re: VBA to Close Excel Not Closing Excel

I would also comment that out:
On Error GoTo ErrHandlerWhat happen if you only have xlApp.Quit in ProcExit:.
Forum: Queries 04-22-2018, 05:45 AM
Replies: 10
Views: 634
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-07-2018, 09:09 PM
Replies: 13
Views: 1,268
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: Sample Databases 01-30-2018, 04:53 AM
Replies: 9
Views: 5,427
Posted By isladogs
A better date picker

Some months ago I uploaded a replacement date picker (see DatePicker.accdb attached) that has no Active X controls and can also be used in 64-bit Access.

It was originally posted in response to a...
Forum: The Watercooler 01-27-2018, 03:09 AM
Replies: 102
Views: 3,625
Posted By Galaxiom
Re: Deep South Deep Freeze

George Carlin was a smug idiot as is often the case with so called comedians.

Basically what he is saying is that it doesn't matter what a couple of generations of humans do to make the planet...
Forum: Code Repository 01-20-2018, 06:36 AM
Replies: 2
Views: 2,888
Posted By isladogs
TIP: Add colour to queries, listboxes & comboboxes

NOTE:
This is similar to the ideas in a thread I posted recently at: https://www.access-programmers.co.uk/forums/showthread.php?t=297618

The idea in this post was explained by an Access newbie...
Forum: Queries 12-29-2017, 03:31 PM
Replies: 13
Views: 1,215
Posted By isladogs
Colourful query

Just picked up this idea from another forum.
Apologies if this hint has been posted previously by others

Not sure how much use it is but I'll leave others to decide for themselves!
You can...
Forum: Modules & VBA 11-30-2017, 09:06 AM
Replies: 6
Views: 1,188
Posted By isladogs
Re: Need a Couple idMso Names

My suggestion if you want to build a ribbon only occasionally is to download a copy of a ribbon creator such as IMDB Ribbon Creator http://www.accessribbon.de/en/

A cut down version is available...
Forum: Modules & VBA 11-30-2017, 08:47 AM
Replies: 6
Views: 1,188
Posted By isladogs
Re: Need a Couple idMso Names

Or direct from MS:
https://www.microsoft.com/en-us/download/details.aspx?id=50745

That link is for 2016 but there are similar web pages for 2007/2010/2013.
Just do a search for Office System...
Forum: Modules & VBA 11-30-2017, 07:54 AM
Replies: 6
Views: 1,188
Posted By moke123
Re: Need a Couple idMso Names

check down around the middle of this page - http://codekabinett.com/page.php?Theme=10&Lang=2
theres a download for MS office object library which references the ribbon objects.
Showing results 1 to 25 of 82

 
Forum Jump



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