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!

  • Congratulations biv343 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

    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

    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 -...
  7. 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.
  8. 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.
  9. jedraw

    Delete query takes FOREVER to run

    Glad you have it resolved. Didn't realize you have SQL server BE.
  10. 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...
  11. 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
  12. 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...
  13. 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
  14. 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)
  15. jedraw

    Accessible archive

    See this link for an example.
  16. 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.
  17. 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]...
  18. 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...
  19. 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