Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.35 seconds.
Search: Posts Made By: isladogs
Forum: Site Suggestions 01-16-2020, 12:33 PM
Replies: 43
Views: 958
Posted By isladogs
Re: Service Unavailable

Just a thought?
Is it possible for you to show an announcement on the main screen to advise members what is going on?
Forum: Tables 01-16-2020, 12:12 PM
Replies: 12
Views: 252
Posted By isladogs
Re: Foreign key and null value

On behalf of all of us, you're welcome.
Remember you may have 3 John Smiths all from London but as each will have a unique EmployeeID, Access cannot confuse them
Forum: Forms 01-16-2020, 12:05 PM
Replies: 5
Views: 124
Posted By isladogs
Re: command button with picture

Why use 2 buttons?
The same button can fulfil more than one purpose depending on the circumstances

So you could use one button cmdBirthday and:
1. Set its backcolor, button caption & image in...
Forum: Tables 01-16-2020, 12:00 PM
Replies: 12
Views: 252
Posted By isladogs
Re: Foreign key and null value

Beaten to it again this time by plog ...

I've never seen it done for names.
I think you are trying to 'over normalise'
There could be thousands of each types of name.
To populate each of the...
Forum: Tables 01-16-2020, 11:40 AM
Replies: 12
Views: 252
Posted By isladogs
Re: Foreign key and null value

Just use one Employee table for the above data with these fields:

EmployeeID PK
FirstName
MiddleName
LastName
PreferredName

You already have a PK field which ensures each record is unique....
Forum: General 01-15-2020, 11:45 PM
Replies: 2
Views: 92
Posted By isladogs
Re: Replication

No. It was scrapped with A2007 when the ACCDB format was released.
If needed, you will have to write your own code to manage that functionality.
Forum: Modules & VBA 01-15-2020, 12:32 PM
Replies: 15
Views: 382
Posted By isladogs
Re: 32-bit won't run on 64-bit installation

I'm not sure which modules Arnel helped you with, but using #If Win64 isn't needed which you have in basBrowse & Module1.
Module FTP_Functions still needs conversion

Rather than react to each...
Forum: The Watercooler 01-13-2020, 03:47 PM
Replies: 8
Views: 394
Posted By isladogs
Re: An open letter to Adam/vba_php

For info, following me reporting the thread linked in post #1, the admins at the MS Forum have now edited the thread, removing the three worst posts and editing others.
I think we should all be...
Forum: Modules & VBA 01-13-2020, 07:51 AM
Replies: 17
Views: 268
Posted By isladogs
Re: Referencing a subform control with VBA

The code in post #7 is wrong for the reason you stated



Your version above is correct PROVIDING the subform container on the main form is called [ARO_Adj_Details Subform]. The fact that it...
Forum: Reports 01-12-2020, 12:42 PM
Replies: 9
Views: 262
Posted By isladogs
Re: Print report in an Excel Format

Display the data in datasheet format which looks similar to an Excel worksheet.
Forum: General 01-12-2020, 12:04 PM
Replies: 14
Views: 310
Posted By isladogs
Re: Possible to clear clip board by VBA in Access 2007?

Punice
I hadn't previously checked the SO link in June's post and therefore wasn't aware that the code is almost identical..

The extra API line CountClipboardFormats in my code sample is used in...
Forum: Forms 01-12-2020, 06:33 AM
Replies: 19
Views: 407
Posted By isladogs
Re: Combobox Search

Alternatively, if the list of SKU items is very long, you may wish to consider further cascading combos. For example, see this Postcode Builder...
Forum: Forms 01-11-2020, 12:23 PM
Replies: 12
Views: 237
Posted By isladogs
Re: How would I open different forms based on a combobox selection

In that case use
Select Case Me.ComboName.Column(2)
Case 1

Case 2
...
End Select
Forum: General 01-11-2020, 12:11 PM
Replies: 14
Views: 310
Posted By isladogs
Re: Possible to clear clip board by VBA in Access 2007?

Although its unusual to do this, I do have code in my Sql to vba and back again (http://www.mendipdatasystems.co.uk/sql-to-vba-back-again/4594398120) utility to clear the clipboard

Add the...
Forum: Forms 01-11-2020, 08:57 AM
Replies: 4
IIf
Views: 124
Posted By isladogs
Re: IIf

You're welcome. An 'inspired' guess on my part.
Forum: Reports 01-11-2020, 06:42 AM
Replies: 32
Views: 515
Posted By isladogs
Re: Create crosstab report from Crosstab query

Hi Stephen
Just to confirm that is exactly what my dynamic crosstab reports do

For example in the extended properties report example database, the report has
a) 36 labels lbl1, lbl2...lbl36 in...
Forum: Reports 01-10-2020, 12:27 AM
Replies: 9
Views: 131
Posted By isladogs
Re: Access Report issue

Access stores dates as double number datatype no matter whether they are displayed as dd/mm/yyyy, mm/dd/yyyy or any other international format.

You shouldn't change your date settings to the US...
Forum: Reports 01-09-2020, 02:21 PM
Replies: 32
Views: 515
Posted By isladogs
Re: Create crosstab report from Crosstab query

I can't see it! When you reply please tell us what to look at in your dB and what you want as your report output.

EDIT I now see its been added to post #13
Forum: Forms 01-09-2020, 07:17 AM
Replies: 9
Views: 155
Posted By isladogs
Re: GetOpenFileName(OpenFile) not working

Well spotted. I had merged two different code snippets and left the duplicate line in error. I've now corrected that code. Thanks
You were right to remove the first one.
Forum: Forms 01-08-2020, 01:06 PM
Replies: 9
Views: 155
Posted By isladogs
Re: GetOpenFileName(OpenFile) not working

Pardon me for jumping in

I think the issue is with 64-bit Access rather than 64-bit Windows
I stopped using GetOpenFileName & GetSaveFileName almost 5 years ago as despite converting the APIs, I...
Forum: Modules & VBA 01-08-2020, 10:33 AM
Replies: 72
Views: 896
Posted By isladogs
Re: editable query without primary key

Eshai
I do understand why several people got frustrated by your responses in this thread.
They were trying very hard to help you but your answers were not making it easy for them to do so.
...
Forum: Modules & VBA 01-07-2020, 01:26 PM
Replies: 17
Views: 215
Posted By isladogs
Re: Changing color for multiple characters in a report

The SQL Search feature is quite complex and embedded in one of my commercial apps so I can't provide a demo here. I'll try to explain the salient features as best I can without a demo.

The most...
Forum: Forms 01-06-2020, 11:28 AM
Replies: 13
Views: 227
Posted By isladogs
Re: Limit slidebar to details?

Not true. When the form is scrolled the header and footer stay visible at all times which is what I want to happen. The detail 'appears to scroll under the header and footer though that is of course...
Forum: Modules & VBA 01-06-2020, 06:29 AM
Replies: 27
Views: 676
Posted By isladogs
Re: User intervention, abort .copyfile() with a button

You can pause or cancel the file copy process if you use a Windows API rather than file scripting object.
I employ this method in my FE updaters because it is far faster and so that the copy can be...
Forum: Modules & VBA 01-06-2020, 03:47 AM
Replies: 9
Views: 215
Posted By isladogs
Re: Power Query Automation from Access

Hi Minty
See my thread in the repository: Normalise Spreadsheet Data Easily For Access Using Excel Power Query (https://www.access-programmers.co.uk/forums/showthread.php?t=306580)
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:07 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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World