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

    command button

    I have a form created with multiple text fields for users to input the information and the data is saved in the access table. How do I add a button to the form for user to attach a word document for each item the user has entered into the form. The word document is different for each item...
  2. ituser2008

    Pivot table questions

    Actually, I need to be able to see the detail behind the bucket 1-30. For example, if there are 2 items in the bucket 1-30, I want to see the detals for these 2 items such as username, systemid, and other fields from the datasource. Currently the way the pivot table has created, it will shows...
  3. ituser2008

    Pivot table questions

    Thanks for everybody's responses. Yes, the datasources is in the workbook and I tried the drill down option. It does bring the details to another tab with the rows I have selected but what I really want to see is if it possible to only show the detail for a particular aging bucket I have...
  4. ituser2008

    Pivot table questions

    I have a pivot table layout liked the following. Is anyway when I double click on the items counts listed under each aging bucket and it will show the detail for the age bucket and the user I clicked on?? For example, if there are 2 items listed under age 1-30 bucket with user Mary, when I...
  5. ituser2008

    data source question

    I have a pivot table created by a former colleage and it was connected to a different sql server. How do I change the datasource so it can connect to the new sql server?? I tried to create a new data source but I still can't get the pivot table to change it to the new server. Any help will be...
  6. ituser2008

    sql server agent

    How can I find out what is the operation system account assigned to the sql server agent?? Any help will be greatly appreciated. thanks
  7. ituser2008

    "SA" question

    Is SA a default username setup up by sql server?? Does it come with a default password??
  8. ituser2008

    dts package

    Has anybody experienced the same issue as I have??
  9. ituser2008

    dts package

    yes, the package was changed to the new server name. I was able to open the package and run it manually but if i schedule the job to run, it failed and I got an error message stated " access is denied". Have no clue why i can run it manually but the job is not running automatically. Has anybody...
  10. ituser2008

    dts package

    I reimported the dts package into the sql on the new box. I don't think there is a password on the package. How do I check the security for the package?? The job only started failed after the move.
  11. ituser2008

    dts package

    We had a server move last month and the scheduled job ( a dts package) started failing after the move. I kept getting error message " access is denied" and can't figure out the reason. All the databases were backup and restored to the new server. I can manually execute the package and it ran...
  12. ituser2008

    remove or supress duplicate

    Thanks for everybody’s help. I was able to suppress the duplicate record by adding the formula to the section detail. However, when I tried to sum the trans amount and place at the report footer section, the trans amount for the duplicate record was also being calculated into the total. Any...
  13. ituser2008

    remove or supress duplicate

    Yes, it is a 1 to many relationship but the records needs to be at the detail level. Is any other way to do it??
  14. ituser2008

    remove or supress duplicate

    How can I suppress duplicate records at the detail section?? The report is group by customer id and below is an example. Any help will be greatly appreciated. Thanks customer id Productid transdate 1234 a50 5/10/07 1234 a50 5/10/07
  15. ituser2008

    ToText

    I am trying to convert a number field to a string field but when I used the totext function, it returned 'comma' to the output. How can I elimiate the ',' from the output?? Any help will be greatly appreciated. Plan_id with type= number (22,0) left(totext({plan_ID}, 0), 5) output 13,22
  16. ituser2008

    insert error

    I am trying to do an insert statement and kept getting this error message and couldn't figure out the reason. I have checked all the fields and they all matched between the two tables. Does anybody know what this means?? Is it because of the datatype?? insert error: column name or number of...
  17. ituser2008

    access general question

    No, they have set up where everybody can go to the shared drive and open the database. I think I do see something like compacting the datbase during closing of the database. What does compacting do?? please help. thanks
  18. ituser2008

    access general question

    I have a database with some forms that was created by former employee and i am experiencing a problem. Whenever someone closed the database abnormally, it will create a seperate database file in the directory for ex, db1, and if 2nd person doesn't close the database by clicking on the close...
  19. ituser2008

    copy dts pkg

    Does anybody know how to copy a dts pkg from one sql server to another sql server with *.dts pkg?? thanks
  20. ituser2008

    dts package

    where do i see the information after the trace has been ran??

Part and Inventory Search

Back
Top