Search results

  1. L

    Solved Query giving date mismatch

    There is a date DocReview is a numerical field indicating the number of months to when the document should be reviewed DocVer is the date the current document was issued so dateadd is adding x months to the issue date
  2. L

    Solved Query giving date mismatch

    In what way? It works as expected
  3. L

    Solved Query giving date mismatch

    Doh, thanks Paul, yes one of the records does have a null value. Is there any error catching I could put in place to capture this? Apart from making it a required field. regards John
  4. L

    Solved Query giving date mismatch

    I have created a document database and want to pull a report of all upcoming documents that require review in the next month I have a query that works until I try to filter DocReview field is a number representing how long before review in months 1, 4 6 12 etc VerDate is the date of the latest...
  5. L

    Opening a new linked form gives #Name error

    Well that works so far, as simple as taking out the .DefaultValue its finally getting near useable for me anyways :) Thanks a lot for your help
  6. L

    Opening a new linked form gives #Name error

    Thanks for the quick response, but no that makes no difference
  7. L

    Opening a new linked form gives #Name error

    Updated post with correct db
  8. L

    Opening a new linked form gives #Name error

    Opps sorry its on the Main Document Form (DocForm) on the switchboard, and the New Version form (NewVerForm) is triggered by the New Version button as the image in my first post
  9. L

    Opening a new linked form gives #Name error

    Moving the code to on Load made no difference. With a bit of playing using MsgBox it appears that a Null value is being passed to the new form even though the correct DocRef value is found Using MsgBox in the on load gives an invalid use of null and on the Click OpenArgs tooltip is Null but...
  10. L

    Opening a new linked form gives #Name error

    I have a main form with a reference number(DocRef) NOT the record ID I set a command button to open a new form to add to a table linked to the main table but I can't get the Reference to come across I just get a #Name? error and unless I manually enter the DocRef it just creates a blank entry I...
  11. L

    Form filter with checkbox and combo not resetting

    Think I finally have it sorted WHERE (((DocMain.DocType)=[Forms]![Register]![CboType]) AND (([Forms]![Register]![chkActive]) In ([Active],False))) ORDER BY RegQuery.DocRef;
  12. L

    Form filter with checkbox and combo not resetting

    Hi Thanks but Changing the query gives me a Reserved Error Item 3201 message John
  13. L

    Form filter with checkbox and combo not resetting

    That just reverses the selection of active v all records CboType doesn't seem to refresh the query on change until ChkActive is clicked
  14. L

    Form filter with checkbox and combo not resetting

    Hi isladogs, that has almost works except now when I make a change in the combo I have to toggle the checkbox (click twice) to make the change show. regards John
  15. L

    Form filter with checkbox and combo not resetting

    Thanks for the quick response, however I just tried that and it doesnt change. regards John
  16. L

    Form filter with checkbox and combo not resetting

    Hi I have a form to display records but I cant get the filters I have set up to work consistently and revert when reset. The Form has a combo dropdown to select a type of record and a tickbox to select All if unchecked and only records marked as Active if checked they are not connected so any...
  17. L

    Append data from multiple workbooks with sometimes different headers

    Hi Thanks for the try but not quite what I'm looking for, I have attached a couple of demo workbooks each month needs to add to the Master then I can extract, trend and graph individual categories
  18. L

    Append data from multiple workbooks with sometimes different headers

    Hi I, I have a results spreadsheet emailed to me every week 2k rows and I want to be able to add each weeks data to a master sheet/book for analysis. I have searched a lot and found some code to do what I want as long as each sheet has the same format/columns, however occasionally there may be...
  19. L

    2007 compatability pack problem

    Hi I have XP pro sp3 with Office 2003 and the 2007 compatability pack installed, on my old pc this worked fine and .xlsx files would open from email instantly. However same setup on new laptop and if I try to open a xlsx file it will only let me save it as a xls, of course I can then open it...
  20. L

    Repeating dialog box

    When using the below query I get a dialog asking for the Retailer followed by a dialog asking for the retailer ref then a second or so pause before it asks again for the Retailer then the ref before finally completeing the query Used to work as expected until I added the wildcard section to...
Back
Top Bottom