Search results

We have a chart that is showing jobs by customer. I'd prefer it be in a pie chart but it's way too many to read. We changed it to a bar which is much easier to read but it displays the percentages as 100% for everything. I cannot figure out how to change it. Can someone please help me with this?

I am creating a report from a database we have. Each item has a product code. I want to list each product code as one item on the report and then it display the average number of days it takes to design that product code. I have a field that has the product code as well as the days for each...

That got it! Somehow it had the correct heading in vb but it wouldn't take. I blew it out and placed it back in and magic! Thanks for all your help!!!

That worked perfect. I finally understood and my novice self finally caught that there was a disable check box in there. Now the only thing is that I have some code in the on click event that says me.release_to_prod_date.value = date and it will not populate the date... I had it working this...

I saw the attachment but I wasn't sure what else I needed in there. Basically saying that if [released to prod date] <> "" then release button is disabled else enabled. I am still very green with the conditional side of things.

I read about the text box to look like a button trick but couldn't figure out how to code it in conditional to disable it. I am open to either way I just cannot figure out for the life of me the code for them.

I thought I had read you couldn't use conditional formatting to disable a button???

So I have a continuous form and I have a button that is pressed when a job is released and it record a date in a field. I wanted to turn that button to disabled after pressed but after lots of reading found that it couldn't be done in a continuous form due to it disabling all buttons :banghead...

I have 2 dates that I need to count between. Easy enough just use the datediff right? Nope cause it won't count just the 5 workdays. I researched and found that the "w" in the function doesn't work the way I need it to. I found lots of code to make a module that will do it for me and they all...

Got it! Thanks!

I have 2 dates. A released date and a due date. The first half compares them and sets the on time to either on time or late. That part works good. But we have some jobs that have a due date but we haven't released yet. The released is a blank value and I want it to look to say if released date...

I looked that function up and gave an attempt at it but it still didn't populate those fields. The expression I used is as follows. On Time / Late Eng: IIf([Released to Prod]<=[Prod Due Date],"On Time",IIf([Released to Prod]>[Prod Due Date],"Late",IIf(Nz( [Released to Prod] ) and [Prod Due...

I have a query driving a report that fills in the on time or late based on comparing the release date to the production due date. The code works except for if we haven't released it yet and the release date is void. I need it to then check versus today's date and then populate the late/on time...

That is correct Linq. That is exactly what I need it to do. I set it up that way and it now functions correctly. Thanks again for everyones help. Chris

So I tried the code in the approval box, one that someone has to enter data in, and it fired. It seems that due to the fact that the duedatetxt box is populated by the software, it won't fire off the after update command. I would have thought that it would have updated anytime the duedatetxt box...

I added it to the after update of the duedatetxt box and still no results. That is what is puzzling is the fact that it shoul be firing and it is not. That is what made me think there was something wrong with my code but the code we have put in is nothing complex and should work with no problems.

Sorry the validation rule was a mistype. I changed the code as you said and it will still not populate the box. I can put the code in the click event for the form but it will only update if I click the arrow that spans vertically down the side of the form.

Let me start off by saying I am new to this so go easy on me. I have a form that I cannot get to act like I think it should I have a date (duedatetxt) that calculates (=DateAdd("w",14,[Approval Date])) off of an approval date (Approval date). Now I have a text box (text25) that I use as a status...