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...
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...
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...
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
----...
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"...
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...
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...
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...
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...
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...
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()...
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...
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...
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...
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...
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
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.