Recent content by HimAgain

I did figure out a work something that works DSum("[hour_in]", "pass_count_log", "[cur_date] = date() AND [hour] between #7:00:00 AM# And #3:00:00 PM#") But i'll still correct my table info instead of using this.

hmmm ok i'll work on it some more. I guess i am trying to make it look to much like an excell spreadsheet. below is what my table currently looks like. don't laugh.. to hard.. column headers ID cur_date hour entrance1_in entrance1_out entrance2_in entrance2_out entrance3_in entrance3_out...

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...

Ok How about this. For your TOC in the report header, make each link a button (make the button flat or what not if you want it to look just like text). Then make an on click event to set focus to the first control in each form you want to link to. Private Sub rep_link_1_Click()...

worked perfectly. Thanks!

I have no clue. I just did a search for ms access report bookmarks and that was the first thing to pop up.

DOh... sorry about that.

Glad i could help.

Found this on the net. Below is the link to the article along with a copy paste of the article. Hope this helps from technet.microsoft.com/en-us/library/ms159823(v=sql.100).aspx How to: Add a Bookmark to a Report (Reporting Services) Add bookmarks and bookmark links to a report when you want...

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...

That's what i was going to end up doing if i couldn't get this to work, but this was just one of those things i was banging my head against the wall to figure out.

That fixed it. Thank you everyone that helped.

Thanks for the reply. Yeah i figured out using symbols in table names and such was a bad idea and plan on changing it soon. I tried your code out but it still gives me the same error "Object variable or With block variable not set". oh and it is text. After i get it working i'm going to add...

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...

Figured it out.. was one search away.... IN '" & strdest & "'"