Search results

Cool that you tried it in a conditional formatting formula. I went your route and create a True/False field in my select query and so the conditional formatting is based on that field and is there when the form opens. No lag that I cant detect. (I am a novice at best and do this for fun, plus...

sneuberg, My apologies I did not return a thanks earlier. Had my sons bday, then pinewood derby, then Super Bowl, then Valentines boxes this week for their school. So a long overdue thank you. While I did not use your exact example, a few things you said got me thinking. Especially about...

Does anyone know if it is possible to use conditional formatting on fields in a form using the Dir () function if a file exists. And if so how? Here's my idea: I currently have a sub form with a field that links to files in a folder "Site Reviews". In this field the user types in the...

vba, I solved it....Not by reference the other subform and trying to tell Access how to compare the records I wanted it to and to cycle through all records and do same...But, I decided to try again on getting the info on the 1st subform. So I used the dlookup function to populate fields...

ok this would be the SQL for the 1st subform (the main form link is where the user selects the contract and it opens a pop up modal form so that you can never navigate away from the form (unless close) so the "contract link" will always pertain. Thats how i filter out the other contracts...

By that you just want the SQL langauge of the quries i used to populate each form?

Vba, I got it to work.... sort of.... I was not using the correct naming rules to go between the main form to the other sub etc.. so i got it to work sort of by doing this.... [Forms]![mainform]![subform1].[Form]![Invoice #]= [Forms]![mainform]![subform2].[Form]![Invoice #] And...

vbaInet, I think, if im following you right, I tried to do that by including the summed totals in the record set by querying them. That worked perfectly to highlight if the records didn't match. However that left the record un-updatable. If im not following you correctly I apologize...

Spike, In essence you got it..... why? well because, well not really sure j/k... let me be the first to say i am more than positive i have probably broken every cardinal rule for access and normilization but i work for government and well my office needed a way to have information captured for...

Is it possible to format a field in a datasheet view of a form if the value of a field on another form is not equal to the field I want formatted? To keep simple: say i have a form that shows invoices and a person enters the summary or totals in a variety of catagories. I have another form...

This is my first post ever but I have benefited from others so let me start off by thanking everyone who takes their time to help those who post on these boards. Your assistance is worth its weight in gold. I'll try and keep simple but I think I need to explain a little. I have a database...