Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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