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
.
Pat Hartman's latest activity
P
Pat Hartman
replied to the thread
tables and relationships for members of a club database
.
If you want to retain history of who held what post, when - you have a many-many relationship. That requires three tables tblMember...
Yesterday at 11:18 PM
P
Pat Hartman
replied to the thread
Renaming database Front End and BackEnd
.
There shouldn't be any VBA that refers to the previous name. The BE is linked. So, if you change the name of the BE, you will get an...
Yesterday at 10:58 PM
P
Pat Hartman
replied to the thread
Update Query
.
For a recordset to be updateable, EVERY part of the query must be updateable. Therefore you cannot create a query that sums a column of...
Yesterday at 8:57 PM
P
Pat Hartman
replied to the thread
Problems with code execution following email
.
Why would you leave If's dangling without end if's? Does the code even compile this way? Have you stepped through the code to see...
Yesterday at 8:50 PM
P
Pat Hartman
replied to the thread
Correlation between two records of the same table
.
@Faoineag The people on the forum who are most likely to help you speak English. Your best option for help is to use Google Translate...
Yesterday at 8:46 PM
P
Pat Hartman
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
I've posted regarding that flaw on multiple occasions.
Yesterday at 7:12 PM
P
Pat Hartman
reacted to
moke123's post
in the thread
Origin of phrase "Banana Republic"
with
Haha
.
About 12 Ounces. ;)
Yesterday at 7:10 PM
P
Pat Hartman
replied to the thread
The Law Perverted
.
Given the way the left pushes abortion, you're lucky to have any grandchildren. Then there is the push to legalize drugs so that people...
Yesterday at 7:09 PM
P
Pat Hartman
replied to the thread
Origin of phrase "Banana Republic"
.
Notice how they carefully avoid the use of lawfare against the evil orange man. Wikipedia sucks. They've gone down the same dishonest...
Yesterday at 7:06 PM
P
Pat Hartman
replied to the thread
Query return max value
.
No, it is not properly normalized. You are experiencing that by the problems you are running into trying to use the data. I have...
Yesterday at 6:47 PM
P
Pat Hartman
replied to the thread
SSMA_TimeStamp field never gets updated
.
Did it peak your interest sufficiently to look at one of your existing BE's and see if you had duplicate indexes for your FK's? If you...
Wednesday at 8:57 PM
P
Pat Hartman
replied to the thread
Query return max value
.
It is never too late to fix a design flaw like this. All you will be doing going forward is working around the way your data is stored...
Wednesday at 7:32 PM
P
Pat Hartman
replied to the thread
Solved
How to use ME in a public function
.
Me. refers to the current form or report object. When the code is running from a standard module or a standalone class module, no form...
Wednesday at 7:13 PM
P
Pat Hartman
replied to the thread
Search comboBox on a bounded form
.
The value property of a combo refers to the BOUND value, NOT the visible string which comes from the RowSource query. It is also NEVER...
Wednesday at 7:06 PM
P
Pat Hartman
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
Or, you could use the MSysObjects table in a query that uses the object type values that I posted.
Wednesday at 6:52 PM
Home
Members
Top
Bottom