I think we are talk about the code as a whole I get it partially solved step by step now by your right recommendations and I need to complete it till end
thanks million
User Profile
Collapse
-
all fields joined in tables are matched but I still have problem in select syntaxLeave a comment:
-
Join Query Syntax Error
the problem now is here
...Code:sqlstring = _ " SELECT payed2.payroll, payed2.amount, " & _ "payed2.type, payed2.page,payed1.datee, " & _ "personal.email, personl.name, " & _ " FROM ((payed2 INNER JOIN payed1 " & _ "ON payed2.page = payed1.page), " & _ "INNER JOIN personal " & _Last edited by zmbd; May 20 '14, 10:36 PM. Reason: [z{stepped the code, added a ";" as best practice}] -
ok
scode is text box I searched in it about page " number" to limit set of recordsLeave a comment:
-
I changed it completely and now i have problem " data type mismatch in criteria expression " at
Set rest = mydb.OpenRecord set(temp, dbOpenDynaset)
...Code:Private Sub Command2_Click() Dim mydb As DAO.Database Dim rest As Recordset Dim temp As String Dim mpayroll As String Dim mpage As String Dim sqlstring As String Dim qdf As QueryDef Dim reset As Recordset Dim mmail
Leave a comment:
-
-
problem now "data type mismatch in criteria expression"
thanks for replying
the problem now "data type mismatch in criteria expression" -
"syntax error " here
Code:rest = "SELECT payed.payroll, personal.namee, payed.type, payed.amount, personal.email, payed.datee" &_ " FROM payed inner join personal ON payed.payroll = personal.payroll" & _ " WHERE payed.payroll = mpayroll and payed.datee = mdatee" & _ " ORDER BY payed.payroll"Leave a comment:
-
send email on query (individual)
need to send email based on query (specific record) to specific one
I have erorr " object required " and " Object variable or with block variable not set" I do not know what is the problem
please some help
thanks
code here
...Code:Option Compare Database Private Sub Command0_Click() Dim mydb As DAO.Database Dim rst As DAO.Recordset
No activity results to display
Show More
Leave a comment: