Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.04 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Reports Yesterday, 01:40 PM
Replies: 6
Views: 94
Posted By Uncle Gizmo
Re: Custom naming pdf reports generated using a loop

If you have a look at my Nifty Tips (http://www.niftyaccess.com/nifty-tips/) on my website here:- http://www.niftyaccess.com/nifty-tips/ if you look at, I think it's the 4th tip down "Take out the...
Forum: Reports Yesterday, 01:30 PM
Replies: 6
Views: 94
Posted By Uncle Gizmo
Re: Custom naming pdf reports generated using a loop

I'm glad you managed to extract some useful information from it.

The problem is, I am explaining an answer to an individual question. I also use several different ideas, pulling them together to...
Forum: Reports Yesterday, 12:31 PM
Replies: 6
Views: 94
Posted By Uncle Gizmo
Re: Custom naming pdf reports generated using a loop

You need to loop through the record set as well. I'm pretty sure I covered it in my blog here without having a look! Generate Multiple Reports (http://www.niftyaccess.com/generate-multiple-reports/)
Forum: Forms Yesterday, 06:58 AM
Replies: 2
Views: 88
Posted By Uncle Gizmo
Re: Form Combobox filter, (boolean), in header

I think I understand your question, however there is plenty of room for misunderstanding.

I'm guessing what you need is an unbound combobox, and a query to limit its values to unique values. I'm...
Forum: General Yesterday, 05:32 AM
Replies: 19
Views: 258
Posted By Uncle Gizmo
Re: Multi user run of a db application

No not clogs, sneakers!
Forum: General Yesterday, 05:01 AM
Replies: 19
Views: 258
Posted By Uncle Gizmo
Re: Multi user run of a db application

I disagree Colin! There's at least 3!

Sent from my SM-G925F using Tapatalk
Forum: Reports 09-24-2018, 06:44 AM
Replies: 2
Views: 81
Posted By Uncle Gizmo
Re: Report Based On Textbox Value - Access 2007

I haven't really grasped the essence of your question. I get the impression that you think you can get the result you want by modifying the report. I'm thinking you should actually be working on the...
Forum: General 09-23-2018, 06:25 AM
Replies: 2
Views: 163
Posted By Uncle Gizmo
Re: Free Code Samples & Example Databases

Hi Colin, I have just posted a link to your samples and examples in my Facebook group "MS.Access.Hints.And.Tips" here:- https://www.facebook.com/groups/MS.Access.Hints.And.Tips ... I've got in...
Forum: Modules & VBA 09-23-2018, 06:04 AM
Replies: 24
Views: 283
Posted By Uncle Gizmo
Re: Assign Global Variable to TextBox Control Source

An interesting feature of my method is that if you add the following line of code:-

CallCalled.prpPrincipleCtrl = Me.txtPartName

Either place it in the forms Close event or in the onclick event...
Forum: Modules & VBA 09-23-2018, 05:55 AM
Replies: 24
Views: 283
Posted By Uncle Gizmo
Re: Assign Global Variable to TextBox Control Source

I got the wrong end of the stick with your question. Although I think my question does have some merit in that maybe your Design is a little out of kilter. But I am in no position to judge that from...
Forum: Modules & VBA 09-22-2018, 09:43 PM
Replies: 24
Views: 283
Posted By Uncle Gizmo
Re: Assign Global Variable to TextBox Control Source

Why can't you use the child parent linking of the subform/subreport control?

Sent from my SM-G925F using Tapatalk
Forum: The Watercooler 09-22-2018, 12:41 PM
Replies: 0
Views: 54
Posted By Uncle Gizmo
4G Tank!

This guy Peter has built a remote controlled tank with an excellent camera for seeing where he's going, and that can be operated remotely over 4G! Basically operated anywhere in the world with a good...
Forum: Introduce Yourself 09-22-2018, 12:18 PM
Replies: 2
Views: 80
Posted By Uncle Gizmo
Re: New guy on the block

Hi Don 88! I reckon you must be the oldest dude here! Mind you a lot of us are quite old, but probably not from your perspective! Welcome to the forum, you're definitely in the right place if you...
Forum: Modules & VBA 09-22-2018, 05:15 AM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

I stopped using "hidden controls" a few years ago. I refer to them as the the "yellow boxes" "yellow perils" because traditionally they have their back colour set to "yellow". When you view the form...
Forum: Forms 09-21-2018, 11:46 AM
Replies: 2
Views: 102
Posted By Uncle Gizmo
Re: Changing the font of a field in a form based on another form

Your thread was marked solved? I assume it is a mistake, and have unmarked it. If you wanted it Mark "Solved" then please reset it again..
Forum: Modules & VBA 09-21-2018, 09:04 AM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

I think one of the main reasons I didn't get much traction with it, besides not really promoting it anywhere is the fact that I promote it a "class module" for loading calendar forms.

Seeing this...
Forum: Modules & VBA 09-21-2018, 08:51 AM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

Let me try and explain it a different way round for you.

The code isn't for you, you are obviously an expert VBA coder who is quite happy coding your own VBA code. However there are people that...
Forum: Modules & VBA 09-21-2018, 07:08 AM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

I thought I'd already posted this video, but I see I haven't posted it in this thread.

This gives you another explanation of how it works, let's see if you can "get it" this time shall we!
...
Forum: Modules & VBA 09-21-2018, 06:48 AM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

Oh dear somebody got out of the wrong side of bed this morning!

I think you ought to have another look at it. I think the problem is I haven't explained it very well yet, I'm working on that and...
Forum: Modules & VBA 09-20-2018, 01:18 PM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

In this Google Presentation is an overview of how it works:-...
Forum: General 09-19-2018, 11:07 PM
Replies: 9
Views: 277
Posted By Uncle Gizmo
Re: I'm worried for future versions of Access

The same question has bothered me periodically over the years. At one stage I was actively looking at moving over to everything Google. I was deceived by their "Do No Harm" message but it turned...
Forum: General 09-19-2018, 12:21 PM
Replies: 4
Views: 214
Posted By Uncle Gizmo
Re: Credentialing Database Help!!! I'm Stuck...

To repeat myself, I point you to an article I posted on LinkedIn recently, basically I say the same, but possibly worded a little stronger!

Moving from Excel to MS Access - Three problems to...
Forum: General 09-19-2018, 12:11 PM
Replies: 4
Views: 214
Posted By Uncle Gizmo
Re: Credentialing Database Help!!! I'm Stuck...

I stopped reading when I got to there!

If I understand correctly you have 7 columns one for each facility. That could well be a big problem. This is commonly known as "Excel in Access" ...
Forum: General 09-19-2018, 02:26 AM
Replies: 4
Views: 176
Posted By Uncle Gizmo
Re: Help for a complete access n00b

I don't know where I read it, I know it was a few years ago. It was a thread where some people were discussing creating questionnaires, the general consensus was it's a very difficult thing to do in...
Forum: Modules & VBA 09-18-2018, 01:35 PM
Replies: 20
Views: 393
Posted By Uncle Gizmo
Re: VBA to reuse data entry popup form

Here's a run through of the Call Called Class Module in action, in a YouTube video:-

Nifty Access - Call Called - Class Module (https://youtu.be/WNeUIyxBYIQ)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:33 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World