Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
kentgorrell's latest activity
K
kentgorrell
replied to the thread
Drag and Drop interface is it possible
.
You can do this using GDI. see Access Gantt Chart for a demo. This demo is a Gantt chart but pivot and the same principles apply to a...
Thursday at 11:54 AM
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
Wow, I just had a flashback to when I first learned about concatenation with + and &. I recall when and where I was. I was on a beach...
Mar 28, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
good point although I'm so far not having an issue with Chr(!0), Chr(30) being embedded. With two fields I used to concatenate them...
Mar 27, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
I'm rather inclined to use one address field which is a free for all that may include Street Name, Street Number, Building Name, PO Box...
Mar 27, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
If you can't modify them using VBA then I can't use them. In my applications, schema modifications are all done by code. No-one manually...
Mar 27, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
so when he said "Relationship" he really meant "Join". a relationship is a database constraint while a join is just SQL and can be...
Mar 27, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
I don't get what you mean, can you give an example?
Mar 26, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
I was just thinking about all the things to consider when migrating. For example, An Access index has a boolean option for Ignore Null...
Mar 26, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
and by "connections" you mean relationships? I really only work with SQL Server dbs so I haven't used Lookups since Access Web Apps. I'd...
Mar 26, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
I'm trying to think of when you might want a relationship but not use RI. I guess maybe to improve join performance while ignoring orphans?
Mar 26, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
Yes it should but then there are lots of things that the SSMA does now that it once didn't. FYI: while following your advice to remove...
Mar 26, 2024
K
kentgorrell
replied to the thread
Missing SQL Server Logs
.
Tip: for testing you can use the Developer edition of SQL Server rather than Express. It's free but has all the functionality of a paid...
Mar 24, 2024
K
kentgorrell
replied to the thread
Solved
Indexing a foreign key in the child table
.
What? Why wasn't I told? so I just iterated the index collection of a table and looked at the fields and you are correct! Thanks for...
Mar 24, 2024
K
kentgorrell
replied to the thread
Access no longer part of 365 business packages
.
When 365 went all subscription on us, the Business plans did not include Access. Only the Enterprise plans did, then after a couple of...
Mar 2, 2024
K
kentgorrell
replied to the thread
Format Condition for unbound Date controls uses US date format regardless of Regional Settings
.
Yes most of us know that date time is a number, left of the decimal point is date, right is the time (at least in Access and VBA not so...
Mar 1, 2024
Home
Members
Top
Bottom