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 Chriss Miller 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: *

  • Users: simian336
  • Content: Threads
  • Order by date
  1. simian336

    DoCmd.ApplyFilter Question

    Ok, so I am looking at someone else's code. They have used a filter on a form. But the filter is like DoCmd.ApplyFilter "NameOfaQuery" I don't see any documentation that you can use a name of a query as a filter. I assume it is just taking the criteria from the query and applying it to the...
  2. simian336

    Logins Per Second

    Hey Guys, We have experienced some general slowness issues and the only metric I have ever had a bad feeling about is our logins per second. Most of the Articles I find on the internet on the subject are for older versions. We are on SS 2016. During the day we are seeing average logins at...
  3. simian336

    Why the Aliases

    Hey Guys, I was look at someone else's code and I don't understand why they would alias each field with [Extent1] when they aliased the table. Or why would they add an AS on each field with the same name. Any thoughts? Thanks Simi SELECT [Extent1].[Premise_Equipment_ID] AS...
  4. simian336

    folder list

    Can anyone tell me what the lines are that only have a length in this listing, when I run this command? Get-ChildItem -Path $path -Recurse -Force | Where-Object {$_.lastwritetime -gt '12/10/2017' -AND $_.lastwritetime -lt '12/11/2017'} Mode LastWriteTime Length Name ----...
  5. simian336

    Parse XML

    Hey, I am having problems figuring out how to parse an xml file... It seems to be abnormal as compared to all the examples I find. Here is my data... <?xml version="1.9"?> <doc> <md_cst.get_CL status="9"> <RS1> <row ROW_NUM="1" CUSTOMER_ID="199147" CUSTOMER_NAME="DOE JOHN A " STATUS="A"...
  6. simian336

    Deadlocks

    ok, here is my scenario. Our users are complaining about "general system slowness". Some of my developers have heard about some locks or deadlocks that "buried way down deep in SQL Server and they think it might be a problem" CPU on the Production server never goes about 5%, Memory is low. No...
  7. simian336

    #Getting Individual Customer services Info custinfostart='http://172.17.3.17:7780/da

    I have the following code. The first urllib call works the second does not. I have beat my head against the wall and can't figure it out. Error is http://12.17.3.7:7780/dataservices/cdk?SP=md_dev.get_device_list(%270003%27,%272%27,%27100703%27,%27n%27,%271%27,%27100%27,?,?,?int status) Bad...
  8. simian336

    download webpage api hangs

    I am trying to download a web page from a local program accessed thru an api. It works thru a browser and it works in python but it appears to hang and just sits there like the request never closes. It actually prints the contents to shell. Any ideas? Simi import urllib.request...
  9. simian336

    Group User

    I tried to great a new user based on a Active Directory User Group. Everything looks correct based on the examples I have seen but when I try to test connecting with a new ODBC connection it fails with Login failed for user 'mydomain\myuser'. Reason: Could not find a login matching the name...
  10. simian336

    open site with urllib

    Hey all, Kinda new to python. Trying to use urllib to read a website. The problem is the site I need to read contains single quotes in the url like http://serverIP:port/dataservices/cdk?SP=md_adm.login_with_session('USER','PW','mySID',?int status) I have tried to encode the single quotes with...
  11. simian336

    Inheritance Problem

    I have some code that I need to repeat so I put it in a sub. But I think when it goes to the sub it is loosing the inheritance to the Word app class. The error is "invalid or unqualified reference". Any idea how to keep the keep the class in the sub? Thanks Simi Private Sub Command8_Click()...
  12. simian336

    Word document bulleted list format

    I have been pulling my hair out so I might as well ask... I found some code below to create a bulleted list. On my machine the bullet is a black dot. My user wants to change the code so the bullet is a blue squeare. Any idea what I need to change? Thanks Simi...
  13. simian336

    indexing question

    When I run... ALTER INDEX ALL ON dbo.[Yadkin Base Form] REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = On); go EXEC sp_updatestats and I look at the Total Fragmentation in the properties of the index it shows 0.00%. But if I run SELECT D.name AS...
  14. simian336

    Update Error

    Oracle is not my forte... Anybody see why this should not work. Trying to add a value converted to text to a existing text field. update c set list = list + cast(b.SERVICE_ID as varchar(12)) from md.subscribe_service a join md.service_menu b on a.SERVICE_MENU_ID=b.SERVICE_MENU_ID join mjlist c...
  15. simian336

    need the earliest date

    My brain is not working today. I need a query for the earliest day and with associated Account_ID. Account_ID Service_Activation_Date 2100089506 1985-08-02 00:00:00.000 2100089506 2004-02-17 00:00:00.000 2100089506 2004-02-17 00:00:00.000 2100089511 1997-12-22 00:00:00.000 2100089511...
  16. simian336

    Add column Packed Decimal

    Does anyone know the syntax to Alter table and add Packed-Decimal columns? I have a field FRNPA that is FIELD TYPE=P, FIELD LENGTH=3, DEC POS=0 and I need to duplicate it with a tmp field. Guessing something like Alter table test add column TMPPA P(3,0) Thanks Simi
  17. simian336

    headset in the handset

    Hey all, I have a mitel 5220 phone (not sure about the controller version). I have an regular corded headset (originally from a Merdian system) it acts the same as the handset and is plugged into the handset plug. I just changed to a new extension and lost my settings. Orinally we found a...
  18. simian336

    refering to a field in a variable

    vb 2010 - How do you refer to a form field in a variable. If I have 10 fields like Me.SpreadAmt1, Me.SpreadAmt2, etc. and I want to blank them (or whatever) without typing each one out.. Dim x As Integer Dim ha As Object '(just guessing here) x = 1 For x = 1...
  19. simian336

    Noob question about creating txtbox control

    ok... I have a row of txtboxes and if the use hits a new row button I want to create a new row of txt boxes. So I want to pass name and number to a procedure and have it create the a new txt box. Private Sub addtextbox(ByVal xday As String, ByVal xnum As Integer) Dim...
  20. simian336

    Total Noob question

    Hey, I am new to python. I am trying to write a line out to a file. f.write('findstr "directory\billing\"' + var) I guess the \b is being interpreted as a dot when it writes to file. Is there way to write the literal line to the file? Thanks Simi

Part and Inventory Search

Back
Top