Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 70
Search took 0.06 seconds.
Search: Posts Made By: Frothingslosh
Forum: Code Repository 09-08-2018, 08:42 PM
Replies: 0
Views: 249
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: 758
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,323
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: 159
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: 575
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,161
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: 0
Views: 1,849
Posted By ridders
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,373
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,121
Posted By ridders
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,011
Posted By ridders
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: 597
Posted By ridders
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: 597
Posted By ridders
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: 597
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: 363
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: 8,924
Posted By ridders
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,007
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: 548
Posted By ridders
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,055
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"...
Forum: Modules & VBA 06-30-2017, 01:38 PM
Replies: 19
Views: 1,055
Posted By The_Doc_Man
Re: TransferText Error

Steve's observation and your earlier comment that it works OK manually lead to the question: Does the target table already exist AND if you try to import to a different name (so that it has to use...
Forum: Modules & VBA 06-30-2017, 01:31 PM
Replies: 19
Views: 1,055
Posted By sneuberg
Re: TransferText Error

While I haven't been able to figure out the cause of the error I suspect that the specification is the culprit as I've been able to create one that works in the the attached database. The one I made...
Forum: Sample Databases 04-19-2017, 01:42 AM
Replies: 1
Views: 3,912
Posted By ridders
Use screen dimmer effect to get users attention

A simple way of getting users attention is to 'dim' the rest of the screen when an important popup form is displayed.
When the form is closed the screen returns to normal.

For an example, see...
Forum: Modules & VBA 04-05-2017, 07:48 PM
Replies: 22
Views: 1,247
Posted By Cronk
Re: Class Object use and workflow

FWIW, I have for some time now, wrapping all my major entity tables into a class. Rather than using DLookups all the time, once the record is in a class variable, a simple objPerson.surname returns...
Forum: Access World News 01-13-2017, 06:10 AM
Replies: 73
Views: 10,773
Posted By Jon
Re: Site changed to secure

Welcome to the new secure site!

You will now notice a green padlock at the top left of the browser in your address bar and on Chrome it will also show the words Secure. It took a while but I got...
Forum: Queries 01-06-2017, 10:03 AM
Replies: 4
Views: 801
Posted By MarkK
You can also join tables on an expression other...

You can also join tables on an expression other than equality, so you can do...
SELECT table1.*, table2.*
FROM table1 INNER JOIN table2 ON table1.Field1 LIKE '*' & table2.Field2 & '*'
Forum: Theory and practice of database design 01-04-2017, 08:15 AM
Replies: 14
Views: 2,908
Posted By The_Doc_Man
How do I know if I have bad performance?

CJ London's posts inspired me. Those of you who know me know this could be a good thing or a bad thing. I'll try to keep it straight-forward.

To understand and properly analyze whether you are...
Showing results 1 to 25 of 70

Forum Jump

All times are GMT -8. The time now is 03:57 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World