Search results

Is there a way to draw a border around a whole bunch of different fields on a report, so they look isolated and grouped together. The only way that I thin this is doable is to draw 1 line at a time (4 lines, making your own border), so I wanted to check here to see if anyone knows of a better...

Yes, that did the trick. Thanks so much!

I did try this: DCount("[Project_ID]", "qryrptProjectInfo", "[Completed_YN] = 'N'") and it worked. Thank you for all your help!

I can never get this right and it's frustrating. I have a field on the form called OverallProjectStatus - it's a combo box and it has values: green, yellow, red. If a user selects green as a value I would like BackColor of the form to turn green color. I tried both before update and after update...

Thank you, that worked.

I'm trying to figure out how many day are between now and a date on my form. I've done a search, but I can't find much that talks about DateDiff(). Here is what I have so far and it's not working. I'm typing this value into a text box on a form. =DateDiff(Day,Now(),"ASSIGNED_DATE_TIME") I want...

I'm thinking somewhere in a txtbox and this is what i have so far: DCount("[Project_ID]", "qryrptProjectInfo", "[Completed_YN] = 'N'") something like that?

I'm going to put this data on a report. So many projects completed________ so many project have not completed yet ____________ Also, how would do I do a count query? Create new values in it?

I have a field on my Project form(form is based on a query) which is called Completed (Y/N). It holds values Y and N. I’m wondering if there is a way to count how many Projects completed and how many didn’t. I’m not sure how to count just Ys and then just Ns. Any help would be appreciated. Thank...

Thank you, that worked. I did have a relationship between project tbl and staff tbl in my main report query.

I’m trying to create a report with a subreport. Main report is a Project report, with project info and subreport is a staff report tied to that project. I linked by Project_ID which is a PK in my main report and FK in my subreport. What I need help with is that I get duplicates of the main...

I’ve attached a sample db that scouser has helped me with the past. On the form frmStaffActivityDetail there is a Before_Update event which contains a DCount statement: If DCount("ID", "qryStaffActivityChk", "ActivityStartDate = Forms!frmStaffActivityDetails!ActivityStartDate AND StaffID =...

Thank you for posting. Do you think that something like this code would work? I can't really program that well, so I need some help with this code, but I think that code would probably run faster than a query would. Dim rstOrig As DAO.Recordset Dim rstNew As DAO.Recordset Set rstOrig =...

You won't loose this one to "Ditech."

I have a DCount() statement that checks to see if records (in a qryCheck) meet that condition. I have it where if DCount(…) > 0 then do something. What I would like to be able to do is to display all records where conditional DCount() check = 0 on a certain form. Is this at all possible? I can't...

Thank you! That works great.

I have a billing date on my form. Each billing date should be on the 15th of any month (1/15 or 2/15 or 3/15, etc…) Is there a way to default a day to the 15th and then make the user enter month and year? Or if there is no way to default the date to the 15th, may be there is somehow I can check...

You're right... This will not work for what M8KWR needs. Sorry.

There were many posts here about password protecting a form - here is an example of one. If this example isn't good enough, search these forums for another one.

Thanks...that's very useful!