Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 477
Search took 0.19 seconds.
Search: Posts Made By: NauticalGent
Forum: Modules & VBA 01-13-2020, 04:55 PM
Replies: 3
Views: 329
Posted By MajP
What You Need to Know About Access Events

There is often a lot of confusion about Access Events and often answering questions posed here is difficult because of inaccurate terminology. People often say "Event" when it is unclear if they...
Forum: The Watercooler 01-09-2020, 06:23 PM
Replies: 15
Views: 295
Posted By Tera
Re: PC vs mac

It all depends on how you look at it. It's true that a Windows OS is more vulnerable than mac. There are two reasons windows is infected more often than Mac.

Firstly, It's because Mac has all the...
Forum: Site Suggestions 01-08-2020, 09:17 AM
Replies: 18
Views: 259
Posted By Jon
Re: Suggested changes to reputation points

Mr Nautical, since no one has replied, I have done a halfway-house solution. I've reduced the Reputation Spread from 20 to 14. You get the extra 1 reduction due to being such a jolly chap!
Forum: Introduce Yourself 01-07-2020, 08:35 PM
Replies: 11
Views: 213
Posted By jocph
Hello All

First off, I am sorry for the confusion I inadvertently created recently with all the thanks that I purportedly given to posts. Even I was taken aback with the PMs I received about this. At first I...
Forum: The Watercooler 01-07-2020, 07:26 AM
Replies: 11
Views: 185
Posted By The_Doc_Man
Re: This guy...

Adam, truth is truth regardless of who speaks it. Doesn't matter whether Ricky Gervais is an atheist or the Pope's second-in-command. Too many folks who gain notoriety through thespian pursuits...
Forum: Site Suggestions 01-06-2020, 04:39 AM
Replies: 3
Views: 77
Posted By Uncle Gizmo
Re: Smileys

Has Adam hacked Jon's account?
Forum: Modules & VBA 01-05-2020, 04:49 PM
Replies: 21
Views: 368
Posted By isladogs
Re: Cashing in on Cache

Just noticed this thread.

I ran these caching tests last year as one of my many speed comparison tests but never got around to posting them until now.

The effect of caching was unsurprisingly...
Forum: Modules & VBA 01-05-2020, 11:11 AM
Replies: 21
Views: 368
Posted By Micron
Re: Cashing in on Cache

I admit I've never used it. Did you see this (https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-properties-dao) and find it not useful? I realize...
Forum: General 01-05-2020, 10:58 AM
Replies: 9
Views: 276
Posted By theDBguy
Re: How to speed-up Access DataBase on a Split table

Check out this article (https://www.devhut.net/2012/09/29/ms-access-persistent-connection-in-a-split-database/). Hope it helps...
Forum: The Watercooler 01-05-2020, 06:30 AM
Replies: 3
Views: 89
Posted By Uncle Gizmo
Re: Imho

#ThePolice #SoLonely #Vevo
The Police - So Lonely (Official Video) (https://youtu.be/MX6MvV8cbh8)

I agree!
Forum: The Watercooler 01-05-2020, 04:00 AM
Replies: 16
Views: 351
Posted By Steve R.
Re: the differences between country cultures

An invaluable observation. The media we hear/see only provides us with filtered and limited views of a country. Consequently, without international travel, one's view of the world is incomplete.
...
Forum: General 01-04-2020, 11:41 PM
Replies: 7
Views: 251
Posted By Abayomi
Re: Distributing access application without being physically present during installat

Thank you all for coming to my aid.

After exploring all of the listed suggestions here which make me feel like a carpenter who has more than a hammer in his toolbox,
I gave SSE setup a try and...
Forum: General 01-04-2020, 06:22 AM
Replies: 12
Views: 302
Posted By MajP
Re: Not IsNull, IsNull

Not wrong, but not complete.
Null is not the same as an empty string or a space. There are several ways to check for all three at once. Here is one

if not trim(me.customer & " ") = "" then

or...
Forum: Site Suggestions 01-02-2020, 01:05 AM
Replies: 39
Views: 726
Posted By Tera
Thanks and Like

I've been thinking about this for quite some time and even wrote this idea about the site several time, and I ended up not submitting the thread at last.

But I can't stop thinking about it. Though...
Forum: Modules & VBA 01-01-2020, 11:03 AM
Replies: 11
Views: 279
Posted By theDBguy
Re: Error 3061 too few parameters expected 2

I suggest you try using Leigh's Generic Recordset (http://www.accessmvp.com/thedbguy/codes.php?title=generic). For example:

Set rs1 = fDAOGenericRst("qryRaceEventTeamResultsIndividual")
Forum: The Watercooler 12-31-2019, 02:34 PM
Replies: 7
Views: 205
Posted By isladogs
20:20

Happy New Year to all AWF members
May 2020 be the year where we all have 'perfect vision' about the future
Forum: The Watercooler 12-30-2019, 10:58 AM
Replies: 31
Views: 504
Posted By isladogs
Re: traditional customer loyalty...

Believe me, we've all noticed. Do you know when to stop?
Forum: PHP & MySQL 12-30-2019, 05:18 AM
Replies: 13
Views: 341
Posted By ionutp23
Re: Display blob in php from table

As i promise maybe some one need it too this will display data from mysql from a table hyperlink text and image (table_name (row text, link,image as (blob) )

Index.php
<!DOCTYPE html>
<html...
Forum: General 12-29-2019, 06:20 PM
Replies: 57
Views: 1,341
Posted By MajP
Re: Good read: What's wrong with VBA

First of all I completely doubt there are any real "Developers" who do not know the difference. Next you will tell me you know serious developers who cannot declare variables and do not know how to...
Forum: Modules & VBA 12-29-2019, 04:14 AM
Replies: 8
Views: 266
Posted By gemma-the-husky
Re: Referring to arrays using variables

to access an array use this. Note that array indexes are zero-based.

myvar = arrayname(n) - returns the nth item of the array.
myvar = arrayname(x,y,z) - used for multi-dimensioned array.
...
Forum: General 12-28-2019, 07:33 AM
Replies: 15
Views: 382
Posted By isladogs
Re: Chip Pearson's website

I'm pleased to note that Chip's site is now back online http://www.cpearson.com/Excel/MainPage.aspx
Many thanks to anyone who has assisted in getting this back online again
Forum: General 12-28-2019, 01:03 AM
Replies: 13
Views: 215
Posted By isladogs
Re: Quote vs Multi Quote

See the FAQ. https://www.access-programmers.co.uk/forums/faq.php?faq=vb3_reading_posting#faq_vb3_replying

However, I find it doesn't work reliably and haven't used it in a long time.
Forum: Forms 12-26-2019, 10:14 AM
Replies: 51
Views: 789
Posted By vba_php
Re: link forms

that doesn't show anything. that's just a form with no sample data. it would be better for everyone if you put some fake data in, re-uploaded it and explained what textboxes play what part in this...
Forum: Access World News 12-25-2019, 05:06 AM
Replies: 7
Views: 414
Posted By Jon
Merry Christmas to all!

Just a quick note to wish everybody a Merry Christmas. Hope you all have a great day.
Forum: Introduce Yourself 12-24-2019, 03:52 PM
Replies: 15
Views: 298
Posted By Uncle Gizmo
Re: Hi Everyone

Richard speaks wisely --- You would do well to take note....
Showing results 1 to 25 of 477

 
Forum Jump



All times are GMT -8. The time now is 10:49 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World