Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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