Search results

Yes it's very Possible! You can do it in the code behind the form. If ([Yes/No Field]= -1) then Me.FirstName.forecolor = 255 Else Me.FirstName.forecolor = 0 End IF

In design mode of your report, on the properties of your textbox find format and choose currency :)

Hello all, How can I prevent the user not to print the form at all. Some users don't realize that when they are looking at the screen and they click the print, it will print whatever they are looking at. I just want to find a way to either grey out the print button or give the a message that...

Is it possible to do it in a form and then take that edited picture in the report?

Hello everybody, I have a report that has a picture of a car on it. I want to make this report interactive. I want the user to be able to access the picture of the car and make notes on the car or circle damage on the car or any other scribbles they want. Then I want this edited image to be...

I already did that, I just forgot to Exit Sub. It is working just perfect now. Thanks again for your help. :) :D

If I have 5 words in the text box, the code will delete them one by one when I click my undo button with the code you gave me. The problem occurs when I delete the very last word and that message comes up. I did put my own error message to prevent that message to come up, but if there is...

Thank you very much, it worked. But it gives me an error message when it is trying to delete the very last item. "Invalid Procedure call or argument" Thanks again :)

I am using 2002 version.

Hi everybody, I have a form that has buttons on it just like a keyboard and when I click the letters it sorts out a bunch of words and then I choose the word to put in a text box. Let's say that I put in "Queen Size Bed, Bedroom damaged". Each words that you see here is choosen out of my list...

Thanks everybody :)

Thanks for your reply. I have used this code also before, but I want to access the internal clock of the computer!

How can I access the internal clock from a button on my form? You know the clock where your double click on your time on your computer and it pops up. I just can't find it to call it! Does anybody know where to access it? Thanks

Thanks Mike for you help :)

I have already done something similar to what you were talking about, but what happens is when I click my button the number is written into the text box but it gets replaced when the other buttons are pushed. I also don't understand what you mean when you say I end up with text. Can you...

How can I make a number pad to input numbers in my textbox. For example if I push 1 and 3 and . and 9 it would input 13.9 in my textbox. I don't want to calculate anything, just strickly inputing numbers. Thank you in advance

Try this: "I am interested in buying a "&[YR]&" "&[MAKE]&" and understand that you may have one."

Try making another query out of your crosstab and the baseQry and take your critaria out of your baseQry and put it in your new one. That should do the trick:)

I think I completly missed your question. The report that I was talking about should be made in Access not word. If the report is made in Access, them it can be imported to word.

First, you have to remember that Access is not a word processor! Second, make a report the way you want using lables to put all your wording, then for each of the information that you have in your table make a text box. Let me give you an example: [Date] [CustomerAddress] [CustomerCity]& "...