Search results for query: *

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

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

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

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!

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

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

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

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.

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

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

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

Oh ok. Thank you!!!

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

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

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

Thanks, we will try that!! =)

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

Thanks a lot to both of you!!!

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

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!