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: Tables Today, 06:29 AM
Replies: 20
Views: 136
Posted By jdraw
Re: How to join two tables with relationship


Please describe the business in simple terms so we understand the issue in context. I don't think your whole setup and requirement is just limited to the 2 tables you provided.
Forum: General Yesterday, 01:07 PM
Replies: 3
Views: 65
Posted By jdraw
Re: Date Difference

In SQL generally

where YourDateToBeChecked Between Date1 and Date2
Forum: Queries Yesterday, 10:08 AM
Replies: 7
[SOLVED] Support Required
Views: 117
Posted By jdraw
Re: Support Required

Your database has 4 tables?
I recommend you research Normalization to assist you with design.
You should avoid names with embedded spaces.
Good luck.
Forum: Introduce Yourself Yesterday, 07:38 AM
Replies: 1
Views: 40
Posted By jdraw
Re: New member Quacker

Welcome Don!
There is a Jurassic section here-- huge dinosaurs such as Stegosaurus(IBM 1620), Ceratosaurus(IBM 360-70), Brachiosaurus(PDP-11/03 --VAX), and Allosaurus(Cobol, PL/1,Macro-11, Mark4,...
Forum: General Yesterday, 05:16 AM
Replies: 4
Views: 448
Posted By jdraw
Re: Northwind DB-Delete transactions and return stock when canceling order doesnt wor


I have never used the 2013 Northwind database. Is your attachment the original or have you modified it.
Could you clarify?

Forum: General 01-18-2018, 04:30 PM
Replies: 9
Views: 165
Posted By jdraw
Re: 1 front end, multiple backends for different uses

Can you tell us more about the organization and its business? You can do this, BUT because it's possible doesn't mean you should. Many organizations spend considerable resources to design ,...
Forum: Forms 01-18-2018, 01:27 PM
Replies: 14
Views: 216
Posted By jdraw
Re: Refresh record and screen

Please post the code for Function_Current()
Forum: Forms 01-18-2018, 10:54 AM
Replies: 5
Views: 107
Posted By jdraw
Re: Select from combobox or add new

You might get some ideas from this re not in list (https://www.youtube.com/watch?v=7xy29Q4-DI4)
Forum: Tables 01-18-2018, 08:06 AM
Replies: 31
Views: 491
Posted By jdraw
Re: Integrity


Others have given good advice and suggestions. I'm attaching a document that also outlines database design principles that you my find useful.

Good luck.
Forum: Forms 01-17-2018, 06:55 AM
Replies: 6
Views: 159
Posted By jdraw
Re: Search button - possible to make default options applicable on all computers?

As others have said, what exactly are you trying to search?
What is the purpose of the subform since it appears to be the source of confusion?
Can you give readers a sample search -in plain English...
Forum: Introduce Yourself 01-14-2018, 04:53 PM
Replies: 4
Views: 151
Posted By jdraw
Re: Hello from Canada

Welcome vlad.
Where in Canada?
Forum: Tables 01-13-2018, 09:52 AM
Replies: 31
Views: 491
Posted By jdraw
Re: Integrity

Please tell us more--remember we know nothing of your set up or requirement.
Are these really databases or tables in the same database?
Forum: Queries 01-12-2018, 03:32 PM
Replies: 14
Views: 277
Posted By jdraw
Re: Query not updateable

This Allen Browne link (http://allenbrowne.com/ser-61.html) shows most common reasons for the "updateable query" message.

Could you post a copy (in zip format) of the database (sufficient to show...
Forum: Modules & VBA 01-12-2018, 01:32 PM
Replies: 16
Views: 376
Posted By jdraw
Re: VBA From DAO to ADO

See links by Allen Browne
Forum: Forms 01-12-2018, 11:04 AM
Replies: 19
Views: 394
Posted By jdraw
Re: using many subforms

Here is a link re some Access specifications...
Forum: Tables 01-12-2018, 10:52 AM
Replies: 5
Views: 211
Posted By jdraw
Re: How to avoid duplicates in append query

You might research this link re composite unique index (http://www.geeksengine.com/article/composite-unique-index-access.html) to prevent duplication of data.
Forum: Queries 01-12-2018, 10:15 AM
Replies: 3
Views: 177
Posted By jdraw
Re: Query to find a match when words in a different order

Yes, your approach(while typing) is akin to general concept.
You will see articles involving keywords, synonyms, stems and noise words.

If words are in a different order, you can capture the...
Forum: Queries 01-12-2018, 07:15 AM
Replies: 1
Views: 129
Posted By jdraw
Re: Remarks does not show on report

Your query does not have a FROM tablename

Perhaps part of your SQL was not copied/pasted correctly.
Please post a copy of your relationships showing how Maintable an Remarks are related.
Forum: Modules & VBA 01-11-2018, 08:20 AM
Replies: 3
Views: 137
Posted By jdraw
Re: Sub Folder search at the click of a button

I found this on the site

Also, this does not do what you may think
Dim sMonth, sYear, Search_path, Search_Filter,...
Forum: Modules & VBA 01-11-2018, 07:40 AM
Replies: 3
Views: 137
Posted By jdraw
Re: Sub Folder search at the click of a button

Can you provide a sample, even if you make it up, to show us what you want?
Sample folder/subfolder; your code; expected result...
Forum: Modules & VBA 01-08-2018, 01:52 PM
Replies: 2
Views: 128
Posted By jdraw
Re: Coding so that query outcome effects main form

Form and subform construct is used typically to show records from tables that are related in a 1 to Many relationship.
Perhaps you could describe what your tables and database represent in plain...
Forum: Introduce Yourself 01-08-2018, 07:22 AM
Replies: 4
Views: 134
Posted By jdraw
Re: Hi from Oz

Welcome roadie3124.
Forum: Tables 01-07-2018, 07:26 AM
Replies: 4
Views: 262
Posted By jdraw
Re: table structure

You may find some ideas here (http://www.utteraccess.com/wiki/Expanding_a_Hierarchical_Data_Structure).

You could also search for Pick List based on concept of -- I have a pick list for X, I need...
Forum: General 01-07-2018, 06:39 AM
Replies: 18
Views: 624
Posted By jdraw
Re: access problem dragging fields

Further to Ridders' suggestion, you could post a copy of the database and readers could see/review the issue. However, it does seem specific to you at the moment.

(Remove anything confidential...
Forum: Forms 01-04-2018, 07:15 AM
Replies: 2
Views: 114
Posted By jdraw
Re: Remove Carriage Returns/Line Breaks in Field As Soon As Pasted.

cross posted at http://www.accessforums.net/showthread.php?t=69822

When you cross post, tell readers that you have done so, and identify the other post(s) by means of a link.

What exactly do...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 02:13 PM.

Microsoft Access Help
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