Recent content by Leopardfist

OK, if I wanted to do it in a different way, how could I do it? My images are all going to be in a folder titled "Pics" that is actually in the directory of the Database on my server. I have never messed with images in a DB before, so I know nothing about it. Can you walk me thru what...

I am using Access 2000 for my database, and I am wanting to know if there is a way I can create a button on my form for someone to click, that will open a browse for file window and let them choose an image to save to that file in the database. All images are in BMP format. Any and all help...

Disreguard this post, I posted it in the wrong forum, and have since reported in the Forms forum.

I am making a report from a query, and my DB contains a date. What I need on my report is that date PLUS the number of days from that date until the date of the report. Sort of like: Todays Date - Entrance Date = Number of days I need. Anyone help me with this info?

Never used CR, and figured I'd check here to see what the best how to books are before I waste my money.

Ken, I can't thank you enough for the help, I appreciate it more than I can say!!!

No, instead of a checkbox saying that yes they are desigtnated, they want a textbox where we enter the designation code. The formatting will format if the text box is NOT empty. So if the text box has "BSY" or "WCBY" it will highlight... but if it is blank it will not. Would this work...

Hey Ken, One more question.... now they are wanting it to be a text control rather than a checkbox. So essentially my expression will be if not equal to "" (not blank) then highlight. How do I write the code for that? Assume the same control names. Reports![SHU Monitor Roster...

Hey Ken... if I apply that conditional formatting to each control on the row, it would work the same right? I tried doing what you did, just adding a text control and placing it behind the other things, but I cant get it to work. The yellow covers up my text from my controls.

The DB you sent me is read only, so I cant open the code. Will the background textbox grow with the others? I think I use the cangrow option on them.

Now with that code, will it oly do it if that particular customer matches, I mean does it run it for every record and only match those that match? Also, where do I enter the code at?

That is EXACTLY what I need bro :), HOW do I do it hehe.

Ken, Basically what I need is this..... if you look at the report you will see a couple check boxes... one is titled DES. If that check box is checked (You will have to go into the form and check it in there because being the numb skull I am I deleted all the records who had it checked hehe) I...

I dont geta wizard, I get the conditional formatting window. OK, so I chose Expression is, and it gives me a line to enter an expression to match. I tried: Me.Designated = "True" That did nto work. The Designated is the name of the control, and it is a checkbox control. When I opened my...

OK Ken, What I did was delete all but about 17 records, ALL forms and reports and queries other than the main form, main table, and the report I am working on... so I got it small enough to zip up and upload to here. Once you get it can you email me so that we can discuss the intimate details...