Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: isladogs
Forum: Queries Yesterday, 11:28 PM
Replies: 7
Views: 176
Posted By isladogs
Re: Access error -query is corrupt

The example I made in post #1 was done in A2010 before I uninstalled the Office update
Forum: Modules & VBA Yesterday, 04:13 PM
Replies: 26
Views: 334
Posted By isladogs
Re: "Unconcatenating" Data In A Field

It might help others in the future if you posted the code your niece kindly wrote for you
Forum: General Yesterday, 03:23 PM
Replies: 18
Views: 266
Posted By isladogs
Re: Useful links

Hi Tera
I added APR Pillai's Access Tips site to my useful links web page a week or so ago.
Its a very comprehensive site and definitely worth checking out
Forum: General Yesterday, 02:56 PM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

Now that reminds me. I'm about to send you an automation attack app :rolleyes:
Forum: General Yesterday, 02:49 PM
Replies: 18
Views: 266
Posted By isladogs
Re: Useful links

Many thanks both for the link & the kind comments.

I've been busy today updating a code repository item on managing IMEX data tasks...
Forum: General Yesterday, 02:40 PM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

The point I'm making is that by requiring users to click the button they are effectively being given 'privileges' they may try to misuse later with another app.

That option doesn't arise with the...
Forum: General Yesterday, 02:22 PM
Replies: 25
Views: 242
Posted By isladogs
Re: Import/Export Data Tasks

I've just updated the example app as follows:
a) added code to allow data tasks to be deleted
b) changed the app so all functions can now be run using a form
c) added a report to view details of...
Forum: Code Repository Yesterday, 02:18 PM
Replies: 2
Views: 151
Posted By isladogs
Re: View & Edit IMEX Data Task Specifications

I've updated the application as follows:
a) added code to allow data tasks to be deleted
b) changed the app so all functions can now be run using a form
c) added a report to view details of all...
Forum: The Watercooler Yesterday, 02:08 PM
Replies: 13
Views: 144
Posted By isladogs
Re: what does your username mean?

Trust me Adam! I worked that out long before I 'outed' you.
Forum: General Yesterday, 02:06 PM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

I don't see how any application can run code if VBA is somehow disabled.

I'm talking about my clients networks - not my own networks.
Therefore I cannot guarantee they all lock down their...
Forum: General Yesterday, 12:57 PM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

Hi DBG
Also to clarify, in my clients' networks its also true that no app ever gets installed unless it's an application approved by the IT network staff following advice from other senior staff....
Forum: Tables Yesterday, 12:14 PM
Replies: 11
Views: 91
Posted By isladogs
Re: Could use a mentor...

The code is correct but a simple test will show you that your final paragraph is untrue.

EDIT:
@whatever2
Feel free to go elsewhere. You haven't made a positive start on this forum. If you...
Forum: Forms Yesterday, 12:05 PM
Replies: 9
Views: 129
Posted By isladogs
Re: Hiding checkboxes depending on the value of another field.

As the other thread makes clear you cannot
a) use conditional formatting on checkboxes.
b) selectively enable/disable or show/hide controls on continuous forms. Its all or nothing as you are...
Forum: General Yesterday, 11:52 AM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

That's exactly the point I've been trying to make...but in reverse!
The system admin ensures my apps are saved to locations made trusted for all authorised users using the supplied script. Its a...
Forum: General Yesterday, 10:52 AM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

End users don't adjust any settings in my client organisations either.
In fact because the apps are locked down they have no access to Access options / nav pane etc

My commercial apps are always...
Forum: The Watercooler Yesterday, 10:46 AM
Replies: 13
Views: 144
Posted By isladogs
Re: what does your username mean?

OK I'll play the game...
My dog in the photo is called Isla and there's a place in London called the Isle Of Dogs
Forum: General Yesterday, 10:28 AM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

I agree but in my experience, certain users will just ignore the security bar message and complain the app doesn't work. That's why I use the approach I mentioned in post #14
Forum: General Yesterday, 10:12 AM
Replies: 35
Views: 269
Posted By isladogs
Re: A Question of Trust

When an app is trusted, it adds an entry to the registry. Its possible to do this using a script but you can't do this from your Access app as no code will run until its trusted! Chicken and egg...
Forum: Forms Yesterday, 09:57 AM
Replies: 9
Views: 129
Posted By isladogs
Re: Hiding checkboxes depending on the value of another field.

Did you look at the link in post #2?

EDIT Looks like DBG got there first again....

I can't make any sense of that IIf statement but its definitely incorrect.
For info, my example in the link...
Forum: General Yesterday, 09:31 AM
Replies: 18
Views: 266
Posted By isladogs
Re: Useful links

Thanks Mark
I've seen your blog before but not all of the items in these links.
Another one to add to the list.
Not sure that what you have is simpler than my other links but it certainly looks...
Forum: The Watercooler Yesterday, 07:52 AM
Replies: 32
Views: 313
Posted By isladogs
Re: Enough!

I'm hoping you mean Col Essex rather than myself!
Forum: Introduce Yourself Yesterday, 05:59 AM
Replies: 4
Views: 65
Posted By isladogs
Re: Hello from Kenya

Hi Kim.
Welcome to AWF. Glad to have you here
Forum: Tables Yesterday, 05:56 AM
Replies: 6
Views: 90
Posted By isladogs
Re: Relationship Set Up

I'd also strongly advise against using the attachment datatype as it causes database bloat and can lead to problems as a result.
Forum: General Yesterday, 05:35 AM
Replies: 18
Views: 266
Posted By isladogs
Re: Useful links

Thanks Phillip and Moke. Will check out anything I've not seen before.
Happy to accept further suggestions as well!
Forum: Queries Yesterday, 05:32 AM
Replies: 6
Views: 103
Posted By isladogs
Re: Average of count per row

The domain functions are much better than they used to be and have their uses.
However, all cause speed issues in queries as the function(s) have to run in turn for each field/record.

If you...
Showing results 1 to 25 of 500

 
Forum Jump



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