Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.80 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Forms 09-09-2019, 08:17 PM
Replies: 4
Views: 95
Posted By Uncle Gizmo
Re: Forms

This assumes you have the basics down pat, so might be a bit advanced for you just now:-

https://www.niftyaccess.com/sql-statements-for-beginners/

Sent from my Pixel 3a using Tapatalk
Forum: Forms 09-09-2019, 08:12 PM
Replies: 4
Views: 95
Posted By Uncle Gizmo
Re: Forms

Here's a bit on filtering:-

https://www.niftyaccess.com/easily-apply-filters/



Sent from my Pixel 3a using Tapatalk
Forum: Forms 09-09-2019, 08:07 PM
Replies: 4
Views: 95
Posted By Uncle Gizmo
Re: Forms

This might get you started with VBA,

https://www.niftyaccess.com/vba-beginner/



Sent from my Pixel 3a using Tapatalk
Forum: Forms 09-08-2019, 04:08 AM
Replies: 23
Views: 280
Posted By Uncle Gizmo
Re: Proper event for loading subfrm procedure

When when you enter a new value in that input "textbox" or "text boxes" what event re-lists the data displayed? There must be some VBA code, something happening under the hood that creates the new...
Forum: Forms 09-08-2019, 02:42 AM
Replies: 23
Views: 280
Posted By Uncle Gizmo
Re: Proper event for loading subfrm procedure

Just a thought maybe it's not an event that is filtering the subform? maybe it uses queries? need a bit more information really!
Forum: Forms 09-08-2019, 02:38 AM
Replies: 23
Views: 280
Posted By Uncle Gizmo
Re: Proper event for loading subfrm procedure

Yes that's what I said in post 3 "I think you need to call the code in this procedure."

But the OP said he'd already tried that and it didn't work?

Edit:-


Don't understand why it does one...
Forum: Forms 09-08-2019, 01:47 AM
Replies: 23
Views: 280
Posted By Uncle Gizmo
Re: Proper event for loading subfrm procedure

My understanding of your arrangement is that when you click on a record in one sub form, it refreshes the related records in the other sub-form. I think you need to call the code in this procedure.
Forum: Modules & VBA 09-05-2019, 07:51 AM
Replies: 11
Views: 162
Posted By Uncle Gizmo
Re: Populating textbox based on specific Combobox entry

You might not need to have a separate field to display "blue folder" you could do it like this:-


https://www.niftyaccess.com/display-data-from-a-combo-box-in-a-text-box/

This technique takes...
Forum: Forms 09-02-2019, 10:59 AM
Replies: 12
Views: 188
Posted By Uncle Gizmo
Re: save error

Here is another example of this error from DATABASE SOLUTIONS

Preventing Duplicates from being entered (http://www.databasedev.co.uk/duplicates.html)
Forum: General 09-02-2019, 07:56 AM
Replies: 7
Views: 157
Posted By Uncle Gizmo
Re: Importing data to tables using IDs

I have a Blog demonstrating how to import Excel data into MS Access. Once the data is imported the next step is to extract any repeating text values and put them in a lookup table. Next you need to...
Forum: Forms 09-02-2019, 04:47 AM
Replies: 12
Views: 188
Posted By Uncle Gizmo
Re: save error

Thank you I'm glad you found it useful. If you haven't already done so, might I trouble you to sign up to my YouTube channel? I'm hoping to get to 1000 subscribers which should unlock a treasure...
Forum: Forms 09-01-2019, 12:56 PM
Replies: 12
Views: 188
Posted By Uncle Gizmo
Re: save error

I answered a question a few years back where I remember seeing that error message! The question was actually about preventing duplicate values appearing in a subform, see YouTube:- Prevent...
Forum: Politics & Current Events 08-30-2019, 11:50 AM
Replies: 433
Views: 25,071
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Here's a very interesting article on global warming, it seems at the Sun has got a lot to do with it!

Climate change culprit? Short answer: the Sun...
Forum: General 08-21-2019, 11:23 AM
Replies: 4
Views: 96
Posted By Uncle Gizmo
Re: Building one same format for a report from different queries

I answered a similar question recently. "Generate Multiple Reports" (https://www.niftyaccess.com/generate-multiple-reports/) There are 4 videos by way of explanation. I also provide a sample...
Forum: Forms 08-20-2019, 10:37 AM
Replies: 16
Views: 248
Posted By Uncle Gizmo
Re: allen brownes Calendar

Nifty Date Picker

I also have a calendar form, all my own code, so there are no issues with ownership.

https://www.niftyaccess.com/nifty-date-picker/

Free with Coupon Code:- BuyTonyA_coffee...
Forum: Modules & VBA 08-19-2019, 09:32 AM
Replies: 4
Views: 103
Posted By Uncle Gizmo
Re: Combo box to filter form

Not 100% sure that I understand the essence of your question, however I thought this thread might help:- "Northwind Problem and Solution" (https://www.niftyaccess.com/northwind-problem-and-solution/)
Forum: Windows 08-14-2019, 02:36 PM
Replies: 8
Views: 168
Posted By Uncle Gizmo
Re: DB on opening Win 10

You can go directly to the Startup folder, just open any folder, replace the folder link? UNC? (I KNOW "PATH") With shell:startup and it will change the folder to the Startup folder.

Drag your...
Forum: Windows 08-14-2019, 07:46 AM
Replies: 8
Views: 168
Posted By Uncle Gizmo
Re: DB on opening Win 10

I'm sure it could be done, and I'm sure someone will let you know! However there is an alternative which might be nearly as good and is straight forward.

Open your MS Access database, then open...
Forum: Forms 08-13-2019, 10:52 AM
Replies: 8
Views: 155
Posted By Uncle Gizmo
Re: Display controls of Data fields in access forms.

If you follow this link:- Run-time error 438 (https://www.niftyaccess.com/run-time-error-438/) you will see the property sheet of a TextBox and the property sheet of a Label. The data tab for each...
Forum: Forms 07-27-2019, 01:43 PM
Replies: 3
Views: 99
Posted By Uncle Gizmo
Re: Message box Icons

You may find my blog on the message box helpful:-

https://www.niftyaccess.com/advanced-message-box/

Sent from my Pixel 3a using Tapatalk
Forum: Forms 07-13-2019, 09:39 PM
Replies: 24
Views: 313
Posted By Uncle Gizmo
Re: Why doesn't the label stay on your Form

That's an excellent tip thank you arnelgp!

Seeing as the associated label property is a relatively new feature of MS Access, I wasn't aware of how handy it could be!


Sent from my Pixel 3a...
Forum: Forms 07-12-2019, 08:23 AM
Replies: 62
Views: 920
Posted By Uncle Gizmo
Re: How to make a field mandatory

I think you might find Colins example on how to enable/disable (and the like) various groups of controls handy.... I don't know if he actually shows an example of control validation, but I reckon...
Forum: Introduce Yourself 07-01-2019, 03:47 AM
Replies: 4
Views: 128
Posted By Uncle Gizmo
Re: Beginner in Access VBA

Hi Ruben, welcome to AWF.

I've made a blog to help VBA beginners on my website here:-

https://www.niftyaccess.com/vba-beginner/

Might be of interest.

Sent from my Pixel 3a using Tapatalk
Forum: Code Repository 06-26-2019, 12:57 PM
Replies: 12
Views: 1,841
Posted By Uncle Gizmo
Re: use a textbox as a resizeable and colourful checkbox

It's funny you should mention that June! It's something I'm currently working on, I thought I had finished it, but then I found some issues which I wasn't happy with. I haven't got around to sorting...
Forum: Politics & Current Events 06-22-2019, 10:07 AM
Replies: 433
Views: 25,071
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I found the following two links.

The first link Here:-
Global Warming: A Chilling Perspective (https://www.geocraft.com/WVFossils/temp_vs_CO2.html)

Leading to the second link:-
Ice Core...
Showing results 1 to 25 of 500

 
Forum Jump



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