Recent content by Ian Wright

  1. I

    Passing the Variable via Forms

    Hi June, Many thanks for your kind reply. In the end I added a go to first record command and named the field that I wanted to pick up in it's full name: DoCmd.GoToRecord , , acFirst X = Forms![System]![OrdNo] That did the trick! Thanks for your advice though :)
  2. I

    Passing the Variable via Forms

    I have an Order number register number, i.e. Order number 4564 etc kept in a table from which I have made an form. When I want to create a new order with next order number I open the form try and take the number and put it in a variable called OrdNo: DoCmd.OpenForm ("System") OrdNo = [OrdNo]...
  3. I

    DataAdd Syntax

    A good point well made, I had looked at that until I was blue in the face. Many thanks for your help, if only as a proof reader to a crap typist ;O) Cheers, Ian :)
  4. I

    DataAdd Syntax

    Hi Rural Guy, Many thanks for your kind reply, so if I drop the [] it should work? Also in DateAdd(D, NumberOfDays , 1STDATE), should 1STDATE be in ## if it is a date field? Ian
  5. I

    DataAdd Syntax

    I am trying to use the DateAdd Function on a form. I have a field called 1STDATE once entered the form takes you to a ‘NumberOfDays’ field. Upon leaving that I want it to calculate the last date and populate the active box with it. The Field is called '2ndDate' I am struggling with line...
  6. I

    Unrecognized Database Format

    Hi YPMA and Gemma, Thank you both for your kind replies. I have to confess that I didn't back up before minor changes, more fool me! It looks like the best way will be to create a new database and copy each table, form, enquiry, report across, doing a compact and repair until I find the...
  7. I

    Unrecognized Database Format

    I created a Database that has been running fine for some years. Sure I've added bits to it, the odd field. pushbutton etc and all was fine until ... when I press a button to open a form I get an error message: Unrecognized Database Format (file path) I have tried to use the "Compact and...
  8. I

    New Field not breaking properly.

    Hi I wonder if you can help I have created a multi record report from a query. The Report breaks upon Branch and lists all stores attached to that branch underneath. I then decided that I needed to make it more specific so added the 1st line of the address to the query then added it to the...
  9. I

    VBA to populate a field with Date +7 Days

    Hi Bob, Please forgive my ignorance, yes, but how do I do that?
  10. I

    VBA to populate a field with Date +7 Days

    Hi Chaps, I've tried the double quotes, and gets the same error msg. I then knocked off the Me. which runs without an error but leaves the intended reulsts field blank :o(
  11. I

    VBA to populate a field with Date +7 Days

    Hi Bob, It wouldn't accept the suggested line the " 'd' ", it would with just a d but I then got the error: Compile Error - Method or Data Member not found I tired the original with [Form Name.Field Name] without success too. Thanks for trying though :O)
  12. I

    VBA to populate a field with Date +7 Days

    Help please, I am struggling to auto populate a field upon loss focus of another field. I want current date + 7 days. I have tried using: NCD1 = DateAdd(d, 7, Date) and get runtime error 5 - Invalid procedure call or argument From what I have seen on the web there should be a () after the...
  13. I

    The Mysterious Death of Access

    Just an update. I had done some buttons by building with VBA statements and others by command wizard. I rebuilt all by the command wizard and not had a problem since.
  14. I

    The Mysterious Death of Access

    Hi CJ, I will take your advise, rebuild and compile etc and if that is no good, I'll come back to you. Many thanks, Ian
  15. I

    The Mysterious Death of Access

    Thanks for your kind reply, as a novice I do need pointing in the right direction, Ian
See more
Top Bottom