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!

  • Congratulations bkrike 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: *

  • Users: renartbrazil
  • Content: Threads
  • Order by date
  1. renartbrazil

    end of one query, trigger another to begin

    How can I set up a brio query to trigger another query in the same bqy file? Like if I had a 2 step query, or a 3 step query, I would want to have step 2 run at the event of the step one's query completion.
  2. renartbrazil

    if cell matches cell in column A in external workbook

    I find myself looking at the same thing over and over when looking at specific data. Can not find any good examples on how to set it up. Simply looking to highlight a cell if it matches a cell in an external workbook. Any suggestions or links I possibably may have not come across to explain some...
  3. renartbrazil

    plotting

    Has anyone seen any examples of longitude and latitude being used in Flash? I have an idea but I have to get past this part or understand how it has been done. Thanks so much.
  4. renartbrazil

    loading txt from external txt file into a dynamic txt box

    I have come across some examples on the web for loading external txt files. I have a gallery I am working on and I am in need of some txt under each image. Any suggestions on the most effective way? Doing this for someone else and trying to make it simple as possible so they do not have to open...
  5. renartbrazil

    how to keep proportional an image

    this is similar as my last post, which was answered. what if i have several images, different dimensions. how to create a smaller image (which i will be using in a gallery) to keep its dimensions or ratio? below is a way for images that are always the same size. onClipEvent (data) {...
  6. renartbrazil

    position of a movie clip

    onClipEvent (data) { this._width = 142; this._height = 142; } i have several of these that will place an image here. it makes the image that size or what ever size i want but my images are not all the same size. does anyone know of a way to have this read to a "x" "y" position instead...
  7. renartbrazil

    DISTINCT COUNT

    I am using Distinct Count quite often and I see on issue so far. If there are 10 rows, 5 have different names in them, and 5 are blank then that will give me a Distinct Count of 6 (i want another column to give me the 'Count' of blanks.) How can I deal with the blanks? Can I drag another...
  8. renartbrazil

    it's like Ltrim but opposite

    I am familiar with creating different types of computed items but do not know how to create this. There is a column which I will be referencing in this computed item called theend or something. The data in there can be approx 17 to 24 characters. I know how to use Ltrim to trim some off or...
  9. renartbrazil

    zip codes

    Would like to know if anyone seen a place where it was explained how to combine a list of zip codes with long/lat in a map of the US using Flash, I have seen one such example (select zip codes at top of page) http://acg.media.mit.edu/people/fry
  10. renartbrazil

    has to do with a date and adding some days

    I have looked for the answer first, can't find anything similar to what I am trying to create. I have a date in column A, then column B will have a number like 90 that represents 90 days which I would like added to the date in column A that the output will be in column C. If I can get that much...
  11. renartbrazil

    need military time

    Is there an easy fix to format this for miltary time? This is what it looks like now. 3/14/2005 1:55:24 PM I am trying to get this format though. 3/14/2005 13:55 <code>Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Target(1, 3) = Date Target(1, 4) = Time...
  12. renartbrazil

    flash form flash form

    Two questions here. I have this in a Flash form using PHP to send the data to an email address. How can I get it to also be able to TAB backwards like Shift+Tab does in most programs? Also, can anyone tell me if there is something more code) that can be added to this that 'if the firstname text...
  13. renartbrazil

    contains / conditional

    =LEFT(C5,LEN($C$2))=$C$2 what do i sub LEFT with if i want 'Contains'? instead of the conditional saying that if current cell begins with what ever is typed in C2 then condition. any ideas?
  14. renartbrazil

    conditional ref a cell on a diff worksheet

    =LEFT(C4,LEN($C$2))=$C$2 I use this and many other variations but now taking it a step further and do not know how to make it reference cell C2 on a worksheet called parameters. I have tried but can not get it.
  15. renartbrazil

    query for distinct information

    Ok, I am going to botch this I already know but one question here about an Access query. I query a database using Access. One field is called State, Car and Type. So if I do a query of course there is different info pulled, but I get alot of data. So what I want to know is how could I complete...
  16. renartbrazil

    may be old news -

    i can not find any fla files or tutorials on how to create a forum in flash with using php or sql. is there a way? reason is that my dept has no communication, we need it but due to security reasons i can not put it on any of the servers that i need to put it. i have already put an...
  17. renartbrazil

    Just a conditional

    By the way the site is looking much better, nice. I have numbers in column D, they range from zero to 1500. The format is 42300 for $423.00. So I just want to make conditional formatting color that space if Cell Value is Between 45000 and 49900 then color BLUE. Which I have gotten that part...
  18. renartbrazil

    downloading a document

    I have done this before, been a while, just needing to have someone help me remember by typing the code for me. hehehe but really, i forgot what i need to do to link my button to a document. i have mx pro. i have tried several things but can not get it, please assist, thanks!
  19. renartbrazil

    play one MC then play another

    I have 3 MC's in my fla that I would like to play in order. Play one, then play the second then third one. Things like this I should know, but been this tends to happen when I dont play with Flash as often as I wish.
  20. renartbrazil

    has to do with me not knowing anything

    This has to do with someone (me) knowing HTML, Flash and have messed with a little PHP, no databases though. QUESTION: What do you think would be the best solution if I have a Flash GUI that will have numerous copies but need to show different information like address, comments, a year,etc...

Part and Inventory Search

Back
Top