Search results

I have a simple query. I made a IIf statement that includes a Dlookup. Before I added the Dlookup, all was fine. I added it in & it works! Wonderful! But when I hit Run, I get the attached error message. I click OK and it goes away. It even gives me the correct data. I have Access 2010 since...

I have two separate reports. They have identical formatting. When I click on Adobe: Convert to PDF, this is what happens. Report 1 will convert with light blue in the column headers. Report 2 will convert with grey scale in the column headers. I have no clue as to how to make them both...

I have a very strange question. Last week I had a Adobe PDF selection at the top of my Access database. It is gone. I still have it in my excel selection, so I know I did not delete the program. I need it back. When I Print to Adobe it is missing lines. This did not happen I I would click...

I have a simple query that can edit the main table. I built a form around that simple query. When you open the form: it asks for a name & then a date to be edited. All works. I have a save command button and a close command button. All is good. I would like a “red explanation point” command...

Thanks to all your help! I am almost done with this monstrosity! :D My boss would like the Time Out field in my table/form to default to a PM time. Right now, when you enter Time In - it defaults to AM (ie: if you type in 9:00 - it enters 9:00AM, which is correct). But when you enter in...

I have: Option Compare Database Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Overtime = 0 Then Me.OT.BackColor = vbBlack Me.OT.Visible = False End If End Sub And it is working, but: I need 5 other statements like this that are not contingent on each other. If...

Does anybody know of a thread or anywhere on the interweb :) that gives steps/ help to build a simple timesheet form. With dates too. Sunday Monday Tues Wed Thurs Fri Sat Name Time in Time in Time in Time in Time in Time in Time in...

I am trying to make a form for a timesheet where you put in a Week Ending date and the corrsponding dates for Sun thru Sat list down so 1 person can add in their time in and time out...etc. So far, I can only get 1 Sunday date in...I am not good with forms. I have an excellent query and multiple...

I have 2, 4 page report. I would like 1 report to be numbered 1,3,5,7 and the second to be numbered 2,4,6,8. I cannot use the subreport because the pages are a maximum. It changes all my formatting. Is there a way to make it number by odds or evens? Jessa

I Have a report that has: Title PP1 PP2 PP3...2012Total 2011Total Diff I Just hit PP20. (PP stands for Pay Period. We have 1-26 in a year.) I am on the largest paper setting. The diff column is now cut off. My boss wants me to have Title PP1 PP2 PP3... to PP 13 on one page Title PP14 PP15...

I have 2 queries (let's call them A & B) base on two seperate Tables I have a 3rd query (C) based on a third table (same info as A & B combined. I have a 4th query so I can compare the Overtime info between the two queries. I used the #3 join like this. soc sec # in A joined to the soc sec...

I need to compare 25-24. I tried doing this in my crossstab querry. I also tried importing my crosstab into a new querry and it did not work for either. I used =sum([25]-[24]) and it says "subqueries cannot be used in the expression (sum([25]-[24]))" This is my sql: SELECT DISTINCTROW...