Search results for query: *

Hey everyone, I would like to take a picture and set it as the background. The only problem is that I have frames! I would like to set the background in my .html document that contains the frameset. The reason for doing this is that I want picture to be seen in all frames as one continuous...

Thanks, you were right. That is strange b/c if you don't have the tblExcludePerson it is an error. But when you do have it w/out a join it creates a mess... Oh well, I understand now, Thank you.

Hi everyone, I am having a serious problem and cannot figure out how to fix it. I have a new query that has one query and a table. The query and table are not joined but I need the table there to exclude information from the original query. Here is the SQL Statement: SELECT...

Your right! I read something in the other thread that I posted the link to that said the tables/queries should be connected somehow. Well I did that and that was causing the problem. Thanks you.

Hey everyone, I am having a problem with a simple SQL Statement. I found something that worked on another thread but when I tried it it did not work. What I am trying to do here is exclude some data from a query by matching up the ApexID's. Here is the SQL Statement: SELECT queSubmit.Name...

Alright I got it to work (well you got it). Thank you so much. I understand now too haha. Thanks.

Okay, first off sorry for this confusion. Here is the SQL Statement: SELECT queCertification.APEX_ID, queCertification.certification FROM queCertification LEFT JOIN queActiveAPT ON queCertification.APEX_ID = queActiveAPT.APEX_ID WHERE...

Alright, I understand now. I think I just had a brain fart or something...just wasn't understanding where I should put it at first. Okay, I put it in the design view for the query (which puts it in the SQL statement under a Where statement) but nothing shows up in the datasheet view. I even...

I am guessing that is a Sequel Statement then, correct? I am a little new to this...I have written a sequel statement before but not one to create a query. Can you please explain or point me to a website, I would really appreciate that. As for as the actual code there, I have a...

Hi everyone, I am trying to create a query that will split a field into two types. The field has numerous certifications that are being kept (in text format). I would like to name some certifications 'CI' and others 'External'. Since there are many different types of certifications I prefer...

Also, there is a lot more that I need than just to be viewing the screen. What I wanted to do was allow the user to select a slide, and then that would copy and paste an excel range onto the slide. I have the code to copy and paste complete and even have an input box for this. Currently, I...

Hello everyone, I am having a problem activating a powerpoint window from a VBA in excel. I have a couple pieces of code but nothing happens when I run it. Can someone please help me with this, thanks: Sub ChangeToPower() Dim PPApp As PowerPoint.Application Dim PPPres As...

Okay I did a combonation of the last two. I made a userform with a button titled "Range." I then made an input box that allows the user to select a range with the mouse. When selecting with the mouse the input box updates automatically (I found this code somewhere else). This is actually...

Sorry, reposting the same thing b/c I did it wrong before... Ummm...not to sure I understand what you mean. I copied and pasted the code you put there but it doesn't allow me to run it. I know I am missing a step here, could you please explain in a little more detail. Thanks.

Ummm...not to sure I understand what you mean. I copied and pasted the code you put there but it doesn't allow me to run it. I know I am missing a step here, could you please explain in a little more detail. Thanks.

Hi, I am trying to write a code that will let the user select a range with the mouse during a macro. I have found a code where the user can select the code before the macro is ran but the user may have to select many different ranges on many different sheets. I have been looking and looking...

Alright, I will play around with it. Right now I am not experiencing any problems. I understand your concern because variables are getting reset and/or reinitializing. If I do find a error I will post it. I will try working with the code another way as well. Thanks, Sean

Okay, first off thank you for responding! In response to Mike, yes I do want the user to enter a column and row letter/number. I guess my brain was not functioning correctly, I looked up help for the error handling. You both were right about where I placed the error-handler. It needs to be...

Okay, I just made continue as so- Dim continue And this works for the loop. I am still getting the run-time error message though :( I do not understand why if the AddError works the first time and you make the same mistake the AddError does not work the second time. For example, if I ran...

Hi, I am a little confused here because my code works the first time the error trap works but the code will not work the second time. I get the error message runtime error 1004. I can type in a number instead of a letter and the error works, but if I do it again it will not work. Basically...