Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 148
Search took 0.05 seconds.
Search: Posts Made By: Minty
Forum: SQL Server 06-21-2019, 12:49 AM
Replies: 16
Views: 1,066
Posted By Gasman
Re: Access SQL Query -> T-SQL Query Conversion ?

Minty,

The link works for me, and I've printed the page to pdf, but to big to upload here.?
PM me if you want me to email it to you. It is 2.25MB
Forum: SQL Server 06-20-2019, 03:25 AM
Replies: 16
Views: 1,066
Posted By Galaxiom
Re: Access SQL Query -> T-SQL Query Conversion ?

If you have complex joins in Access they are horrible to convert to clean TSQL because Access nests the joins. Then all those horrid parentheses to separate from the ones you actually need.

I have...
Forum: SQL Server 06-20-2019, 02:44 AM
Replies: 16
Views: 1,066
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: Forms 06-10-2019, 01:44 AM
Replies: 44
Views: 704
Posted By BadBoy House
Re: How to populate a text box and field based on combo box value?

Hi all. Just wanted to come back and say thanks again for all the assistance with this project.

We went live with the database about six weeks ago and it turned out to be a big success. No...
Forum: Modules & VBA 05-01-2019, 04:01 PM
Replies: 9
Views: 1,105
Posted By bsacheri
Re: Error- Cannot open any more databases

I was the original author of that utility. :D I'm glad to hear that it has been helpful to others. I recently discovered that it has been enhanced and made available on Colin's website. I'd post...
Forum: Modules & VBA 04-16-2019, 11:23 AM
Replies: 16
Views: 303
Posted By Gasman
Re: Sending Email from Two Different Addresses

Minty,
Yes May 18 I think, however I could not get the Msdocs code to work from the link I originally posted?
Not my code, I just copied Rogers code as he posted it and then replaced the index for...
Forum: Theory and practice of database design 03-24-2019, 10:29 AM
Replies: 1
Views: 733
Posted By isladogs
Performance Tips to speed up your Access database

The link is to an extended article written by Luke Chung from FMS....
Forum: The Watercooler 03-23-2019, 06:57 AM
Replies: 2,953
Views: 577,153
Posted By CJ_London
Re: What's your best/worst joke?

A Mother visits her son for dinner, who lives with a female roommate.
During the course of the meal, his mother couldn't help but notice how pretty his roommate was. She had long been suspicious of...
Forum: Politics & Current Events 03-15-2019, 05:14 AM
Replies: 2
Views: 168
Posted By The_Doc_Man
More shootings - but not USA this time

My heart goes out to the New Zealanders of our forum who are probably rocked to their cores to discover that their fair country is not immune to the "crazies" who want to start shooting in support of...
Forum: Site Suggestions 03-07-2019, 04:19 AM
Replies: 3
Views: 364
Posted By isladogs
Re: Site Down intermittently?

Yes - everyone affected yesterday. I was as well today.
I informed Jon both times via his other forum
Forum: Forms 12-19-2018, 01:18 AM
Replies: 14
Views: 255
Posted By arnelgp
Re: Goto instead of Filter !

minty is telling to use equality operator.
partial search is slow if you have volume of data on your table.

.FindFirst "[FieldToSearch] = '" & Me.txtSEARCH & "'"
.FindNext "[FieldToSearch] = '"...
Forum: Queries 11-23-2018, 09:26 AM
Replies: 7
Views: 394
Posted By pbaldy
Re: DSum Criteria

Playing with 2 year old grandson, have to have quick fingers to keep up with him. :p
Forum: Sample Databases 11-12-2018, 01:57 PM
Replies: 6
Views: 34,527
Posted By isladogs
Re: Password Login Screen with session login recording

OOPS!
There was a serious error in my two previous versions in that new users could not be added to the system
Many thanks for user MarcusGR for spotting this

Whilst fixing this I took the...
Forum: Sample Databases 10-29-2018, 02:01 PM
Replies: 4
Views: 712
Posted By isladogs
Grouping & Filtering #2 Kiosk Mode DEMO

This is the second in a series showing different ways of filtering and grouping data in Access.

This example is a DEMO of a typical patient login system similar to that used in my local medical...
Forum: Reports 10-19-2018, 07:10 AM
Replies: 10
Views: 394
Posted By GinaWhipp
Re: Lost Specific Printer Settings

Found it! I thought I saw something about paper sizes and found where I saw it. This might help...
http://www.utteraccess.com/forum/Select-Printers-Configur-t1982972.html
Forum: Reports 10-18-2018, 03:03 PM
Replies: 10
Views: 394
Posted By GinaWhipp
Re: Lost Specific Printer Settings

Hmm, you might have to do something like...

Dim strDefaultPrinter As String
Dim strPrinterName As String

'get current default printer.
strDefaultPrinter =...
Forum: Theory and practice of database design 09-25-2018, 02:28 AM
Replies: 2
Views: 1,960
Posted By isladogs
Re: Access File Security : MDB / MDE vs ACCDB / ACCDE

Agree totally.... though I had to look up the meaning of exfiltrate! :)
withdraw (troops or spies) surreptitiously, especially from a dangerous situation.

For info, I've updated the attached PDF...
Forum: Theory and practice of database design 09-24-2018, 12:58 PM
Replies: 2
Views: 1,960
Posted By isladogs
Access File Security : MDB / MDE vs ACCDB / ACCDE

I’ve been going on about security in Access databases for some time.

Whilst there are many things that developers can do to improve the security of their applications (both design & data), no...
Forum: General 09-23-2018, 01:35 AM
Replies: 2
Views: 324
Posted By isladogs
Free Code Samples & Example Databases

For info, I've just finished adding a large number of example databases, code samples plus my security challenges to my Mendip Data Systems (http://www.mendipdatasystems.co.uk) website.

Just...
Forum: Reports 09-19-2018, 02:38 AM
Replies: 15
Views: 444
Posted By jleach
Re: Conditional Formatting the Field based on the Value of Another Field

I've generally found Conditional Formatting to be slow, especially based on heavily calculated fields (usually some flicker/delay in rendering the format, especially noticeable when scrolling).
...
Forum: Reports 09-19-2018, 02:19 AM
Replies: 15
Views: 444
Posted By isladogs
Re: Conditional Formatting the Field based on the Value of Another Field

Hi Minty
Depends on the form/report.
For 'simple' formatting such as the form I showed, its fast enough not to be an issue. Less than a second for the form in the last reply which has approx 1500...
Forum: Modules & VBA 08-24-2018, 02:36 AM
Replies: 41
Views: 1,291
Posted By isladogs
Re: dbEngine(0)(0) vs Currentdb

An interesting thread. Thanks NG

I almost always just use CurrentDB.Execute so I rarely bother with the Set db commands

Having read the article & the various comments, I thought I'd test the...
Forum: Access World News 08-23-2018, 08:28 AM
Replies: 14
Views: 1,906
Posted By Jon
Re: Site down - out of memory

Host has said it was a bot attack. They are still looking into it.
Forum: Forms 07-19-2018, 10:27 AM
Replies: 30
Views: 700
Posted By Pat Hartman
Forum: General 07-19-2018, 06:46 AM
Replies: 22
Views: 2,526
Posted By The_Doc_Man
Re: Dashboard Scaling for 42" TV Screen

True that. The reason Access works internally in TWIPS is because Access doesn't draw anything. It passes it to a WINDOWS renderer that looks at the sizes and interacts with the screen's resolution...
Showing results 1 to 25 of 148

 
Forum Jump



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