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!

Register Log in
  • Congratulations Rhinorhino 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: flaviooooo
  • Content: Threads
  • Order by date
  1. flaviooooo

    Dxdiag doesn't recognize my driver

    Hey, I'm having issues reinstalling FIFA14 and the EA helpdesk pointed me to an apparent video card issue: I have a NVIDIA GeForce 8800 GTX. If I run dxdiag, it shows the Card Name but no drivers are being detected?: I downloaded the latest drivers several times, but dxdiag doesn't budge...
  2. flaviooooo

    Link to cell in another workbook

    Hey, I have a list of usernames as such: John Davies Elmer McDonald Alberto Vicenzo ... Every month, excel workbooks are created via a VBA macro that have the names of these users. So we have a book called John Davies.xls, Elmer McDonald.xls etc etc Now: in each of these sheets, several...
  3. flaviooooo

    Code which tray to print from

    Hey, I have a database that is being used by 2 different users. There is a report that will always need to print from their printer tray 2 (labels), but they use a different printer (2 different types as well off course) If I set in the page setup of the report that the tray 2 needs to be...
  4. flaviooooo

    IE7: selection of text is unreadable

    Hey, I have a strange issue on one PC with IE7 installed: when the user selects a block of text, the background colour is the same as the text colour (black) -> the block is unreadable... This only happens in IE, not in MS Word etc... Any ideas? Grtz Fabian
  5. flaviooooo

    Count unique values that have a condition

    OK, here is my problem: I have a list of orders that were started in a certain period. Most of them have a produced qty, but some don't. In their cases, the order started and then they found out there was not enough material or whatever to go ahead. It can also happen that an order was produced...
  6. flaviooooo

    Problems came up in the following areas during load

    Hey, a colleague of mine has an annoying excel-issue. She saved an excelfile on her desktop and took it home with her, to finish it in the evening. She did some extensive work on it, but when she returns to work the next day... the file won't open anymore. Well, it opens but gives this error...
  7. flaviooooo

    Km per hour -> how many hours

    Hey, if I have a value number of kilometers, and a value kilometers/hour... how can I calculate and display the number of hours, minutes and seconds (even thousands of seconds if possible)? So I have 50 kilometers, we have a speed of 20 km/hour -> 2,5 = 2:30:00(:00) Thanks in advance
  8. flaviooooo

    Random number between 2 values

    Hey, I'm looking for a way to create a random number between 2 values, for example between 20 and 40. At the moment I use this code: Public Function randomvalue(number As Integer) Dim x As Integer Randomize ' Initialize random-number generator. randomvalue = Int((number * Rnd) + 1) '...
  9. flaviooooo

    2 "odds"-questions

    Hey all, I have 2 questions regarding odds, which I hope someone can help me with: 1) How can I create a function which returns me the following: I have percentage and based on that percentage it gives me the value 1 or 0. So for example I pass 75% to the function, so there is 75% chance the...
  10. flaviooooo

    Select top 3 per site

    Hey guys, I have a table which consists of the sales figures, per person per site. Site A Chris 5000 A Frank 2000 A Holly 3500 A Mark 6000 A Tony 1000 A Isabelle 2500 B Harry 3000 B Peter 9000 B Willy 1050 B Jack 2000 B Ann 6500 Now I would like to have some kind of top 3 people per site...
  11. flaviooooo

    Exporting as XML

    Hey, I'm trying to export a query to XML format, but don't know how to do it properlY... I'm using the following at the moment: Dim stDocName As String stDocName = "Q_STOCK_LABEL_RM" DoCmd.OutputTo acOutputQuery, stDocName, acFormatXML, "C:\test.xml", False, "" But this only pops up the...
  12. flaviooooo

    Turn over the crosstab

    Hey, I have a crosstab that's formatted like this: A B C Mat1 1 2 3 Mat2 6 7 8 ... Now I would like to get this like this: Mat1 A 1 Mat1 B 2 Mat1 C 3 Mat2 A 6 Mat2 B 7 Mat2 C 8 Off course this is a simplified example, the real...
  13. flaviooooo

    Nested select statement

    Hey, I'm trying the following: I have a query containing all cylinders of a code, like this: A 1 123 A 2 124 A 3 256 B 1 125 B 2 222 C 1 126 C 2 127 C 3 128 I have another query with detailed info per code: A CodeA Customer1 B CodeB Customer2 C CodeC Customer3 Now I would like to add 3...
  14. flaviooooo

    Setting percentages straight

    Hey, I'm having some problems with the following: we have a designcode that consists of several inks. Every ink is defined as to having a certain amount of KG in the design, and then a column percentage is set that shows how much of the design this ink is part of... sounds complicated, but...
  15. flaviooooo

    Reportfield upside down

    Hey, I don't know if this can be done, but how would I put a field on my report upside down? Thanks in advance
  16. flaviooooo

    Concatenating column into 1 field

    Hey, I have the following situation, and have no idea how to solve this: A table (actually a view, but let's call it table1) contains the following: Mat Our Material Importdate 1 123 1/10/2007 1 124 1/10/2007 2 321 1/10/2007 3 456 1/10/2007 1...
  17. flaviooooo

    Filtering rows from textfile

    Hey, I have a massive txt-file (62 MB, over 1 million rows) that contains a 10-digit code. Now I need to filter out the codes on row 6,14,22,30,38,... (every 8th row, starting from row 6) I don't think this is possible in textfile, so I'm pumping the data to Excel (in different sheets) Now...
  18. flaviooooo

    Count distinct orders with condition

    Hey, I have an excel like this: Week Order1 Order2 Order3 1 123456 123457 123457 01 2 123458 123459 2 123460 Now I would like to count the amount of distinct orders in each row. Watch out, an distinct order is only the first 6 digits. So in Week 1 for example 123457 and...
  19. flaviooooo

    Average of 3 values

    Hey, this seems like an easy task, but I can't see the solution: I have 3 separate ratings for a player, from 3 different news papers. Now I would like to compile an average rating per player. I have PlayerID, HBVL_Rating, LDH_Rating, VM_Rating Beware, sometimes one of the ratings is not...
  20. flaviooooo

    Sortable percentage in query

    Hey, this seems like such a simple question, but I can't get it to work... I have a query that does a calculation. Now I would like to show this calculation through a new query, as a percent. I do this as follows: SELECT Format([attr_perc]/100,"Percent") AS ATTR_P, Q_ATTR.StaffID...

Part and Inventory Search

Back
Top