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...
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 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...
Thanks for the help, managed to do it this way in the end which works fine
This is the first piece of code in the first SP that runs.
It creates the folder if it doesn't already exits.
DECLARE @RunNumberTest int
--set @Dir = '\\jaguar\share$\Database Services\BrighthouseExports\'
SET @Dir =...
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.