Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.78 seconds.
Search: Posts Made By: isladogs
Forum: General Today, 07:00 AM
Replies: 0
Views: 40
Posted By isladogs
Office Account security breach fixed

A very simple security breach in Microsoft accounts has now been fixed by Microsoft 'ONLY' 4 months after being reported to them. It could have affected anyone with an MS account including all those...
Forum: General Today, 06:02 AM
Replies: 9
Views: 97
Posted By isladogs
Re: Suddenly non updateable recordset

Not really possible to give you a definitive answer based on the info you supplied.
Suggest you start by looking at this article: Why is my query read only (http://allenbrowne.com/ser-61.html)
Forum: Queries Today, 05:59 AM
Replies: 2
Views: 68
Posted By isladogs
Re: Please help!

For info there is an extended version of my contribution to that thread on my website together with other related articles:
http://www.mendipdatasystems.co.uk/compare-access-file-security/4594444323
Forum: Forms Today, 03:45 AM
Replies: 5
Views: 111
Posted By isladogs
Re: How to get logged in ID on Navigation form

Your code makes little sense and has many errors.
For example, you can't use Column(1) in a DLookup IIRC.
Try this

Me.txtUsernameEmpNav =
Nz(DLookUp("EmpID","tblUserSecurity","LoginID='" &...
Forum: Modules & VBA Yesterday, 05:24 PM
Replies: 3
Views: 1,017
Posted By isladogs
Re: scroll to top of a multi select listbox

Well done DBGuy. It works


Dim lngC As Long
With Me.LstClasses
' For lngC = Abs(.ColumnHeads) To (.ListCount - 1) 'top to bottom
For lngC = (.ListCount - 1) To Abs(.ColumnHeads) Step -1...
Forum: Modules & VBA Yesterday, 03:06 PM
Replies: 10
Views: 155
Posted By isladogs
Re: Looking for List Box VBA help after click update

I'm still unclear what the Column Headings refer to - see post 2

The phrase Column Headings as used in listboxes refers to the top line shown in your listboxes : Table Name select & (confusingly)...
Forum: Forms Yesterday, 01:08 PM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

OK - now i'm also confused

Using Access 2010:
I took the same text from the last post and pasted it directly into your form.
Result - formatting lost:...
Forum: Forms Yesterday, 12:40 PM
Replies: 6
Views: 27,365
Posted By isladogs
Re: VBA Syntax: IF variable is NOT in list

hi Paul
That's interesting.
Before I posted, I had tested with this:

Select Case Me.cboArea

Case "GI", "BD"
MsgBox "This postcode area is not used for geographical...
Forum: Forms Yesterday, 10:30 AM
Replies: 6
Views: 27,365
Posted By isladogs
Re: VBA Syntax: IF variable is NOT in list

Welcome to the forum PleasantB

thanks for spotting that error that nobody else noticed in the past 7 years!
For info, this would also SOMETIMES work....BUT NOT RELIABLY - see posts 6 & 7

...
Forum: Forms Yesterday, 09:41 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

Not sure I can answer that without looking at it.
Perhaps you didn't specify the font size in your highly formatted text
Feel free to upload if you wish.
What you posted in your screenshot didn't...
Forum: Forms Yesterday, 08:46 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

I do understand your frustration.
However, until your last post it sounded like you wanted to paste plain text from a text editor, paste it into Access and then format it in place

Now it is clear...
Forum: Forms Yesterday, 07:31 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

Its the same database.
All I did each time was change the default font in the form control property sheet
Forum: Modules & VBA Yesterday, 07:30 AM
Replies: 10
Views: 155
Posted By isladogs
Re: Looking for List Box VBA help after click update

Just to repeat my previous comments



Include the table name field but untick it in the Show checkbox (or set its width to zero in the listbox property sheet)
Move your filter criteria to the...
Forum: Forms Yesterday, 07:02 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

No I think you are correct.
But my point is that it will happen automatically.
Just pasted Calbri 48pt text from Notepad into my form.
When pasted it becomes the default font (currently Arial...
Forum: Modules & VBA Yesterday, 06:55 AM
Replies: 10
Views: 155
Posted By isladogs
Re: Looking for List Box VBA help after click update

By column headers, do you mean field names?
Why do you have two copies of your table in the query in the third screenshot?
Furthermore, as they aren't joined, you will get each repeated many times....
Forum: Forms Yesterday, 06:32 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

Sorry but me neither....
It should change to your default font as soon as you paste it into the form control.
No need to lose focus or close the form.

If still stuck, post a stripped down copy...
Forum: Forms Yesterday, 06:04 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

In my example, the memo field is set as rich text in the table.
That is why you won't see the code used in the table itself.
That code is used 'behind the scenes' to format the text.

I'm not...
Forum: Queries Yesterday, 04:47 AM
Replies: 8
Views: 169
Posted By isladogs
Re: Count within 24h but not one day

No problem! Its an automatic 'feature' in the forum software related to blocking possible spam. Sometimes it gives false positives

The issue seems to go away once you've reached 10 posts or so
Forum: Queries Yesterday, 04:36 AM
Replies: 8
Views: 169
Posted By isladogs
Re: Count within 24h but not one day

Posting to trigger email notifications

For info, your last two (duplicate) posts were moderated.
This sometimes happens for new users.
I've approved one & deleted the other.

If further posts...
Forum: Forms Yesterday, 04:30 AM
Replies: 5
Views: 110
Posted By isladogs
Re: How to avoid duplication

To solve this, you need to have either a unique index or PK field so you can use an unmatched append query.
For example:
INSERT INTO TotalSales ( SaleDate, TotalAmount )
SELECT DISTINCT...
Forum: Forms Yesterday, 04:02 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

I've just altered the control default to Arial 7 pt and pasted your last reply into the control. As you can see it works perfectly
...
Forum: Forms Yesterday, 03:17 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

I would set the default for the form control using the property sheet.
No VBA needed
That will then apply unless you modify the font name/colour/size etc
You do so by editing the rich text...
Forum: Forms Yesterday, 03:09 AM
Replies: 4
Views: 104
Posted By isladogs
Re: Cascading combo box works (sometimes)

For a standard form/subform, the control reference syntax is fairly straightforward.
See e.g. http://allenbrowne.com/casu-04.html

However referring to controls in navigation forms can be rather...
Forum: Forms Yesterday, 02:37 AM
Replies: 23
Views: 246
Posted By isladogs
Re: Changing the font

For rich text, the font size & appearance is controlled in the rich text itself.
That is so where you want something other than the default size
See the attached for how examples on how to manage...
Forum: Forms 12-11-2018, 04:06 PM
Replies: 4
Views: 209
Posted By isladogs
Re: Text Box - Control Source

Welcome Jimmy

Agree with June's comment re Date rather than Now

Suggest you use a label lblTraining (only one label needed) & set its caption with code similar to this in e.g. Form_Current...
Showing results 1 to 25 of 500

 
Forum Jump



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