Search results

Worked great, thanks :)

I have a report based on a query. This query has a BETWEEN [ENTER STARTING NUMBER] AND [ENTER END NUMBER] as criteria for the NUMBER field. I want to include the [ENTER STARTING NUMBER] and [ENTER END NUMBER] data in my report. How and I capture these. The report heading will be as such...

Worked great, Thanks

Did Not Work I put the following in the Form Before Update and it did not work. The record saved did not change: still has a blank in the fields. I also tried, = "". Private Sub Form_BeforeUpdate(Cancel As Integer) If [Forms]![frm_oil_sample_slip].test_no = Null Then...

I shall give it a whirl

I have a form for entering records. On some of the TEXT fields I want to update the table with the literal "Unknown" if nothing is entered. But I do not want to make this field's Default "Unknown". Where can I check for this?There is no tab control; the client can move thoughout the form with...

Question Graham T, Is this example allowing for multiple row sorting? If I only want to choose one row to sort on, do I only have one combo list? The example has several. :confused:

Thanks, this is precisely what I needed :D

I have a report based on a query with eight different data columns. How can I sort any column that I want dynamically? In the form, where I choose the report; in the query, where the data comes from; or in the report, which prints the data columns? :confused:

Sub Form I shall try it. Thanks

I have one table with electrical equipment, tbl_equip. This table contains data like Serial Num, Company Num, Location, etc. I have a form, frm_search, based on a search query that I can enter the first number of the Serial Num and it will list all equipment that start with that number. I...

kva The table contains electric transmission equipment data. kva is the size rating for transformers. Other data in the table is the equipment serial number, manufacturer, etc. The search form has several search text boxes; MFG, SERNO, KVA.

Working Thanks for your help. Tried this suggested by a co-worker and it worked. IIf([Forms]![frm_search]![KVA]<>" ",[Forms]![frm_search]![KVA],[kva])

In the form KVA Text Box, If I type 50, I get all the data KVA records equal to 50. However, If I skip over the KVA Text Box and not type anything, I get no records. I am expecting to see all KVA records.

No Bueno Since my data is numeric, I tried the second IIF, but it did not work for the TRUE. However, it does not for the FALSE. If I put a number it finds that data, but if I leave it blank, I get a null result, no records. Helppp.

Thanks, I will try both. The data is numeric and I may have a problem with the "<" and ">" signs. Will let you know

I created a search form and query. If I do not enter anything I want to retrieve all the records. Otherwise I want to retrieve the records that meet the critertia I enter. Example, I want to enter, >500, <500 or =500. However, no matter what I enter, I always get the records equal to 0. This is...

Sub Form This is almost working. When I show the subform on the main form, the linked field is passed and I can fill up all the fields and append the record with all fields. However, When I set the Visible to NO on the subform, run a macro that does an Open Form on the subform, the linked...

Would the PacientsVisits Subform be display over the main Pacients Form every time, or only when I want tio display it?

I have two tables. Pacient- Holds Name, etc. Key is CustomerId defined as AutoNumber. PacientVisits - Mulitple records per Pacient. Key is CustomerID defined as Number. I display Pacient data on Pacients Form and Click on Button to bring up PacientVisits records on another Visits Form. If a...