Search results

YES

I have a parent form and a subform. The parent form shows an order and the subform should show all item lines for the order. But I'm only seeing one line As you can see I have 14 entries in the subform, but only one showing The above is the property sheet for the subform container The...

Thanks guys for your feedback CJ I did mean form controls and I did mean displayed not printed Thank you The DB Guy, I didn't even think of Conditional Formatting applied on that control? Checked it out and YES there was. Thanks very much

I have a form that displays the contents of a record searched for on a major file. The field in question is made up from the expression below It only happens with one record on the qry file - Where the result of the expression is printed in RED The data generated for this field comes from a...

Thanks gemma I take you point. Reconsidering my intentions, it's really uniqueness is what I'm after but I didn't expect a nine digit number

Doc Man thanks for your explanation, I respect your views and will take it on board. Thanks again

Thanks for all your input. This is what I used. I took a copy of the table in question, deleted the corrupt rows (4 of them) and then Compact and repair. I was told that it would it would tidy tables up and then create the next PK from the last PK value + 1, and it worked perfectly. I had to...

Can I create a query to change the 2 Primary keys to what they should be. Will this fix it so that the next record added will follow on from the new numbers

Yes it is a autonumber Primary key and is set to incremental. I have already completed a Compact and Repair

This table has many relationships based on it's primary key. I now get overflow problems in some areas. How can I fix the table ?? How can I stop it happening again ?? I had some weird things happen yesterday in random areas. I compacted and repaired the database and everything appeared OK...

I changed it to mcalex suggestion - still got invalid syntax IIF(Not IsNull([CourtRefNo]) Or Len([CourtRefNo]) > 0, "Court - " & [CourtLocation] & " - " & [CourtRefNo], IIF(IsNull([QcatRefNo]) Or Len([QcatRefNo]) = 0," ", "QCAT - " [QcatLocation] & " - " & [QcatRefNo]))

I'm trying to create a field in my Book Mark source file to go into a merge with a set of precedent documents If the matter is in the Magistrates court i.e. len([CourtRefNo]) is > 0 I want to use the Court Location - CourtRefNo If the [CourtRefNo] Has nothing in it I want to check the...

PersonResp: DLookUp( "RTrim([Users].[FirstName] & "" "" & [Users].[LastName])","Users","UserId = " & [Matters].[RespPerson]) PersonResp is a field in my query. I keep on getting an invalid syntax message Any help would be appreciated

Thanks Arnelgp. I changed mine to be exactly like yours and it still didn't work. I copied yours and pasted it into the code and worked.??? Thanks again mate

= "(" & DCount("*","ItemsOrderedOnlyQry","[OderNo] = '"OrderNoFld"'") & ")" The error I get = "The expression you entered contains invalid syntax You may have entered an operand without an operator I have been staring at this and looking for examples but I just can't work it out. When it's...

No I haven't but I will - Thank you

yes I have

Yes I did

Thanks arnelgp, I will try to implement that. It sounds what I need:) (y)

I have a search option and the field where the search criteria goes into keeps changing from a string to numeric If I activate the Order No, the second field from the right changes the caption to Order No. and then the last field (cmbFilter) is where the user places in the value. In this case...