Search results for query: *

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

Right now I am using [HasData] to reference whether a subreport has data but what I really want to use it for is to reference where the field within the subreport has data. Is this possible? If I do this - I end up with #name - [subreport].[Report]![Jan].[HasData]=True If I do this it works...

I have a report ... Right now it displays Current Year Data per Sales Rep of Revenue etc. Each row is a subreport cross tab query. Below the Current Year data I want to place past year data right below it. Is there a quick an easy way to do this without having to create new subreports for...

I briefly looked at the link and here is a slight workaround I tried but still problems using HasData - =IIf([qryMarcCTRPVol subreport].[Report].[HasData]=True,[qryMarcCTRPVol subreport].[Report]![Jan]+[qryMarcCTVol subreport].[Report]![Jan],[qryMarcCTVol subreport].[Report]![Jan]) If my data...

Ok ... I have a bunch of subreports each presenting different data. It goes by sales report with different categories. Lets say I am trying to total for each rep Cat A and Cat B. Each rep might not have any data returned in the subreport for one or the other. So I was trying to do the...

I have a section that needs to be set to can grow. When 'Can Grow' is set to yes an increased, and unneeded, space is creating between rows. I have 'Can shrink' also set to yes thinking that if it doesnt need to grow it won't and there wont be this spacing. But that is not working. If I put...