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: General Yesterday, 10:37 AM
Replies: 5
Views: 95
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: 17
Views: 1,745
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: 17
Views: 1,745
Posted By NauticalGent
Forum: Queries 06-22-2019, 08:52 AM
Replies: 1
Views: 84
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: 847
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: 17
Views: 1,745
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: 501
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: 501
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: 16
Views: 1,096
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: 16
Views: 1,096
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: 16
Views: 1,096
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: 501
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: 153
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: 133
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: 500
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: 153
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...
Forum: General 06-18-2019, 01:46 PM
Replies: 18
Views: 500
Posted By NauticalGent
Re: Splitting Database With Different Front Ends

Not sure why you are saying that, no one has asked you to leave AFAIK...
Forum: General 06-18-2019, 01:05 PM
Replies: 18
Views: 500
Posted By NauticalGent
Re: Splitting Database With Different Front Ends

Emphatically agree with AWFs favorite uncle. There are better ways to impose restrictions on certain users. If you choose to go this way, sing out and you will be showered with the many options to do...
Forum: Queries 06-17-2019, 08:05 PM
Replies: 6
Views: 176
Posted By NauticalGent
Re: Pass through Query to access AS400

Im sure you have already been to this site, but just in case:

https://www.connectionstrings.com/as-400/

There is even a link to an AS400 Q/A forum...may be able to find some answers there.
Forum: General 06-17-2019, 08:36 AM
Replies: 21
Views: 500
Posted By NauticalGent
Re: Entity Attribute Value Model datatypes

Thanks DBG, learn something new everyday!
Forum: General 06-17-2019, 08:31 AM
Replies: 21
Views: 500
Posted By NauticalGent
Re: Entity Attribute Value Model datatypes

At the risk of sounding ignorant, what is EAV?
Forum: Modules & VBA 06-17-2019, 06:45 AM
Replies: 12
Views: 239
Posted By NauticalGent
Re: Order By is DAO open

Without digesting the SQL statement, have you tried designing the query in the query builder to see if it runs without error.

If it does, you could switch to SQL view and see how Access writes...
Forum: Forms 06-17-2019, 06:30 AM
Replies: 4
Views: 138
Posted By NauticalGent
Re: send email

Yeah, I’d say that would be problematic!
Forum: Theory and practice of database design 06-16-2019, 12:12 PM
Replies: 5
Views: 206
Posted By NauticalGent
Re: Backend database is suddenly getting inconsistent stat

It sounds as if the DB isn’t split or if it is, someone is using the “master” copy on a shared location.

Is your DB application split and is everyone using their own copy of the Front End on...
Forum: Forms 06-16-2019, 02:03 AM
Replies: 13
Views: 162
Posted By NauticalGent
Re: Unlock Button and Status Field to Header

Happy to help. Use the ode you had before that locked the fields in the button’s On_Click event.
Showing results 1 to 25 of 500

 
Forum Jump



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