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
.
MajP's latest activity
MajP
replied to the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
.
My bigger point here is that the default for a nueric fields is 0 and that is almost never appropriate if that field is used as an FK...
Yesterday at 2:16 PM
MajP
replied to the thread
Correlation between two records of the same table
.
When someone says a procedure does not work, I am assuming that means nothing happens. (no error message) one of the first things to...
Yesterday at 12:06 PM
MajP
replied to the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
.
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 11:39 AM
MajP
replied to the thread
Correlation between two records of the same table
.
If this is the case, how would I do it? Lets say we are associating products that can be swapped out. And say it is true that if A can...
Yesterday at 3:25 AM
MajP
replied to the thread
Correlation between two records of the same table
.
It is fully make believe and not really a working solution, just a demo of some concepts. I do not even know what kind of data the OP...
Yesterday at 2:32 AM
MajP
replied to the thread
Correlation between two records of the same table
.
Hard to see and debug. I would put a msgbox here in the code. That way you can ensure the function is called, and see that the sql is...
Friday at 11:25 PM
MajP
replied to the thread
Close and reopen form to specific record
.
I am not saying that is wrong design, but it sounds suspect. usually it would be the other way. Example I have a Task with child Action...
Friday at 6:55 PM
MajP
replied to the thread
Close and reopen form to specific record
.
IF the thing you are searching for is a string you have to put single quotes around the value forms("Formname").recordset.findFirst...
Friday at 6:40 PM
MajP
replied to the thread
Correlation between two records of the same table
.
I have built so many examples and demos that I have lots of demo databases and do not have to build new things or have new ideas...
Friday at 6:39 PM
MajP
replied to the thread
Close and reopen form to specific record
.
dim ID as long 'assumes primary key is numeric adjust as necessary ID = forms("formName").PKfieldName DoCmd.Close acForm, "formname"...
Friday at 5:30 PM
MajP
replied to the thread
Length Efficiency Calculator
.
If you have not noticed this is a well known problem and many people selling solutions. If you cannot build it yourself or get online...
Friday at 5:26 PM
MajP
replied to the thread
Correlation between two records of the same table
.
Here is a simple and silly example. The concept is that you may need some robust features to find and subjectively link items. Assume...
Friday at 5:05 PM
MajP
replied to the thread
Correlation between two records of the same table
.
I will make a demo, showing a few capabilities.
Friday at 2:31 PM
MajP
replied to the thread
Length Efficiency Calculator
.
This one has the ability to import all properties from excel. Handles irregular stock too...
Friday at 2:30 PM
MajP
replied to the thread
Correlation between two records of the same table
.
That may work for you, I do not know. But scrolling thousands of products with little information may not be easy. I do not know how...
Friday at 1:47 PM
Home
Members
Top
Bottom