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 Rhinorhino 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: SQLScholar
  • Content: Threads
  • Order by date
  1. SQLScholar

    Subform not firing event

    Hey all, I dont "do" access stuff very often and i am struggling. I have a form\subform all working fine. However on the subform design i have added this Private Sub Form_AfterUpdate() Me.Form.OrderBy = "OrderKey" Me.Form.OrderByOn = True End Sub This works fine when i view the form on its...
  2. SQLScholar

    Connect to SQL in ADP

    Hey all I am trying to hide a text box - based on a query that runs on the database (its an ADP so database is SQL). I have the below: Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSQL As String Set db = CurrentDb() strSQL = "SELECT col1, col2, col3 FROM tablename WHERE fields...
  3. SQLScholar

    Invalid Syntax when opening form

    Hi all, I have this code in a form (generated by access) Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmUserOverides" stLinkCriteria = "[ADLogon]=" & Me![ADLogon] DoCmd.OpenForm stDocName, , , stLinkCriteria Which should all be fine...
  4. SQLScholar

    No Data message

    Hey all, I have converted a 2005/Dundas report to 2008 r2. All is ok - however i have a matrix. In the matrix data section is a chart. This works fine. However in the old version if there was no data for the chart - it said "***** No Data *****". However the converted one just has a...
  5. SQLScholar

    Report builder usage

    Hey all, One element of SSRS i have never used is report builder. I understand report builder works much better with SSAS than BIDS does (isnt difficult). I have a request for a dashboard, but there are a lot of filters - making it an unpractical request. We are currently looking to the need...
  6. SQLScholar

    Lookup Value

    Hey all, Been a while since using access - so please be gentle :-) I have SQL tables and columns like this tbl_user Username Firstname Surname Tbl_GroupMembership Username Groupcode tbl_groups Groupcode Groupname Owner So effectively its a many to many relationship split with a bridge...
  7. SQLScholar

    Comma Separating

    Hey all, I am trying to get a comma separated list of all my pk columns for a table. So i have this DECLARE @PKCols VARCHAR(100) SELECT @PKCols = CASE WHEN @PKCols IS NULL THEN '' ELSE @PKCols + ',' END + c.name FROM sysindexes i INNER...
  8. SQLScholar

    Live Reporting Server

    Hey all, If you have an OLTP system (SQL 2008 r2) and you wanted to have a dashboard running off it that was Near Live information (15 mins max). How would you go about it? For safeties sake lets say its a normalised database that has 1,000,000 customers 10,000,000 orders, 10,000 products, 10...
  9. SQLScholar

    Website direction

    Hey all, I am a little confused here. A friend of mine is going to host my website (not email or DNS or anything else). So if i point my www A record to his IP..... what does he then have to do his end? Does he need to create another DNS entry on his server for my domain so we can then point...
  10. SQLScholar

    Join to same table 3 times

    Hey all, I have a join that is used in many queries and stored procs. I keep thinking that i must be able to not have 3 joins all to the same table but i cant figure it out. here is effectively what i have: select * from table1 t1 LEFT JOIN dbo.tblMI_Team_Structure ORG ON T1.TeamName =...
  11. SQLScholar

    Odd USB

    Hey all, I have a rather odd USB. USB optical mouse works fine. USB pensticks.... some seem fine. USB cables to phone\satnav\tablet all seem to only work if i push the cable up slightly on the connection to me laptop. Seems strange that its not on all uses of port. Also the cable will...
  12. SQLScholar

    Pivot - but for a quite a few splits

    Hey all, I have the below query SELECT TransactionId, SupplierId, TransactionPercentage FROM tblTransaction ORDER BY TransactionPercentage desc This would return data like this (this is for one transaction) TransactionId SupplierId TransactionPercentage ------------- -----------...
  13. SQLScholar

    RS 2005 Transaction isolation level

    Hey all, I have a reporting server that has a table that i have set up so that via an SSIS package it can be having data uploaded at any time. The upload conists of holding tables followed by a SP that opens a transaction and uploads the data into the tables used by SSRS. Now if the last bit...
  14. SQLScholar

    Top one for each group by

    Hey all, I have this query - which isnt quite doing what i want. SELECT tblPolicyBrokerTeam.TeamName , UserName FROM adw.policy.tblAcceptedByUser INNER JOIN adw.policy.tblPolicyBrokerTeam ON tblAcceptedByUser.BrokerTeamId =...
  15. SQLScholar

    SQL Management Studio - Regions

    Hey all, You know in management studio when you write a query, you can break it down into regions (so you get the little plus\minus symbol to collapse or maximise). As a standard feature was this in 2008 or 2008r2. I thought it was in 2008 but it doesnt seem to create any regions for me. I...
  16. SQLScholar

    Excel JET connection

    Hey all I have this code exert connectionString = "Provider =Microsoft.Jet.OLEDB.4.0; Data Source =""" + Dts.Variables("Filename").Value.ToString + """; Extended Properties =""Excel 8.0;HDR=No;IMEX=0""; " conn.ConnectionString = connectionString...
  17. SQLScholar

    Excel column headers

    Hey all, I have a piece of VB.net code within SSIS that seems to do nearly what i want it to do. However where i am currently saying MsgBox(Reader.Item(0)) it brings back what is on row 2. I want the row headers first, so i want whats on row1. Or the column name, field name - however...
  18. SQLScholar

    File in use by another process

    Hey all, I have a for each file loop in SSIS. After its gone through its stuff with each file, i want it to delete the file. However its saying that the file is in use by another process. Any ideas? Is it because the loop is still running and its still on that file in the loop? How do i...
  19. SQLScholar

    CTE non stop recursiveness

    Hey all, I am still dont 100% understand CTEs. We have a little issue with a CTE that doesnt stop running. Basically i need to create a list of every date, cross joined to a table with about 10 rows. Without the cross join element it works perfectly. With it - it starts off working ok...
  20. SQLScholar

    File Not Found

    Hey guys, I have this code (BTW i have enabled xp_cmdshell): CREATE TABLE #Files ( [FileName] VARCHAR(256) NULL ) INSERT INTO #Files([FileName]) EXEC xp_cmdshell 'dir /A-D /B c:\qr' SELECT * FROM #Files drop table #files and all i get back is: File Not Found however if i run dir /A-D...

Part and Inventory Search

Back
Top