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: Access Web 10-14-2019, 02:00 PM
Replies: 5
Views: 103
Posted By Uncle Gizmo
Re: Looking for advice on migrating to Cloud

Also search the forum for Citrix, there's been a lot of posts about it and you might find it a suitable option.

Sent from Newbury UK
Forum: General 10-13-2019, 10:30 AM
Replies: 17
Views: 230
Posted By Uncle Gizmo
Re: Do while loop

I'll just say the same to reinforce what everyone else is saying!

I also did a Blog on the subject which is on my website here:- Excel in Access (https://www.niftyaccess.com/excel-in-access/)
...
Forum: Politics & Current Events 10-13-2019, 10:17 AM
Replies: 525
Views: 27,234
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

That's an interesting observation and I read something recently which made my ears prick up! I have no idea of the truth of it, or though I suspect there's a grain of truth in it...

I understand...
Forum: The Watercooler 10-12-2019, 11:51 PM
Replies: 50
Views: 790
Posted By Uncle Gizmo
Re: Prince Harry, Duke of Sussex

John, I think you hit the nail on the head with your comments about this forum. And as for Colin, whatever you think of him, he is at least "genuine" and consistent.

I also suspect that Colin is...
Forum: Forms 10-12-2019, 04:07 AM
Replies: 12
Views: 231
Posted By Uncle Gizmo
Re: Counting non empty textboxes

I've added this video, along with an explanation of the For Each Control in Me.Controls method to my website here:- https://www.niftyaccess.com/loop-through-a-set-of-controls/

Where there are some...
Forum: General 10-11-2019, 04:12 PM
Replies: 10
Views: 177
Posted By Uncle Gizmo
Re: VBA DoCmd.TransferText add file name to field in table

I'm slowly getting to the bottom of this, but it is very frustrating, like it was 6 months ago, and I wish I'd never got back into it! I think one problem is the sample data has a vendor column...
Forum: General 10-11-2019, 11:30 AM
Replies: 10
Views: 177
Posted By Uncle Gizmo
Re: VBA DoCmd.TransferText add file name to field in table

I haven't fixed it yet, but I think I know how to. I was looking the wrong place, I thought I needed to fix it at the Variant "varSplit"...

However, before it gets there, it's in a string...
Forum: General 10-11-2019, 08:49 AM
Replies: 10
Views: 177
Posted By Uncle Gizmo
Re: VBA DoCmd.TransferText add file name to field in table

I've been working on a system for importing spreadsheets with more than 255 columns into several MS Access tables. I've discussed it with colleagues on this site a while back, I think it was...
Forum: General 10-10-2019, 02:39 PM
Replies: 10
Views: 177
Posted By Uncle Gizmo
Re: VBA DoCmd.TransferText add file name to field in table

What are the text files like? are they Comma Separated Value files (CSV)? If not, what separates the text into the different Fields? Can you supply a sample of the the data from the text files?
Forum: Modules & VBA 10-10-2019, 11:59 AM
Replies: 12
Views: 228
Posted By Uncle Gizmo
Re: Passing values between forms

I too am having trouble picturing your situation.

I think you are saying that the code works fine if you run it in the OnLoad event in the list Form. And I think the list Form is one of two...
Forum: Modules & VBA 10-10-2019, 11:07 AM
Replies: 12
Views: 228
Posted By Uncle Gizmo
Re: Passing values between forms

No, it's not ... Have a better look....

The combobox controls the records displayed in the subform on the left and the subform on the left controls the records displayed in the subform form on the...
Forum: Modules & VBA 10-10-2019, 10:08 AM
Replies: 12
Views: 228
Posted By Uncle Gizmo
Re: Passing values between forms

Please see Attached:- PassingValBetweenForms_1a.zip
Forum: Forms 10-10-2019, 05:34 AM
Replies: 12
Views: 231
Posted By Uncle Gizmo
Re: Counting non empty textboxes

When I first started out with MS Access I would use "Let" ... I think I inherited the idea from BASIC. I posted some code on a forum, pretty sure it was Woody's Access Lounge. Someone told me that I...
Forum: Forms 10-10-2019, 04:53 AM
Replies: 12
Views: 231
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: Politics & Current Events 10-09-2019, 04:05 PM
Replies: 525
Views: 27,234
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

The Town I live in Newbury needed a bypass! https://en.wikipedia.org/wiki/Newbury_bypass Anyone who ever drove through Newbury could have told you it needed a bypass! any little hiccup, any holiday,...
Forum: Politics & Current Events 10-09-2019, 03:54 PM
Replies: 525
Views: 27,234
Posted By Uncle Gizmo
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

We've got this guy in the UK, Piers Morgan, I'm not a fan, but I did find this clip amusing... The woman he's talking to is Extinction Rebellion Co-Leader Skeena Rathor, normally very capable of...
Forum: The Watercooler 10-09-2019, 12:01 AM
Replies: 4
Views: 155
Posted By Uncle Gizmo
Re: What would this TURF war look like?

That's a shame, I would have loved to have seen what he came up with next!

Sent from Newbury UK
Forum: Forms 10-08-2019, 11:04 PM
Replies: 7
Views: 297
Posted By Uncle Gizmo
Re: Combobox to text field input

Have a look at at "Get info from a combobox" on this this webpage:-

https://www.niftyaccess.com/combo-box/

on Nifty Access.

Edit:-
For example, if you have a Combobox "cboMyCombo" and a...
Forum: The Watercooler 10-08-2019, 03:37 PM
Replies: 4
Views: 155
Posted By Uncle Gizmo
Re: What would this TURF war look like?

Richard, Your comment reminded me about this contestant on America's Got Talent:- Ray Jessel - The Penis Song Audition (https://youtu.be/P4_Bxqp2tQU?t=132)







Full Clip:-...
Forum: Introduce Yourself 10-08-2019, 03:29 PM
Replies: 3
Views: 73
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: 150
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: Modules & VBA 10-08-2019, 03:09 PM
Replies: 2
Views: 120
Posted By Uncle Gizmo
Re: Receive emails using vba in thunderbird as client

I note your question has yet to receive reply, so I thought I would add a comment to bump it up the list...!
Forum: Reports 10-08-2019, 03:08 PM
Replies: 2
Views: 136
Posted By Uncle Gizmo
Re: ODBC -call failed when printing

I note your question has yet to receive reply, so I thought I would add a comment to bump it up the list...!
Forum: Forms 10-07-2019, 11:40 AM
Replies: 11
Views: 182
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: 247
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...
Showing results 1 to 25 of 500

 
Forum Jump



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