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
.
GPGeorge's latest activity
GPGeorge
reacted to
mike60smart's post
in the thread
Solved
New Record
with
Like
.
Why not just use a Main Form and Subforms?
Yesterday at 3:15 PM
GPGeorge
replied to the thread
Solved
New Record
.
Thank you. I think the most effective way to do this is to design data entry as a main form bound to the Client table, with two...
Yesterday at 3:15 PM
GPGeorge
replied to the thread
Hide System Tables When Connecting To SQL Server
.
Perhaps, if this question is asked in the context of an end user, and not the developer, it would be better not to allow the user that...
Yesterday at 3:12 PM
GPGeorge
replied to the thread
Solved
New Record
.
Show us the fields in these tables and the relationships between them please. I think the problem is starting to look more like a table...
Yesterday at 2:28 PM
GPGeorge
replied to the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
.
Agreed and enthusiastically supported. I think, based on nothing more than intuition and healthy skepticism, that the default of 0 was...
Yesterday at 2:25 PM
GPGeorge
replied to the thread
Solved
New Record
.
Please explain the context more fully. Please refer to Primary Key, not just "ID", if that is what you mean. Or explain what "ID" is if...
Yesterday at 1:45 PM
GPGeorge
replied to the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
.
There are two ways to interpret the claim that a value in a Foreign Key field is optional. One, the way I would normally expect to see...
Yesterday at 1:41 PM
GPGeorge
reacted to
MajP's post
in the thread
Correlation between two records of the same table
with
Like
.
Here is a simple and silly example. The concept is that you may need some robust features to find and subjectively link items. Assume...
Yesterday at 1:26 PM
GPGeorge
reacted to
MajP's post
in the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
with
Like
.
One problem is now a numeric fk defaults to zero unless you change it. Do not know why they just do not set the default to null.
Yesterday at 12:49 PM
GPGeorge
reacted to
gemma-the-husky's post
in the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
with
Like
.
Yes, but unless there's special circumstances, I don't believe you would really want a record in a sub table without the reference to...
Yesterday at 12:46 PM
GPGeorge
replied to the thread
Hyperlinks not working in printed report
.
Sure. DoCmd.OutputTo ObjectType:=acOutputReport, OutputFormat:=acFormatPDF, ObjectName:="YourReportNameGoesHere"
Thursday at 5:31 PM
GPGeorge
replied to the thread
SSMA_TimeStamp field never gets updated
.
There are further developments forthcoming. I'll wait for Pat to weigh in. However, this screenshot is relevant to that further...
Wednesday at 1:57 PM
GPGeorge
replied to the thread
SSMA_TimeStamp field never gets updated
.
You're getting there. It took me a while to come around on this one. :cautious: I always remove the autoindex code words because they...
Tuesday at 10:35 PM
GPGeorge
reacted to
Pat Hartman's post
in the thread
SSMA_TimeStamp field never gets updated
with
Like
.
Sorry to be so persnickety but there have been so many red-herrings thrown into this discussion that are totally irrelevant, I couldn't...
Tuesday at 7:28 PM
GPGeorge
replied to the thread
SSMA_TimeStamp field never gets updated
.
I've seen similar names generated in SSMS when creating indexes as well. Sorry I was not clear that I was referring only to the naming...
Tuesday at 7:27 PM
Home
Members
Top
Bottom