Recent content by Bretcutler

well i made it work.. :) Here it is if you are looking for more info. I used red green and yellow for a typical stoplight chart. Thanks for the help everyone. If DCUCapable > 4 Then Me.DCUCapable.BackColor = 65280 ElseIf DCUCapable < 2 Then Me.DCUCapable.BackColor = 255 Else...

if i were to use backcolor in the above VB how would i format it? I want to use the color's number such as 255 for red. I have been trying things like &quot;backcolor 255&quot; and &quot;backcolor vbred&quot; and nothing is working for me. So i need something else with this text or can i not...

yeah i found the transparent part but i need to be able to make the text box change to whatever color i want based on certain criteria. I just don't know if there is vb code for this or not. Something that i could put in place of the (&quot;fontunderline&quot;). Maybe this should be in vb for...

I have been able to get the fontunderline and fontblod to work with the following code. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) DCUCapable.Properties(&quot;fontunderline&quot;) = DCUCapable > 1 End Sub I need the background color to be changed though and can't...

I do not know either and was pretty sure that i had seen a way to do this in autocad 2000. It isn't important enough to get into programmming. It is just a convenience thing. Thanks, Bret

Yeah you heard me.. I would like to have it so when i plot the drawing it has a field in the titleblock or just somewhere on the drawing it has the date and time printed on it. I would like this to be dynamic obviously so that i can keep track of my revisions more easily. Please let me know if...

thanks you both, I am using 97 right now and used the first method but will be using 2000 soon and might try the second one. Thanks alot, Bret I would never have gotten that!

I want to be able to split this type of data at the hyphen. I don't want the hyphen to be included on either part. Here is a good example of a one. CA100231-01231H01X I want to be able to split it into CA100231 and 01231H01X. I am using the right and left expressions now but it isn't always...

I am using access 2000 Developer and have had a problem with a package that i have created. I install it on a computer with a runtime version of access on it, and when i try to run it i get a runtime error. I am using a form with vba code for everything to keep it simple and have the startup...

I want to use the Package and deployment wizard to make an access file to run on another computer. I have all of the code but need to use the add in and it isn't there.... I am using developer edition.. I go to add ins and there are none listed and none available to add in! I must have not...

This actually works only partly. It is odd. It shows up as selected but doesn't work unless you click on it. It is showing selected but acting like it isn't selected. I am not sure why or how to fix this. I have been playing with it in order to try to get it to work but to no avail. If you...

This actually works only partly. It is odd. It shows up as selected but doesn't work unless you click on it. It is showing selected but acting like it isn't selected. I am not sure why or how to fix this. I have been playing with it in order to try to get it to work but to no avail. If you...

I have managed to get everything working from my previous post.... I can't however get the forms list box to automatically select the control number in it. There is only one number in the list box, and the list box is named &quot;list0&quot;... I need it to automatically highlight this...

I am trying to make a fully automated, report printing Form. I have a form that automatically checks for new data every minute and need it to be able to print. The form has a list box that is where control numbers of unprinted reports are put. I then made a macro that will open the report...