Search results

is there a way to do conditioinal formatting based on one field value and have it affect all the fields for that record?

how would you set up the conditional formatting. do you mean just using if statements in VBA or something else?

I have a CONTINUOUS form that shows all my records. I want it to change the back color of a field when it is a certain value. so far i get it to change back color when the very first record in the list is a certain value, but then it will change the back color for every value and not just one...

This may just be a MS XP thing, but when I open my Database it gives a series of 3 prompts to open the database. The first is a security warning for unsafe expressions, do i want to block them or not, the second is telling me that only MS Jet 4.0 service pack can block the unsafe expressions...

I'm confused as to how you add SortOrder as a field. Do I just title it as SortOrder? then where do I put the if statment? I also changed the order in which High Med and Low appear in my table and they changed back to the order they were in before. Is there a way to move the record order...

I have a Field that has the values High, Med, and Low. I want to have a header in the report sort High, Med, then Low and not alphabetically. Can I do this?

lol...I figured it wasn't just for looks. Thanks.

Is the purpose of the stepping down simply for looks or does that do something

does stepping down like that in the query "OR" all the fields together?

the query wont let me search a table using the "*" symbol. I want to use Like "*" & [Search by word:] & "*" but it has to be able to search all fields for that word.

oh and i definately made 3 back-ups...lol

I thank your for your patience. It works when I split the database. It's too bad MS doesn't try and get something that teaches you more about Access and the ntricacies of how it works. I feel like I dont' know nearly enough but at the same time have passed up the help menu.

yes it does. After splitting i did get the blue arrow next to the table names. it didn't work when front and back end were in the same folder. when i moved the front end to the user computer it worked fine. I have two more questions, is there a way to unsplit once split and is there a way to...

when i said it(splitting the database) doesn't work i mean that the record source of the report doesn't change when multiple users are in the database at one time. when one of my check boxes are checked, it changes the recordsource of the report so it will print what the checkboxes say to...

I did it and it didn't change anything. There is no need to be rude Uncle Gizmo. I'm new at this and just trying to learn more from others. I find there is a lot that the help and other things leave out.

will the users access the database the same way? or do they have to choose either the table database or the form/report/ect database?

well the way the button works is that I have a series of checkboxes that filter a form. i don't know if its continuous or another type because i'm not that familiar with the terminology yet. in my form code, an SQL string is set at the recordsource for the filter that is applied and set as the...

I have a Database that is on a network and allows everyone to be able to use this database and make changes at the same time. When more than one person try to use a button that i created that prints a report, It doesn't work. Why?

How do I get a Query to do a keyword search in a Table? So far I get it to do a search but it has to match a specific Field in it's entirety.

is there no way to update the recordsource of a report without it being open than creating a macro to do it?