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 jedraw

  1. jedraw

    delete having more than 1 count

    Not a foxpro person, I was looking at the SQL. Unfamiliar with this syntax requirement. I see this is what you mean: DELETE FROM MyTable ; WHERE CustNo IN ; (SELECT CustNo FROM MyTable ; WHERE CustNo IN ; (SELECT CustNo FROM Test1) ; GROUP BY CustNo ; HAVING...
  2. jedraw

    delete having more than 1 count

    Is this what worked ? DELETE FROM MyTable WHERE CustNo IN ( SELECT CustNo FROM MyTable WHERE CustNo IN (SELECT CustNo FROM Test1) GROUP BY CustNo HAVING COUNT(*) > 1 );
  3. jedraw

    delete having more than 1 count

    Try DELETE FROM bell_lns WHERE newtob = 1 AND custno IN ( SELECT custno FROM test1 GROUP BY custno HAVING COUNT(custno) > 1 );
  4. jedraw

    Clear all table contents without deleting records

    What exactly are you really trying to achieve? Can you give us a before and after scenario? I hope Duane has guessed well.
  5. jedraw

    Access VBA Syntax Error

    Try "Division ='" & rs.Fields("Division") & "'" rather than "Division = " & rs.Fields("Division")
  6. jedraw

    SELECT FROM Table in Another Access File

    See if this helps.
  7. jedraw

    currentWeek excluding weekends

    Here are a few date calculations that may offer some insight. Sub SomedateStuff() 10 Debug.Print "First Day of Week is Sunday" 20 Debug.Print "First day Last Week " & DateAdd("ww", -1, Date - Weekday(Date) + 1) 30 Debug.Print "Last day Last Week " & DateAdd("ww", -1, Date -...
  8. jedraw

    There is no object in this control

    What is the "bitness" of your 365? WIN 10 64bit can still run 32 bit Access/Office.
  9. jedraw

    Hiding or resizing Access Application so my pop up form is all that is seen by the user

    Here is a link on Application Interface that should help.
  10. jedraw

    Delete query takes FOREVER to run

    Glad you have it resolved. Didn't realize you have SQL server BE.
  11. jedraw

    Delete query takes FOREVER to run

    Have you considered? - a copy of the database for your testing totally separate from the copy being used by the accountant - a database /table designed specifically for you to "tune your skills" before working with the "official" database Either option would allow you to check/revise the...
  12. jedraw

    How to send/receive text/SMS message through Access

    See this video by Richard Rost https://599cd.com/blog/display-article.asp?ID=1806
  13. jedraw

    Create a Report from a query and then personalise the report for each client - possible?

    Are the Terms and Conditions consistent for all Contracts? That is, is it boiler plate with customization for a few fields. If so, then you may get some insight from this code/sample. ' ---------------------------------------------------------------- ' Procedure Name: testStr ' Purpose: To...
  14. jedraw

    Trying to programmatically select Navigation Options in Access Options

    You can find details by Google search https://docs.microsoft.com/en-us/office/vba/api/access.docmd.locknavigationpane https://docs.microsoft.com/en-us/office/vba/api/access.docmd.navigateto
  15. jedraw

    Identifying Users in Access 2016

    See this link for more info There are several articles/videos on Managing User Logon (eg this by Steve Bishop)
See more

Part and Inventory Search

Back
Top