Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.57 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Introduce Yourself Today, 05:34 AM
Replies: 4
Views: 33
Posted By Uncle Gizmo
Re: Hey!

Welcome to Access World Forums (AWF). I can practically guarantee you will get some help, unless you come up with a really obscure question! But most questions have been asked and answered before, so...
Forum: Queries Today, 05:26 AM
Replies: 49
Views: 8,998
Posted By Uncle Gizmo
Re: IIF returns 0 instead of boolean

Well in some languages it could well be 1 and 0, but in VBA it's 0 and -1 ... But that's not exactly true either, if you read this Microsoft help file "Boolean" is itself "Boolean" - not a number. ...
Forum: Other Software Yesterday, 08:14 AM
Replies: 7
Views: 111
Posted By Uncle Gizmo
Re: Quicken Deluxe

If you have an Android phone & a Gmail account then this means you have access to many of Google's free software offerings. One of them is "Google Forms" (https://www.google.co.uk/forms/about/) a...
Forum: The Watercooler Yesterday, 02:58 AM
Replies: 2
Views: 49
Posted By Uncle Gizmo
Merry Christmas everyone!

https://www.bbc.co.uk/news/av/uk-england-york-north-yorkshire-50690345/moment-baby-daughter-s-new-hearing-aids-are-turned-on

Sent from Newbury UK
Forum: Other Software 12-06-2019, 07:25 PM
Replies: 7
Views: 111
Posted By Uncle Gizmo
Re: Quicken Deluxe

I noticed you have yet to receive a reply, hence I am bumping it up the list to see if it gets a few more views
Forum: Excel 12-06-2019, 04:02 AM
Replies: 0
Views: 62
Posted By Uncle Gizmo
New Excel function

I was impressed with this video demonstrating an up-and-coming new function for filtering in Excel....

https://youtu.be/eqB2mklvWSg

Sent from Newbury UK
Forum: Modules & VBA 12-04-2019, 04:58 PM
Replies: 23
Views: 406
Posted By Uncle Gizmo
Re: calculate multi yes/no fields in percentage

You had a square wheel, and instead of changing it to a round wheel as advised by many, you got a team of horses to pull the cart.

But when you get to a hill, you are going to need to get behind...
Forum: Modules & VBA 12-04-2019, 03:32 PM
Replies: 23
Views: 406
Posted By Uncle Gizmo
Re: calculate multi yes/no fields in percentage

The correct structure is language independent.



Sent from Newbury UK
Forum: Modules & VBA 12-04-2019, 03:30 PM
Replies: 23
Views: 406
Posted By Uncle Gizmo
Re: calculate multi yes/no fields in percentage

I don't agree...



Sent from Newbury UK
Forum: Modules & VBA 12-04-2019, 01:23 PM
Replies: 23
Views: 406
Posted By Uncle Gizmo
Re: calculate multi yes/no fields in percentage

The design of your database is completely wrong...

See my blog:-

https://www.niftyaccess.com/excel-in-access/

for an explanation of how to correct these problems easily.

I also provide a...
Forum: The Watercooler 11-29-2019, 04:55 PM
Replies: 9
Views: 205
Posted By Uncle Gizmo
Re: Smarting Incredulously...

Thanks for the warning, I won't wear these shorts ever again!

Sent from Newbury UK
Forum: The Watercooler 11-29-2019, 02:18 PM
Replies: 9
Views: 205
Posted By Uncle Gizmo
Smarting Incredulously...

After many years of coding, it never ceases to amaze me how, time and time again I spend many hours scratching my head, suffering in anguish, as I look for an error, which turns out to be that I have...
Forum: The Watercooler 11-29-2019, 05:43 AM
Replies: 35
Views: 438
Posted By Uncle Gizmo
Re: Thanksgiving plans

Brilliant explanation as usual Richard!

I've even learnt something I didn't know! I've always heard about "black Friday" but didn't know where it originated. It always seems a bit odd to me,...
Forum: The Watercooler 11-28-2019, 03:39 PM
Replies: 35
Views: 438
Posted By Uncle Gizmo
Re: Thanksgiving plans

This is the right place to ask this question! You may not know this but this is fundamentally a UK based forum. It started out mostly UK, but now I think it has a lot more US than UK, and then a good...
Forum: The Watercooler 11-27-2019, 09:19 AM
Replies: 22
Views: 394
Posted By Uncle Gizmo
Re: got a few questions for the gamers around here...

Been playing subspace on and off for about 20 years (https://en.wikipedia.org/wiki/SubSpace_(video_game)) it was one of the first multi person online games. I used to play it with a modem...
Forum: Reports 11-27-2019, 09:07 AM
Replies: 12
Views: 162
Posted By Uncle Gizmo
Re: How to change subreport source dynamically?

I don't think it's possible to do what you're trying to do. You've only got one subform, and you want to change it Record Source on each generation of its display in the main report. I have on many...
Forum: Queries 11-27-2019, 08:24 AM
Replies: 1
Views: 158
Posted By Uncle Gizmo
Re: Excel VBA - "[Microsoft][ODBC Text Driver] Record is too Large." - Joining 2 csv

I noticed your question has yet to receive a reply so I am pumping it up the list so that it gets a second look - best of luck
Forum: Reports 11-27-2019, 01:20 AM
Replies: 12
Views: 162
Posted By Uncle Gizmo
Re: How to change subreport source dynamically?

Reading your question, I get the impression that your data structures are incorrect. I realise that you have not provided your data structure, so my comment might seem a bit strange to you.

When...
Forum: Modules & VBA 11-26-2019, 02:56 PM
Replies: 21
Views: 278
Posted By Uncle Gizmo
Re: Using Access to automate a Pivot Table in Excel

Paul,
What about making the Excel subroutine "CreatePivotTable" into a public function, and then call that function from MS Access?
Forum: Modules & VBA 11-26-2019, 10:55 AM
Replies: 21
Views: 278
Posted By Uncle Gizmo
Re: Using Access to automate a Pivot Table in Excel

I have used this excellent code from Bob Larson (https://btabdevelopment.com/about/) a Former prolific Contributor to AWF to manipulate Excel. Export A Table Or Query To Excel...
Forum: Forms 11-26-2019, 04:04 AM
Replies: 19
Views: 235
Posted By Uncle Gizmo
Re: Requery List Boxes

I think I've got the gist of your question, but I thought I should reiterate it for clarity.
You have a pop-up form in which you can add a new customer.
When this popup form is closed, you want to...
Forum: Introduce Yourself 11-25-2019, 02:14 PM
Replies: 6
Views: 164
Posted By Uncle Gizmo
Re: What have I gotten myself into?

Well, I'm not sure. if you look at all of the Microsoft help files, there is no longer a reference to VBA it just says VB....





Sent from Newbury UK
Forum: Forms 11-25-2019, 06:00 AM
Replies: 14
[SOLVED] SEESAW Form?
Views: 256
Posted By Uncle Gizmo
Re: SEESAW Form?

I think see-saw is a brilliant name for it, it's exactly right, but it just doesn't have something... So when I think of see-saw I think of "Snoopy" so I reckon it should be called a "Snoopy"
...
Forum: Forms 11-25-2019, 05:05 AM
Replies: 14
[SOLVED] SEESAW Form?
Views: 256
Posted By Uncle Gizmo
Re: SEESAW Form?

I have built just one Class. I built it in stages over several years, adding refinements as and when they occured to me.

The Class, on the face of it is quite simple, but even as the creator, I...
Forum: The Watercooler 11-24-2019, 02:23 PM
Replies: 77
Views: 1,649
Posted By Uncle Gizmo
Re: Prince Harry, Duke of Sussex

Have you tried the chocolate Hobnobs!



Sent from Newbury UK
Showing results 1 to 25 of 500

 
Forum Jump



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