Recent content by mxfrail

I am probably just missing something - dlast(""chargeid"", ""tblcontractaddlchargeshdr"", ""UserEntered ="" & CurrentUser)" I error unknown. My full sql is - DoCmd.RunSQL "Update tblContractAddlChargesHDR set expirationdate = #" & txtToDate & "#, effectivedate = #" & txtFromDate & "#...

I tried using this ... but it crashes everything on peoples machines off the run time access version. Seems NetRemoteTOD causes runtime error. Private Declare Function NetRemoteTOD Lib "netapi32.dll" (yServer As Any, pBuffer As Long) As Long Private Declare Function NetApiBufferFree Lib...

I have an application that runs off deadlines. I had been using the system date/time off the users computer. But now some of them are merely changing the clocks on there PC to get around it. Is there another option that I can explore?

Awesome! Thanks. Didn't think of activate. I was trying focus etc.

What I have is this - I have a form well call it frmClients (set to maximize on load) that has a clickable label that opens a msgbox and then a form (well call it frmNew). Problem is that know if you maximize one thing it does it to all so frmNew opens maxed and it doesn't look good. So on...

I have researched online a bit about requerying a sub form that I still cannot get past. I have tried many "hacks" to the problem with no resolution. What I know does not work - With Forms!frmContracts_SW!sfDetail.Form.Form .RecordSource = .RecordSource End With...

Yes

I tried moving the portion of the join clause and same data result is returned for both if running the stored proc.

I did that i guess it is going into the if / else statements. But if i run each select statement separately I get 37 rows if (@all would be 1) and 1 if (@all would be 0). But if stored proc runs it returns 37 rows no matter what. I assume the problem is here - In Select of @all <> 1 Case...

CREATE PROCEDURE ASP_StatusReport @SalesRep int, @Range int, @All int AS If @All = 1 Begin SELECT tblclients.clientid, tblclients.dbaname, tblcontractdetail.psijobno as PSIJobNo, convert(varchar(10),tblContractDetail.InHomeDate, 101) as InHomeDate...

Just to add to this - Under Special Effects - If it is set to (Flat, Sunken, Etched) the backcolor will show the header color below like its set to transparent. If it is set to (raised, shadowed, chisled) it will display. Is there a bug or a reason why it wil not show in Flat, Sunken, or Etched?

I have an option group in a header. The header background is set to say Navy Blue. The option group is set like this - Backstyle = Normal Backcolor = 10092543 But when you go into form view the option group has the background color of the header (almost like its transparent) and not the the...

Thats in access SQL but it will not obviously run from SQL 2000 directly because not until SQL 2005 is PIVOT really an option.

I am trying to convert this into SQL form - TRANSFORM count(tblinserts.clientid) AS SumOfHomes SELECT tblInserts.SalesRep, tblstaff.firstname, tblstaff.lastname FROM tblInserts, tblstaff WHERE tblinserts.inserttype<>'W' and tblinserts.salesrep=tblstaff.repid GROUP BY tblInserts.SalesRep...

Thanks. So I took into what you gave me an example of. Everything works EXCEPT ... if nz tries to check one of the subreport fields and it doesn't exist (IE - no data/value from cross tab). I get the following error - nzError(2427) You entered an expression that has no value. Is there a way...