Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.05 seconds.
Search: Posts Made By: jdraw
Forum: Modules & VBA Yesterday, 10:11 AM
Replies: 7
Views: 93
Posted By jdraw
Re: Make Table query issue (VBA)

Please tell us more about the application that updates the database constantly.
Who or what updates the database?
What is the subject matter in general terms?
What exactly is your role?
What is...
Forum: Introduce Yourself Yesterday, 10:07 AM
Replies: 3
Views: 35
Posted By jdraw
Re: New member

Welcome John. Good luck with your project.
Forum: Queries 09-17-2019, 04:35 AM
Replies: 13
Views: 147
Posted By jdraw
Re: Union Query & Combo Box

Ian,

Do you have a description/list of your requirements?
It sounds like you are still doing some analysis and design while getting deeply involved in details of SQL and or Access.
Good luck...
Forum: Queries 09-17-2019, 04:29 AM
Replies: 13
Views: 147
Posted By jdraw
Re: Union Query & Combo Box

If you take the SQL
SELECT [Stock]., [Stock].[Stock] FROM Stock WHERE [Sector]="Beef";
and put it in the query designer, what result do you get?
[I]Can you post a copy of the database (zip...
Forum: Queries 09-17-2019, 04:13 AM
Replies: 13
Views: 147
Posted By jdraw
Re: Union Query & Combo Box

In the form design, what is the bound column?
Forum: Queries 09-16-2019, 09:02 AM
Replies: 5
Views: 85
Posted By jdraw
Re: What Report level fields are available to the 'On Print' event

Stephen,

Can you post a copy of the database so readers can "experience" the issue?
We only need enough data to highlight the issue. You can anonymize a few records if there is some...
Forum: Modules & VBA 09-14-2019, 02:35 PM
Replies: 3
Views: 123
Posted By jdraw
Re: Form Button to browse for a default folder location

cross posted @ https://www.accessforums.net/showthread.php?t=78098
Forum: General 09-14-2019, 09:32 AM
Replies: 5
Views: 143
Posted By jdraw
Re: Hello!

Welcome to AWF.
Glad you have resolved your issue.
Forum: Introduce Yourself 09-13-2019, 02:22 PM
Replies: 8
Views: 154
Posted By jdraw
Re: Been around but just getting started!

Welcome to AWF Mike.
Better late than never....

I'm a little like Doc --- oversaw purchases of TRS80 and Commodore, but I was on various PDP and Mainframe/service bureau hardware.

Lots of...
Forum: Introduce Yourself 09-12-2019, 04:56 AM
Replies: 12
Views: 157
Posted By jdraw
Re: Hi everyone

Is there a term "re_welcome to the forum"? Welcome back regardless.
Forum: Queries 09-11-2019, 04:31 AM
Replies: 12
Views: 160
Posted By jdraw
Re: Delete record from table based on query

I agree with Mark. Sounds like you may have a design issue. If the only difference in the purpose of the three tables is to identify STATUS, then 1 table with Status seems appropriate.
Delete...
Forum: Introduce Yourself 09-10-2019, 12:04 PM
Replies: 7
Views: 114
Posted By jdraw
Re: Hello!

Welcome aboard.
Forum: Queries 09-10-2019, 11:52 AM
Replies: 12
Views: 160
Posted By jdraw
Re: Delete record from table based on query

Why are there similar records in 2 tables? Need more info on table design and what your database is about.
Forum: Introduce Yourself 09-08-2019, 05:00 PM
Replies: 4
Views: 75
Posted By jdraw
Re: hello

Welcome aboard.
Forum: Queries 09-07-2019, 05:34 AM
Replies: 7
Views: 152
Posted By jdraw
Re: Find and extract text if it occurs in first 4 characters

This is SQL for a query to get records where leftmost 4 chars contain 30.
You can adapt to your field and table names and replace 30 with 01
SELECT CompInfoJun212016.tCompany
,...
Forum: Tables 09-07-2019, 04:58 AM
Replies: 3
Views: 167
Posted By jdraw
Re: Table design

PWG,

Nobody can comment on your tables and relationships without knowledge of your business. Tables and relationships reflect the business entities and attributes and the rules/facts of the...
Forum: Modules & VBA 09-06-2019, 04:42 AM
Replies: 23
Views: 294
Posted By jdraw
Re: code explanation

You're welcome. I have more info here (https://www.accessforums.net/showthread.php?t=65220&p=352133#post352133).

Good luck with your project.
Forum: Modules & VBA 09-06-2019, 03:44 AM
Replies: 23
Views: 294
Posted By jdraw
Re: code explanation

PWG,

I agree with the comments and advice given by the others. Several of the sample database(s) (eg northwind specifically) has been criticized in many posts and articles for some of the...
Forum: Introduce Yourself 09-01-2019, 04:21 PM
Replies: 4
Views: 77
Posted By jdraw
Re: New Member

Welcome to AWF!
Forum: Forms 09-01-2019, 06:02 AM
Replies: 5
Views: 71
Posted By jdraw
Re: Front end user

With a split database each user should have a copy of the front end on their own PC (http://www.fmsinc.com/microsoftaccess/databasesplitter). See Managing FrontEnd databases on each Desktop.
Front...
Forum: Introduce Yourself 09-01-2019, 04:20 AM
Replies: 3
Views: 106
Posted By jdraw
Re: Hello from the US!

Welcome to AWF.
Forum: The Watercooler 09-01-2019, 03:23 AM
Replies: 13
Views: 207
Posted By jdraw
Re: Yeah baby!

Good stuff NG!!
Forum: Forms 08-31-2019, 03:56 AM
Replies: 10
Views: 152
Posted By jdraw
Re: Requerying Data in Combo box after adding a new record

You may get some info from this youtube video combo edit list (https://www.599cd.com/tips/access/121112-combo-box-edit-list-items/)by Richard Rost.
Forum: Introduce Yourself 08-30-2019, 06:27 AM
Replies: 4
Views: 90
Posted By jdraw
Re: New to forumm

Welcome to AWF Allen.
Forum: General 08-27-2019, 12:52 PM
Replies: 10
Views: 154
Posted By jdraw
Re: Database Design

Mega1, you may get some ideas from the data models at Barry Williams' site. (http://www.databaseanswers.org/data_models/index_all_models.htm)

See those in the Law Enforcement area.

As Doc...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:05 AM.


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