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!

  • Congratulations strongm 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: TrailblazerLS
  • Content: Threads
  • Order by date
  1. TrailblazerLS

    Can someone recommend a good book for charts and graphs

    I need to get to speed on charts and graphs...is there a good chapter in one of the books or a web site that someone can recommend. Thanx
  2. TrailblazerLS

    Could not delete from specified tables -- delete query message

    I am getting the message "Could not delete from specified tables" when I try to run a simple delete query. This query returns 1 row when I run it as a select query. ANy ideas?
  3. TrailblazerLS

    Lock file behavior. Does not delete itself.

    Confused about the lock file behavior. I noticed a lock file tonite when I was leaving the office. The users said they all closed out of the app. I looked at the lock file and my pc was the one in the file. I did not have the app open. When I got home, I checked the situation again, the lock...
  4. TrailblazerLS

    How to Make a database - read only...

    We have a read-only version of a database that they give to certain people. The save btn as well as some other things have limited functionality. Problem is now there are two versions to keep in sync. How do any of you deal with a situation such as this. And setting the property to read only is...
  5. TrailblazerLS

    Need design advise on option group and storing the value

    My user would like to tag their account records as a type 1 Or type 2 Or type 3. I originally set this up as an Option Group (with checkboxes) and stored the value "1" or "2" or "3" into a text field in the table. However, the fields on the form are checkboxes and this is causing some havoc with...
  6. TrailblazerLS

    How do you export a large table into excel

    I have a user with a table of 210,000 rows. She exported it into EXCEL and received only 16,000 rows. I thought Excel would convert 64,000 at a time. Should she copy from Access and paste into Excel???? Does she have to do it in increments????
  7. TrailblazerLS

    How can I Password protect a report

    A manager has requested that I password protect a report. They don't want the other users to see it. Off the top of my head I am not sure how to accomplish this. Is there a good way to do this.
  8. TrailblazerLS

    Access 2007

    Does anyone know if the new version will address compacting and repair. For instance, if you delete a table will the database automatically handle that bloat issue. Any improvements on the corruption issues.... Thanks
  9. TrailblazerLS

    Getting Type mismatch:’formatDateTime’ error

    It works on some computers and some it does not? One of the sites we work with have a testing room with 17 computers and all of a sudden this error comes up on one of our apps, but it works fine on other computers in the room and throughout the building. Any ideas?
  10. TrailblazerLS

    How do you load all the files in a folder for a user to select

    I would like to load a directory containing all the excel files and have the user be able to select the appropriate file and click on it to open.... Is there an easy way to accomplish this? OR a sample piece of code to do this task.
  11. TrailblazerLS

    How to Change check boxes to option box without the wizard...

    Is there a way to create option check boxes without going thru the wizard. I have inherited an existing app where there is a series of check boxes BUT the user wants to be able to select only 1....Is there an easy way to do this.... The app is OOP, and its difficult to maintain.
  12. TrailblazerLS

    Does IBM have a front end for DB2 for queries

    I have been using Access to query our mainframe DB2 tables. This works pretty well, but we would like to know if IBM-DB2 has some kind of front-end for developing queries.
  13. TrailblazerLS

    Anyone use InfoPath...

    I am doing an evaluation of the benefits and issues with Infopath. It may be useful for our organization, I would like to hear how and what you like about it and what you dislike. Thanks
  14. TrailblazerLS

    What does this mean...Can't contact LDAP Directory server (81)

    On my home machine I have Office Pro and use Outlook as my email client. Outlook has a feature when you begin a new email and type a letter in the "To" box, you get a list of everyone you have sent an email to that begins with that letter. How can I remove some of those names? I get the...
  15. TrailblazerLS

    What is raid 0

    I was talking to a collegue the other day about a new pc i was thinking about. He recommended I get the hard drive as RAID 0, he says its really fast. Can someone explain the benefits and the negatives of having this in a home machine.
  16. TrailblazerLS

    How can i change checkboxes to only select 1

    I am supporting an app where a section contains a series of check boxes...there are a series of 9 labels (1 to a row). After the label, there are 3 check boxes, the user can select more than one...How can I make it so they can select only one. Note...the code is object oriented and its very...
  17. TrailblazerLS

    Why would the modified date for class files be the same

    I noticed something strange with class files in my Access folders. If I change someting in one of the class files, all the class files dates become the same. Its not like that with the forms, for instance, if you modify a form, only the modified date for that form is changed. On class files...
  18. TrailblazerLS

    Using SendObject, can I send an attachment as part of the email?

    I have a report that I need to email on a daily basis, I would like to use the DoCmd.SendObject ..... I know I did this in the past, but I don't have the code available or I forgot how to do the attachment part. Anyone know ???
  19. TrailblazerLS

    How to Save the place in recordset --

    I have two loops, I want to save the place in the table being processed in the inner loop when control goes to the outer loop. And then when control passes to the inner loop again, I wish to move to the next record and process... I am using regular DAO dynasets....How can this be done... Thanks

Part and Inventory Search

Back
Top