Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.26 seconds.
Search: Posts Made By: isladogs
Forum: Modules & VBA Today, 11:29 AM
Replies: 39
Views: 356
Posted By isladogs
Re: Populate the name of the active control on focus in a form.

Another approach that I use is to have an unbound label whose caption provides a hint when the user moves the mouse over a control. The caption font is large (20 pt) and a bright colour (magenta) so...
Forum: General Today, 11:04 AM
Replies: 6
Views: 157
Posted By isladogs
Re: NOTICE TO ALL MEMBERS : Site Issues

A quick question on behalf of the site owner
Is anyone still experiencing any of the issues we had yesterday?
It would also be helpful to know if members are now finding the forum error free :D
Forum: Queries Today, 10:30 AM
Replies: 9
Views: 90
Posted By isladogs
Re: SQL in VBA gets me everytime

As well as scrapping the text delimiters if its a number field, you should use = instead of LIKE as you aren't using a wildcard.
Value is the default property so can be omitted.
I think you mean...
Forum: Modules & VBA Today, 07:14 AM
Replies: 7
Views: 91
Posted By isladogs
Re: Make Table query issue (VBA)

You will first need to close the form so the table can be overwritten. Also do not keep creating the table repeatedly as it will lead to instability.
Instead either empty the table using a delete...
Forum: Modules & VBA Today, 05:17 AM
Replies: 7
Views: 91
Posted By isladogs
Re: Make Table query issue (VBA)

Hi and welcome to AWF

Your post was moderated. This often happens when new members post a lot of code.
I also moved your post from the Introduce Yourself forum as its a technical question....
Forum: Modules & VBA Today, 12:25 AM
Replies: 3
Views: 85
Posted By isladogs
Re: How do I use a filepath to open a file in VBA?

Use Application.FollowHyperlink.
This will open any file using the default application (Word/Excel etc)

EDIT:
If there is no default application for that file type, you will be asked which...
Forum: Modules & VBA Today, 12:20 AM
Replies: 3
Views: 78
Posted By isladogs
Re: Chow password gives me a strange result

I don't get your result but the method isn't reliable.
Try typing longer password of more than four characters then click the button to hide the password. You will get an error

Either follow the...
Forum: Forms Yesterday, 02:26 PM
Replies: 8
Views: 110
Posted By isladogs
Re: Form on a loop? "duplicate values in the index, primary key, or relationship."

I've never used the Str function in this way but it seems logical that you would need text delimiters assuming VictimID is a text field. I've made a few other changes as well. Try this


Private...
Forum: General Yesterday, 12:56 PM
Replies: 6
Views: 157
Posted By isladogs
Re: NOTICE TO ALL MEMBERS : Site Issues

The site owner, Jon, has rebooted the server and, as far as I can tell, the issues previously described have been resolved.
Please let us know if that isn't the case for you
Forum: Forms Yesterday, 12:44 PM
Replies: 4
Views: 82
Posted By isladogs
Re: Login Screen on forum

Hi
See if this example app is any use to you https://www.access-programmers.co.uk/forums/showthread.php?t=193131
Forum: General Yesterday, 04:55 AM
Replies: 6
Views: 157
Posted By isladogs
There are various issues affecting the site today...

There are various issues affecting the site today (Wed 18 Sept) including:
1. Many posts being moderated so don't appear at once. If so, please don't duplicate the post. One of the mods will...
Forum: General Yesterday, 04:45 AM
Replies: 2
ddd
Views: 65
Posted By isladogs
There are various issues affecting the site...

There are various issues affecting the site today. Thanks for letting us know about this one.
Forum: Modules & VBA 09-17-2019, 11:56 PM
Replies: 7
Views: 138
Posted By isladogs
Re: Enhanced Msgbox alternative with unicode character set

Thanks for the update. The author definitely needs to know about these issues and hopefully fix them
Forum: Site Suggestions 09-17-2019, 10:41 PM
Replies: 13
Views: 189
Posted By isladogs
Re: Another strange site quirk?

That was the issue I had as well.
Also very odd to be told I had to wait for a moderator to approve my message :D
Forum: Excel 09-17-2019, 09:53 PM
Replies: 2
Views: 71
Posted By isladogs
Your post was moderated. No idea why. Now...

Your post was moderated. No idea why. Now approved.
I will report the issue to site admins
Forum: Modules & VBA 09-17-2019, 09:51 PM
Replies: 7
Views: 138
Posted By isladogs
Re: Enhanced Msgbox alternative with unicode character set

Many thanks for providing such a detailed account of the issue which you've explained very clearly.

I have only looked briefly at the code involved and make to pretence to have understood it...
Forum: Site Suggestions 09-17-2019, 09:24 PM
Replies: 13
Views: 189
Posted By isladogs
This happens to me but only on another forum. In...

This happens to me but only on another forum. In my case it can occur when using a WiFi connection and the signal strength is poor.

Something else strange here. Doc's post was moderated which...
Forum: Modules & VBA 09-17-2019, 01:26 PM
Replies: 6
Views: 101
Posted By isladogs
Re: How to Run a procedure on a schedule

Set Task Scheduler to open your database and run a macro which calls your procedure.
The task scheduler settings can include waking the computer if in hibernation.
However it can't turn on a...
Forum: Forms 09-17-2019, 04:59 AM
Replies: 4
Views: 82
Posted By isladogs
Re: chart + button

Consider having a combo or listbox alongside your radar chart which has the chart object labels. You can then use that in the standard way to do what you want
Forum: Modules & VBA 09-17-2019, 04:42 AM
Replies: 7
Views: 138
Posted By isladogs
Re: Enhanced Msgbox alternative with unicode character set

Isn't the example you showed just intended to illustrate the point?
This is also from the example app:
...
Forum: Modules & VBA 09-17-2019, 02:24 AM
Replies: 7
Views: 138
Posted By isladogs
Re: Enhanced Msgbox alternative with unicode character set

I've found the enhanced message box example works well though I've not needed to use it with anything other than standard character sets.

Are you suggesting it doesn't work at all for you?
Forum: Tables 09-16-2019, 10:18 PM
Replies: 12
Views: 135
Posted By isladogs
Re: Find out if data one one table exist on another.

@Mackbear
You've changed your description of what you want several times so I'm not at all certain what you want.
If you want a list of all items in one table that do not exist in the other, you cn...
Forum: Tables 09-16-2019, 03:59 PM
Replies: 12
Views: 135
Posted By isladogs
Re: Find out if data one one table exist on another.

If there are no matches, DCount will be zero.
Using IsNull would appear to be inappropriate here
Forum: Tables 09-16-2019, 03:29 PM
Replies: 12
Views: 135
Posted By isladogs
Re: Find out if data one one table exist on another.

Perhaps you made a mistake but you listed the same table in both cases.
If you meant two different tables, just create a query and join by the fields you listed.
If the query result contains any...
Forum: Sample Databases 09-16-2019, 07:02 AM
Replies: 1
Views: 112
Posted By isladogs
Re: Better Msgbox alternative

Good to have another alternative. I see much of the code is by Richard Bompuis (Cypris) & is used in his very similar Enhanced Message Box replacement...
Showing results 1 to 25 of 500

 
Forum Jump



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