Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Forms Yesterday, 11:27 AM
Replies: 9
Views: 155
Posted By Uncle Gizmo
Re: vba code to turn on test boxes

To get you started have a look on my website here:-

Loop Through a Set of Controls (http://www.niftyaccess.com/loop-through-a-set-of-controls/)

Although I suspect that Moke has already...
Forum: Forms 10-17-2018, 02:47 PM
Replies: 9
Views: 155
Posted By Uncle Gizmo
Re: vba code to turn on test boxes

Code is run by events. To trigger the code you need to associate it with one of the events.

So in this case you would probably want the after update event of the text box which holds the values to...
Forum: General 10-16-2018, 04:24 AM
Replies: 15
Views: 311
Posted By Uncle Gizmo
Re: Form with lookup tables

I'm still confused by your question, however looking at your database sample, I can't see any way to connect the subform to the main form. You don't have any relationship between people and machine....
Forum: The Watercooler 10-14-2018, 07:43 AM
Replies: 5
Views: 149
Posted By Uncle Gizmo
Checking AWF hit Count...

I was checking website hits - I do this occasionally. I haven't seen anything published on AWF about it before, so I started this Thread ... Makes interesting reading!

According to similar web :-...
Forum: The Watercooler 10-14-2018, 04:27 AM
Replies: 36
Views: 582
Posted By Uncle Gizmo
Re: Song Lyrics

I like most I reckon, have been online for many years, had many runnin's, seen and been in flame wars!

I realised there was something wrong when I lost my rag with a guy who was an iPhone guy and...
Forum: Excel 10-13-2018, 09:52 AM
Replies: 9
Views: 153
Posted By Uncle Gizmo
Re: why wont the use of a variable work

It's never a good idea to use a Real Words in your MS Access database. Take for instance your function name "Start", this should be changed to something like:- fStart... If you change it to that...
Forum: Modules & VBA 10-13-2018, 07:04 AM
Replies: 8
[SOLVED] Class error 430
Views: 158
Posted By Uncle Gizmo
Re: Class error 430

Also add:-

Option Compare Database
Option Explicit

Thus
Forum: Modules & VBA 10-13-2018, 03:19 AM
Replies: 8
[SOLVED] Class error 430
Views: 158
Posted By Uncle Gizmo
Re: Class error 430

The first thing to check, have you got a reference to ADO in the references?

Sent from my SM-G925F using Tapatalk
Forum: General 10-10-2018, 02:12 AM
Replies: 4
Views: 414
Posted By Uncle Gizmo
Re: Problem filtering records of a table with SQL and forms

I don't Know...

You don't seem to be getting much feedback on this question so I thought I would post what I've looked at so far. - It's easier to see a problem/solution if the code is written in...
Forum: General 10-09-2018, 01:53 PM
Replies: 4
Views: 414
Posted By Uncle Gizmo
Re: Problem filtering records of a table with SQL and forms

Shouldn't this line:-
ORDER BY AlmacenLentes.Nombre;

Be:-
'ORDER BY AL.Nombre;

????
Forum: Tables 10-08-2018, 01:15 PM
Replies: 7
Views: 203
Posted By Uncle Gizmo
Re: Linked Table with Links to PDFs

Not sure whether this solution will work for you, it works for me because I use a Chrome browser and Chrome displays PDFs...

Create a Form based on the linked table (linked to the spreadsheet) ---...
Forum: General 10-07-2018, 12:12 PM
Replies: 2
Views: 243
Posted By Uncle Gizmo
Re: Importing to a Memo Field from Excel

It's exactly the same for me, I start creating something, something I think will only take a few minutes, maybe an hour, it ends up taking half a day, 3 days, sometimes a week. And I end up with...
Forum: Introduce Yourself 10-02-2018, 09:17 AM
Replies: 1
Views: 83
Posted By Uncle Gizmo
Re: Kinda new to Access in East TN

Hi Joshua, welcome to AWF


Cheers Tony

Sent from my SM-G925F using Tapatalk
Forum: Reports 09-25-2018, 12:31 PM
Replies: 6
Views: 167
Posted By Uncle Gizmo
Re: Custom naming pdf reports generated using a loop

You need to loop through the record set as well. I'm pretty sure I covered it in my blog here without having a look! Generate Multiple Reports (http://www.niftyaccess.com/generate-multiple-reports/)
Forum: General 09-19-2018, 11:07 PM
Replies: 9
Views: 333
Posted By Uncle Gizmo
Re: I'm worried for future versions of Access

The same question has bothered me periodically over the years. At one stage I was actively looking at moving over to everything Google. I was deceived by their "Do No Harm" message but it turned...
Forum: Modules & VBA 09-13-2018, 08:31 AM
Replies: 7
Views: 194
Posted By Uncle Gizmo
Re: Defining how many times to loop.

I think having a variable number of text boxes might be a difficult approach. And, what do you do with the information once you put it in the text boxes! How do you get hold of it to use it?

So I...
Forum: General 09-11-2018, 07:57 AM
Replies: 9
Views: 1,445
Posted By Uncle Gizmo
Re: Retrive a Base64 text to picture

I note your post has yet to receive a reply. I thought it was worth bumping it up the list just to make sure everyone's seen it.
Forum: General 09-11-2018, 04:27 AM
Replies: 11
Views: 769
Posted By Uncle Gizmo
Re: Help with design

When building a database for a customer the first step is to write down exactly what the database will be expected to do.. I reckon you should spend at least a day doing this, one day on site, with...
Forum: General 09-09-2018, 12:24 PM
Replies: 2
Views: 660
Posted By Uncle Gizmo
LinkedIn article which might amuse!

I've just posted an article on LinkedIn which might amuse!

Moving from Excel to MS Access - Three problems to Avoid!...
Forum: Forms 09-09-2018, 03:28 AM
Replies: 117
Views: 1,937
Posted By Uncle Gizmo
Re: A Little Help With Tab Control

Some Errors are very hard to track down. I recall deploying a runtime version of MS Access on a Citrix system with an MS SQL back end. It worked fine on my own PC but just would not work properly on...
Forum: Forms 09-07-2018, 02:12 PM
Replies: 117
Views: 1,937
Posted By Uncle Gizmo
Re: A Little Help With Tab Control

I just found this excellent video demonstrating using a tab control and a single Subform/Subreport Control.

MS Access Tab Control with Multiple Subforms (https://youtu.be/r-Z_nhBtJCI)
Forum: General 09-05-2018, 11:19 AM
Replies: 14
Views: 423
Posted By Uncle Gizmo
Re: How Do You Search The Forum?

There's a Blog here showing you how to use Google to specifically search Access World Forums (AWF) there's also a link to a web page setup ready to go!

Searching For Answers...
Forum: General 08-30-2018, 03:18 AM
Replies: 6
Views: 431
Posted By Uncle Gizmo
Re: A quandary regarding form events

Reading your question again, I realise that the first time I read it I assumed that you had tried calling the code from the Forms load event, and it failed to run. So that's what my 1st answer...
Forum: Tables 08-27-2018, 04:44 AM
Replies: 31
Views: 745
Posted By Uncle Gizmo
Re: List of last used tables

To flesh out on Pats comment, and there's not really any need to, she's got it in a nutshell. But I think there's an important issue with people's perception of Microsoft Access which Luke Chung...
Forum: Introduce Yourself 08-23-2018, 01:48 PM
Replies: 4
Views: 107
Posted By Uncle Gizmo
Re: I'm new here

Hi bcnu,

Welcome to Access World Forums (AWF)

Don't worry about asking your questions, they can never be silly. Speaking for myself, I am always getting stuck and needing to look something up,...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 01:41 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World