Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.45 seconds.
Search: Posts Made By: Uncle Gizmo
Forum: Reports 02-08-2019, 11:06 AM
Replies: 6
Views: 124
Posted By Uncle Gizmo
Re: Control Source Name

I don't get it?

Sent from my SM-G925F using Tapatalk
Forum: Reports 02-07-2019, 12:46 PM
Replies: 8
Views: 135
Posted By Uncle Gizmo
Re: Counting multiple fields in a report

Yes it's very confusing because you are thinking in terms of Excel instead of MS Access. I've done several blogs on this very subject, however I get the impression that you might respond better to...
Forum: General 02-06-2019, 02:10 PM
Replies: 12
Views: 202
Posted By Uncle Gizmo
Re: Run App on a Data Stick?

Hi Bob,
I have moved over to Google Drive. So instead of keeping folders on my PC I keep folders in Google Drive. When I finished something, I upload it to Google Drive. I just keep a working folder...
Forum: Forms 02-06-2019, 03:46 AM
Replies: 23
Views: 358
Posted By Uncle Gizmo
Re: How to make series subform in the main form by (infinity)adding button?

I did something similar for a customer a while back. Same situation, storing information about family structure. However differs slightly because some members of the family were ill and being cared...
Forum: Access Web 02-05-2019, 07:49 AM
Replies: 18
Views: 294
Posted By Uncle Gizmo
Re: ODBC vs. Sharepoint - which is faster?

I'm just glad I'm not the only one!

Sent from my SM-G925F using Tapatalk
Forum: Forms 01-29-2019, 01:49 PM
Replies: 15
Views: 76
Posted By Uncle Gizmo
Re: Use the same for for data entry and later editing

Thank you for taking the trouble to let me know! Much appreciated.

I've got around 300 videos on my YouTube channel, most of which address some issue with MS Access. I thought I'd mention it, as...
Forum: Introduce Yourself 01-25-2019, 04:37 AM
Replies: 2
Views: 72
Posted By Uncle Gizmo
Re: New to Access

Hi collen, Welcome to Access World Forums! (AWF)

Cheers Tony
Forum: Forms 01-23-2019, 01:13 AM
Replies: 7
Views: 5
Posted By Uncle Gizmo
Re: Comobox adjusted list items

Put the entries you want to appear in the combobox in a table. Have an extra column in the table for a check mark (Boolean). Put a check against the ones you don't want to appear. Use a query to stop...
Forum: Forms 01-22-2019, 07:59 AM
Replies: 15
Views: 76
Posted By Uncle Gizmo
Re: Use the same for for data entry and later editing

First, I'm out of the office so to speak, can't check anything on the PC, so relying on my memory!

I think you could set data entry to true, but I don't, not usually.

It appears that you want...
Forum: Forms 01-22-2019, 07:39 AM
Replies: 15
Views: 76
Posted By Uncle Gizmo
Re: Use the same for for data entry and later editing

You are correct, it is considered good practice to use one form for as many tasks as possible.

If you are going to edit records, then you are going to need some method of finding the record you...
Forum: General 01-21-2019, 04:34 AM
Replies: 20
Views: 210
Posted By Uncle Gizmo
Re: Data are Same for Allthe record in the subform

Well, I have not been able to code for a week as I'm on holiday. I have pointed you to video instructions, that I'm sure will offer some insight. However, if they are not helping, then I'll be at...
Forum: Politics & Current Events 01-20-2019, 01:51 PM
Replies: 147
Views: 12,354
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I have been following this climate change Fiasco since it started. I have no idea what's causing it, and I'm convinced that no one else does either! Both sides wheel out this person, that person,...
Forum: Tables 01-19-2019, 08:13 AM
Replies: 9
Views: 355
Posted By Uncle Gizmo
Re: Accounting Database Tables & Structure

I'd be very surprised if there wasn't an accounting module for Python.

Good choice by the way!

I need to write some special software for my 3D printer and I think that Python is the way to go...
Forum: Forms 01-16-2019, 02:00 AM
Replies: 42
Views: 526
Posted By Uncle Gizmo
Re: How to populate a text box and field based on combo box value?

If you have access to YouTube, you may find this video in my MS Access blog informative...

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

Sent from my SM-G925F using...
Forum: General 01-12-2019, 05:47 AM
Replies: 5
Views: 227
Posted By Uncle Gizmo
Re: Excel to Access

Hello there Asterix, Welcome to access world forums.

Re:- My question is whether it would be easy to convert the excel file into an access file so I can get a report.

Looking at your Excel...
Forum: Introduce Yourself 01-12-2019, 05:28 AM
Replies: 2
Views: 173
Posted By Uncle Gizmo
Re: Am new here and to access 2013

Hi Mike,
Welcome to (AWF) Access World Forums.

I note your interest in stock control, and I wondered if you have happened upon this explanation from Allen Browne which may be of interest to you....
Forum: General 01-09-2019, 05:12 PM
Replies: 1
Views: 276
Posted By Uncle Gizmo
Re: Packaging for release protocols

I'm surprised you haven't received an answer to this question. There are a few people here who have a lot of experience with this, I've seen them answer similar questions in the past. I'm sure your...
Forum: Forms 01-03-2019, 02:40 PM
Replies: 21
Views: 8,786
Posted By Uncle Gizmo
Re: how to lock all controls in the form at once

I provide video instructions on how to lock and unlock controls on my website here:- Lock, Unlock Controls (http://www.niftyaccess.com/lock-unlock-controls/)

I show several methods from a Basic...
Forum: General 01-02-2019, 04:06 PM
Replies: 2
Views: 1,482
Posted By Uncle Gizmo
Invalid Bracketing

I see many beginners with MS Access using field names with spaces in. Access can handle this, it puts square brackets around these "Offensive" objects!

I say "offensive" because they offend me!...
Forum: Forms 12-31-2018, 12:23 PM
Replies: 18
Views: 714
Posted By Uncle Gizmo
Re: Theory Question About Forms and Underlying Queries instead Tables

There have been some interesting discussions here on this subject, see this thread:-

https://access-programmers.co.uk/forums/showthread.php?p=1110510#post1110510

BTW - boblarson made some...
Forum: Queries 12-29-2018, 05:18 PM
Replies: 7
Views: 364
Posted By Uncle Gizmo
Re: Duplicate Records with multiple fields

I suspect you've supplied all the information necessary to answer your question, however it's hidden in the way you have presented it. I'm thinking a better approach to asking the question, might be...
Forum: Excel 12-27-2018, 02:47 PM
Replies: 13
Views: 1,613
Posted By Uncle Gizmo
Re: Index Match to replace a Vlookup

I notice you have yet to receive a reply. Hence I'm bumping it up the list. Merry Christmas!
Forum: Forms 12-26-2018, 12:32 PM
Replies: 18
Views: 714
Posted By Uncle Gizmo
Re: Theory Question About Forms and Underlying Queries instead Tables

>>>"IMO, the single biggest problem new Access users face is not knowing how to design and implement a valid, well-normalized, set of tables. If one doesn't get that right, it's tough sledding all...
Forum: Introduce Yourself 12-22-2018, 12:47 PM
Replies: 5
Views: 334
Posted By Uncle Gizmo
Re: 20+ years trial and error

Those victories are sweet! Welcome to Access World Forums (AWF)

And a Merry Christmas to you!



Sent from my SM-G925F using Tapatalk
Forum: Introduce Yourself 12-22-2018, 01:35 AM
Replies: 2
Views: 263
Posted By Uncle Gizmo
Re: Hello from Poland

I agree with Colin your input on macros will be most helpful.

A few years back we had a member, I think his name was Mike365 and he knew macros inside out. I was always amazed to see his Macro...
Showing results 1 to 25 of 500

 
Forum Jump



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