Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.16 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Forms 10-10-2019, 04:53 AM
Replies: 12
Views: 237
Posted By Uncle Gizmo
Re: Counting non empty textboxes

Please find attached CountMT_TextBoxes_NiftyAccess.accdb which uses the controls collection as originally suggested by moke123. I strongly suggest you study this method as understanding it will help...
Forum: Introduce Yourself 10-08-2019, 03:29 PM
Replies: 3
Views: 78
Posted By Uncle Gizmo
Re: hi everyone

Hi esso, welcome to AWF...

I'm not sure what you mean? If you mean do you need to prefix field names with something in a table, then you could add the prefix fld so a field you named "MyField"...
Forum: Forms 10-08-2019, 03:20 PM
Replies: 8
Views: 151
Posted By Uncle Gizmo
Re: date & Time with two criteria

You may find this YouTube Helpful:-

MS Access - Add Time to a Date - Nifty Access (https://youtu.be/D_magBM3rOY)
Forum: Forms 10-07-2019, 11:40 AM
Replies: 11
Views: 186
Posted By Uncle Gizmo
Re: pass combo box value to another form's combo box

See Attached...

Edit:- To Close the Calling form, add this code:- DoCmd.Close acForm, Me.Name


Private Sub Command0_Click()

If IsNull(Me.cboTest1) Then
MsgBox "Select something...
Forum: General 10-07-2019, 11:01 AM
Replies: 13
Views: 251
Posted By Uncle Gizmo
Re: Microsoft Access Forms Review for Suggestions.

Assuming you are referring to this video:- PROJECT MANAGEMENT DATABASE SYSTEM (PMDS) Training Overview2 (https://www.youtube.com/watch?v=DHHrRFTthbY) - (I couldn't find number 1)

I make the...
Forum: Forms 10-07-2019, 03:04 AM
Replies: 12
Views: 237
Posted By Uncle Gizmo
Re: Counting non empty textboxes

You have already received an excellent answer from moke123

I would add the following observations:-

I think your question needs some clarification, my guess is you mean a macro and not VBA...
Forum: Politics & Current Events 10-03-2019, 06:55 AM
Replies: 543
Views: 27,744
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Dr Patrick Moore, (not the British Astronomer)

Fascinating insight!

https://youtu.be/S6sKPSKkvVs


He shows that it's not CO2 that is causing the warming, but it is water vapour. Exactly as...
Forum: General 10-02-2019, 11:00 AM
Replies: 11
Views: 243
Posted By Uncle Gizmo
Re: Training Database

Another thing you can do is draw a set of flowcharts, one flowchart for each process. Don't be tempted to do everything in one flow chart, use separate ones for each process and indicate where the...
Forum: Queries 09-12-2019, 10:50 PM
Replies: 9
Views: 218
Posted By Uncle Gizmo
Re: Too Few Parameters Expected 2 Error

Video number 2 of my blog here suggests ways you can simplify complicated SQL Statements:-

https://www.niftyaccess.com/insert-into-sql-statement/



Sent from Barcelona!
Forum: Forms 09-09-2019, 08:17 PM
Replies: 4
Views: 112
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: 112
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: 112
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: 286
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: 286
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: 286
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: 286
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: 166
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: 192
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: 160
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: 192
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: 192
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: 543
Views: 27,744
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: 257
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/)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:02 PM.


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