Here is kind of long way to extract the info you want
A B
2 Day/Current
Month Calc =IF(OR(A5=4,A5=6,A5=9,A5=11),30,
IF(A5=2,28,31))
4 =YEAR(NOW()) =YEAR(B12)
5 =MONTH(NOW()) =MONTH(B12)
6 =DAY(NOW())...
wemeier:
We are getting close. I pasted the first code for "recordset", but it appears to be missing something. It hangs up at "set rst = Me.sfrRates.RecordClone". It says there is a Compile Error - Method or Data Member not Found and the "sfrRates" is highlighted.
Any ideas
Rick
I am trying to build a database to keep track of workers hours and prepare multi-year billings to client and am having problem with getting a default value into a subform.
Have 2 tables
tblLaborClass with
ClassNo pk
ClassName
tblLaborRate with
RateID pk
ClassNo
RateStart...
I am trying to build a database to keep track of workers hours and prepare billing to client, but am having problems getting the tables to enter default values.
Have one table
tblLaborClass with
ClassNo PK
ClassName
Have second table
tblemployee with
EmployeeID PK
LastName...
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.