Search results

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...

Let me make a copy of my DB Ken and delete most records so it isnt so big. I hope it doesnt exceed max file size limits. Now my example is nothing like what I need hehe. But I can tell you exactly what report I need and what I need done to it, which may even be easier on you. Gimme a few...

I'm trying to do the same thing basically. My question is, with that code, I need it to check the condition on each separate record that goes onto the report. For instance the first customer is Joe, and he is a VIP Customer, so I want to highlight his name and address, but the next customer is...

I read thru that post, but it really doesn't help me on my issue. I think the difference is that I need my conditional formatting to apply only to those records which meet the standard. Also, I want the entire row of data to be highlighted, not just the field for which the conditional...

I'm not sure what you mean. I know absolutely nothing about conditional formatting. Can you walk me through the steps to check what you need me to check?

Below is a description of a report, and what I need to do to it. I know I can use conditional formatting to do it, I just dont know how to code it. Report: Each row consists of a member and lists the following info... Name Address Phone Superclub Member(Y/N) VIP(Y/N) Now, what...