Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: isladogs
Forum: Queries Today, 12:29 AM
Replies: 45
Views: 8,925
Posted By isladogs
Re: IIF returns 0 instead of boolean

Actually Boolean values in Access are 0 and -1.
Forum: General Yesterday, 04:06 PM
Replies: 12
Views: 184
Posted By isladogs
Re: email - DoCmd.SendObject - slow to load

Or you could send email direct from Access using CDO without Outlook being involved at all.
You can try that approach using my CDO Email Tester ...
Forum: Forms Yesterday, 03:40 PM
Replies: 6
Views: 76
Posted By isladogs
Re: Can't find field. Error 2465

How you need to reference a control will depend on where you are calling it from

If its in a subform, you need to reference the name of the subform control.

See...
Forum: The Watercooler Yesterday, 03:34 PM
Replies: 23
Views: 297
Posted By isladogs
Re: we seem to be getting more visitors lately....

Whether its a generation gap or not, I also find your continual use of shorthand both irritating and a distraction to the point you are trying to convey. Whether its 'prolly' or 'cuz' or 'u r' or...
Forum: Forms Yesterday, 02:59 PM
Replies: 6
Views: 76
Posted By isladogs
Re: Can't find field. Error 2465

Debug.Print Me.filespec if on the same form

Or

Debug.Print Forms!frmList.FileSpec if on another form

Or

Debug.Print Me.frmList.Form.FileSpec if on a subform
Forum: SQL Server 12-06-2019, 02:04 PM
Replies: 18
Views: 286
Posted By isladogs
Re: SQL BE with MS Access FE - Speed up searches

Can you remind me how/when Access queries can be run on the server? And how would I know where that had happened??

Where can I find the Recent Expensive Queries list? I'm using SQL Server Express...
Forum: SQL Server 12-06-2019, 12:19 PM
Replies: 18
Views: 286
Posted By isladogs
Re: SQL BE with MS Access FE - Speed up searches

Indexing fields in SQL Server will make the search faster whether the search criteria are managed in SS using a view or done in Access using a query.
I was trying to cover both options.

For info,...
Forum: General 12-06-2019, 10:58 AM
Replies: 17
Views: 171
Posted By isladogs
Re: Fill down and auto tab to next field issues

I've just approved the attachment to post #1
Forum: Modules & VBA 12-06-2019, 10:19 AM
Replies: 34
Views: 508
Posted By isladogs
Re: Export data fields based on checkboxes on Form

As this is a separate question it ought to be in a separate thread.
However, unless I'm missing the point, this is so trivial to do that you will kick yourself!

In your query, just add the fields...
Forum: Forms 12-06-2019, 08:26 AM
Replies: 7
Views: 103
Posted By isladogs
Re: Change BackColour of Form

Its in the Thread Tools dropdown
Forum: Forms 12-06-2019, 07:12 AM
Replies: 7
Views: 103
Posted By isladogs
Re: Change BackColour of Form

Yes you can but the expression is based on the field name not the control name.
Use Expression Is ...[FieldName] = some condition
You can apply the same formatting to multiple controls at the same...
Forum: Modules & VBA 12-06-2019, 07:04 AM
Replies: 11
Views: 179
Posted By isladogs
Re: Dmax error 2465 cannot locate field

DBG
I never use TempVars but looked it up here and it said TempVar![Name] so I copied that!
https://docs.microsoft.com/en-us/office/vba/api/access.tempvars
Forum: Modules & VBA 12-06-2019, 06:10 AM
Replies: 11
Views: 179
Posted By isladogs
Re: Dmax error 2465 cannot locate field

Several errors
1. Number is a reserved word and shouldn't be used as a field name or a control name.
2. VarTemp? I think you mean TempVar!Location
3. Is Workplace a combo or listbox? Column...
Forum: Forms 12-06-2019, 05:59 AM
Replies: 7
Views: 103
Posted By isladogs
Re: Change BackColour of Form

Continuous forms just have one set of controls, repeated for each record. So any standard formatting is for all records (or none). As DBG stated, you need to use conditional formatting via the wizard...
Forum: Modules & VBA 12-06-2019, 05:31 AM
Replies: 34
Views: 508
Posted By isladogs
Re: Export data fields based on checkboxes on Form

1. Try setting a default value for your checkbox =false and set triple state =false
4. In that case, don't keep making a fresh copy of it. Instead empty the table then append new data
5 To start...
Forum: Forms 12-06-2019, 02:45 AM
Replies: 12
Views: 107
Posted By isladogs
Re: Update table code

ZeidHadded
You may have noticed that I added code tags to posts #1 and #3 to make it easier to read.
Please can you do so for any future code using the # button on the edit post toolbar.
Forum: Modules & VBA 12-06-2019, 02:39 AM
Replies: 34
Views: 508
Posted By isladogs
Re: Export data fields based on checkboxes on Form

1. You have an unbound checkbox which can also be null. Thea black shading are null values Try this
If ctl.ControlType = acCheckBox And ctl = True And Nz(ctl.Tag,"") <> "" Then

If that still...
Forum: SQL Server 12-06-2019, 02:24 AM
Replies: 18
Views: 286
Posted By isladogs
Re: SQL BE with MS Access FE - Speed up searches

Following on from Galaxiom's excellent advice, you may find this article on Optimising Queries (http://www.mendipdatasystems.co.uk/speed-comparison-tests-8/4594556613) to be useful

The tests in...
Forum: General 12-05-2019, 02:22 PM
Replies: 5
Views: 91
Posted By isladogs
Re: Changing font color for comments

As you've no doubt discovered you can change the comment colour from the default green to blue (or whatever) but it affects all comments, both new and old.
Forum: Forms 12-05-2019, 02:19 PM
Replies: 4
Views: 92
Posted By isladogs
Re: Using DCount in a IIF statement

Happy to help. Do you now have working code?
Forum: Modules & VBA 12-05-2019, 09:13 AM
Replies: 15
Views: 204
Posted By isladogs
Re: Login and User Access

We'll have to disagree about this.

If the app was 'cast in stone' with no further development planned, that might just possibly have some limited merit.
However, I would still advise against it...
Forum: Queries 12-05-2019, 09:07 AM
Replies: 58
Views: 1,916
Posted By isladogs
Re: Access error -query is corrupt

Is anyone else experiencing the same issue as me.
Having applied the fix to both A2010 and A365 on several workstations, each has had the fix reversed at least once by subsequent updates.

Whilst...
Forum: Introduce Yourself 12-05-2019, 08:59 AM
Replies: 6
Views: 87
Posted By isladogs
Re: Hi from Shropshire in the UK

Hi Greg.
We have many members at different levels of experience, both young and old.
Glad to have you join us....what took you so long?
Forum: Modules & VBA 12-05-2019, 08:55 AM
Replies: 34
Views: 508
Posted By isladogs
Re: Export data fields based on checkboxes on Form

No idea without seeing the latest code. Most of your error handling was disabled anyway apart from the On Error Resume Next line which you shouldn't normally use anyway.

If not already done...
Forum: The Watercooler 12-05-2019, 08:50 AM
Replies: 3
Views: 70
Posted By isladogs
Re: Paid Subscriptions

There are a reasonable number of paid members at each level.
Obviously such payments help offset the costs as do the advertisements that most of us ignore or hate.
If you do become a paid...
Showing results 1 to 25 of 500

 
Forum Jump



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