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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jedraw

    delete having more than 1 count

    ...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 COUNT(*)...
  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

    ...+ 7) 40 Debug.Print "We are in week " & Format(Date, "ww") 50 Debug.Print "Start of 16TH week in 2023 is " & DateAdd("d", ((16 - 1) * 7), #1/1/2023#) 60 Debug.Print "End of Second week in 2023 is " & DateAdd("d", (2 - 1) * 7, #1/1/2023#) 70 Debug.Print "Start of current week in...
  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?

    ...90 x(3, 1) = "Hislegzoff" 100 For i = 0 To 3 110 Debug.Print testStr(Trim(x(i, 0)), Trim(x(i, 1))) 120 Debug.Print vbCrLf & " ***************** " & vbCrLf 130 Next i 140 On Error GoTo 0 150 Exit Sub testit_Error: 160 MsgBox "Error " & Err.Number & " (" & Err.Description...
  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)
  16. jedraw

    Accessible archive

    See this link for an example.
  17. jedraw

    Accessible archive

    It's been years, but I have used a single front end (form with combo) to select and use tables in multiple back ends. The BEs were different Oracle environments (dev, test, prod, maint) . See these link andLink for info.
  18. jedraw

    Summarise per day from one table with relation to other table with dates

    You seem to be missing some commas in the sql you posted??? SELECT tblO.DateL ,ROUND(SUM(tblO.A + tblO.B + tblO.C), 2) AS Ovs ,COUNT(tblO.Client) AS NumCl ,tblR.Reas FROM ( tblO LEFT JOIN tblR ON tblO.CLIENT = tblR.CNr ) GROUP BY tblO.DatumL ,tblR.Reas ,[tblR].[DateN] <= [tblO].[Datel]...
  19. jedraw

    Following code as it executes

    Vic, I am not aware of any feature to watch code as it executes. What I often do for debugging is the following: Add a line in each or selected procedures to indicate that procedure has been entered. You can also include Now() to show the time. I add a global boolean variable to allow this...
  20. jedraw

    Help with Powershell -json

    I am new to Powershell. I have the following script. I am trying to determine the powershell "code" to identify which, if any, "field" is an array or hashtable. $txt = @" { "id": "02002010", "booktitle": "", "pagetitle": "Demo Page", "parent": "02002000", "img": [ {...

Part and Inventory Search

Back
Top