|
Hi!
I took the routine from Gastronor.mdb:
In the frmOrderDetails -> ITemID_AfterUpdate:
Dim strFilter as String
strFilter = "ItemID = " & Me!ItemID
but it didn't work on win 2000 with access 2000. However, after
playing around for a while,
I found: Me!UnitPrice = ItemID.Column(2) to work just fine, even after
updating prices in
the tblItems. Anybody knows why?
The routine in win 98/win nt in the footer of frmOrderDetails:
=Sum((Price*Amount*(1-[Discount])/100)*100))
didn't either work. After testing and trying I finally discovered that
=Sum(Price*Amount*Discount) does the job on win 2000. ????
What is happening? Anybody know if there is a major difference in this
thing from
win98/win nt to win 2000? (I should maybe say that I'm working only
with DAO 3.6)
Questions:
1.I have my own four buttons on frmOrders
(btnGoToFirst,btnGoToPRevious,btnGoToNext,btnGoToL ast).
How can I disable them: when user click GoToLast and comes to last
order and I wish that
btnGoToNext and btnGoToLast should be disabled, and similarly with the
first record?
Anybody know an article on this?
2.I have two invisible fields on the form.
I=chkWritten and II=chkCreditMemo
In the cmdWriteCreditMemo I want to check whether I and/or II is
checked. Because the user
should not be able to print a CreditMemo if either he forgot to print
an invoice first,
or if he already sendt both invoice and creditmemo to printer. I have
been trying:
if (Me.chkPrinted.Value=False) AND (Me.chkCreditMemo.Value=False)
then
MsgBox "You have not printed INVOICE YET!"
DoCmd.CancelEvent
ElseIf (Me.chkPrinted.Value=True) AND
(Me.chkCreditMemo.Value=False) then
......
To me it seems very logical, but nothing keeps happening when fireing
the event. You have
a commentary on this?
I've been playing with other variations too, but out of respect for
the community I'd
better leave You without knowing.
3.Finally I want to set reference to the different type libraries in
code, instead of
using 'Tools -> references' in the VBA Editor. Where do I find some
code examples on this,
because the one in the help-file didn't give me any hint.
Well, I thank You always for Your willingness and eager to give good
comments. I think I
have progressed as a "programmer" by participating here.
Kind regards,
Me.Name
| 
