Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.15 seconds.
Search: Posts Made By: NauticalGent
Forum: The Watercooler Today, 05:47 AM
Replies: 19
Views: 280
Posted By NauticalGent
Re: Our wonderful political system

Exactly. Sad state of affairs, this paradigm of ours...
Forum: The Watercooler Today, 05:45 AM
Replies: 19
Views: 280
Posted By NauticalGent
Re: Our wonderful political system

In the words of a former colleague of mine named Dempsey Bullock: A to the MEN!
Forum: Introduce Yourself 11-09-2018, 10:15 AM
Replies: 1
Views: 48
Posted By NauticalGent
Re: Hello from italy

Ciao! Welcome to AWF!
Forum: The Watercooler 11-08-2018, 08:04 PM
Replies: 19
Views: 280
Posted By NauticalGent
Re: Our wonderful political system

...I’m her 8th old man, I’m ‘enery. ‘Enery the 8th I am...
Forum: The Watercooler 11-07-2018, 08:15 PM
Replies: 19
Views: 280
Posted By NauticalGent
Re: Our wonderful political system

True, much like the Republicants did to Obummer while the Democraps had the Oval Office.

Same shitty lyrics to the same shitty song...
Forum: The Watercooler 11-07-2018, 07:56 PM
Replies: 19
Views: 280
Posted By NauticalGent
Our wonderful political system

Just a quick visual-tutorial...

https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=72600&stc=1&d=1541649296
Forum: Modules & VBA 11-04-2018, 09:36 AM
Replies: 6
Views: 149
Posted By NauticalGent
Forum: SQL Server 11-04-2018, 09:34 AM
Replies: 5
Views: 640
Posted By NauticalGent
Re: Just Thinking about moving my main db to sql server

I took the plunge about 8 months ago and life has never been better.

I see you have bought a book, but if you are a more visual learning inclined, here is a series of videos I watched to help me...
Forum: Reports 11-03-2018, 08:26 AM
Replies: 3
Views: 218
Posted By NauticalGent
Re: How to "jump" (select/setfocus) to a specific record in a long report

Since you really did not define what the issue(if any) is, I can only assume your code is not working.

Looking at your code, everything seems to be right except for the string that contains a...
Forum: Modules & VBA 11-02-2018, 11:02 AM
Replies: 5
[SOLVED] NoData reports
Views: 134
Posted By NauticalGent
Re: NoData reports

Nice work! Glad you got it sorted.
Forum: General 11-02-2018, 10:51 AM
Replies: 17
Views: 320
Posted By NauticalGent
Re: Help with multiple IIF statements

Id wager heavily that Case Statements are going to win the day. I was going to suggest this very test, but you seem to be two steps ahead of me. Git R done!
Forum: General 11-01-2018, 08:27 PM
Replies: 17
Views: 320
Posted By NauticalGent
Re: Help with multiple IIF statements

Hello Cassidy7782 and welcome to AWF!

I could not agree more with DBGuy’s reasponse regarding CASE statements. I use them any time I have more than 2 “If’s” for a number of reasons, first and...
Forum: Code Repository 11-01-2018, 08:15 PM
Replies: 16
Views: 695
Posted By NauticalGent
Re: Speed Comparison Tests - Having vs Where

Colin, these tests of yours are simply fantastic. Thanks and please continue, Mythbusters has always been one of my favorite shows and this ranks right up there....
Forum: Introduce Yourself 11-01-2018, 12:34 PM
Replies: 4
Views: 124
Posted By NauticalGent
Re: Hello from Marcus (Italy)

L'onore tutto mio. Benvenuto in AWF!
Forum: Introduce Yourself 11-01-2018, 11:39 AM
Replies: 4
Views: 124
Posted By NauticalGent
Re: Hello from Marcus (Italy)

Ciao Marcus! What part of Italy are you from?
Forum: General 11-01-2018, 11:00 AM
Replies: 3
Views: 142
Posted By NauticalGent
Re: AfterUpdate not working with auto-populated field

Happy to help...AND...your thanks but me at the 200 mark, so thank YOU.
Forum: General 11-01-2018, 10:48 AM
Replies: 3
Views: 142
Posted By NauticalGent
Re: AfterUpdate not working with auto-populated field

Place the Event code on the field that auto-populates the HiringMgr field...
Forum: Modules & VBA 11-01-2018, 10:27 AM
Replies: 5
[SOLVED] NoData reports
Views: 134
Posted By NauticalGent
Re: NoData reports

Maybe this could help...

https://answers.microsoft.com/en-us/office/forum/office_2007-access/hide-report-group-section-if-no-data/a91f2751-ff55-e011-8dfc-68b599b31bf5?db=5
Forum: Introduce Yourself 10-31-2018, 10:03 PM
Replies: 2
Views: 155
Posted By NauticalGent
Re: Hello from Cahyanto

Welcome aboard!
Forum: Introduce Yourself 10-31-2018, 05:33 AM
Replies: 1
Views: 63
Posted By NauticalGent
Re: Southern Girl saying Hello

Welcome to AWF, this Forum has everything you need!
Forum: Modules & VBA 10-30-2018, 09:09 PM
Replies: 8
Views: 149
Posted By NauticalGent
Re: Check Box to exclude from search

..or you could use Arnel’s contribution! Sorry Ariel, you must have posted while I was replying
Forum: Modules & VBA 10-30-2018, 09:08 PM
Replies: 8
Views: 149
Posted By NauticalGent
Re: Check Box to exclude from search

Rather than tell you where to put the code, read up on the In() Function. To achieve what you want, you will need to use it with the Not operator as in “Not In() “

Here is a good example on how to...
Forum: Modules & VBA 10-30-2018, 11:13 AM
Replies: 9
Views: 139
Posted By NauticalGent
Re: VBA Causing Disruption on controls

[Shooting from the hip, i think the problem lies with trying to do a DLookup thst involves a textbox value that is null. Try replacing
" & [Forms]![WorkOrders]![Project Number])

With
" &...
Forum: Modules & VBA 10-30-2018, 10:51 AM
Replies: 9
Views: 139
Posted By NauticalGent
Re: VBA Causing Disruption on controls

Can you post the code attached to the button?
Forum: Introduce Yourself 10-30-2018, 08:51 AM
Replies: 3
Views: 72
Posted By NauticalGent
Re: Hi Everyone

Welcome to AWF!
Showing results 1 to 25 of 500

 
Forum Jump



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