Search results

Hey everyone. I need some help with displaying totals in the header on a continuous form. I am working on a project to keep track of how many people enter and exit the building each hour every day at 4 different entrances. Table has the following columns ID, c_date, hours, entrance1_in...

Hey everyone, I need some help with making a report. I have 3 separate non related tables that need to be placed into one report. So I made a report (Let’s call it master_rpt) with three sub-reports (subA, SubB, and SubC). Each of the three sub-reports are based on a date range query that the...

I am having trouble running a query with vba. I can click the query on the left had side and it works perfectly. But when i try to run the query using a button on a form it does not work and gives the error "Object variable or With block variable not set". more detail of the form What i have is...

Hey guys, I have a project i am working on and needed to create a way to transfer the data in a table to another file. I got it working with the following code Private Sub Transbtn_Click() Dim dbs As DAO.Database, strsql As String Set dbs = CurrentDb strsql = "INSERT INTO [table1] ( [Date In]...

Hello everyone. Let me first apologize if I do not use the correct terms for things. I am new to access and have made only a few databases buy just figuring them out or with countless hours searching forms like this one for solutions. I a not very savy with VB terms and such and most of the time...