Recent content by flip79

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