Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: jdraw
Forum: Introduce Yourself 12-12-2019, 04:18 AM
Replies: 13
Views: 170
Posted By jdraw
Re: Hello from Fallon, Nevada, USA

Welcome to AWF Tanya.
Forum: Tables 12-08-2019, 06:05 AM
Replies: 14
Views: 255
Posted By jdraw
Re: Problem in conversation of date


I recommend you keep 1 fact in 1 field in data storage (tables). If you need to display some combination of fields, then concatenate and do so, but do not concatenate separate fields and...
Forum: Introduce Yourself 11-27-2019, 12:18 PM
Replies: 4
Views: 99
Posted By jdraw
Re: Hi from new member

Hi Gray. Welcome. Nice to welcome another Canadian on board.
Forum: Queries 11-24-2019, 07:33 AM
Replies: 28
Views: 463
Posted By jdraw
Re: Range of ASCII values in criteria


Here's a function that should be helpful.
It checks each character in the incoming string and returns True if it has only
Valid characters are (1) space, (2) hyphen, (3) apostrophe,...
Forum: Modules & VBA 11-23-2019, 03:18 PM
Replies: 17
Views: 268
Posted By jdraw
Re: Help backing up a database that is stored on a USB drive

Is the intent to backup to the same USB where the database is located?
If you lose the USB, or it fails, you've lost the whole 'kit and caboodle"!!!

An "offsite"(another USB or other...
Forum: General 11-18-2019, 04:46 PM
Replies: 13
Views: 319
Posted By jdraw
Re: Adding a 'dummy' field to an historic database and updating it

Here is a link to a generic database structure relate to Legal Case management (http://www.databaseanswers.org/data_models/case_management/index.htm). You may be able to adapt to your needs.
Forum: Modules & VBA 11-16-2019, 06:26 AM
Replies: 23
Views: 324
Posted By jdraw
Re: Module needed for "random 6 string" search

Here's a sample function from a couple of years back with an example of alpha then
5 numerics
' Procedure...
Forum: Modules & VBA 11-15-2019, 05:20 AM
Replies: 15
Views: 285
Posted By jdraw
Re: Hangman Style Search


Here is another hangman game for Access from the forum (https://access-programmers.co.uk/forums/showpost.php?p=588851&postcount=6). It's from an older post, but may contain some code or...
Forum: The Watercooler 11-14-2019, 01:22 PM
Replies: 34
Views: 547
Posted By jdraw
Re: what does your username mean?

Mine is a little less obvious, but same genre as Steve R., James Bailey, James Harris....
Forum: Modules & VBA 11-11-2019, 05:16 AM
Replies: 4
Views: 206
Posted By jdraw
Re: Database cannot open, because VBA-project cannot be read....

Have you reviewed the Similar Threads at the bottom of the page? Can you tell us more about the database, split status etc as has been requested.
Several tips from FMS here...
Forum: Modules & VBA 11-09-2019, 04:25 AM
Replies: 15
Views: 241
Posted By jdraw
Re: only numbers function

You could check the textbox with IsNumeric() and take a selected path based on the result of the check. Perhaps the textbox has no value?? You could check that as well.
God luck.
Forum: Introduce Yourself 11-07-2019, 08:55 AM
Replies: 2
Views: 77
Posted By jdraw
Re: Hello!

Belated welcome to the forum. Glad you posted.
Forum: Theory and practice of database design 11-07-2019, 08:08 AM
Replies: 58
Views: 19,784
Posted By jdraw
Re: Access OOP examples wanted

CJ, perhaps you could post your class with a sample.

Here are a couple of youtube videos by Paul Kelly re Class Modules. He uses Excel (that's the basis of his business) but the concepts and...
Forum: The Watercooler 11-07-2019, 06:15 AM
Replies: 15
Views: 433
Posted By jdraw
Re: Microsoft Access is Dead!


Tony seems to be offline.
I think this is the link/thread (https://access-programmers.co.uk/forums/showthread.php?t=307786) he was referencing.
Forum: Introduce Yourself 11-07-2019, 05:15 AM
Replies: 3
Views: 104
Posted By jdraw
Re: Hi All...

Welcome to AWF, Ernie.
Forum: General 11-02-2019, 09:49 AM
Replies: 2
Views: 134
Posted By jdraw
Re: 1001 * dbg

Congrats DBG!!
Forum: Forms 11-01-2019, 04:48 PM
Replies: 12
Views: 312
Posted By jdraw
Re: Using a single table for multiple comboboxes

I opt for 1 table per Subject, not 1 table encompassing several disjoint topics.
You'll find lots of info on Lookup tables by Joe Celko --here's one...
Forum: General 10-31-2019, 05:10 AM
Replies: 11
Views: 485
Posted By jdraw
Re: Access: The DB that will not die

I agree that the intended move to include web applications in MS Access was to expand the user base as Colin noted. Too often it seemed that Access had been forgotten when newer versions of Office...
Forum: Modules & VBA 10-23-2019, 04:44 AM
Replies: 6
Views: 166
Posted By jdraw
Re: Xth Occurrence of a string within another

No intrinsic function, but a user defined function is possible as you indicated.
How about showing the readers your function, just in case someone else needs same?

After a little searching:
Forum: Tables 10-18-2019, 01:28 PM
Replies: 3
Views: 222
Posted By jdraw
Re: Referencing a lookup field in a separate table in Lookup field

Avoid Lookup fields in Tables (http://www.theaccessweb.com/lookupfields.htm). Use a lookup table.
Forum: Introduce Yourself 10-17-2019, 02:53 PM
Replies: 5
Views: 137
Posted By jdraw
Re: Thank you in Advance :-)

Welcome aboard LewisJ!
Forum: General 10-17-2019, 05:21 AM
Replies: 5
Views: 167
Posted By jdraw
Re: Composite Key relationship


Please provide a little more description to help readers understand your post/requirement.
In most scenarios you have a business issue/problem/opportunity that you can describe in ...
Forum: Introduce Yourself 10-09-2019, 03:53 AM
Replies: 3
Views: 117
Posted By jdraw
Re: Greetings from Zambia

Welcome aboard Andy.
Forum: Queries 10-03-2019, 06:21 AM
Replies: 9
Views: 770
Posted By jdraw
Re: Sequentially numbering records in a query

Check the responses in the Similar Threads at the bottom of the page.
Forum: Introduce Yourself 10-02-2019, 03:06 AM
Replies: 6
Views: 157
Posted By jdraw
Re: Hi People

Hi and welcome to AWF.
I also like the Hernandez book.
Here is a link to a list of database related articles in various format...
Showing results 1 to 25 of 500

Forum Jump

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