Search results

Try putting your =Count([Fieldname]) in the GROUP footer rather than the page footer.

Could you base the reports on a query, then in the criteria of whatever field you want, reference the form e.g. =[Forms].[frmReportsMenu]![Field1] As long as your running the report from this form it should work.

What about if you put a /B after the exit command? What operating system are you using?

I know when ive come across similar posts and problems myself, people always suggest re-selecting your references incase one of them is broken. Write them down, then unselect all you can, close the dialog box, close access then go back in and select them. I know this sounds a cop out answer...

How about putting exit on the last line of your batch file?? Or am i missing something here.

You could run the application from the server, then it would pick the time up from there. Other than that im not sure if you can reference the server's time.

it was eaten!

Thanks for that Rich, had to unselect my references then re-apply them. Never came accross that before!! Cheers everyone for your time.

Not if i can help it. I think the problem lies in the format function rather than the criteria im specifying.

Its a very confusing situation which i'll try and be brief about. Ive got a database that works fine with Access 2000 Runtime and Windows 2000, however when ive put it on a Windows XP machine it comes up with a runtime error. Ive narrowed it down to the format function: Format(Now(),"dddd")...

he ripped it!

A Date Reference, sorry, mistype.

Im having problems with Dates but only using Windows XP and runtime. There isn't any references missing as such, but does anyone know if there is a specific date on i can add, just to see if this will solve my problem. I doubt it will work but im running out of ideas!! Thanks in advance.

I know its a bit of a hassle, but the only suggestion i can come up with would be to split the dates into 3 seperate rows and export them, then when you import it back merge the 3 sperate rows back into one with query. The only issue with this would be in the actual text file you are editing...

I know this may seem odd but have you tried it on the Before_Update, or On_Enter of the next tabbed text box after your jobNo??

Put a msgbox in the Err_handler: bit that says msgbox Err.Number

Try using the If Err.Number = NUMBER HERE then msgbox "....... End if

Find out what the Err.Number is then Try this: Private Sub txtPersonProjectID_AFTER_Update(Cancel As Integer) On Error GoTo Err_Handler Exit Sub Err_Handler: If Err.Number = " NUMBER HERE " Then Msgbox "This person is already working on this project", vbExclamation Exit Sub End Sub Haven't...

In my experience its easy to base a query on the data then find it from the Unique ID you've set. Alternatively ive put the Combo box on a main form and the other data you want to look up on a sub-form. Thats usually sorted it for me anyway. Hope this is of help!!

Sorry, In a text box its: Format(Now(), "dddd") In the code its: Format(Now, "dddd")