Recent content by Egg 'n' Bacon

Jason, it sounds like you have a seperate table with "list of items" (if not you'll need it ;) ). To do the comapison, you'll need to have a query with both tables selected & related on the 'class of trade' fields. Then you populate the query field with the relevant fields from the list of...

I think you'll end up with the old problem by mixing text results with number results; you'll loose the ability to set the number of decimal points.

Ah the joys of trying to explain things by text, without the benefit of a sample :confused: I'll try to put this down politely (off to a bad start!!!), but there is only the one [Name] field in the table, likewise only one [Date] field. The challenge :eek: is to have some kind of validation...

I get the feeling there's something else I might be missing here. The name part of ctl.name, is this something I should change to reflect a control or field or something?

Any ideas anyone?

Morning, been away, so I've only just got back to this. Well the previous issue (the missing 'Then') seems OK, but now geting a runtime error, 438; ;"Object doesn't support this property or method". The line of code that gets highlighted on debug is; If (IsNull(ctl) Or ctl = "") And (ctl.Name...

Well that looks about right (not that I can really tell :confused: ), but the line; if booRequired = True is showing up in red & I'm getting a syntax error.

Hmm, never used Select in this manner, could you give me an example please?

You just need to work with the formatting; transparent borders etc

Ah nearly, unfortunately this doesn't quite do the trick. It's a little difficult to explain but here goes; any of the other fields can remain blank, but if a user enters a value in any one of these, then the [name] & [date] fields must also have values.

Not exactly sure what happened with the auto-form you did, but here's an edited DB with a new auto-form (Customer1) that seems to work. You will have to edit it to match your formats though.

Here's something I'm hoping someone will be able to help me with; I have a form based on a table populated from one of our servers. This leaves some fields blank, which is fine. What I need is to have 2 of the blank fields mandatory, but ONLY if certain other fields have any values entered...

Cheers Gemma, I did try a couple of ideas, med, right etc, but the problem was more basic; I should've declared the values as LONG!

I'm trying to change a standard date value into the date format used by our AS400 system (this is year - 1900 & mm & dd e.g. 1st Jan this year = 1060101). I'm using 'Datepart' but I'm running into a couple of problems; Datepart doesn't give leading zeros, that I need & mid seems to do the same...