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

  1. flip79

    Single Quote problem when connecting to Oracle db

    I can't get to your link. Can you post the entire address? Thanks for your help!!!
  2. flip79

    Single Quote problem when connecting to Oracle db

    ...help me figure out how to pass a SQL string to an Oracle database if the where criteria has a single quote in it somewhere. For Example: Select * From tblTitle Where Title = "A Book's Title" I tried using this statement below where me.txtTitle = "A Book's Title&quot...
  3. flip79

    How to stop some records being updated.

    Why don't you do a logical test and lock the field if (test) then me.field.locked = true Else me.fieldname.locked = false) End if
  4. flip79

    Create a list of tables on a form???

    Thanks a lot. I'm still wondering why the code I posted doesn't work. BTW, the error occurs whenever the form is opened (I put the code in the onCurrent event). Thanks again!
  5. flip79

    Create a list of tables on a form???

    I have found some code to create a dynamic list of tables in Access on a form, but I keep getting error #438 "object doesn't support this property or method". Do I need to add a reference from the reference library? If so, which one? Here's the code in case it helps. Private Sub...
  6. flip79

    Ms Access Query Export to Excel

    If you have a file open with the same name, you will get that error. Try closing the file before you export it.
  7. flip79

    Powerpoint Slide Show Music

    Thanks a lot! I posted the question for my boyfriend, and he says it works great!!!!
  8. flip79

    Powerpoint Slide Show Music

    How can you make a slideshow with Microsoft Powerpoint? I am trying to make a slide-show with music and a customized soundtrack that coincides with each slide, but I can't figure out how to start a music file and have it running for the duration of the slide show.
  9. flip79

    How to update a table on close/exit of the database??

    Thanks for the link, Maq! I'm looking foward to working on it!
  10. flip79

    How to update a table on close/exit of the database??

    Yes, I do have a main (switchboard form), and I also have quit buttons on all forms of the database. My concern is what if they click the X (close button) on the top right corner of the database. Does the 'Quit' button still execute the code behind it? I don't think the users are very...
  11. flip79

    How to update a table on close/exit of the database??

    How can I know when a user is exiting a database, and write code to update a table before the database closes? I have a database where a user logs in as a certain user type. When a user logs in, I update a yes/no field that says whether or not a user of the same type is logged in. That way if...
  12. flip79

    How can I show the character "&" in reports?

    Oh ok. Thank you!!!
  13. flip79

    How can I show the character "&" in reports?

    The & character usually concatenates things together, but I would like to show it as part of a label for a company name in a report, and it doesn't show up. Even when I put extra quotes around it. Anybody know how to get around it combining two strings together??? Thanks for any help!!
  14. flip79

    Unwanted Characters in Phone Numbers

    Thanks for all your help! I think I am very close to coming up with a solution.
  15. flip79

    Unwanted Characters in Phone Numbers

    I have a huge file containing phone numbers where all unwanted characters like paranthesis, spaces, periods, and dashes need to be removed. Is there a way to do this in VBA? Right now I am using the functions Left$, Right$, and Mid$ to remove the characters (and place the numbers back...
  16. flip79

    Refresh Excel formula results???

    Thanks, we will try that!! =)
  17. flip79

    Refresh Excel formula results???

    A coworker has a spreadsheet where the results of a formula on 1 worksheet are not being refreshed as new information is being inserted on another sheet (the new information is used in the formula). Is there any way to do a refresh for an entire worksheet? Currently, she has to go into each...
  18. flip79

    Excel - Lock a cell?

    Thanks a lot to both of you!!!
  19. flip79

    Excel - Lock a cell?

    I tried that, but it's not letting me format any cells after I protect the spreadsheet. Any more insight?? Thanks!
  20. flip79

    Excel - Lock a cell?

    Is it possible to lock a range of cells, and keep other cells open for user input? I would like to let users input values into cells, but not let them accidentally erase or change formulas relating to those cells. Is that possible? Thanks so much for any feedback!

Part and Inventory Search

Back
Top