Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.39 seconds.
Search: Posts Made By: isladogs
Forum: Forms Today, 03:35 PM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

For info, getScrollhWnds wasn't in the original file

Thanks for the example. I remember discussing that with you a few months ago. Hence my comment in post #36
Forum: Modules & VBA Today, 03:24 PM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

That looks fine but it doesn't work for me either
Try using a modified version of my code instead
Forum: Sample Databases Today, 02:50 PM
Replies: 0
Views: 28
Posted By isladogs
Folder Image Viewer

The attached database is used to display thumbnail images for selected images in a folder.

Click the Populate Image List button then select a folder containing images. This will add the names of...
Forum: Forms Today, 02:25 PM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Hi CJ
Magic. Thanks! :cool:


LOL!

Where did you discover that necessary change? Just 2 locations to alter
And have you tried converting this code for 64-bit?
Forum: Modules & VBA Today, 02:16 PM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

That's doing exactly the same as my code.
I'm just getting all the extended properties rather than a selected value

This is from the GetExtFileProps procedure in modFileExtProps

'get extended...
Forum: Forms Today, 01:54 PM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Thanks
I've tried that in the past and it also doesn't seem to do anything at all for me.
I've also tried the original MDB. Also not working for me
I've not reviewed the code
Forum: Forms Today, 01:18 PM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Much as I admire Stephen Lebans' skills, some of his code no longer seems to work and converting it for 64-bit is a nightmare

If you have a specific reference I'm happy to look into it.



I'd...
Forum: Modules & VBA Today, 01:02 PM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

I've done some further checking and it is not possible to get DateTaken using FileSystemObject code. For a list of available properties using FSO, see...
Forum: Forms Today, 11:25 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Hi MajP
Good to know that my Wizhook based code provided the foundation for listbox drag and drop.
It certainly seems to be close to a working solution.

I've had a quick 'play' on my tablet so...
Forum: Forms Today, 10:59 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Thanks Phillip. I wasn't aware of that will look into it.
Do the 64-bit controls work in 32-bit or are two sets of code needed?

Also, apologies. I've not had time to review your comments in our...
Forum: Modules & VBA Today, 10:02 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

Remember I supplied two links.
Here is the output for the same file with each app
1. Extended File Properties ...
Forum: Forms Today, 09:34 AM
Replies: 5
Views: 102
Posted By isladogs
Re: Rich Text Formatting not working in Ribbon

Can you upload a stripped down copy of your database with that table and form.
It might also help to know which version of Access you are using.
Forum: Forms Today, 08:43 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Not sure whether the VB6 file is what you want.
Also can't remember whether you need to register the file using regsvr32.
Suggest a google search.

To use the common controls library you need to...
Forum: Modules & VBA Today, 08:10 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

For digitised pictures I'm still unclear why you don't just use the Date Created property for the file. Much less code and utterly reliable...
Did you look at the examples I suggested in one of my...
Forum: Queries Today, 08:06 AM
Replies: 6
Views: 73
Posted By isladogs
Re: Delete Records with conditions

You may get an error message that you cannot delete from the specified table.
If so, set Unique Records =Yes in the query properties.
That's the same as using DELETE DISTINCTROW in your SQL...
Forum: Forms Today, 07:51 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Again with respect to my example:
1. The multiselect movement is useful in this case to quickly reorder a delivery itinerary for the current date.
2. The code includes update statements to store...
Forum: Modules & VBA Today, 04:45 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

Sorry but I didn't understand your last answer.
My first example included a valid time. 00:21:25 is 21 min 25 sec after midnight.

Don't get me wrong.
If your code works for your purposes of...
Forum: Modules & VBA Today, 04:23 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

What happens with these examples?
20140229_002125_xyz
20141230_252311_abc
19102019_132205_now

The first is an invalid date. The second an invalid time. The last has UK date format for current...
Forum: Modules & VBA Today, 03:43 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

In case it helps, have a look at this function taken from https://bytes.com/topic/access/answers/197276-istime-function

Public Function IsTime(dat As Variant) As Boolean
'handle null values
If...
Forum: Forms Today, 03:28 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Thanks. Very kind.
That code was adapted from a suggestion by another forum colleague and it works really well. I've seen lots of similar code but that is probably the most concise.
In fact if the...
Forum: Modules & VBA Today, 03:21 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

OK it wasn't completely clear from the original post.
I'll test that extra code later.
My point still applies.
Your IsTime function isn't reliably testing whether a string includes a valid time
...
Forum: Reports Today, 03:06 AM
Replies: 3
Views: 62
Posted By isladogs
Re: Chart not appearing

So what do you see where the chart should be? A blank space?
Does the code compile?

Try making the chart again on a copy of the report
Forum: Modules & VBA Today, 03:02 AM
Replies: 31
Views: 268
Posted By isladogs
Re: IsTime Function

Mick
I've moved this out of the repository as a simple test shows its not working as you described

I did this:
Public Function IsTime(dat As String) As Boolean
IsTime = Left(dat, 2) <> "00"...
Forum: Reports Today, 02:39 AM
Replies: 3
Views: 62
Posted By isladogs
Re: Chart not appearing

Hi and welcome to AWF.
If the charts were created using the new 'modern' charts feature available in A365/2019, they cannot be displayed in A2016 retail or earlier.
So if any of your users are...
Forum: Forms Today, 12:28 AM
Replies: 44
Views: 544
Posted By isladogs
Re: MS Access: custom control built in another language

Whilst agreeing that in the end this is about personal preference, I disagree fundamentally with your analysis of the amount of code required.

The attached screenshot is for a route planner from...
Showing results 1 to 25 of 500

 
Forum Jump



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