I have two cross tab queries.
qry_PayCrostab which sums the wages
TRANSFORM Sum(Tbl_FTEallocation.Wages) AS SumOfWages
SELECT tbl_Dept.DpName
FROM tbl_Revenue INNER JOIN (tbl_Dept INNER JOIN Tbl_FTEallocation ON tbl_Dept.DPID = Tbl_FTEallocation.Dpid) ON tbl_Revenue.revnum =...
i have this form where i can input data.
tabbing and auto fill option from combo box is
making the process pretty easy.
one question though, when im entering data, certain
fields are same as the previous input.
is it possible to set the Default value as something like
Previous Data()??
i have just few update queries that runs afterevent of a command buttong.
ie. docmd.OpenQuery "qry_Total"
docmd.OpenQuery "qry_Expenditures"
docmd.OpenQuery "qry_Balance"
for some reason, queries are not updating the current
values on the form. At first, I thought the queries
are...
How do I use DLookUp to find the next number?
ie.
tbl_PSC
contractno | addendumno
test00 | 00
test00 | 01
I have a form "frm_PSCupdate"
I have a combobox where user can select the contract they want to update.
if they choose "test00" from cboContNo
i want...
I've previously posted a coding that i thought it'll work.
I've just thought of one problem
Dim DB As DAO.Database
Dim RS As DAO.Recordset
Set DB = CurrentDb()
Set RS = DB.OpenRecordset("tbl_PSC", dbOpenDynaset)
Set bs = DB.OpenRecordset("tbl_PSCtx", dbOpenDynaset)
If Me.txtContractNo =...
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.