Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: NauticalGent
Forum: Modules & VBA Today, 07:17 AM
Replies: 13
Views: 202
Posted By NauticalGent
Re: Call Stack, who knew??

Exactly. Really cuts down on my Debug time becuase it lets me “walk backwards” while I am trouble-shooting”. My coding skills are not what the should be so what most of you get done right the first...
Forum: Modules & VBA 07-17-2019, 08:34 AM
Replies: 13
Views: 202
Posted By NauticalGent
Re: Call Stack, who knew??

Apologies for the delay, for some reason my computer at work does not like AWF. Frustrating...

In a nutshell, it makes debugging much, much easier - especially if your code calls Subs and...
Forum: Modules & VBA 07-17-2019, 02:15 AM
Replies: 13
Views: 202
Posted By NauticalGent
Call Stack, who knew??

All the time I have wasted tracing through code when the ultimate short-cut was right there in front of me...
Forum: General 07-16-2019, 01:01 PM
Replies: 17
Views: 296
Posted By NauticalGent
Re: Scaling Down Form

Roll up the sleeves and get into it. If you get stuck, you know what to do...
Forum: General 07-16-2019, 12:44 PM
Replies: 17
Views: 296
Posted By NauticalGent
Re: Scaling Down Form

Give this thread a read. One of our members, Isladogs, has written a sub that does exactly what you're looking to do...

https://www.access-programmers.co.uk/forums/showthread.php?t=304090
Forum: Politics & Current Events 07-13-2019, 06:46 AM
Replies: 532
Views: 34,581
Posted By NauticalGent
Re: In case anyone thought racism in America was dead . . .

The smartest comment made in this entire thread...
Forum: General 06-25-2019, 12:06 PM
Replies: 13
Views: 277
Posted By NauticalGent
Forum: General 06-25-2019, 11:33 AM
Replies: 13
Views: 277
Posted By NauticalGent
Re: Moving to SQL Server

Give this a read: https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017
Forum: General 06-25-2019, 11:30 AM
Replies: 13
Views: 277
Posted By NauticalGent
Re: Moving to SQL Server

I have tried to look for some sort of rationalization that this was not an insult aimed at me. I failed, so here it is:

Your prowess in all things Access is rivaled only by your utter lack of...
Forum: General 06-24-2019, 10:37 AM
Replies: 13
Views: 277
Posted By NauticalGent
Re: Moving to SQL Server

Just to add to the confusion, when I first “upsized”, I did so with AC2010 and was able to use the wizard. The wizard automatically added a timestamp field so I could edit tables as I normally would....
Forum: Theory and practice of database design 06-23-2019, 08:42 AM
Replies: 19
Views: 3,817
Posted By NauticalGent
Re: Rename Database and Corruption Error Goes Away?

I think that statement is actually spot on...
Forum: Theory and practice of database design 06-22-2019, 10:14 PM
Replies: 19
Views: 3,817
Posted By NauticalGent
Forum: Queries 06-22-2019, 08:52 AM
Replies: 1
Views: 153
Posted By NauticalGent
Re: append query

All doable with the macro wizard. Have you tried anything?
Forum: Tables 06-22-2019, 08:08 AM
Replies: 6
Views: 2,783
Posted By NauticalGent
Re: Multiple backends and relationships

Hi Matt, at the least I would look into combining the backends into one. But the real reason I am responding is to hopefully impress upon you the SQL Server option.

If you have 40+ users then it...
Forum: Theory and practice of database design 06-21-2019, 11:59 PM
Replies: 19
Views: 3,817
Posted By NauticalGent
Re: Rename Database and Corruption Error Goes Away?

This topic has been debated, in some instances in a hostile manner, in this forum many times. There is one particular thread that I believe ChrisO was the prolific contributor that spoke to this...
Forum: Modules & VBA 06-21-2019, 10:55 AM
Replies: 59
Views: 746
Posted By NauticalGent
Re: Compile stops at db.OpenRecordset

Under one of his posts, click on the scales icon, make sure you check “approve” and then type something nice. That last bit is optional but encouraged! Welcome to AWF
Forum: Modules & VBA 06-21-2019, 10:45 AM
Replies: 59
Views: 746
Posted By NauticalGent
Re: Compile stops at db.OpenRecordset

I have been following this thread from the get-go. Jrickards, you need to send DBG a box of cigars and/or case of scotch. He really stuck it out and got you to the finish line!

I know you know...
Forum: SQL Server 06-20-2019, 02:21 PM
Replies: 18
Views: 2,721
Posted By NauticalGent
Re: Access SQL Query -> T-SQL Query Conversion ?

I couldn’t get the page to load...error message attached.
Forum: SQL Server 06-20-2019, 03:12 AM
Replies: 18
Views: 2,721
Posted By NauticalGent
Re: Access SQL Query -> T-SQL Query Conversion ?

Well, it isn't often I get to help someone with a higher rep count then me, so I consider this day a success!
Forum: SQL Server 06-20-2019, 02:44 AM
Replies: 18
Views: 2,721
Posted By NauticalGent
Re: Access SQL Query -> T-SQL Query Conversion ?

I imagine you have already found this but just in case you haven't OR you choose to write your own conversion utility:...
Forum: Modules & VBA 06-19-2019, 10:43 AM
Replies: 59
Views: 746
Posted By NauticalGent
Re: Compile stops at db.OpenRecordset

Looking at the URL you provided, pstrSQL is an argument that is passed to the Function you copied. Given that you have said you are a beginner and since you did not provide the SQL string, or the...
Forum: The Watercooler 06-19-2019, 02:39 AM
Replies: 6
[SOLVED] Death Crystals
Views: 315
Posted By NauticalGent
Re: Death Crystals

Careful now Tony...let's not introduce logic and pragmatics into a topic. It only confuses the issue!
Forum: Introduce Yourself 06-19-2019, 12:03 AM
Replies: 8
Views: 207
Posted By NauticalGent
Re: Intro

Welcome to AWF, you have come to the right place!
Forum: General 06-18-2019, 07:50 PM
Replies: 18
Views: 645
Posted By NauticalGent
Re: Splitting Database With Different Front Ends

Ah yes. dealing with Access can be a real challenge and dealing with the many “personalities” here at AWF can be a real pain at times too.

There were times I felt as if I was almost being...
Forum: Modules & VBA 06-18-2019, 01:49 PM
Replies: 7
Views: 222
Posted By NauticalGent
Re: SQL Server table not updateable

I had a similar problem. The answer turned out to be a timestamp field. As soon as I added one, all my problems went away...
Showing results 1 to 25 of 500

 
Forum Jump



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