Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.09 seconds.
Search: Posts Made By: jdraw
Forum: Gadgets Yesterday, 05:27 AM
Replies: 10
Views: 211
Posted By jdraw
Re: I need a new PC! --- is it a Gadget?

I would opt for ssd as CJ mentioned. And USB 3.0.

Also please describe "glitches!". Most of my "glitches" relate to my inability to type (fat finger syndrome).
Forum: General Yesterday, 05:23 AM
Replies: 2
Views: 105
Posted By jdraw
Re: Match 2 tables and find related record on input

I agree with plog and would also ask you to give a brief description of the processes/activities involved.

Scan --as with a scanner or...?
Location --as in City or warehouse, shelf and bin??...
Forum: Tables 10-11-2018, 03:58 PM
Replies: 4
Views: 115
Posted By jdraw
Re: Input from memo field on form appears as characters in table

Have you tried Compact and Repair as I found at
https://access-programmers.co.uk/forums/showthread.php?t=247087
Forum: General 10-07-2018, 04:14 AM
Replies: 27
Views: 551
Posted By jdraw
Re: Microsoft Windows / Office upgrade woes

I'm having internet issues (3 days now). Technician to arrive soon this AM. I have a notice from M$oft that I require a system restart and it will install 1809. Don't want to do that because my...
Forum: Modules & VBA 10-06-2018, 09:03 AM
Replies: 90
Views: 33,674
Posted By jdraw
Re: calculate the driving distance between 2 zip codes

Thanks for the update. Glad it is working as expected.
Forum: Modules & VBA 10-04-2018, 03:14 AM
Replies: 90
Views: 33,674
Posted By jdraw
Re: calculate the driving distance between 2 zip codes

shadow9449, Colin

Thanks Colin for responding and clarifying.

I didn't want to get a key and account and insert same in the sample routines because I have no idea who or how often people would...
Forum: Modules & VBA 10-03-2018, 02:35 PM
Replies: 90
Views: 33,674
Posted By jdraw
Re: calculate the driving distance between 2 zip codes

I have done some additional testing and looked at the response from the call to the Distance API.
<DistanceMatrixResponse>
<status>OVER_QUERY_LIMIT</status>
<error_message>
Keyless access to...
Forum: Modules & VBA 10-03-2018, 02:07 PM
Replies: 90
Views: 33,674
Posted By jdraw
Re: calculate the driving distance between 2 zip codes

shadow9449,
I'm not sure what is happening. I downloaded the database from post #65 and ran it several times with the parameters you used. It gave me error 601. This is an error I concocted and...
Forum: Modules & VBA 10-03-2018, 05:55 AM
Replies: 90
Views: 33,674
Posted By jdraw
Re: calculate the driving distance between 2 zip codes

@shadow9449
It worked for me @30-Aug-2018.
It is possible that Google may change some parameters/code, but I posted an example with lat/lon in recent post.

What is the issue you are...
Forum: Tables 10-03-2018, 04:16 AM
Replies: 5
Views: 138
Posted By jdraw
Re: Help needed for better table structure

clatham,

It is always a good idea to start with a clear description of the "business" involved in simple, plain English. I recommend you provide such a description to clarify the processes and...
Forum: Queries 10-02-2018, 11:33 AM
Replies: 5
Views: 116
Posted By jdraw
Re: get a list of record based only the specific values from table

@akika,

Why do you consider these tables to be independent?
Forum: Introduce Yourself 10-02-2018, 08:32 AM
Replies: 1
Views: 51
Posted By jdraw
Forum: Introduce Yourself 10-02-2018, 08:32 AM
Replies: 10
Views: 195
Posted By jdraw
Re: Change of User Name

Our current cat --adopted from our daughter-- is named Mango. We have had Duke, Gary, Ozzie and Red.
Forum: Introduce Yourself 10-02-2018, 04:45 AM
Replies: 10
Views: 195
Posted By jdraw
Re: Change of User Name

Colin,
Noted.

Via Google
Isla Dogs are a four-piece rock band from Hawick playing in and around the Scottish Borders.
??
Forum: Reports 10-02-2018, 04:38 AM
Replies: 14
Views: 215
Posted By jdraw
Re: Conditional Formatting on Dates

Stuart,

If date is within 7 Days of now - Always Green.
If date is within 4 Days of now = Always Orange
If date is within 2 days of now = Always Red

If a Date is 3 days from now, it is within...
Forum: General 10-02-2018, 03:59 AM
Replies: 58
Views: 730
Posted By jdraw
Re: User Level Security Wizard

In addition to Gina's suggestion see this video by Steve Bishop for ideas on User Access/Privileges (https://www.youtube.com/watch?v=DxRpo496w_c). Steve has several videos on various Access...
Forum: Introduce Yourself 09-23-2018, 03:24 PM
Replies: 2
Views: 94
Posted By jdraw
Re: going beyond my limits!

marvo,

Here is a link to Football fixtures inf (http://www.databasedev.co.uk/football_soccer_data_model.html)o that may help.
And here is a link to a lots of articles in various formats related...
Forum: Introduce Yourself 09-23-2018, 09:11 AM
Replies: 2
Views: 92
Posted By jdraw
Re: hi from CAT!

Welcome jrfml.
Forum: General 09-22-2018, 12:31 PM
Replies: 5
Views: 230
Posted By jdraw
Re: Bing, Google & Here map API's

I have some code with sample database in this thread (https://access-programmers.co.uk/forums/showthread.php?t=225339).
It allows street address, Postal/Zip and/or lat/long in any combination. It...
Forum: Reports 09-22-2018, 05:01 AM
Replies: 12
Views: 237
Posted By jdraw
Re: Dynamic multi search help

I do not understand your post either. More details and possibly some examples of your needs might help readers.
You can post your database (even though you have less than 10 posts) if you make it a...
Forum: Forms 09-20-2018, 06:06 AM
Replies: 10
Views: 184
Posted By jdraw
Re: Slow Loading Tab Control

You may be looking for this info from Albert Kallal (http://www.kallal.ca/Wan/Wans.html)

This info by Pat Hartman (https://access-programmers.co.uk/forums/showpost.php?p=66500&postcount=6) may be...
Forum: General 09-20-2018, 05:50 AM
Replies: 14
Views: 360
Posted By jdraw
Re: Limitations

You can link to tables in multiple database files, each of which can be as large as 2GB
https://dba.stackexchange.com/questions/167731/bypass-ms-access-2gb-file-size-limitation
That's why I said...
Forum: General 09-19-2018, 04:00 PM
Replies: 14
Views: 360
Posted By jdraw
Re: Limitations

As others have advised the 2GB limit is real. Stored images eat up space; better to store paths to files on filesystem.



I don't see where/how java would be involved. You could move to SQL...
Forum: Queries 09-19-2018, 02:35 PM
Replies: 16
Views: 257
Posted By jdraw
Re: Match Word in Sentence

mtl021,

???This is what you said earlier
Forum: Queries 09-19-2018, 04:53 AM
Replies: 16
Views: 257
Posted By jdraw
Re: Match Word in Sentence

Can you show us, based on your sample data, what you want as a final result?
Also, where do you handle the match being 7 or more characters?

Perhaps the following: ( also exposes the length of...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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