Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.52 seconds.
Search: Posts Made By: jdraw
Forum: Theory and practice of database design 02-16-2019, 08:13 AM
Replies: 45
Views: 8,267
Posted By jdraw
Re: Meaningless vs Meaningful Primary Keys

Just thought I'd throw a little fuel on the fire.

I often create a separate autonumber PK on a junction table rather than using the combination of PKs from the members of the junction. Then use a...
Forum: Modules & VBA 02-15-2019, 05:59 PM
Replies: 15
Views: 186
Posted By jdraw
Re: me.orderby not working

Just a thought for consideration.

What if you had EventStartDate (dateTime) and EventDuration (number) representing the length of the Event in days.

Does that offer anything new?
I haven't...
Forum: Forms 02-15-2019, 01:57 PM
Replies: 4
Views: 103
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-13-2019, 12:29 PM
Replies: 8
Views: 155
Posted By jdraw
Re: Query shows id instead of value

Good stuff. Happy to help.
Forum: Queries 02-13-2019, 10:29 AM
Replies: 8
Views: 155
Posted By jdraw
Re: Query shows id instead of value

Just describe what you want this database to do.

I think your Order table is not correctly designed. Normally you would have named ids
eg CustomerId, ProductID, OrderID . In your Order table you...
Forum: Queries 02-13-2019, 09:45 AM
Replies: 8
Views: 155
Posted By jdraw
Re: Query shows id instead of value

I'm not sure of your intent, but it seems there may be a design issue.

Can a Customer order more that 1 product at a time? That is can an Order have multiple Products?
If yes, then you may be...
Forum: Queries 02-13-2019, 06:37 AM
Replies: 8
Views: 155
Posted By jdraw
Re: Query shows id instead of value

Please post a copy of the database in ZIP format.

It appears that you may be showing the ID column because of the Format setting of the combo.... but seeing the database will get you focused...
Forum: Modules & VBA 02-11-2019, 09:38 AM
Replies: 18
Views: 198
Posted By jdraw
Re: UK Fixed Date in VBA

Try enclosing with CDate(SqlDate(strInputBox)) to convert string to Date

Why Dim these as strings?
Dim Startdate As String
Dim Enddate As String
Forum: Queries 02-11-2019, 09:24 AM
Replies: 10
Views: 172
Posted By jdraw
Re: Queries with a table of related records

Glad you have a solution. I did make a query and using that as the recordsource of th form and that worked.
Here's the SQL of that query

SELECT TBL_Circuits.ID, TBL_Circuits.Circuit_Name,...
Forum: Queries 02-11-2019, 08:56 AM
Replies: 10
Views: 172
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-11-2019, 07:25 AM
Replies: 10
Views: 172
Posted By jdraw
Re: Queries with a table of related records

No, not Rube Goldberg. That table/query structure is what I was thinking.

Can you post a copy of the database in zip format? I'll take a look.
You might also identify a meeting and the...
Forum: General 02-10-2019, 06:24 PM
Replies: 19
Question ActiveX Controls
Views: 552
Posted By jdraw
Re: ActiveX Controls

MajP,

Re the spinner

Did you post the database somewhere? Sounds like something for the sample databases or code repository.
Forum: Introduce Yourself 02-10-2019, 05:53 PM
Replies: 3
Views: 88
Posted By jdraw
Re: Long Way From Claiming Knowledge

Welcome SamW. I agree fully with Doc --been retired 10+ yrs-- not sure about the learning but I also have experienced many errors.
Forum: Theory and practice of database design 02-10-2019, 08:27 AM
Replies: 49
Views: 17,987
Posted By jdraw
Re: Access OOP examples wanted

Here is a youtube video by PDTech describing his routine/class module to adjust and resize form controls. (https://www.youtube.com/watch?v=wfRWTUDBLxQ)
His code is available as mentioned in the...
Forum: Queries 02-09-2019, 04:23 PM
Replies: 5
Views: 120
Posted By jdraw
Re: Combining two queries in one sql statement

I moved your post from Code Repository to Queries. (jdraw)
Forum: Modules & VBA 02-09-2019, 06:11 AM
Replies: 5
Views: 110
Posted By jdraw
Re: mouse over issues

BigMac

More info please. Can you give an example of what you want to happen?
Forum: Reports 02-08-2019, 11:15 AM
Replies: 6
Views: 126
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: Queries 02-08-2019, 10:40 AM
Replies: 5
Views: 126
Posted By jdraw
Re: Invalid Operation in Left Outer Join (in Access)

Is this one of those issues where seeing your database or part of it might help in finding a solution?
You could post a copy of the database or significant part to highlight the issue.
Forum: Modules & VBA 02-07-2019, 01:32 PM
Replies: 4
Views: 130
Posted By jdraw
Re: Making a Library Management database

You started at the wrong spot.
Start with a clear statement of the requirement; identify tables and relationships.
Work through( about 30-45 minutes) this tutorial from RogersAccessLibrary...
Forum: Queries 02-07-2019, 01:16 PM
Replies: 10
Views: 172
Posted By jdraw
Re: Queries with a table of related records

Hank,

I have no idea what you are talking about.
As plog requested --a screen shot or SQL of the query would be useful to readers.

is this close?

You have a table of customers and you want...
Forum: Forms 02-04-2019, 12:02 PM
Replies: 22
Views: 296
Posted By jdraw
Re: Enter data into multiple tables from one form

Further to the advice provided so far, could you give us an overview of the"system" in simple terms? You have mentioned Customer, Stock and Transactions, but what are the rules/facts in which they...
Forum: Tables 02-03-2019, 07:55 AM
Replies: 13
Views: 365
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: 365
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: 365
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: 36
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.
Showing results 1 to 25 of 500

 
Forum Jump



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