Search results for query: *

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

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 );

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

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

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

See if this helps.

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

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

Here is a link on Application Interface that should help.

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

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

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

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

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

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

See this link for an example.

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.

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

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

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": [ {...