0

I have been working for MS Access payroll.. How can you call a query that's already made in Access inside a VBA function?

Public Function InsertAndUpdate()
    //i want my queries here for conditioning
End Function
Improve this question
0

1 Answer 1

Reset to default
0 
Dim dbs As DAO.Database
Dim rs As DAO.Recordset

Set dbs = CurrentDb
Set rs = dbs.OpenRecordset("Your_Query_Name")
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.