Search results for query: *

Hi, I would greatly appreciate it if anyone could 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...

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

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.

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

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!!

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

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

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!

I am trying to create a macro that copies the values of one cell and pastes it into another cell. Each time the macro is run the number of records might be different. How can I find the row number of the last record, so my macro doesn't copy empty cells over?

How do I start a report's page number at 3 and then continue counting the page numbers from there?