Rob,
One other thing: Consider reducing the level of encry to speed things up. I realize this will reduce security, but really many folks don't need tripe DES and it's a lot of overhead.
You may find a considerable improvement by using DES.
Of course igore all this with your already...
Rob,
I've got a client with two FVL328's. I don't have as many connections as you, but wanted to suggest that you should update to the lastest firmware update (rev 30).
I've been working with Netgear tech support off and on for the past several months. They were aware of the slowdown and...
Should be:
If Me![WorkDay1] = 0 Then
Me![WorkDay1Reason] = Me![WorkDay1Reason].ItemData(0)
Else
Me![WorkDay1Reason] = Me![WorkDay1Reason].ItemData(6)
End If
Jim.
Actually, you can use the default value property, but you must use a fully declared reference:
=Forms![myFormName]![myComboControlName].ItemData(0)
Jim.
Hum... that should be fairly fast. Contrary to popular belief, DCount() can be faster then other methods and in this case, I think it would be.
You do have the holiday table indexed on the date correct?
Jim.
As has been said, there is no Decode() available. However you can write any custom function and call it from a query, so you can get equivalent functionality. In a query, you'd define a column as:
NewName:SomeFunction([arg1],[arg2],...)
The only requirement is that you must pass a field name...
Strange. First go in and check any reference. Close the MDB and Access. Now reopen and uncheck the reference you just checked. This will refresh the references again. Now try a compile. Still errors on the DIM dbs as Database?
If so, reregister the DAO lib by following step 1 in the MSKB...
Yes it's possible. But a little more detail is required. How do you indicate that a order is delivered/undelivered? And do you have a form for the user to change the criteria (ie. a checkbox for undelivered only)?
Jim.
THe default data lib for A2000 is ADO. Open a module in design view, click tools/references. Uncheck the ADO reference. Then scroll down and find "Microsoft DAO 3.60 ...." (it's close to that - don't remember the workding exactly - just look for "DAO") and check it...
Actually, because you used SUM(), which is used in conjunction with SQL and queries. So yes, it only works on bound controls. Instead do this:
=[Text1]+[Text2]+[Text3]
Jim.
What's hurting you is the DCount() for the holidays. Your testing each and every date to see if it's a holiday.
It would be much more efficent to get ALL the holidays between start/end dates with one recordset, loop through them and total, rather then checking each date to see if it's a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.