Search results

I have 3 tables that are connected in a query by an ID number. Everything works well except that I get back 3 duplicate records instead of just one record. I attempted to try to fix this error by adding a group by first to one of the unique fields. However since I have a parameter up to prompt...

I am trying to figure out how to apply a filter using a button on a report so that when someone clicks the arrow it filters the query populating the report to the previous month or the next month of the current month on the report. I have it so that the report opens up to the current month. I...

If you can let me know how to hide textboxes on a report while in report view I would be very greatful. On another report I have have a code for it but it only hides the label when you print the report and still shows it while it is in view. Private Sub Detail_Format(Cancel As Integer...

I uploaded a picture of how I would like the report to show up. Is there a way for this report to be filtered for each month without having to create a new report for each month? I'm not sure if that makes sense.

Thank you, that helped a lot. I am still kind of stumped as to how to write a report to show this according to month without having to make each one. Is there a way that I could add the day under the date?

Yeah that is what I am looking for. I will have to try what you suggested when I get back on Monday I am about to leave for the weekend. It sort of worked but not really. This is what I ended up with. TRANSFORM Count(ProductionVacationTimes.Reason) AS CountOfReason SELECT...

I am not sure if this should be under this or under queries. :confused: However I am trying to make a report that shows the person name down the side and across the top has the dates of the month. Next to the persons name under the date it would have why they are off that day. I have attached...

Is this what you are trying to do? I changed the report so that it only cycles through the current record, and then I added a where condition on the open report button. Where the query StationID = the form StationID.

Re: Lable Visibility basied on Field value Okay, thank you :)

Re: Lable Visibility basied on Field value Is there a way to have it work in Report View also?

Re: Lable Visibility basied on Field value Okay, I fixed the spelling on the report and code so that they should be correct also.

Re: Lable Visibility basied on Field value Okay, give me a moment to make that. Thank you, even with just the ones above that it wasn't working though. I will fix it though.

Re: Lable Visibility basied on Field value How do I make a db sample small enough to post on here?

Re: Lable Visibility basied on Field value No, they are just labels.

Re: Lable Visibility basied on Field value Yeah, they are all yes/no fields.

I have a report (in access 2007) that has labels on the bottom where certain people need to sign once the report is printed out. I am trying to figure out how to make it so that only the labels that have been checked for that record show (since not everyone will need to sign all the time). Right...

Okay, this is the code might help then:

I know in 2007 & 2010 you can with buttons or even turn a label into a hyperlink (both inside and outside of the database). Do you want them just to open up those sections or do you want them to open the report to a corresponding record?

Access 2007, it I haven't had an issue with it with any of the other forms I have made. Ah I think my issue had to do with me trying to use a label to form the Save process, when I made it a regular button it worked.

I am trying to figure out why on one of my forms when saving if the user doesn't click off of the last textbox it won't save the value they entered. this is the first time I have encountered this problem. I have made many different forms and never had this issue before.