Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Reports Yesterday, 11:32 PM
Replies: 3
Views: 23
Posted By Uncle Gizmo
Re: Export multiple PDF reports with recordset loop VBA

I couldn't make head nor tail of your code. Possibly because I'm viewing it on my mobile.

I direct you to my website where I have noted the steps I took in helping another Access World Forums user...
Forum: Politics & Current Events Yesterday, 10:29 PM
Replies: 407
Views: 22,784
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

We could be heading for a mini ice age!

https://www.express.co.uk/news/science/1155380/weather-forecast-long-range-ice-age-solar-minimum-space-weather-city

Sent from my Pixel 3a using Tapatalk
Forum: Politics & Current Events Yesterday, 10:15 PM
Replies: 407
Views: 22,784
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Con trails are thought to have a noticeable warming effect:-


https://thebulletin.org/2019/07/airplane-contrails-are-changing-the-climate/

Sent from my Pixel 3a using Tapatalk
Forum: The Watercooler Yesterday, 11:40 AM
Replies: 2,970
Views: 578,354
Posted By Uncle Gizmo
Re: What's your best/worst joke?

I just LOVE This!

https://youtu.be/SA7bKo4HRTg
Forum: Forms 07-18-2019, 02:11 AM
Replies: 2
Views: 86
Posted By Uncle Gizmo
Re: How to copy data from another form

See Example:- LabelCheck.zip

Code:-
Private Sub Command0_Click()
Dim strFrmName As String
strFrmName = "Form2"

DoCmd.OpenForm strFrmName

With...
Forum: Modules & VBA 07-17-2019, 11:59 AM
Replies: 13
Views: 230
Posted By Uncle Gizmo
Re: Call Stack, who knew??

That's Impressive!
I think that's partly a problem with MS Access, not a problem actually, but the fact that is so good, and once you've got it right it rarely causes any problems...

The only...
Forum: Modules & VBA 07-17-2019, 11:17 AM
Replies: 13
Views: 230
Posted By Uncle Gizmo
Re: Call Stack, who knew??

I never used to worry too much about putting error checking in my functions. However I had the job of building a a runtime application which ran over Citrix, and it crashed, and crashed, and crashed,...
Forum: Forms 07-17-2019, 10:39 AM
Replies: 3
Views: 85
Posted By Uncle Gizmo
Re: Event procedure to change record

I thought you might find this useful.

The Second video on my website here shows you how to ensure that out of a set of check-boxes, one checkbox always remains checked.

Loop Through a Set of...
Forum: General 07-17-2019, 03:43 AM
Replies: 4
Views: 157
Posted By Uncle Gizmo
Re: Accidental them changed

I'm not 100% sure if you are actually asking a question! However just in case, I've bumped it up the list so that it gets another look!
Forum: Excel 07-17-2019, 03:40 AM
Replies: 1
Views: 71
Posted By Uncle Gizmo
Re: Top 10 Pivot Table

A quick search of the forum for the search term top 10 returned the following results:-

https://www.access-programmers.co.uk/forums/showpost.php?p=481745&postcount=3
...
Forum: Modules & VBA 07-16-2019, 02:46 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

I'm not happy with the idea of making the custom property variable public. In any event it's not necessary because just a slight change to your example:-

DoCmd.OpenForm "frm2"
Forms!frm2.prpTest...
Forum: Modules & VBA 07-16-2019, 08:21 AM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

I stand by that. I never did like trying to cram loads of variables through in an OpenArgs string, it's just not right. A very clever workaround though ...

Sent from my Pixel 3a using Tapatalk
Forum: Tables 07-16-2019, 04:01 AM
Replies: 11
Views: 142
Posted By Uncle Gizmo
Re: Using access to store chemistry experiment results

I reckon we posted at the same time!

I'm looking at the data on my mobile! They are getting really clever, these mobiles!

Sent from my Pixel 3a using Tapatalk
Forum: Tables 07-16-2019, 03:57 AM
Replies: 11
Views: 142
Posted By Uncle Gizmo
Re: Using access to store chemistry experiment results

I know there's a way to get MS Access to load data automatically from a (CSV) comma separated value file. And also detect when there's a new file (I think)...

Sent from my Pixel 3a using Tapatalk
Forum: Tables 07-16-2019, 03:17 AM
Replies: 11
Views: 142
Posted By Uncle Gizmo
Re: Using access to store chemistry experiment results

Could you post a sample of the data produced by the data logger?

Sent from my Pixel 3a using Tapatalk
Forum: Modules & VBA 07-15-2019, 10:44 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

The reason it is unexpected to my mind, is because when you use OpenArgs the value passed through can be used. So why not the values of Custom Properties?

I suspect it's deliberate , (or possibly...
Forum: Modules & VBA 07-15-2019, 10:31 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

OpenArgs can be very useful, but I see people abuse it (to my way of thinking) by trying to pass through loads of variables in a string!

It was as an alternative to OpenArgs that I adopted custom...
Forum: Modules & VBA 07-15-2019, 01:31 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

It's the way they work that's the problem. I've explained it in the videos linked to on my website.

To summarize the problem. You have a custom property in your forms code module, you can set the...
Forum: Modules & VBA 07-15-2019, 12:14 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

One thing I have learned over the years is that the form events don't operate as you would expect.

I usually create a public function in the Form code module to replace the Load & Open events,...
Forum: Politics & Current Events 07-15-2019, 02:03 AM
Replies: 407
Views: 22,784
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I think this is the same story I posted earlier but from a different publication:-
...
Forum: General 07-15-2019, 12:46 AM
Replies: 12
Views: 164
Posted By Uncle Gizmo
Re: PO generator

It just occurred to me that a Purchase Order is essentially an invoice by another name.

One of the early examples provided by Microsoft Access is an invoicing application. I think it was the...
Forum: General 07-15-2019, 12:38 AM
Replies: 12
Views: 164
Posted By Uncle Gizmo
Re: PO generator

The idea of these forums is that you post your question publicly and then you will get advice from an amazing variety of people with different experiences and ways of doing things. From their...
Forum: Forms 07-14-2019, 11:55 PM
Replies: 24
Views: 303
Posted By Uncle Gizmo
Re: Why doesn't the label stay on your Form

Is the link OK Now?




I'm not sure whats happened there! I've removed the link for now, should get it sorted on the weekend.
Forum: Modules & VBA 07-14-2019, 02:22 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

The linking information is contained within the subform/subreport control.

This subform/subreport control is an intermediary control between your main form and your sub-form.

That means that...
Forum: Modules & VBA 07-14-2019, 02:11 PM
Replies: 33
Views: 1,172
Posted By Uncle Gizmo
Re: Get value of Link Master Field

I don't understand?

Sent from my Pixel 3a using Tapatalk
Showing results 1 to 25 of 500

 
Forum Jump



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