Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 6.64 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Queries 09-13-2019, 08:47 AM
Replies: 8
Views: 120
Posted By Uncle Gizmo
Re: Too Few Parameters Expected 2 Error

Indeed, It's not the same scenario as yours, but the basic principles shown in that video apply, divide and conquer!

You could pass your textbox values through as variables into the function and...
Forum: Queries 09-12-2019, 10:50 PM
Replies: 8
Views: 120
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: Introduce Yourself 09-12-2019, 05:48 AM
Replies: 12
Views: 126
Posted By Uncle Gizmo
Re: Hi everyone

And it is a brand of gasket sealant for industrial situations, like big diesel engines.... Which I have disassembled and reassembled on occasion.. They usually worked OK, except for one occasion,...
Forum: Introduce Yourself 09-12-2019, 04:47 AM
Replies: 12
Views: 126
Posted By Uncle Gizmo
Re: Hi everyone

I might be confusing hammerite with hematite!

Long time since I've used it, "hematite" that is ..



Sent from Barcelona!
Forum: Introduce Yourself 09-12-2019, 12:50 AM
Replies: 12
Views: 126
Posted By Uncle Gizmo
Re: Hi everyone

Well I'm not sure whether to say welcome to the forum!

From your handle, I get the impression that you like taking engines to pieces and putting them back together again?

Sent from my Pixel 3a...
Forum: Tables 09-09-2019, 10:39 PM
Replies: 16
Views: 244
Posted By Uncle Gizmo
Re: Best way to design table for (gender & province)

A spreadsheet layout in MS Access is fine if you just want to look at it. However, if you want to do anything with it like extract useful information, count things, anything slightly complicated,...
Forum: Forms 09-09-2019, 08:17 PM
Replies: 4
Views: 94
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: 94
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: 94
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: The Watercooler 09-09-2019, 08:02 AM
Replies: 20
Views: 325
Posted By Uncle Gizmo
Re: Little League World Series

How did they get on Richard?

Sent from my Pixel 3a using Tapatalk
Forum: Forms 09-09-2019, 06:51 AM
Replies: 6
Views: 147
Posted By Uncle Gizmo
Re: spell checker

I have a pop-up spell checker form available on my website here:- Spell Checker Popup Form (https://www.niftyaccess.com/spell-checker-popup-form/)

There are video instructions demonstrating how...
Forum: Forms 09-08-2019, 04:08 AM
Replies: 23
Views: 279
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: 279
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: 279
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: 279
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: The Watercooler 09-07-2019, 03:10 PM
Replies: 2,989
Views: 579,311
Posted By Uncle Gizmo
Pyramid Scheme for Graduates

https://i.redd.it/edj3xk2wp2k31.jpg

Sent from my Pixel 3a using Tapatalk
Forum: Modules & VBA 09-07-2019, 09:55 AM
Replies: 10
Views: 991
Posted By Uncle Gizmo
Re: Runtime Error 3134

I have today finished off this blog about insert into SQL Statements:- "INSERT INTO SQL Statement" --- It could really do with another video, but haven't got the time! Sample database is available...
Forum: Modules & VBA 09-06-2019, 06:23 AM
Replies: 23
Views: 293
Posted By Uncle Gizmo
Re: code explanation

I have blogged about the north-wind database problems, well, the earliest version of it anyway... I'm not sure about the later version, I haven't bothered to go through it. The older version of the...
Forum: Modules & VBA 09-06-2019, 02:23 AM
Replies: 23
Views: 293
Posted By Uncle Gizmo
Re: code explanation

What really niggles me about the Microsoft templates is that one template will have a customer table, a supplier table, etc... Then another template will have the same tables but they have different...
Forum: The Watercooler 09-06-2019, 02:16 AM
Replies: 0
Views: 66
Posted By Uncle Gizmo
Private Eye's version of Su Doku for Sun readers

I have a very old link to this website DI Management Home (https://www.di-mgt.com.au/index.html) because it shows ideas on creating a class module for beginners. I couldn't find any links to the...
Forum: Reports 09-05-2019, 05:05 PM
Replies: 6
Views: 146
Posted By Uncle Gizmo
Re: Creating Report with Table Format

It is likely there is a problem with the way you are storing your data in the table. It would be prudent to discuss the options you have have before creating any reports.

Sent from my Pixel 3a...
Forum: Modules & VBA 09-05-2019, 04:14 PM
Replies: 5
Views: 154
Posted By Uncle Gizmo
Re: How to split the code in VBA

Something else you can do to tidy up your code is to "Take Out The Tables" If you have a single table, it's not clear from the code snippet you've posted, but it appears that you only have one table....
Forum: Reports 09-05-2019, 02:34 PM
Replies: 6
Views: 146
Posted By Uncle Gizmo
Re: Creating Report with Table Format

I think we need to have a discussion about how your data is stored in the table, as it doesn't follow the normal conventions of MS Access. It is probably worth discussing the pros and cons before...
Forum: Modules & VBA 09-05-2019, 02:28 PM
Replies: 11
Views: 144
Posted By Uncle Gizmo
Re: How to save previous record in one table and the current record in another table

I thought it prudent to mention I've done quite a few examples on Checklists.

This short video demonstrates the Check List Problem:- "Checklist Required - Nifty Access"...
Forum: Modules & VBA 09-05-2019, 02:02 PM
Replies: 11
Views: 144
Posted By Uncle Gizmo
Re: How to save previous record in one table and the current record in another table

I'm wondering if what you want is what is referred to as Audit Trail? If that's the case, have a look at this thread:- https://www.access-programmers.co.uk/forums/showthread.php?t=294923 Basically...
Showing results 1 to 25 of 500

 
Forum Jump



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