Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.18 seconds.
Search: Posts Made By: isladogs
Forum: Modules & VBA Today, 03:58 PM
Replies: 12
Views: 89
Posted By isladogs
Re: Need help with bitmasking permissions

I wish my brain still held all it did a couple of years ago ... ;)
But its often easier to suggest something when you're looking at it from outside
Forum: Queries Today, 03:55 PM
Replies: 5
Views: 63
Posted By isladogs
Re: Delete Query Criteria

I was assuming the delete query would be saved
Forum: Queries Today, 03:21 PM
Replies: 5
Views: 63
Posted By isladogs
Re: Delete Query Criteria

That should be:
DELETE * FROM TableName WHERE some condition

OR if more than one table is involved in the query, something like:
DELETE DISTINCTROW * FROM TableName LEFT JOIN OtherTableName ON...
Forum: SQL Server Today, 03:13 PM
Replies: 21
Views: 346
Posted By isladogs
Re: SQL BE with MS Access FE - Speed up searches

Ah yes. Got it now. Sorry, Never noticed that before!
One query shown but it disappears after a few seconds!
Will investigate further
Forum: SQL Server Today, 03:04 PM
Replies: 21
Views: 346
Posted By isladogs
Re: SQL BE with MS Access FE - Speed up searches

Hi

Apologies for the delay in replying
I'm using SSMS 2014 Express and am unable to find the 'Recent Expensive Queries' option..

I am aware that monitoring can be switched on for all queries...
Forum: Macros Today, 01:36 PM
Replies: 23
Views: 601
Posted By isladogs
Re: Custom Right Click Menu

Or you can set Unique Records = Yes to make it editable.
The SQL becomes
SELECT DISTINCTROW Contacts.*
FROM Contacts INNER JOIN Titles ON Contacts.ContactTitle = Titles.Title
ORDER BY...
Forum: Macros Today, 01:09 PM
Replies: 23
Views: 601
Posted By isladogs
Re: Custom Right Click Menu

If I understand you correctly, change the form's recordsource to
SELECT Contacts.*
FROM Contacts INNER JOIN Titles ON Contacts.ContactTitle = Titles.Title
ORDER BY Titles.TitleID;
Forum: Modules & VBA Today, 12:35 PM
Replies: 7
Views: 84
Posted By isladogs
Re: How to add password automatically to exported excel file

There's no password argument in TransferSpreadsheet.
Suggest you do an online search for password protect Excel file vba.

Try this as a starting point...
Forum: General Today, 12:08 PM
Replies: 9
Views: 120
Posted By isladogs
Re: Unable to view Objects

Apologies. I was thinking of another thread with similar issues where I'd outlined a strategy

1. Try decompiling a copy of your database to remove any corrupt compile code.
See...
Forum: Modules & VBA Today, 11:55 AM
Replies: 12
Views: 89
Posted By isladogs
Re: Need help with bitmasking permissions

For info, the large number (bigint) datatype is available in both 32-bit and 64-bit Access providing you have A2016 (with updates), A2019 or A365.
Having said that, the double number datatype would...
Forum: Modules & VBA Today, 11:50 AM
Replies: 13
Views: 317
Posted By isladogs
Re: Problems importing file into Access 2019

See my original comment in post #2
Forum: General Today, 09:48 AM
Replies: 7
Views: 85
Posted By isladogs
Re: Map button - Go slow I'm a noob

You can!
As previously stated, ZIP the screenshots and upload one zip file.
Once you reach 10 posts, that restriction is removed
Forum: Sample Databases Today, 09:46 AM
Replies: 0
Views: 36
Posted By isladogs
UK Postcode Address & House Price Lookup

Attached is a simple app I created to get a list of addresses & house price info for selected UK postcodes together with the geo-coordinates and a static Google map for that postcode.

It is a cut...
Forum: General Today, 09:08 AM
Replies: 7
Views: 85
Posted By isladogs
Re: Map button - Go slow I'm a noob

Hi Boch
Your post was moderated due to the attached images. Until you have 10 posts you need to zip any attached files

Buttons can't link to modules but they can run procedures contained in those...
Forum: General Today, 09:03 AM
Replies: 9
Views: 120
Posted By isladogs
Re: Unable to view Objects

Thanks for confirming the linked and local tables exist.
Can you see the linked tables in the linked table manager?

Suggest you now try my other suggestions to deal with probable corruption
Forum: Queries Today, 07:44 AM
Replies: 64
Views: 2,051
Posted By isladogs
Re: Access error -query is corrupt

The MS webpage on this issue was updated again yesterday.
It would appear that a fix is now available for all affected versions
See...
Forum: Modules & VBA Today, 07:12 AM
Replies: 22
Sticky: ME. or ME!
Views: 14,701
Posted By isladogs
Re: ME. or ME!

To make this easier to find in future, I've just made it a sticky thread.
Thanks to all who contributed their wisdom on the tooic
Forum: Modules & VBA Today, 06:33 AM
Replies: 8
Views: 103
Posted By isladogs
Re: using text box inputs to use in your filename

Excellent. Glad I could help.
As you've found out, it will allow dots in the date values but slashes would I think have failed
I'd still personally use something like...
Forum: Modules & VBA Today, 02:55 AM
Replies: 8
Views: 103
Posted By isladogs
Re: using text box inputs to use in your filename

One issue is the quote marks. Its just treating the contents as a string.
Omitting those, I think it will still fail if your dates look like 10/12/2019 even using .Value (though that can be omitted...
Forum: Queries Today, 01:10 AM
Replies: 7
Views: 93
Posted By isladogs
Re: Rank query returning same rank

Have a look at my article on rank orders in queries.
http://www.mendipdatasystems.co.uk/rank-order-queries/4594424063

This uses the Serialize function instead of subqueries and in my opinion...
Forum: General Today, 12:21 AM
Replies: 9
Views: 120
Posted By isladogs
Re: Unable to view Objects

Please run this query in the FE and post a screenshot of the results
SELECT MSysObjects.Name, MSysObjects.Flags, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Type)=1 Or...
Forum: Queries Today, 12:11 AM
Replies: 16
Views: 192
Posted By isladogs
Re: Using Min as Formula in Query to Find Min values from range of fields

Post#10 with the huge screenshots was moderated. Just discovered and belatedly approved.
However I've replaced the enormous inline images with links to the external files.

RC01
Until you have...
Forum: Modules & VBA Yesterday, 10:22 AM
Replies: 5
Views: 151
Posted By isladogs
Re: Compare table with imported table and find differences

Glad to have helped. Do ask if you have any questions about the article in my link
Forum: Site Suggestions Yesterday, 08:23 AM
Replies: 3
Views: 93
Posted By isladogs
Re: no email notification when posts happen too quickly in succession

By design you only get email notification of the first reply. No more emails are sent until you view that thread again. This is the case for most of the forums I belong to and in my view is a good...
Forum: Reports Yesterday, 08:17 AM
Replies: 4
Views: 94
Posted By isladogs
Re: Text Boxes Height needs to match a given text box

You would use that in the On Format event of the report section where the textboxes are located
e.g. Detail_Format event

Obviously you would need to use the names of your own textboxes with the...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:45 PM.


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