Search results

if you all have access to the shared drive, look into splitting your database and giving each user their own front end. This should allow all users to enter data into the database directly

Can you post up a sample database? Id like to see some data and give it a try

sorry. You can use yes or no. Then in the report no data event put your label.visible=yes then all others=no

Could you turn group footer on and create that textbox in there for each group. I cant see why that wouldn't work. I haven't tried it though.

Ok So what if you create a label on the report and set it to visible=false then in the No Data set it to visible=true? and maybe hide everything else?

Is there a specific reason that you would want that to print?? That would be a waste of paper if you ask me!

In 2000 I used to do it like this Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report..." Cancel = -1 End Sub

Which it will because it is creating the jobtype of the first one on the report creation. What I think you need to do is distinguish the jobtype for each section. Do you have grouping on for the job types?

What version on access are you using? 2007 has a event for No Data

On your DRMO form you can create a dropdown to select the equipment that you want to "end" OR on your inventory page, you can put a drmo option on there that they can check and fill out right on the inventory page, removing the need for another form. Could also do the same with the replacement...

So do you get any values if you just do Me.TotalPagesTextbox = DSum("Pages", "HBELP_FINAL_Q", "JOBTYPE = '" & Me.[JOBTYPE] & "'")

Is that how you have it in the form? This should work IIf ([Job Status] = "Complete",0,DateDiff("d",[Date In],[Due Date]))

Is job type a text value or a number?

I would create a field in your equipment table called DRMOID or something like that. When you create a drmo you can then fill that date in on your equipment form and have a button or something that will link to that drmo record

Glad that fixed it for you

As James said check now(). It will probably work according to this thread http://www.accessforums.net/programming/access-2003-date-function-returns-name-1138.html if that is the case, then you almost definitely have a reference issue

found this article... have anything to do with your situation? http://www.eggheadcafe.com/software/aspnet/35012807/access-2007-date-name.aspx Also check your references http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

try creating another textbox on your report with the =Date() and see what happens... Do you have the same result?

Solved this issue by doing a make table on the crosstab query. Works like butter now.

put "exit sub" in the section where the statement would evaluate to true