Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: jdraw
Forum: General 11-08-2018, 10:57 AM
Replies: 1
Views: 83
Posted By jdraw
Re: Control of warehouses and sales* men

Please provide more info on this project in plain simple English. Readers can't guess what your project is about nor do we have any knowledge of you, your environment etc.

Without a description of...
Forum: Modules & VBA 11-08-2018, 10:52 AM
Replies: 3
Views: 107
Posted By jdraw
Re: Creating a breadcrumbs field in VBA

I have seen this link to Treeview (https://www.jkp-ads.com/Articles/treeview.asp) mentioned, but I have not tried it.

If you do use it/test it, then please post your comments so we can all learn....
Forum: Reports 11-05-2018, 05:44 AM
Replies: 26
Views: 573
Posted By jdraw
Re: Advice Required Please

Start with a simple description of what you are trying to do in plain English.

I tried Google for OTF approval from (https://www.google.com/search?q=OTF+approval+from&ie=utf-8&oe=utf-8)

I have...
Forum: Queries 11-02-2018, 07:28 AM
Replies: 4
Views: 114
Posted By jdraw
Re: UK dates in SQL queries

RogerC,

What was your solution? It may help someone else.
Sometimes asking user to select from a combo with Month names spelled out removes the US/UK/CAN date format confusion.

OOooops: I...
Forum: Code Repository 11-01-2018, 05:38 PM
Replies: 16
Views: 683
Posted By jdraw
Re: Speed Comparison Tests - Having vs Where

My results

https://access-programmers.co.uk/forums/attachment.php?attachmentid=72529&stc=1&d=1541122680
Forum: Modules & VBA 10-24-2018, 02:13 PM
Replies: 21
Views: 334
Posted By jdraw
Re: How to populate a textbox with ONLY the first Combo Box selection when selecting

SashaSolo,

It seems your issue is really based in your use of MVF. I don't mean to cause you a lot of work but I suggest you normalize the table with the MVF.
It may be useful to post a copy of...
Forum: Modules & VBA 10-24-2018, 01:06 PM
Replies: 21
Views: 334
Posted By jdraw
Re: How to populate a textbox with ONLY the first Combo Box selection when selecting

SashaSolo,

Cross posting is acceptable when done in a manner that
-identifies the other link(s) explicitly in the post
-original is updated if a solution is found

I like the Posting Tips...
Forum: Modules & VBA 10-24-2018, 08:55 AM
Replies: 17
Views: 253
Posted By jdraw
Re: Compile Error: Overflow

It appears that you have exceeded the capacity of a Long datatype.

From M$oft.
Long Integer — Use for integers that range from -2,147,483,648 to 2,147,483,647

I tested you routine after...
Forum: Queries 10-24-2018, 03:38 AM
Replies: 17
Views: 343
Posted By jdraw
Re: Random Selection of Records

No, they are discussing Randomize -which is required to reseed the Random number.
Without Randomize you will get repeat result.
Here is a function that deals with random.
...
Forum: Queries 10-23-2018, 04:26 AM
Replies: 17
Views: 343
Posted By jdraw
Re: Random Selection of Records

Further to MajP's advice here is a link to Allen Browne subquery tips --see top N records per group (http://allenbrowne.com/subquery-01.html)
Forum: Queries 10-23-2018, 04:17 AM
Replies: 9
Views: 143
Posted By jdraw
Re: Opening/Closing Stocks

SiGill,

Here is a link to a 26 minute free video on Stock Management by Software-Matters (https://www.youtube.com/watch?v=9HRmSRR29fY). It should give you ideas on set up and processes that may...
Forum: Introduce Yourself 10-20-2018, 05:13 AM
Replies: 8
Views: 305
Posted By jdraw
Re: Hello From Ontario - Not California!

Welcome Micron.
We have "talked" on AccessForumNet. I had assumed (wrongly) that you were here as well. I do not do Facebook, Twitter etc---must be an age thing.
I agree with the others --your...
Forum: Queries 10-20-2018, 05:07 AM
Replies: 3
Views: 174
Posted By jdraw
Re: i want book in sql access

Simply SQL (https://www.amazon.ca/Simply-SQL-Easy-Learn-Best-Practice/dp/0980455251#customerReviews) by Rudy Limeback is a good book for SQL - not Access specific.
Forum: Visual Basic 10-18-2018, 03:02 PM
Replies: 23
Views: 2,006
Posted By jdraw
Re: VBA, I desperately need help.

I've also found a better way to deal with the problem I had trying to automate the process of copying data from one field to another on data entry.

Perhaps you would like to share your "better...
Forum: Visual Basic 10-18-2018, 02:42 PM
Replies: 23
Views: 2,006
Posted By jdraw
Re: VBA, I desperately need help.

Post a copy of the database to get more focused responses.
Forum: Visual Basic 10-18-2018, 09:11 AM
Replies: 23
Views: 2,006
Posted By jdraw
Re: VBA, I desperately need help.

I recall a photo with attributes question
https://www.access-programmers.co.uk/forums/showthread.php?t=276886

A lot of what you need seems to focus on the kind of question/searches you want to...
Forum: Visual Basic 10-18-2018, 05:00 AM
Replies: 23
Views: 2,006
Posted By jdraw
Re: VBA, I desperately need help.

I recommend you tell us about the application in simple plain English. You could also post a copy of your database in a ZIP file.
Good luck.
Forum: Gadgets 10-15-2018, 05:27 AM
Replies: 12
Views: 1,322
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 10-15-2018, 05:23 AM
Replies: 2
Views: 377
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: 163
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: 731
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,848
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,848
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,848
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,848
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...
Showing results 1 to 25 of 500

 
Forum Jump



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