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
.
CJ_London's latest activity
C
CJ_London
replied to the thread
Length Efficiency Calculator
.
Think you have to clearly define the overall objective. Is it to reduce waste or reduce stock? Is it to be considered on an order by...
22 minutes ago
C
CJ_London
replied to the thread
Mandatory FK values? "You cannot add or change a record because a related record is required in table"
.
Assuming you have defined the relationship then the FK field has to have a matching parent, or is set to null - which is not the same as...
38 minutes ago
C
CJ_London
replied to the thread
Solved
How to use ME in a public function
.
If you used a public function rather than a sub, per post #3 change Public Sub CloseForm(frm As Access.Form) To Public Function...
Wednesday at 11:14 PM
C
CJ_London
replied to the thread
Solved
accdb v accde
.
suggest put some msgbox’s to display variable values so you can check the accde ODB does not seem appear to have been declared or...
Wednesday at 2:23 PM
C
CJ_London
replied to the thread
Solved
Query with multiple criteria
.
if you remove all the brackets and replace just around criteria 2 (the OR) I would expect it to look like this SELECT [App Data].[Regi...
Wednesday at 9:05 AM
C
CJ_London
replied to the thread
Solved
Query with multiple criteria
.
In that case, implies you don’t have any data to fit the criteria
Wednesday at 8:32 AM
C
CJ_London
replied to the thread
Solved
Query with multiple criteria
.
Have you tried using the query builder - looks like your brackets may be incorrectly paired. or remove all the brackets and just...
Wednesday at 8:07 AM
C
CJ_London
replied to the thread
Solved
Show all Records on zero/null etc
.
the nz function only works with null, not 0. Your union query uses 0 so discard the null approach it doesn't matter - your criteria...
Wednesday at 12:43 AM
C
CJ_London
replied to the thread
Solved
Show all Records on zero/null etc
.
Either add one in or use a union query as you mentioned in your first post
Tuesday at 11:58 PM
C
CJ_London
replied to the thread
Solved
Show all Records on zero/null etc
.
You now have 3 options to try
Tuesday at 11:49 PM
C
CJ_London
replied to the thread
Solved
Show all Records on zero/null etc
.
another alternative if the combo 'All' value is null WHERE YourField = nz([forms]![frmMain]![cboWorkSlips],YourField)
Tuesday at 10:04 AM
C
CJ_London
replied to the thread
Solved
Show all Records on zero/null etc
.
Describing what you have is vague- show us. What is the sql to the query that references your combo and what is the sql to your combo?
Tuesday at 9:00 AM
C
CJ_London
replied to the thread
Max Query Join
.
other considerations - are the fields being linked on and sorted indexed? I doubt it - the first query wont run until the second query...
Monday at 12:00 AM
C
CJ_London
replied to the thread
Solved
Caching recordset in MS Access VBA
.
not sure where you are getting your idea of a discoonected recordset - see this link for an example...
Sunday at 11:59 PM
C
CJ_London
replied to the thread
Solved
Caching recordset in MS Access VBA
.
You are talking about a single recordset, not the whole app. Ado won’t work for reports and for forms, the default filtering and sorting...
Sunday at 8:58 AM
Home
Members
Top
Bottom