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

  • Users: DataChick
  • Content: Threads
  • Order by date
  1. DataChick

    How to Create a SharePoint Report of User Activity (Last Login)

    Is there a way for a SharePoint site admin to be able to see when the last time the members of the user groups logged in/accessed the SharePoint site? I have a SharePoint site with over 900 users in a group and I need to be able to see who is actively using the site content and who has not used...
  2. DataChick

    VBA PassThrough To Link SQL Tables

    I have an MS Access 2003 database front end that I am linking to a SQL Server 2008 backend. I need to assure that the users can log in through the ODBC DSN but NOT be able to access the password. I have 40 tables that are linked from SQL so what I was using was a PassThrough query that doesn't...
  3. DataChick

    Set db = CurrentDb Not Working for One User

    I have an MS Access database front end that is being used by over 50 users. I have one user who receives an error when attempting to run the "Set db = CurrentDb" code. He receives the error "Cannot Create Object" and when you click Debug it highlights "Set db = CurrentDB" in the VBA Code. He...
  4. DataChick

    Set db = CurrentDb Not Working for One User

    I have an MS Access database front end that is being used by over 50 users. I have one user who receives an error when attempting to run the "Set db = CurrentDb" code. He receives the error "Cannot Create Object" and when you click Debug it highlights "Set db = CurrentDB" in the VBA Code. He...
  5. DataChick

    Need Advice - Can we use Oracle in this situation?

    I am an MS Access developer working for a very large corporation. I have designed a database in Access to manage a process that has been thus far managed (poorly) in Excel and an eRoom. At the time that they gave me the specs on the project, they said it would have no more than 50 users -...
  6. DataChick

    Generating MS SharePoint Notifications/Emails from MS Access

    I have an MS Access database that I am using to send out notifications to distribution lists(generated from users linked to the MS Access record) through MS Outlook. The warnings and waiting that Outlook has is getting to be cumbersome for the users so I was attempting to use SharePoint to...
  7. DataChick

    Link to View Access 2003 Forms and Reports in Sharepoint

    I need to be able to let users open a form that is linked to an Access 2003 database from within a Sharepoint site. All the info I can find only shows how to link it from Access 2007. Is this possible with 2003 or do we need to upgrade to 07? Thank you in advance for any help you can provide...
  8. DataChick

    Linking Teradata Tables Through ODBC Shows No Tables In Access

    I am attempting to link tables in a MS Access database from a teradata database. The link table box shows up but there are no tables listed in the box (available for me to link). If another user links the tables (from their machine) then I can open the tables and access the data. Also, if...
  9. DataChick

    MS Excel Default File Location No Longer Exists

    One of the users in my department had their Default File Location set to a share drive. The server was changed and now that share drive no longer exists so whenever he tries to change anything in the Tools > Options area, he gets an error saying it cannot access that directory and it won't...
  10. DataChick

    Import From Excel - Cutting Off At 255 Characters

    I am importing from an Excel document into a memo field in Access and it's cutting off the data at 255 characters even though the Excel cells contain more than 255 characters. Is there a way to get all of the characters (even more than 255) to load in Access? Thank you in advance for your...
  11. DataChick

    Need Script To Change User Passwords

    I have a database that I've disabled the menus/toolbars but I need the users to be able to change their passwords. What I need is the script to be able to allow them to change their passwords without going through the toolbar options. Also, if anyone knows how to set it up so it requires them...
  12. DataChick

    Converting Word Documents to Excel Spreadsheets

    I have 100+ word documents that all consist of the same 6 tables in the same order - but some of them have one line of data and some have 10 lines of data in them (no two are ever the same). I need to get this data into an excel spreadsheet to gather some other information and then load into an...
  13. DataChick

    Saving XLS as CSV with Quotes

    I need to save my Excel document as a CSV file with the quotations. Just selecting the CSV format without quotation marks around the data doesn't put the quotes around the data when you open it in another application (ex. Word or Notepad)...but if I manually put quotations around each data...
  14. DataChick

    Union Queries - Referencing The Names Of The Source Table

    Is it possible to create a field that shows the name of the source table in a Union query? I am creating a union query to combine many source tables and I need to be able to easily reference which source table the particular data came from. Does anyone know if there is a way to pull in the...
  15. DataChick

    Displaying A Calendar with Events In Access

    I have a series of schedules and a group of people all assigned to a different schedule. What I want to be able to do is have a database that has a table with the schedules in it (schedule name and dates) then a table with the people and which schedule they are assigned to then have it populate...
  16. DataChick

    Difference between RTrim and RTrim$

    In MS Access in the Expression Builder there are number of Built In Functions listed both with and without the $. What is the significance of the $? What does it do differently and when should I use the one with the $ and when should I use the one without? "The most likely way for the world...
  17. DataChick

    Checking For Data In A Cell When User Activates

    I have two cells (E9 and M9) that can hold email addresses. I need to set it up so that when an email address is entered into one of the cells, it checks the other cell to make sure nothing has been entered into that cell and if there already IS an email address in the other cell, pop up a...
  18. DataChick

    Win98 ReInstall Setup

    I am definately in over my head. I was able to format the drive and reinstall Win98 but now the display is all messed up (only 256 colors) and it only has 8 bit audio. I don't know exactly what the setup was before but I had better display and audio. I don't know how to determine what drivers...
  19. DataChick

    Need Help Formatting Hard Drive And Installing Win98

    I have an older machine that got riddled with viruses and now I plan to wipe the hard drive and install Win98. I do not have the original CD that came with this system and have never attempted an O/S installation before. If someone knows of a FAQ or resource out there that I can read through...
  20. DataChick

    Putting A Hard Return In To A Field In Access

    I am attempting to create a list of items from a table. I have one user who has multiple unique records and I want to create one row with the user name and a list of the records. I have done this in the past putting commas between the unique items (ex. Item1, Item2, Item3...) but what I want...

Part and Inventory Search

Back
Top