Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 6.30 seconds.
Search: Posts Made By: isladogs
Forum: Queries Yesterday, 12:55 PM
Replies: 5
Views: 99
Posted By isladogs
Re: Update or Append query

Yes it is correct
Forum: Sample Databases Yesterday, 09:35 AM
Replies: 1
Views: 90
Posted By isladogs
Get Geolocation Data from Photos

If you’re anything like me, you will have built up a large collection of digital photos from your phone or camera but may have forgotten where many of those photos were taken

This app is designed...
Forum: SQL Server Yesterday, 08:24 AM
Replies: 7
Views: 107
Posted By isladogs
Re: Using DateSerial to get first day of current year.

Whichever expression you use, you need a space before AND in your code
Forum: General 10-20-2019, 12:27 PM
Replies: 23
Views: 265
Posted By isladogs
Re: Obtain geolocation data from Image

Now that's clever!
I tried to to do this a couple of years ago using the extended property 'Location' but it never seemed to be populated so I gave up.

Wayne Phillips' code gets the latitude &...
Forum: General 10-20-2019, 12:00 AM
Replies: 15
Views: 160
Posted By isladogs
Re: Question external monitors and Form Design

I always use automatic form resizing to handle different monitor sizes and resolutions. See my extended tutorial on its use http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784....
Forum: Queries 10-19-2019, 11:27 PM
Replies: 3
Views: 105
Posted By isladogs
Re: Turn off "Microsoft Access can't append all the records in the append query"

You can disable all such messages permanently in the client settings section of Access options but I don't recommend it as it will hide other messages that you may want.
Or run that sql statement...
Forum: Forms 10-19-2019, 07:51 AM
Replies: 61
Views: 959
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: Forms 10-19-2019, 03:28 AM
Replies: 61
Views: 959
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: Forms 10-19-2019, 12:28 AM
Replies: 61
Views: 959
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...
Forum: Forms 10-18-2019, 11:01 AM
Replies: 61
Views: 959
Posted By isladogs
Re: MS Access: custom control built in another language

Hopefully you're not referring to my code! :rolleyes: AFAIK that's not being used in ironfelix's example
Here is the link to the example app where I worked out how to get the listbox item under the...
Forum: Modules & VBA 10-18-2019, 04:25 AM
Replies: 5
Views: 135
Posted By isladogs
Re: Picking up file created date from browse event

See if my Folder Image Viewer (http://www.mendipdatasystems.co.uk/folder-image-viewer/4594429467) app is any use as I do something very similar including grabbing date created, date modified, file...
Forum: Queries 10-16-2019, 04:43 AM
Replies: 5
Views: 82
Posted By isladogs
Re: Crosstab and ACCDE

I can confirm the opposite. Crosstab queries work perfectly for me in both ACCDB and ACCDE and do so in all versions of Access I've ever used
Forum: Queries 10-15-2019, 01:07 PM
Replies: 8
Views: 123
Posted By isladogs
Re: Dlook for text with 2 criteria

Try this
DLookUp("[drug name]","[drug list]","[drug name] ='" & [Drug name] & "' AND [Chemo_drug]= 0")

However using DLookup in a query will be slow. There may be better ways.
Can you post the...
Forum: Queries 10-15-2019, 12:31 PM
Replies: 36
Views: 515
Posted By isladogs
Re: Appending an auto-increment date to a Query

It did indeed. Now approved.
Until you have ten posts you need to zip attached files.
Forum: Modules & VBA 10-15-2019, 09:57 AM
Replies: 17
Views: 656
Posted By isladogs
Re: Play different sounds as Quick as DoCmd.Beep


You need to do more than just add PtrSafe for your code to work correctly. See below in red

For info, I've updated the API declarations using conditional compilation to work in both 32-bit &...
Forum: Macros 10-15-2019, 01:32 AM
Replies: 18
Views: 206
Posted By isladogs
Re: Using Keyboard keys as condition in 2010 macro (not vba)

The last post was moderated due to the attached files. Until you have 10 posts, please zip any attachments to avoid this issue.

Posting this to trigger email notifications

FYI macros are more...
Forum: Forms 10-12-2019, 04:33 PM
Replies: 48
Views: 1,159
Posted By isladogs
Re: Problem referencing a control on a tabbed subform

A debug.print shows that the value of GetUserName is being retrieved.

However, as far as I can tell, there are no controls called Inspector or PostedFlag on that subform
Also why is your Schedule...
Forum: Forms 10-12-2019, 04:17 PM
Replies: 2
Views: 100
Posted By isladogs
Re: Dlook up from query if empty cancel

Try this

Private Sub Command1487_Click()

Dim strText as String

StrText = Nz(DLookup("[Drug Name]", "Recycle_query", "[ID] = " & Me.Text1477 & ""),"")
If strText<>"" Then
Forum: General 10-12-2019, 01:43 PM
Replies: 6
Views: 142
Posted By isladogs
Re: Installer

If you decide to purchase that, make sure you get the Pro version which includes scripting capability.
You should also be prepared to pay for a publishers certificate to reduce or prevent the issue...
Forum: General 10-12-2019, 01:38 PM
Replies: 11
Views: 262
Posted By isladogs
Re: how to properly secure the BE

Hi Ahmed
I thought we discussed this a few months ago in connection with my encrypted no strings example app ( an updated version of which will be uploaded in the next couple of weeks

You can...
Forum: General 10-12-2019, 01:19 PM
Replies: 6
Views: 142
Posted By isladogs
Re: Installer

I use SamLogic Visual Installer which is very good but is a commercial product.
Others use Inno which is open source and, I believe, all done using scripts.
Forum: General 10-12-2019, 10:31 AM
Replies: 10
Views: 222
Posted By isladogs
Re: remove the "Unknown Publisher" security warning

Are you distributing your files as ACCDE files or using a professional installer package?
If the latter, you can include script to make the install location trusted. You can also purchase a...
Forum: Queries 10-12-2019, 08:11 AM
Replies: 10
Views: 200
Posted By isladogs
Re: Help with query calculated colums and query count

You can't use a calculated field as part of another field in the same query.
You need to use the entire expression for length as volunteer again in your IIf statement.

SELECT Count((Date()-[Start...
Forum: Modules & VBA 10-12-2019, 03:45 AM
Replies: 5
Views: 121
Posted By isladogs
Re: Create Sharepoint Online folder from VBA (access 2016)

Hi Pat.
Welcome to the forum
Have you tried asking at SO as well?
If you copy the SO link here, one of the mods can edit your post and make it an active link
Forum: General 10-10-2019, 02:03 PM
Replies: 10
Views: 181
Posted By isladogs
Re: VBA DoCmd.TransferText add file name to field in table

Suggest you either
a) use an update query to insert the file name based on strFile after your code has run
b) scrap the TransferText code, link to the text file and use an append query to insert...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 03:13 AM.

Microsoft Access Help
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