Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 374
Search took 0.15 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Politics & Current Events Today, 01:45 AM
Replies: 147
Views: 12,341
Posted By Galaxiom
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

A friend has one of them. It can melt anything at the focus, even a piece of brick.

I think they were an arc lamp.
Forum: General 02-08-2019, 09:32 AM
Replies: 5
Views: 137
Posted By isladogs
A trip down memory lane

Whilst the site was down today, I was going through old files and found a long discarded copy of Access 1.0 from 1992 so decided to install it on a VM as part of my research into system tables.
Forum: Forms 01-29-2019, 10:17 AM
Replies: 15
Views: 72
Posted By Zydeceltico
Re: Use the same for for data entry and later editing

Gizmo - I just wanted to let you know that the combobox works like a champ for my needs. Thank you for pointing me to that video.
Forum: Forms 01-22-2019, 08:34 PM
Replies: 15
Views: 72
Posted By Wayne
Re: Use the same for for data entry and later editing

I have found (after trying a few other possibilities) that Uncle Gizmo is right - it is best to use the same form for both editing existing and adding new records. I have custom navigation and search...
Forum: Forms 01-22-2019, 04:14 AM
Replies: 42
Views: 526
Posted By Gasman
Re: How to populate a text box and field based on combo box value?

I am guilty of that I'm afraid, especially when I use the wizards to create a form based on table or query, so I thought 'why not write something to rename them'?

Created my own little program and...
Forum: Introduce Yourself 01-19-2019, 12:15 PM
Replies: 1
Views: 63
Posted By NauticalGent
Re: Hello from Italy

Ciao Theoden, un piacere conoscerti e benvenuti in AWF!
Forum: Forms 01-19-2019, 02:59 AM
Replies: 57
Views: 4,082
Posted By DiogoCuba
Re: audit trail

Hey, jdraw!

I removed the debugging and the code is working.

After reviewing the code and trying it out on my own DB I noticed that 3 controls names were not being collected, after revising...
Forum: General 01-18-2019, 09:55 AM
Replies: 3
Views: 113
Posted By sxschech
Re: Digital signature to PDF ?

If you don't have full version of acrobat, you can use pdftk or pdftkserver. They are free programs. I use pdftkserver as that is a command line and can be run from vba. Haven't tried signatures...
Forum: Queries 01-15-2019, 04:55 AM
Replies: 19
Views: 426
Posted By jdraw
Re: iff issue with Like "*"

It's always a good idea to set some context for your post by describing to readers WHAT you are trying to do and then show some of your code/sql etc.

11 posts in and it seems (to me at...
Forum: Excel 01-07-2019, 02:25 PM
Replies: 18
Views: 654
Posted By DanG
Re: Magic formula appears

I see in your profile you're retired....keep giving answers like this and you'll find yourself working again :)....I wouldn't wish that on anyone, thanks again!
Forum: General 01-04-2019, 02:21 PM
Replies: 2
Views: 1,482
Posted By Pat Hartman
Re: Invalid Bracketing

Wow, I've never run into that problem probably because I never create improper names and also because I rarely use subqueries since for most purposes joins to other queries will do the same job and...
Forum: Forms 01-03-2019, 06:22 PM
Replies: 3
Views: 182
Posted By henryihunter1954
Re: Need Suggestions for Website

Uncle Gizmo:
Thank you so much for your insight. (I also thank you for comments. I laugh sometimes by the comments - I often think people are too business like to add in humor, but for me, it is a...
Forum: Forms 12-31-2018, 01:26 AM
Replies: 4
[SOLVED] Subform Tutorial
Views: 299
Posted By Gasman
Re: Subform Tutorial

Start here perhaps?

Forum: Reports 12-27-2018, 01:19 PM
Replies: 2
Views: 618
Posted By PleasantB
Re: Sizing an Access report, opened as acDialog while the main window is hidden

I tried that originally but found that though a popup form is not hidden with the main Access window, a popup report is.
The only way I found to have a report persist when the main Access window is...
Forum: General 12-27-2018, 08:28 AM
Replies: 6
Views: 438
Posted By theDBguy
Re: Use data from tables in VBA on form with different record source

You can also do the same with the following SQL statement:

Set rs = db.OpenRecordset("SELECT * FROM OtherTable WHERE FK=" & Me.ID)
Forum: Forms 12-26-2018, 12:20 PM
Replies: 4
Views: 177
Posted By henryihunter1954
Re: Need Drop-Down Menu to auto-fill 2 unbound boxes

Uncle Gizmo:

I tried it and it worked like a Magical Charm....
Thank you so much.

I also read about subscribing to your channel.
(I subscribed)
Thank you again and Merry Christmas
Forum: Theory and practice of database design 12-21-2018, 12:34 PM
Replies: 2
Views: 298
Posted By plog
Re: Normalizing a Manufacturing DB

First and foremost, stop thinking about forms. It's a common rookie mistake to think they drive everything and build everything with them in mind. Data is what you need to focus on first. After...
Forum: The Watercooler 12-20-2018, 12:45 PM
Replies: 2,920
Views: 570,669
Posted By Rx_
Re: What's your best/worst joke?

Forum: Forms 12-16-2018, 10:36 AM
Replies: 8
Views: 15,754
Posted By missinglinq
Re: Move existing objects into tab control

No reason you should have to create a Textbox on the Tabbed Page before cutting and pasting an existing Control on it...not really sure what is going on, there...but here's a hack for automatically...
Forum: Debates 12-05-2018, 06:41 AM
Replies: 37
Views: 11,965
Posted By AccessBlaster
Re: Flat Earth and Hollow Earth Theories

Proof the Earth is not flat.

Forum: Modules & VBA 12-03-2018, 04:38 AM
Replies: 6
Views: 275
Posted By Tessa
Re: Hello from Denmark

Your suggestion about moving my previous post to a separate thread sounds like a good idea and I wouldn't feel that you are censoring me. So please do so.

I wouldn't mind writing an introduction...
Forum: Tables 11-29-2018, 12:57 PM
Replies: 8
Views: 1,199
Posted By plog
Re: Tables Normalization

A good way to test your relationships is to convert your image into english and see if the statement is true. For every relationship, start with the 1 side and construct a sentence like this to the...
Forum: SQL Server 11-23-2018, 04:50 PM
Replies: 2
Views: 1,026
Posted By ahmed_optom
Re: Access back to mysql - the long journey

Also before I did all this, I was weighing up the pros/cons. Now I have done it let me summarise.

-definitely faster. It strangely seems even faster than when front and back are on same pc....
Forum: Forms 11-18-2018, 07:08 AM
Replies: 19
Views: 418
Posted By pbaldy
Re: VBA Code to check a Form for empty/Null Controls

Where would be the fun in that?? :p
Forum: Introduce Yourself 11-18-2018, 12:23 AM
Replies: 7
Views: 787
Posted By isladogs
Re: Hi, new member from the UK

There's also the phenomenon where you think you've cracked some difficult code, celebrate then realise it doesn't work after all....
That's called 'premature algorasm' :eek:
Showing results 1 to 25 of 374

Forum Jump

All times are GMT -8. The time now is 11:59 PM.

Microsoft Access Help
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