Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.23 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Forms Yesterday, 04:19 AM
Replies: 2
Views: 47
Posted By Uncle Gizmo
Re: Error 2137 ocurring in new version

I can't speak for your problem in particular but I can, for the general process of finding errors. I have just now, spent a good few hours trying to track down an error! I have a VBA routine that...
Forum: General 11-07-2019, 10:33 AM
Replies: 1
Views: 86
Posted By Uncle Gizmo
Useful MS Access Tools

If you happen upon an online service which helps you with your MS Access coding, then please post a link to it here!

I just found this website which checks the bracketing of your SQL, and I found...
Forum: The Watercooler 11-07-2019, 08:06 AM
Replies: 15
Views: 313
Posted By Uncle Gizmo
Re: Microsoft Access is Dead!

A spreadsheet was the first application to make PCs an attractive purchase for business, particularly accountants. I would agree I cannot ever see spreadsheets going out of fashion.


The...
Forum: The Watercooler 11-07-2019, 04:44 AM
Replies: 15
Views: 313
Posted By Uncle Gizmo
Microsoft Access is Dead!

A question that pops up on the forum from time to time is is how long will Microsoft Access last as a product? I've asked myself the same question many times over the years and I've usually...
Forum: Modules & VBA 11-07-2019, 04:31 AM
Replies: 3
Views: 143
Posted By Uncle Gizmo
Re: Finding avaiable scanner properties

This link looks useful!

https://stackoverflow.com/questions/17008480/scan-multiple-pages-with-adf-scanner-using-vba
Forum: Modules & VBA 11-07-2019, 04:29 AM
Replies: 3
Views: 143
Posted By Uncle Gizmo
Re: Finding avaiable scanner properties

Not anything I am familiar with myself, however I did a quick Google and discovered this link:-...
Forum: The Watercooler 11-07-2019, 02:51 AM
Replies: 22
Views: 409
Posted By Uncle Gizmo
Re: Why most assholes are men

Looking at a simpler and more common experience, most of us drive I should imagine. We have all seen unsavoury behaviour and I'm reasonably sure we have all been involved in unsavoury behaviour at...
Forum: Introduce Yourself 11-07-2019, 02:30 AM
Replies: 3
Views: 58
Posted By Uncle Gizmo
Re: Merhaba

Translation:-
Hello All members of ACCESSWORD,
Actually, I wasn't a new member, but since I haven't logged into the forum so far, you can perceive it as new. After that, I will follow the site more...
Forum: The Watercooler 11-05-2019, 11:17 AM
Replies: 22
Views: 409
Posted By Uncle Gizmo
Re: Why most assholes are men

Thank goodness they are different from men! How the French put it:- Vive la Difference
Forum: Modules & VBA 11-05-2019, 11:12 AM
Replies: 6
Views: 116
Posted By Uncle Gizmo
Re: Hangman Style Search

I'm not sure if you want this, I get the impression you want to build it yourself! However, if you want a pre-made one, then have a look at this....

By the way it's not mine and I have no idea...
Forum: Modules & VBA 11-05-2019, 09:25 AM
Replies: 6
Views: 116
Posted By Uncle Gizmo
Re: Hangman Style Search

Well, it depends on whether you are actually making a hangman game or not. If you're going to make a hangman game then you will want to divide your word out, with each letter in a single text box.. ...
Forum: Visual Basic 11-04-2019, 07:40 PM
Replies: 9
Views: 187
Posted By Uncle Gizmo
Re: Text Box boarder color

I also put the Video and download on my website here:-

https://www.niftyaccess.com/loop-through-a-set-of-controls/

Sent from Newbury UK
Forum: Visual Basic 11-04-2019, 07:38 PM
Replies: 9
Views: 187
Posted By Uncle Gizmo
Re: Text Box boarder color

Yes! See previous thread here:-
...
Forum: Modules & VBA 11-04-2019, 07:46 AM
Replies: 3
Views: 162
Posted By Uncle Gizmo
Re: Copy file (e.g. picture) from android device (e.g. cell phone, tablet...) to PC

I note you have yet to receive a reply! In order to give your post a second shot, I have made a comment to bump it up the list! Hope you have better luck this time!
Forum: General 11-04-2019, 07:39 AM
Replies: 3
Views: 129
Posted By Uncle Gizmo
Re: Python exercise

This forum also has a section for other software:- https://www.access-programmers.co.uk/forums/forumdisplay.php?f=59 -- However you would be very lucky to get some help with Python here...

If you...
Forum: Modules & VBA 11-04-2019, 07:36 AM
Replies: 21
[SOLVED] Error Handling
Views: 232
Posted By Uncle Gizmo
Re: Error Handling

My guess is that ".OpenRecordset()(4)" occasionally returns a NULL value. If that's the case, then try:- Nz(.OpenRecordset()(4))
Forum: Politics & Current Events 11-02-2019, 07:11 AM
Replies: 611
Views: 30,378
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Jeremy Clarkson on climate change - hilarious!

https://www.thesun.co.uk/news/10261846/greta-thunberg-kids-terrified/

Sent from Newbury UK
Forum: Forms 11-02-2019, 12:47 AM
Replies: 12
Views: 235
Posted By Uncle Gizmo
Re: Using a single table for multiple comboboxes

I'm not a stickler for it Paul, sometimes it feels a lot of work for little benefit.

Sent from Newbury UK
Forum: Tables 11-01-2019, 06:30 PM
Replies: 2
Views: 97
Posted By Uncle Gizmo
Re: excel in access

If you're importing Excel data into MS Access, then there are few issues you should be aware of, I cover them in my blog here:- https://www.niftyaccess.com/excel-in-access/
Forum: Forms 11-01-2019, 06:21 PM
Replies: 12
Views: 235
Posted By Uncle Gizmo
Re: Using a single table for multiple comboboxes

I've used one table for years! I have a a form which loads, and can edit any of the look up Groups. The names of the lookup groups are also stored in the single lookup table.

I've recently...
Forum: General 10-27-2019, 02:27 AM
Replies: 21
Views: 377
Posted By Uncle Gizmo
Re: Need "Select All Option" in Combobox for Query Parameters

There's an easy way to remove the table name. See the tip:-

"Take out the Tables" on my website here:-

https://www.niftyaccess.com/nifty-tips/


it's about the 4th one down.

Sent from...
Forum: General 10-26-2019, 01:12 PM
Replies: 21
Views: 377
Posted By Uncle Gizmo
Re: Need "Select All Option" in Combobox for Query Parameters

'You Can simplify further by removing the Table Name (Only if there is a single Table)
'SELECT [Entry Number], [Account Name], [Employee Name], [Work Date], [Hours Worked], [Pay Per Hour], [Amount...
Forum: Reports 10-24-2019, 06:04 PM
Replies: 14
Views: 292
Posted By Uncle Gizmo
Re: SubReport in Report layout issue

I note you have yet to receive a reply, and it's been a while! thought I would give you a bump up the list and see if if your post attract any attention!
Forum: Politics & Current Events 10-23-2019, 04:36 PM
Replies: 611
Views: 30,378
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Interesting article on Exxon hearing...

https://www.theguardian.com/business/2019/oct/23/exxon-climate-crisis-house-democrats-hearing

Sent from Newbury UK
Forum: Queries 10-23-2019, 05:42 AM
Replies: 9
Views: 161
Posted By Uncle Gizmo
Re: SQL SubQuery and EXISTS

I ran into a similar problem recently. I was trying to create an unmatched query as an SQL Statement. I wanted to return several Fields, but I could only return one.

The solution it appears was...
Showing results 1 to 25 of 500

 
Forum Jump



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