Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.28 seconds.
Search: Posts Made By: jdraw
Forum: Theory and practice of database design Today, 02:05 PM
Replies: 5
Views: 65
Posted By jdraw
Re: Best Practice Advice: How to find out when a record is updated in read only BE

@GBalcom,

Have you tried talking to the product supplier? Is there a user group for the product?
Any product documentation?
Can you point readers to Product overview and marketing materials?
...
Forum: General 04-16-2019, 05:00 AM
Replies: 8
Views: 156
Posted By jdraw
Re: Compliance Database design in Access 2019

You may get some ideas from this free model (http://www.databaseanswers.org/data_models/inspections_of_facilities/index.htm) from Database Answers.org.

A quick look at your png suggests you may...
Forum: Forms 04-15-2019, 12:03 PM
Replies: 5
Views: 117
Posted By jdraw
Re: Form with search criteria

Suggest you describe the requirement in simple English to give readers some context. A few examples of your typical search would also be helpful.

Often referenced search info is this by Allen...
Forum: Forms 04-14-2019, 04:48 PM
Replies: 5
Views: 117
Posted By jdraw
Re: Form with search criteria

With Access vba , you must explicitly DIM your variables --otherwise they become Variant data type.

Dim A as string, B as Integer OR
Dim A as string
Dim B as Integer

I have attached a png...
Forum: Introduce Yourself 04-13-2019, 08:05 AM
Replies: 5
Views: 90
Posted By jdraw
Re: Hello from Canada!!!

Welcome to the forum.
Where in Canada?
Forum: The Watercooler 04-12-2019, 09:37 AM
Replies: 6
Views: 106
Posted By jdraw
Forum: Modules & VBA 04-12-2019, 06:42 AM
Replies: 4
Views: 93
Posted By jdraw
Re: Primer on Debugging, Error Handling, and The VBA Editor

See these links

http://www.cpearson.com/Excel/ErrorHandling.htm
http://www.cpearson.com/Excel/DebuggingVBA.aspx

You an Google vba extensibility for various materials on the vba editor.
Here...
Forum: Modules & VBA 04-09-2019, 06:28 AM
Replies: 6
Views: 260
Posted By jdraw
Re: Split by Commas and add to new table

Here is a solution. I'm using 2 recordsets -rs1 your original, rs2 the desired output as a new table.


' ----------------------------------------------------------------
' Procedure Name:...
Forum: Modules & VBA 04-09-2019, 05:45 AM
Replies: 14
Views: 436
Posted By jdraw
Re: How can I copy a file from a table to another table?

Glad you have it resolved. Thanks fr posting the SQL.
Forum: Modules & VBA 04-07-2019, 02:56 PM
Replies: 14
Views: 436
Posted By jdraw
Re: How can I copy a file from a table to another table?

ppetrol,

It seems readers are not following the intent of your post. I suggest you write a description of what you are trying to achieve in your native language - in clear and complete terms -then...
Forum: Introduce Yourself 04-05-2019, 02:27 PM
Replies: 6
Views: 137
Posted By jdraw
Re: Hi all from Pennsylvania, USA

Welcome JohnK320,

Come on John, as my mother said to me--if I've told you once, I've told you a million times-

don't exaggerate.

Welcome.
Forum: The Watercooler 04-05-2019, 02:23 PM
Replies: 11
Views: 419
Posted By jdraw
Re: S-Q-L or SEQUEL?

I've be known to call it lots of things---I suppose SQL and Sequel were in there somewhere ---especially in mixed company.
Forum: Forms 04-03-2019, 06:54 AM
Replies: 23
Views: 332
Posted By jdraw
Re: Help with Order form design

Further to plog's advice, it is easier for reader and you to understand your requirement when you describe "the business" in simple, plain English --not in terms of tables and forms.

Access does...
Forum: Modules & VBA 04-03-2019, 05:19 AM
Replies: 5
Views: 140
Posted By jdraw
Re: dates issue

You might also consider the BeforeUpdate event where you could check your conditions and decide whether or not to change the "current value".
Forum: Queries 04-03-2019, 05:11 AM
Replies: 3
Views: 127
Posted By jdraw
Re: Latest Date Query

Try
select * from tbl_SupplierNumber where
expirydate = (SELECT Max(ExpiryDate)
FROM tbl_SupplierNumber )
Forum: Queries 04-03-2019, 03:33 AM
Replies: 3
Views: 127
Posted By jdraw
Re: Latest Date Query

Show us the query SQL you re using.

Please clarify the requirement:

1--How can I get the latest date
2--But I only want the 19 July rows
Forum: Queries 04-01-2019, 05:10 AM
Replies: 1
Views: 92
Posted By jdraw
Re: Change data in a subform by Date

Typical usage of Form/subform construct is when tables involved have a 1 to Many relationship. For instance, 1 Student takes Many Courses. Student is the recordsource for the Form, Course is the...
Forum: General 04-01-2019, 05:03 AM
Replies: 45
Views: 962
Posted By jdraw
Re: Matching logic

Colin,

I noticed the same thing --Soundex quite often gives no response. I also note that the Levenshtein and Simil responses often have a quite different order. eg High rank in Levenshtein may be...
Forum: General 04-01-2019, 03:17 AM
Replies: 45
Views: 962
Posted By jdraw
Re: Matching logic

Agree that Levenshtein seems best, then Simil, then soundex on some tests.
Thanks MajP for putting these tests side by side.
If you do something with the Excel Add-on, please post any results.
Forum: General 03-31-2019, 06:49 AM
Replies: 45
Views: 962
Posted By jdraw
Re: Matching logic

@MajP

Looks good. Awaiting your tests. Could be a great sample database.

@dcavaiani

I agree with the suggestion by the_Doc_Man. You need an identifier in your environment that can handle...
Forum: General 03-31-2019, 05:22 AM
Replies: 45
Views: 962
Posted By jdraw
Re: Matching logic

Why and what exactly does Home Depot have to have an exact spelling of someone's customer name (your Customer is not necessarily HD's customer). Home Depot would need the Sales/Invoice/receipt info...
Forum: Forms 03-31-2019, 03:48 AM
Replies: 8
Views: 187
Posted By jdraw
Re: Combo box& Query

@mohamedmatter

I noticed your Employeetbl has field Fullname with values Lastname Firstname. Your form has controls for Fullname, Firstname and Lastname, but Firstname and Lastname show ??. ...
Forum: General 03-30-2019, 01:45 PM
Replies: 3
Views: 220
Posted By jdraw
Re: date of Last trip Made by a truck

I agree with Tony -- doesn't seem to be enough info in your post to provide a focused response.

It seems to me you also need a Shipment table in your database. And further that some rules must...
Forum: Queries 03-24-2019, 09:46 AM
Replies: 7
Views: 170
Posted By jdraw
Re: Sum by character within value

Try
SELECT Mid(T1.[F1],3,1) AS ThirdChar
, Sum(T1.F2) AS Qty
FROM T1
GROUP BY Mid(T1.[F1],3,1);


OOOoooops: I see Gasman has replied while I was testing.
Forum: Queries 03-24-2019, 09:36 AM
Replies: 8
Views: 207
Posted By jdraw
Re: combine multiple fields into a query

There is a Family Tree template (https://www.lifewire.com/microsoft-access-genealogy-database-template-1019528)here also.
Good luck with your project.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:24 PM.


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