Search results

In the control source of the field put this: =iif(isnull[field name],"No records","[field name]) As for the null records, I would set the default prop to 0.

Even easier is just use a standard query, put the checkbox on the report and set its visible property to no / false. Then in your control source of the textbox use the same iif statement. example: controlsource:=iif([check22]=true,"Statement","Other statement") Either way will work.

Thanks Pat as always you give insight. I will try this tonight. Add On: Ok I tried it Pat and what it does is list all of the records for the first subreport then all of the records for the next report. Which in a way is good, however, I need the page headers from both sub reports to always...

Does anybody know how to setup an access database so multiple users can access it at the same time over a large network that has multiple servers? I have three offices that are separated by 35 miles. All of them are on the same network but with different servers. All servers connect to the...

Ok all here we go. I hope I can explain this. I have a report that has one sub-report in it. The reports share the matching primary key field. Both tables will always have the same 75 primary key records. The reports are linked (master and child) by this primary key. Main Report setup: no...

OK, first off I read all 14 pages for this search. I have found many examples some more complex than others. Nothing I have seen really explains what I need. I guess I am not interpreting the info correctly. I have a form(Form A) that the users click a command button to open the main form...

Oooh Thanks for pointing out the obvious. Man I feel stupid. Obvious signs of working too long and not thinking before posting. Thanks for the help.

All, I have seen it somewhere and have searched all of these forums and couldn't find the answer. The question: I have two reports that currently are set to print when a button is clicked. Dim strDocName1 As String Dim strWhere1 As String Dim strDocName2 As String Dim strWhere2 As String...

nevermind I am retarded DoCmd.OpenForm "fleet2", , , "[Vehicle Number] = forms![form2]![text2]", acFormEdit Thanks for all of the patience and help Pat. I think this will make it easier and quicker.

Yeah that is what I was referring to, but I have a syntax issue. DoCmd.Openform "fleet2",,,"[vehicle number]=forms!form1![vehicle number]", acformedit I am overlooking something. This way when vehicles are added I don't have to change the code.

Ok I took a single form and made subforms that were continous and modified the queries as necessary. Alot less work, however, I still need on click to open a filtered form by that record. Meaning that say the third record is e4567 on click docmd.openform "form name" , , , "[the actual record...

Ah HA I was astounded again. Unfortunately all of the records are listed in a single column. Is it possible to break them up into groups so all 47 records are on one page and the end user doesn't have to scroll down? If you repeat the field then you just get a duplicate of the same records...

OHHHHH I see what you are saying. (sheepish grin) :D Thanks for the info. I am having to look to see if it will work like I want. I think it will though. It should load a lot quicker to. Thanks for dumbing it down for me.

Maybe you didn't understand what I was trying to accomplish. I understand what you are saying, however I tried to do that and access only allows one record to be displayed at a time. If you know of a way to display all records in a table of record id = vehicle number on the same form then...

Yeah OK I finally got it working. Here is the problem. Microsoft (in all their infinite wisdom) made a glitch in the program. Even though the query sees all records you can only work with one at a time. No matter how you make the code. We have done for do's, if's, and pretty much any other...

True True...darn now I am having to think. You are definetly right, however, you can not apply conditional formatting to a command button. So...I am now doing this via a continous form. It is working to an extent. I am figuring out how to have several forms displayed at the same time side by...

Well, that made it worse. Nothing works with that version, good shot though. I have been trying to do a for loop to search I added a field called id - autonumber so code is like this for x = 0 to 100 select distinctrow [vehicle number], [in service] from fleet where [id] = x...

Damn I thought you had it on that one. It still is stuck on command22. I am trying something else here in a second and will post it.

Still no go arghhh. I have no idea why this is not working. It just stops at the first record. Even with the new code command2 works fine. But command22 doesn't. I don't know.

That works for the on activate part. Thanks that makes the changes instant, however, now I have several buttons. When you change in service to false or true it changes all the buttons color. Private Sub Form_Activate() If [In Service] = True Then Command2.ForeColor = vbBlue Else...