Search results

  1. E

    Comparing a Large Amount of Information

    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...
  2. E

    Format % in query

    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.
  3. E

    Validation on form

    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...
  4. E

    Validation on form

    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?
  5. E

    Validation on form

    Any ideas anyone?
  6. E

    Validation on form

    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...
  7. E

    Validation on form

    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.
  8. E

    Validation on form

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

    one to many

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

    Validation on form

    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.
  11. E

    one to many

    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.
  12. E

    Validation on form

    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...
  13. E

    Extract date to odd number string

    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!
  14. E

    Extract date to odd number string

    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...
Back
Top Bottom