Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 77
Search took 0.19 seconds.
Search: Posts Made By: Frothingslosh
Forum: General 01-03-2019, 01:27 PM
Replies: 18
Views: 626
Posted By The_Doc_Man
Re: Combo Box Length Limit?

Did a follow-up search, found this article:


It is from 2007, so this is not a new issue. Maybe it will...
Forum: General 01-03-2019, 12:03 PM
Replies: 18
Views: 626
Posted By theDBguy
Re: Combo Box Length Limit?

Hi. My humble opinion is you might consider using another method besides a combobox. For example, maybe you can use a continuous form. You might be able to construct it to mimic a combobox.
Forum: General 12-13-2018, 07:00 AM
Replies: 0
Views: 135
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: Modules & VBA 10-23-2018, 02:16 PM
Replies: 3
Views: 263
Posted By CJ_London
Re: Fixing #DELETED# After Data Change

I have seen this behaviour before (quite some time ago) and if I remember correctly, there was an error in the data. It wasn't apparent unless you happened to come across the incorrect data whilst...
Forum: Modules & VBA 10-10-2018, 04:06 PM
Replies: 17
Views: 500
Posted By JHB
Re: Error 'Constant Expression Required' For Constant

I know you've solved it in a way, so ...
What happen if you create a new database and put the code you provide here (+ what is missing) and then change the parameters, do you get a compiler error...
Forum: Modules & VBA 10-10-2018, 01:33 PM
Replies: 17
Views: 500
Posted By The_Doc_Man
Re: Error 'Constant Expression Required' For Constant

OK, looking at the syntax and context, you were declaring a private constant and allowing VBA to decide the type for you. In the past, I've had issues by declaring constants after declaring anything...
Forum: Modules & VBA 10-10-2018, 10:52 AM
Replies: 17
Views: 500
Posted By Cronk
Re: Error 'Constant Expression Required' For Constant

Bit of corruption somewhere? Tried importing everything into a blank accdb?

Post your code. I'm sure any number of us would try to emulate your problem.
Forum: Code Repository 09-08-2018, 08:42 PM
Replies: 0
Views: 794
Posted By NauticalGent
Changing Saved Import XML

The need for Access and Outlook to talk to each other is inevitable. There are plenty examples on the web if all you are doing is working with your own e-mail account, but when you need to work with...
Forum: Modules & VBA 08-25-2018, 06:11 PM
Replies: 41
Views: 1,029
Posted By The_Doc_Man
Re: dbEngine(0)(0) vs Currentdb

I will step in for one related but slightly tangential comment.

The difference between DbEngine.Idle dbRefreshCache and DoEvents is that the former is a DBEngine-only event, whereas DoEvents...
Forum: Gaming 06-25-2018, 02:44 PM
Replies: 30
Views: 6,732
Posted By Vassago
Re: Elder Scrolls Online

By copying the address of the uploaded attachment? (Serious question. I've never tried, but I just linked to your profile pic.)

EDIT: Yep, that's how it's done. They copy/paste the address of...
Forum: Modules & VBA 06-06-2018, 11:58 AM
Replies: 4
Views: 173
Posted By JHB
Re: VBA to Close Excel Not Closing Excel

I would also comment that out:
On Error GoTo ErrHandlerWhat happen if you only have xlApp.Quit in ProcExit:.
Forum: Queries 04-22-2018, 05:45 AM
Replies: 10
Views: 610
Posted By plog
Re: Show the first record

Seriously, this needs to stop.

It's as if you slightly glance at the original posters post, totally miss other's valid responses and immediately fire up a module to solve everything via code.
Forum: General 04-07-2018, 09:09 PM
Replies: 13
Views: 1,216
Posted By NauticalGent
Evolution an the Access User

As is normal to human behavior, I tend to classify people by their attributes and pidgin-hole them (it has gotten me into some minor trouble in the past) accordingly.

Since joining this forum...
Forum: Sample Databases 01-30-2018, 04:53 AM
Replies: 3
Views: 2,997
Posted By isladogs
A better date picker

Some months ago I uploaded a replacement date picker (see DatePicker.accdb attached) that has no Active X controls and can also be used in 64-bit Access.

It was originally posted in response to a...
Forum: The Watercooler 01-27-2018, 03:09 AM
Replies: 102
Views: 3,429
Posted By Galaxiom
Re: Deep South Deep Freeze

George Carlin was a smug idiot as is often the case with so called comedians.

Basically what he is saying is that it doesn't matter what a couple of generations of humans do to make the planet...
Forum: Code Repository 01-20-2018, 06:36 AM
Replies: 2
Views: 2,289
Posted By isladogs
TIP: Add colour to queries, listboxes & comboboxes

This is similar to the ideas in a thread I posted recently at: https://www.access-programmers.co.uk/forums/showthread.php?t=297618

The idea in this post was explained by an Access newbie...
Forum: Queries 12-29-2017, 03:31 PM
Replies: 13
Views: 1,043
Posted By isladogs
Colourful query

Just picked up this idea from another forum.
Apologies if this hint has been posted previously by others

Not sure how much use it is but I'll leave others to decide for themselves!
You can...
Forum: Modules & VBA 11-30-2017, 09:06 AM
Replies: 6
Views: 728
Posted By isladogs
Re: Need a Couple idMso Names

My suggestion if you want to build a ribbon only occasionally is to download a copy of a ribbon creator such as IMDB Ribbon Creator http://www.accessribbon.de/en/

A cut down version is available...
Forum: Modules & VBA 11-30-2017, 08:47 AM
Replies: 6
Views: 728
Posted By isladogs
Re: Need a Couple idMso Names

Or direct from MS:

That link is for 2016 but there are similar web pages for 2007/2010/2013.
Just do a search for Office System...
Forum: Modules & VBA 11-30-2017, 07:54 AM
Replies: 6
Views: 728
Posted By moke123
Re: Need a Couple idMso Names

check down around the middle of this page - http://codekabinett.com/page.php?Theme=10&Lang=2
theres a download for MS office object library which references the ribbon objects.
Forum: Modules & VBA 11-16-2017, 07:52 AM
Replies: 5
[SOLVED] Undo Doesn't
Views: 381
Posted By Minty
Re: Undo Doesn't

Oops - I did miss that. I blame US time lag. (In the USA working so my body clock and brain are not in sync. At all!)

Wait a moment. It's an unbound check box. Doesn't that mean the before update...
Forum: Modules & VBA 08-31-2017, 04:46 PM
Replies: 64
Views: 10,591
Posted By isladogs
Re: Using/parsing JSON with vba

I've just returned to this after a couple of weeks doing other things.

The prompt was this thread at Utter Access:...
Forum: General 08-31-2017, 06:53 AM
Replies: 10
Views: 1,018
Posted By Lightwave
Re: Can I find anyone here to help me?

I can answer this question

Forum: General 07-18-2017, 05:30 AM
Replies: 2
Views: 564
Posted By isladogs
Allen Browne's website


Allen Browne is in the process of moving his website to a new server

As a result his normal address http://allenbrowne.com is currently unavailable

Until this is restored, the content is...
Forum: Modules & VBA 07-02-2017, 12:43 AM
Replies: 19
Views: 1,210
Posted By JHB
Re: TransferText Error

The problem is one of the field in the specification is missing the "Data Type".
For getting access to an already created specification you've to create a new specification and click the "Advance"...
Showing results 1 to 25 of 77

Forum Jump

All times are GMT -8. The time now is 04:19 PM.

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