Search results

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 & "'"

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

OK i ended up getting it to work. Not sure if its the proper way or not but it works for me. Read below if you care to know what i did. On my form i made an unbound text box named it numm and set default data to Nz(Dlast("PhotoNum","PhotoNumTbl"),0)+1 another text box bound to my table with...

I am already using the primary key to link two table together that have different data in them. But the photoID= format(date(),"yyyy-mm-") & does solve part of what i need. If the index isnt the primary key let me know and i'll look and see.

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