//
Please find in the attached database the example I am talking about. Unfortunately the maximum number of groups is 10 so The main report has 10 reports. Of course you can add two reports to each group and then two reports in the form itself so you can reach 22 reports. Without any doubt there must be a way to add 23 reports but I will be traveling in the next two days so I won't be able to assist further. Anyways, here is how it...
liimra
Last Activity: Mar 4 '12, 01:18 AM
Joined: Aug 21 '10
Location:
-
Solution/
Of course I don't - You are most welcome. Yes as stated before you need different context so it becomes:
Code:DLookUp("INVNUM","INVOICE","[LatestRevisionDate] = #" & DMax("LatestRevisionDate", "INVOICE") & "#"))
Regards,
AliLeave a comment:
-
Solution/
The problem is not with the format or context but with the filters & scenarios.
This would happen if you are leaving one of the two criteria null. Usually when you have more than one criteria you have to assume different scenarios. For example If date is selected then filter based on date or If date & time are selected then filter based on them.
In order to overcome this, you have to...Leave a comment:
-
You are most welcome. Glad it worked.
Regards,
AliLeave a comment:
-
Alright
Regards,
AliLeave a comment:
-
Very strange. You should be getting the BFNAME indeed as you are looking for its value in the table WHERE the condition (last record) is met. logically speaking, there is no reason for such behavior. I will try to create something similar just now and post it here.
Regards,
AliLeave a comment:
-
You should close brackets!
Regards,Code:DLookup("BFNAME", "REGISTER", "[REGID] = "& DMAX ("REGID","REGISTER"))
AliLeave a comment:
-
Solution/
In this case you have to use different context.
Code:DLookup("[FirstFieldName ]", "TableOrQueryName", "[REGID] = "& DMAX ("REGID","TableOrQueryName")
Regards,
AliLeave a comment:
-
?
I see, and REGID happens to be Number Field, right? Note that dealing with Number Field is different than dealing with date field.
Regards,
AliLeave a comment:
-
?
I know but strongly believe in discussion and its benefits. One advantage is that your post is now clearer! For instance "complex" makes me think that you need Access because "Instant Accounts" supports only up to two users.
Back to the issue, I don't have sage at the moment to try and see but will get access to it next week as my friend uses it in his department ("50 Accounts" - think...Leave a comment:
-
?
I just wanted to offer a simple/easy to understand approach. However, it is indeed not the best approach for filtering. I didn't try NeoPa's approach but think it must be a better one.
It is worth mentioning that one good thing about Access is that even with little knowledge you can make good achievements (working around).
Regards,
AliLeave a comment:
-
Solution/
I strongly believe that this due to using tables as forms/reports recordset or recordsource. Just create queries based on the same tables (mirrors) and change the recordset of forms and reports accordingly and you are done.
The reason is that queries stay in the FrontEnd after split --> direct connection; where tables reside on the other end.
Regards,
AliLeave a comment:
-
//
Is the field "time last revised" in the same table?
Regards,
AliLeave a comment:
-
//
We are all here to help. Glad it worked for you mate.
Regards,
AliLeave a comment:
-
Solution/
You can use If Then in a way where the filter will be based on the populated fields.
...Code:If [A] Is Not Null And [B] Is Null And [C] Is Null 'set the action you want WHERE THE FILTER is [A] End If IF [A] Is Not Null And [B] Is Not Null And [C] Is Null 'set the action you want WHERE THE FILTER is [A] & [B] End If IF [A] Is Not Null And [B] Is Not Null And [C]
Leave a comment:
-
Solution/
You define the criteria as the last date.
Attach the SetValue function to the Onclick event of the button. It will populate the field with the value with the last date (MAX).
...Code:FirstFieldName = DLookup("[FirstFieldName ]", "TableOrQueryName", "[DateFieldName] = #" & DMax("FirstFieldName", "TableOrQueryName") & "#")Leave a comment:
-
//
Glad it worked for you.
Regards,
AliLeave a comment:
-
Solution/
Unfortunately I don't have any idea about such integration but why would you need this when you can create the order directly in Sage? Can't Sage do what you require?
Can you please state when you need to have the orders first created in Access?
Regards,
AliLeave a comment:
-
liimra replied to Have created a form in MS Access. When I open the form I cannot edit or add records.in AccessSolution/
Is the Query based on the table? You can't edit if they are not related as you won't be working on one record from one record set. Please post more info on the components of the query and the table.
Regards,
AliLeave a comment:
-
?
If you have date field on the form (i.e when customer joined or created) then you can use SetValue using the Max function. If you don't, then you can just enter the first field and autopopulate the remaining using SetValue (all fields will be populated with the fields where the first field matches the field you have entered).
There is one function called DLast which should work as its name indicates Last but unfortunately...Leave a comment:
No activity results to display
Leave a comment: