Search results for query: *

I am going to give him a star as well, although to be honest as I had already said I had solved it by playing around with the joins until I got them correct, my issue was an old report that someone else had built (a very long time ago), on a poorly designed database that had 23 links through it...

Ok, got this sorted out, it all about the joins that just were not right. 'Clever boy...'

Having a stupid moment that I hope someone can help me with. I have a number of tables to pull some data from, two tables in particular, one has an ID that may or may not appear in table 2, the tables are linked via a join where a.con_id = b.Con_id. How do or I set up my join to pull back data...

I have had notification of a response, but can't see it? 'Clever boy...'

I have a report that basically looks like this Line 1 Date Day of the week 1 (should be 2) Line 2 Group Campaign 1 1 Line 3 All Regions 1 Line 4 Detail Row Region1 0 Line 5 Detail Row Region2 1 Line 6 Detail Row Region3 0 Line 7 Group Campaign 2 1 Line 8 All Regions 1 Line 9...

I am trying to set up a system to pull data from more than 1 sftp site at timed intervals during the day. I have found a piece of work that someone else did that does it from one, but I need to as I say from a second as well. The code I have in the app config is this. <appSettings>...

I am new to MVC and EF, I have followed a few pluralsight videos about implementation of MVC and EF, and want to create a Questionairre for staff to fill in, can anyone recommend a good online tutorial to achieve this. I have a basic concept of what I want to achieve, but am having a few issues...

Please excuse me if this is elsewhere but I can't seem to find it. I am trying to build a C# windows application form I have a combo box that is populated from a SQL database, which after the user updates the combo box, it adds an email address into a hidden filed on my form that will get...

I have a form within an application, the users can only log into the system if there NTlogin is in a table called Permissions, this also has a permission level, User or Admin. Certain buttons are all set to Visible = False On the Form Load event they are then turned on by this UserName =...

Sorry Duane I must be really dumb here. SELECT ID, Agent_Name, Admin_Name, Campaign_Name, Monitor_Date, Monitor_Time, Monitor_Comments, task_1_description,TempID FROM dbo_New_FTA_Score; If I make the adjustment as above, so bringing in the Task_1_Description into the main body of my...

I know you are trying to help, and I do appreciate it, but I can't really give you any more info. Below is the part of the above post where I say where the text box Text_Data get's it's value I have a text box on the report that has a field called Text_Data The text box will be populated by...

Than ks for this, managed to sort this out another way in the end, the code was commented out as I was testing and I just posted the wrong code snippet. 'Clever boy...'

Thanks, kind of what I thought, it should work, and does on a dev box but not a live one, both are set up exactly the same Getting the code re-written at the moment now to see if that makes a difference. 'Clever boy...'

I have a stored proc that when I run the code on it's own create table #Campaign_Hours ( Dateperiod varchar(20), USerID varchar(20), total_dialler_secs int, logged_on_time_secs int, busy_secs int, notready_secs int, preview_secs int, ready_secs int, wrapup_secs int, waittime_secs int...

Ok, maybe I haven't tried to tell you what is happening correctly, while I do not have a pull to the Task_1_Description, this is because the code snippet I gave you doesn't include it, however, please assume the following. I have a text box on the report that has a field called Text_Data The...

Duane I know you are trying to help here, I have said here how the report is populated. The query pulls the rest of the data through from the SQL table based on the id that is sent from the form, this includes the Task 1 description which is a field in the table from where the data is got...

The details for the report are passed by the id being pushed to the report when it is opened via strReport = "Agent_Report_FT_Admin" strWhereCondition = "TempID = " & Me.Number DoCmd.OpenReport strReport, acViewReport, , strWhereCondition The Task 1 etc.. is the x axis headings for the...

Sorry, I will try and explain better. I have a form that is filled in by a person, the details of that form are passed to a report which is emailed to that person. On the form are four drop downs, containing 30 different items from which they can choose from. The query pulls the bulk of...

I have a bar chart, where what will be on it will differ each time the report is run, what I want to do is name the elements dynamically from a field on the report, I have tried adding an alias to the query, noting the form filed I want to use, but this just errors with...

...Run_UK) SET @MkDir = ''+@Dir+@fileunique+'' UPDATE Run_UK SET Run_number = @RunNumberTest+1,Date = Getdate() SET @file = '"'+@MkDir+'"' + '\parkbad.txt' SELECT @sql = 'bcp "select * from Park.dbo.Park_Bad_Export_out " queryout '+ @file +' -c -t"," -T -S' + @@servername 'Clever boy...'