Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mxfrail

  1. mxfrail

    dlast with string criteria

    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 & "#...
  2. mxfrail

    Getting date/time from remote server

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

    Getting date/time from remote server

    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?
  4. mxfrail

    Maximize / Restore question

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

    Maximize / Restore question

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

    the requery subform bug

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

    Stored Procedure If Statement not working/executing

    Yes
  8. mxfrail

    Stored Procedure If Statement not working/executing

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

    Stored Procedure If Statement not working/executing

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

    Stored Procedure If Statement not working/executing

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

    Option Group backcolor will not display

    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?
  12. mxfrail

    Option Group backcolor will not display

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

    Help converting Cross Tab to SQL form

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

    Help converting Cross Tab to SQL form

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

    [HasData] function

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

Part and Inventory Search

Back
Top