Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 10.11 seconds.
Search: Posts Made By: jdraw
Forum: General Today, 01:58 PM
Replies: 18
Views: 120
Posted By jdraw
Re: "Cascading" tables and forms

See the Debugging link in my signature for Debug.print.
Forum: General Today, 01:08 PM
Replies: 18
Views: 120
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: General Today, 10:49 AM
Replies: 18
Views: 120
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 Today, 10:29 AM
Replies: 18
Views: 120
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 Today, 10:05 AM
Replies: 18
Views: 120
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: Tables 03-15-2019, 07:42 AM
Replies: 11
Views: 185
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: Tables 03-12-2019, 02:23 PM
Replies: 13
Views: 236
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: 122
Posted By jdraw
Re: Retrieving a Value

I suggest you post a copy of your database (zip format).
Forum: Forms 02-15-2019, 01:57 PM
Replies: 4
Views: 128
Posted By jdraw
Re: Time difference between two times

Your code,seems correct to find the difference in minutes between timein and timeout
DateDiff("n",[timein],[timeout])

That is simply a number.
Divide your "n" minutes by 60 to get Hours.

1.5...
Forum: Queries 02-11-2019, 08:56 AM
Replies: 10
Views: 184
Posted By jdraw
Re: Queries with a table of related records

Hank,
I'm looking at your sample database--I made a copy.
Then I put an alias on each of the tbl_Facilities in the recordsource of the form as per these png files attached.

See if that helps.
...
Forum: Queries 02-09-2019, 04:23 PM
Replies: 5
Views: 129
Posted By jdraw
Re: Combining two queries in one sql statement

I moved your post from Code Repository to Queries. (jdraw)
Forum: Reports 02-08-2019, 11:15 AM
Replies: 6
Views: 166
Posted By jdraw
Re: Control Source Name

Perhaps you could show us a sample with data of what you are trying to describe.
I'm with Uncle Gizmo--confused why column headers change??
Forum: Tables 02-03-2019, 07:55 AM
Replies: 13
Views: 404
Posted By jdraw
Re: IFF dosn't work

??? But you wrote the wrong code
From your post #9


What is to attach? I showed the expression and the new record in the graphic.

As has been stated before, calculations should be done in...
Forum: Tables 02-03-2019, 07:09 AM
Replies: 13
Views: 404
Posted By jdraw
Re: IFF dosn't work

I downloaded your database.
And retyped the expression in the calculated field Total.
Then, added a new record to tbl---- # 16.
And no error and seemed to work fine.

I have attached a png.
Forum: Tables 01-31-2019, 11:42 AM
Replies: 13
Views: 404
Posted By jdraw
Re: IFF dosn't work

As was suggested use a query
SELECT tbl.amount, tbl.price, [amount]*[Price] AS LineTotal
FROM tbl;


amount price LineTotal
20 200 4000
30 400 12000
Forum: Modules & VBA 01-31-2019, 10:32 AM
Replies: 13
Views: 44
Posted By jdraw
Re: Randomized Allocation w/in Category - Loop

I don't know if this (www.accessforums.net/showthread.php?t=41737) fits your situation, but it may be useful. It's a few years old, but it did solve the poster's question.
Forum: Queries 01-31-2019, 08:35 AM
Replies: 8
Views: 54
Posted By jdraw
Re: Ms access changing field name in query

Please tell us more.

You can alias a field in a query

Select fld1, fld2 as MyCustomName from MyTable

as MyCustomName represents an alias in the SQL of the query.

Access does not like...
Forum: Forms 01-27-2019, 05:45 AM
Replies: 5
Views: 12
Posted By jdraw
Re: Pesky Users Prevention: How to AVOID Editing record to produce a duplicate record

Depending on your specific requirements there are things you could check for and if found, ask the user/operator to confirm or review an entry or edit
-if FName and LName already exist
-if Position...
Forum: Modules & VBA 01-26-2019, 04:53 AM
Replies: 15
Views: 807
Posted By jdraw
Re: Rounding up numbers depending on their value

??? Almost 2 years since previous post???
The GetRoundedTo function is located at the link given in post #8 above.
Forum: Forms 01-22-2019, 07:36 AM
Replies: 5
Views: 17
Posted By jdraw
Re: Search between two dates

Please tell us what this really means.


Error message, number?

Also, you should use code tags. That is, highlight your code, then click the #(hash) in the header area.
Indent your code for...
Forum: General 01-17-2019, 01:22 PM
Replies: 9
Views: 235
Posted By jdraw
Re: Code Generators

I found this link that may be useful to you with vba code (https://www.codeproject.com/Articles/229280/Office-Programming-Helper-Indent-code-and-more-4). I have not used it. I have not seen a code...
Forum: Forms 01-17-2019, 12:11 PM
Replies: 8
Views: 128
Posted By jdraw
Re: Getting Error - Trying to delete a record

The error is saying ---you are trying to delete a record on the main form that has related record(s) on the subform. If you delete that main form record, you will have an orphan on the subform--And...
Forum: Forms 01-16-2019, 04:43 AM
Replies: 4
Views: 122
Posted By jdraw
Re: How do I "tag" along a combo box field ?

I think this is a case where a picture would help the discussion. I'm not following the essence of your post. "Tag" has a specific meaning (property) in Access, but it doesn't seem to apply here....
Forum: General 01-15-2019, 01:02 PM
Replies: 45
Views: 1,107
Posted By jdraw
Re: Relate one field to multiple fields

I see 62 EndItems but only 61 Assemblies which I don't quite understand.
It's possible that EndItem (Assembly_PK 62) is planned, but doesn't yet exist.
My thinking is create an EndItem and then...
Forum: General 01-15-2019, 05:42 AM
Replies: 45
Views: 1,107
Posted By jdraw
Re: Relate one field to multiple fields

Wow!

1 for me and 9 for Frothy ----he's 9 times quicker than me.

Zydeceltico,
Here's a graphic that may be useful (at some time) re getting data from tables.
...
Showing results 1 to 25 of 500

 
Forum Jump



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