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: *

  1. jeffwest21

    selecting data where it does or does not appear in a table

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

    selecting data where it does or does not appear in a table

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

    selecting data where it does or does not appear in a table

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

    Two groups totalling

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

    Two groups totalling

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

    Connect to more than 1 sftp

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

    Create MVC Questionairre

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

    Combo Box populating a text box after update

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

    Password Form for Multiple Objects HELP!

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

    Chart Headings from Field

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

    Chart Headings from Field

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

    Stored proc not creating temp table

    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...'
  13. jeffwest21

    Stored proc not creating temp table

    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...'
  14. jeffwest21

    Stored proc not creating temp table

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

    Chart Headings from Field

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

    Chart Headings from Field

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

    Chart Headings from Field

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

    Chart Headings from Field

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

    Chart Headings from Field

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

    Export to sequential folders

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

Part and Inventory Search

Back
Top