Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 100
Search took 0.06 seconds.
Search: Posts Made By: jdraw
Forum: Site Suggestions Yesterday, 11:07 AM
Replies: 56
Views: 1,173
Posted By Jon
Re: Service Unavailable

We supposedly have nearly 1000 guests on the forum right now, which I recon must be bots, because Sunday's are normally quiet. But in any case, whatever they are, the forums are barely breaking a...
Forum: The Watercooler 01-13-2020, 03:47 PM
Replies: 8
Views: 412
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: General 01-10-2020, 10:06 AM
Replies: 9
Views: 276
Posted By Moore71
Re: How to speed-up Access DataBase on a Split table

These are what I did to have my Access Application speedup:
I opened the backend while the frontend were all closed,
I Repair and Compile the Backend as manually,
I re-indexed most fields...
Forum: Tables 01-01-2020, 10:10 AM
Replies: 26
Views: 447
Posted By MajP
Re: How best to do an array in Access 2013

Sorry, but you are completely wasting you time trying to make a Rude Golberg solution to a non problem. I can guarantee I can build a properly designed database that will blow away any bizarre...
Forum: General 12-19-2019, 03:22 PM
Replies: 15
Views: 382
Posted By isladogs
Chip Pearson's website

As many of you will know Chip died in April 2018.
He ran an excellent website for Excel and VBA at http://www.cpearson.com/

Unfortunately, the site has recently gone down though archived pages...
Forum: General 12-11-2019, 01:46 PM
Replies: 38
Views: 840
Posted By isladogs
More Useful links added

I've just added the three MS sites mentioned by Jeff Conrad together with several other new links including :
a) the excellent site by Christos Samaras https://myengineeringworld.net/ which some of...
Forum: Queries 11-27-2019, 06:59 AM
Replies: 28
Views: 496
Posted By isladogs
Re: Range of ASCII values in criteria

Hi Jack
Thanks to both you and Greg for both the code and dataset.
That was very helpful as I'm very much a novice with Regex.

I've made a few minor changes to your test app.
These were mainly...
Forum: Modules & VBA 11-22-2019, 07:25 AM
Replies: 26
Views: 505
Posted By The_Doc_Man
Re: Exceeding Limits via Code?

Again, not a matter of logic. Whenever I hear the limit is X and that number is neither an integer multiple of 100 nor a power of 2, I think of it as deriving from a capacity issue.

For instance,...
Forum: Modules & VBA 11-19-2019, 04:20 PM
Replies: 4
Views: 206
Posted By MajP
Interfaces in Vba

So recently there was a discussion on the value of Object Oriented Programming, and I will contend that since this is an Access forum that, that question makes no sense. Everything you do in VBA is...
Forum: The Watercooler 11-18-2019, 03:49 PM
Replies: 65
Views: 1,519
Posted By MajP
Re: Is OOP actually useful?

So I played with this and It is not a game changer, and not huge. I think for those of us who understand the limitations of VBA it was a potential hopeful extension to those limitations. My...
Forum: The Watercooler 11-14-2019, 10:36 PM
Replies: 65
Views: 1,519
Posted By The_Doc_Man
Re: Is OOP actually useful?

Adam, since you are familiar with Alan Turing and The Imitation Game, you would perhaps recognize this paraphrase from when A.T. is being interviewed by the police, having been picked up on suspicion...
Forum: Code Repository 11-14-2019, 02:18 PM
Replies: 3
Views: 481
Posted By isladogs
Re: View & Edit IMEX Data Task Specifications

I've updated the application as follows:
a) added code to allow data tasks to be deleted
b) changed the app so all functions can now be run using a form
c) added a report to view details of all...
Forum: General 11-12-2019, 10:13 AM
Replies: 26
Views: 333
Posted By isladogs
Re: Import/Export Data Tasks

For info I've just uploaded a new thread to the repository with code to view & edit the XML in the import/export data tasks: ...
Forum: Forms 11-10-2019, 06:48 PM
Replies: 31
Views: 688
Posted By apr pillai
Re: Copy previous record fields into new record form fields

If you don't mind spending some time to copy paste some Code, try this link for duplicating fields from previous record: https://www.msaccesstips.com/2012/02/duplicating-fields-with-conditional.html...
Forum: Forms 11-04-2019, 03:19 PM
Replies: 12
Views: 367
Posted By Pat Hartman
Re: Using a single table for multiple comboboxes

While I do use single tables for some things, for ANY lookup table that has no ancillary data or relationships, I use my lookup table manager (which I am including). I want to tell you that this is...
Forum: General 10-31-2019, 12:44 AM
Replies: 11
Views: 563
Posted By NauticalGent
Access: The DB that will not die

My wife, of all people, sent me this article. Have a read, it is good stuff and absolutely nails it...
Forum: Forms 10-27-2019, 10:53 PM
Replies: 83
Views: 1,892
Posted By isladogs
Re: MS Access: custom control built in another language

I see this has moved on overnight.
The error is consistent for me. Tested on two different PCs. Happens every time.
As Tera showed, error in AddItem procedure. Don't know if that's your code or...
Forum: Modules & VBA 10-23-2019, 08:37 AM
Replies: 6
Views: 179
Posted By Tera
Re: Xth Occurrence of a string within another

I'm home and away from my desk. But my function was something like this:

Function nthPos(str As String, SearchForThis As String, Nth As Integer) As Integer

' Returns 0 if not found
Forum: Forms 10-21-2019, 07:11 AM
Replies: 83
Views: 1,892
Posted By MajP
Re: MS Access: custom control built in another language

If anyone interested here is an updated class with a few more features.
1. Optional dragdrop
2. optional double click drop
3. Return a sorted column
4. return current value from specified column...
Forum: Forms 09-25-2019, 07:16 AM
Replies: 4
Views: 129
Posted By Pat Hartman
Re: Creating Multiple Items in One Form

There are three types of form view.
Single - shows only one record at a time
Continuous - shows multiple records - as many as will fit on the screen. You scroll to see more.
DataSheet - similar...
Forum: Code Repository 09-16-2019, 01:51 AM
Replies: 7
Views: 811
Posted By moke123
Re: Randomizing Data for Posted db's

I was away for a few days but this thread was on my mind. I was thinking that it might be difficult for some posters to execute code from a module.
I threw together a form that could be imported...
Forum: The Watercooler 09-13-2019, 01:21 AM
Replies: 3,003
Views: 582,023
Posted By hammerite
Re: What's your best/worst joke?

Physicians were unable to reach a consensus: Should Brexit take place?

The Allergists were in favour of scratching it, but the Dermatologists advised not to make any rash moves.

Forum: Code Repository 09-07-2019, 05:37 PM
Replies: 7
Views: 811
Posted By Micron
Randomizing Data for Posted db's

We often ask Original Poster to upload a copy of their db but the issue might be that it contains sensitive data. Complete data removal may not allow us to troubleshoot the OP's issue because...
Forum: General 08-16-2019, 04:09 AM
Replies: 2
Views: 125
Posted By isladogs
DBG's Post Count

Just a quick post to observe that, to my surprise, I've just 'snuck past' the DBGuy's top listing of post counts for the last 7 days.
It won't last and indeed will probably not be true by the time...
Forum: Sample Databases 08-09-2019, 04:28 AM
Replies: 4
Views: 5,150
Posted By isladogs
Re: CDO EMail Tester

Something Iíve been meaning to do for a long time
Iíve just updated my CDO Email Tester to include HTML Email as well as plain text.

Unzip the attached file & keep all files in the same folder...
Showing results 1 to 25 of 100

Forum Jump

All times are GMT -8. The time now is 10:17 AM.

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 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World