Search results

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

In what way? It works as expected

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

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

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

Thanks for the quick response, but no that makes no difference

Updated post with correct db

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

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

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

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

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

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

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

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

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

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

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

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

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