Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 5.39 seconds.
Search: Posts Made By: jdraw
Forum: Queries Today, 09:46 AM
Replies: 7
Views: 85
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 Today, 09:36 AM
Replies: 7
Views: 95
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.
Forum: Forms Yesterday, 03:33 PM
Replies: 8
Views: 134
Posted By jdraw
Re: can't assign a value to this object

Further to JohnF53's post
Or possibly on the click event of the Calc Time button.
Forum: Forms 03-21-2019, 12:19 PM
Replies: 6
Views: 109
Posted By jdraw
Re: Make data entry depending on which button is clicked

That's where I'd put it.
You have already clicked Inspection, now you choose which Inspection Type; Then you open the appropriate form to do your info entry...

Good luck.
Forum: Forms 03-21-2019, 11:51 AM
Replies: 6
Views: 109
Posted By jdraw
Re: Make data entry depending on which button is clicked

For consideration, you might click on Inspection and get a list/combo of valid InspectionTypes; select the one that applies; then

with a select case construct...
Forum: General 03-20-2019, 08:36 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

If each of your sub inspections have the same parent Inspection info eg job,operator etc, then you might consider Form and subform(s). It seems that you open the Min form, select job or Inspection;...
Forum: General 03-20-2019, 07:54 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

I agree with your general approach to the sub-Inspection -- that is if LineStop is needed, you must save your current info to table even if that info is not complete (not sure how much you need for a...
Forum: General 03-20-2019, 05:52 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

Agree generally, but instead of working with the physical database and "thinking about foreign key to pass etc", work with the logical requirement.
For example, you have recognized that your form...
Forum: General 03-19-2019, 01:58 PM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

See the Debugging link in my signature for Debug.print.
Forum: General 03-19-2019, 01:08 PM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

Can you take one form (Inspection) and a subInspection, then lead us through the LineStop process (step by step)? Just using plain English describe what should happen and what you need to record.
...
Forum: Forms 03-19-2019, 11:59 AM
Replies: 1
Views: 55
Posted By jdraw
Re: text box search for unique entry

In your search criteria use =

eg somefield = tboxEntry

You'll get the 52, 25, 456 etc if you use Like *& tboxentry & *
Forum: General 03-19-2019, 10:49 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

I wouldn't as a first step. But, if you are in an inspection or sub inspection it seems there is always the possibility to hit the "Stop the Line". So that could be called from any...
Forum: General 03-19-2019, 10:29 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

Does a LineStop event always occur during an Inspection? Do you have a diagram (even a rough one) showing what happens generally on a specific line, or at a specific inspection.
You could try...
Forum: General 03-19-2019, 10:05 AM
Replies: 34
Views: 402
Posted By jdraw
Re: "Cascading" tables and forms

I haven't looked at details, but I note that any one of several "Lines" could stop. It seems to me you would want to identify which Line (mill line, welding line, fabrication line, or paint line) was...
Forum: General 03-18-2019, 05:02 AM
Replies: 4
Views: 99
Posted By jdraw
Re: help with quiering costing from multiple options

I think it would be more efficient to post a copy of the database with instructions to show the area involved and what you want as output. Your post seems a little light on details and readers(me for...
Forum: Reports 03-18-2019, 04:58 AM
Replies: 3
Views: 89
Posted By jdraw
Re: Applying Filter to Report & All Bound Children on Report

Can you post a copy of the database -- remove anything confidential/private first --in zip format?
We only need a few records to highlight the issue.
Forum: Forms 03-18-2019, 04:35 AM
Replies: 5
Views: 138
Posted By jdraw
Re: error message

@bigmac,

Have you considered just using a text field rather than hyperlink type?
Then use the Application.FollowHyperlink "yourtextfield here" or more specifically

Application.FollowHyperlink ...
Forum: Modules & VBA 03-16-2019, 09:19 AM
Replies: 15
Views: 311
Posted By jdraw
Re: QR code in Ms Access Module without internet

You may find the wiki article on Reed-Solomon error correction (https://en.wikipedia.org/wiki/Reed%E2%80%93Solomon_error_correction) of some value. It's more involved than I want to work with.
There...
Forum: Modules & VBA 03-16-2019, 07:37 AM
Replies: 15
Views: 311
Posted By jdraw
Re: QR code in Ms Access Module without internet

???


What does the module claim to do? What documentation do you have?

I have not seen a routine independent of the internet that claims to generate a QR code, but it isn't something I have...
Forum: Tables 03-15-2019, 07:42 AM
Replies: 11
Views: 208
Posted By jdraw
Re: Noobieissues

Further to the great advice you have been given so far, I'm suggesting you work through 1 or 2 of the tutorials from RogersAccessLibrary in this link to articles on Database Planning an Design....
Forum: Reports 03-15-2019, 05:33 AM
Replies: 9
Views: 140
Posted By jdraw
Re: Form is passing a '0" to Report when combo box is left blank on form

Perhaps you could post a copy of the database in zip format and include instructions to show how to produce the issue.
Good luck.
Forum: General 03-14-2019, 03:34 AM
Replies: 16
Views: 304
Posted By jdraw
Re: General Questions and advice

I don't see any relationships in the database???
Forum: General 03-13-2019, 03:20 PM
Replies: 16
Views: 304
Posted By jdraw
Re: General Questions and advice

Post a copy of the database structure in zip format. The only way anyone can comment on your relationships is to have a list of your business rules...
Forum: Tables 03-12-2019, 02:23 PM
Replies: 13
Views: 257
Posted By jdraw
Re: Need some serious help

You might consider a supported commercial package. It's your business.
Forum: General 03-11-2019, 03:27 PM
Replies: 5
Views: 145
Posted By jdraw
Re: Retrieving a Value

I suggest you post a copy of your database (zip format).
Showing results 1 to 25 of 500

 
Forum Jump



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