Search results

I see, and it works really well. Thank you.

Its a single form. Thank you I will put this in and see what I come up with.

Hi, I have a form that has 2 fields. On the first field which is the date, I have my form setup that if there is no value all the other fields are disabled. Once a date is entered all the fields become enabled. Then on that same form I have a 2nd field and depending on the number entered...

Thank you June 7, I found that exact same answer after some googling. Much appreciated.

Well that is interesting, I just googled how to add carriage return to a label and I came up with another way, hold shift and press enter in between each letter.

I see, let me google see what I can come up with. Thank you for the information.

Is it possible on a report to have a label stack vertically but each letter is horizontal (see attached picture)?

This works beautifully. Thank you.

Yes currently that is what I am using. And I would prefer not to upload that original DB as it would be to embarassing, I made it so very badly.

Hi, I explained what they were for in post 23. If you need more detail than that I will see what I can do to elaborate it more. But I am thinking this post has gotten away from the original question I was asking. I am just trying to find code that will allow me to view only the most recent...

No, basically the report can look like anything I want it to just so long as I get the information on it across. I have already redone it, removed all the check boxes and just went with combo boxes that state, “Management”, “Contractor”, “Both”, or “Neither”. Next thing is I can’t seem to get...

I appreciate the effort you put into that, I will gear my setup more towards that as best as I can, thank you.

Well this might possibly get a few interesting responses, but okay. This DB is made to report up several things to higher management about contractor performance, plus it also keeps the contractors informed of what was observed that takes place each night. First there is there is the...

Ok, have a good night.

I could navigate to the specific date but the other people might not. This DB is run only on one computer, so only 1 person at a time can be using it. There is code to prevent multiple days, I just have not put it in there yet. So multiple records for each day is not possible.

I see. That is not always going to be an option as I am not the only one using this. So maybe an extra query might be the way I have to go.

Ok, I see what is happening. I made the changes you recommended and it still gave me the same error as before but for the D_Date part now. But what happens is if I go ahead and put a date in the date field, it will open the report and show that record. I need it to show the last record of the...

Ok. Please don't judge.

I did see the one about Me.Dirty, this is a date field.

Well the report is opened using a button from a form. So I am using the onclick part. So I am putting this specific code in: DoCmd.OpenReport "rpt_DailyCoversheet", acViewPreview, , "txtDate=#" & Me.D_Date & "#" But I am getting the following error: Run-time error '3075': Syntax error in...