Search results for query: *

Hi Guys! I have a table that has the reasons for loosing a game. This table contains the following fields: ID, Reason. ID REASON 1 FRAUD 2 LACK OF UNIFORM 3 BAD HITTER 4 COLD BAT 5 BAD COLD Now, I'm trying to make a query (I will integrate it into an ETL...

Hi Guys! I want to hide the source of my page, so that when the visitor selects View --> Source, nothing shows. Is there a way to do that? Thanks! [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Hi Guys!!! I need to translate a date. For example, if my user enters 08/20/2004, I need it to read 20 de agosto de 2004, instead of August 20, 2004, WITHOUT me having to change the system settings. Does anyone knows how to do this, without entering into a long, long SELECT --> CASE routine...

Hi Everyone! As many of you know, I work for a telecommunications company, in which we handle millions of customers anually. These customers have each a customer_id assigned, and in many cases (specially corporate customers), one customer_id can have several tel_number assigned to it. I have...

Hi Guys! I have the following situation. After calculating the difference between two dates, I need to separate the weekends contained within those two dates. Do you guys have any idea how to do that? Thanks! [gorgeous] Issys Pouerie Systems Support Analyst San Juan, Puerto Rico

Hi Guys! I have a table that contains all the vendor codes and descriptions. For example: Cod_vendor Vendor_desc -------------------------------- 108553 Vendor1 108556 Vendor2 108559 Vendor3 108561 Vendor4 108563 Vendor5 What I want is to create a...

Hi Guys! I have an Access app that calls a report from a form. This form contains only three fields: PO No., Part No, Labels Amount. The report is supposed to print the amount of labels specified on the Labels Amount field. So, if PO No Part No Labels Amount 1111 2222...

Hi! My father's Windows XP Pro has been showing the following error every time you turn on the computer: Invalid BOOT.INI Booting from C:\windows I tried to do the Windows XP CD to start the Recovery Console. Once I run the part, and the C prompt appears, I do a chkdsk and it runs for a...

Hi! I have a model whose source are a few iqd's. I'm having problems with one of the dimensions. It should return 2 categories: cat 1 (debit) and cat 2 (credit). Instead it only returns one. I have tried removing the category and re-creating it, and it works then, but if I save the model...

Hi!!! I'm running Crystal 8.0. I have a main report that has 2 subreports, which I'm calling from VB 6.0. I am passing Crystal a selection formula, so that only the data that meets that criteria gets returned. But that also applies to the subreports, which I only need to see specific data...

Hi Guys! I need to capture when a user presses the ESC key to close a form or when they use their mouse by pressing the X button. Automatically it goes into the Unload event without capturing which was pressed (Esc or mouse). Can any of you help?? Thanks a lot!! [sunshine] [gorgeous] Nunina

Hi guys! I have a field that holds telephone numbers. They can be in any format: 1234567890, 123-456-7890 or 456-7890. I need to format the field in a query to show the telephone as 123-456-7890. I tried this in my query: to_char(G.TEF_CLIENTE1,'### ###-####') , but I get an...

Hi! I get a "Cannot define field more than once" error when trying to link a table to my Access project. I have several other tables linked, and there was no problem linking them. Does any of you know what does it mean? Thanks in advance! [gorgeous] Nunina

Hi!!! I'm trying to bind a column of my datagrid to a table other than the one the grid is bound to. Any suggestions? Thanks, [gorgeous] Nunina

Can I open a .NET app in VB6 sp5?? If so, how do I do it? Thanks for your answer... Nunina [gorgeous]

Hi Guys! I have a data grid that is bound with an ado recordset. I need to populate the columns of another grid that is unbound in order to show information, write additional data into the grid, and then save it to a table. The problem is I cannot show the 1st's grid data into the 2nd's...

I'm new at .NET, but experienced at VB 6.0. Is the proyect extension the same for VB 6.0 as for a .NET proyect? I developed a new proyect but I don't think I saved it, so if I was to look for it on my Windows Search, which extension would I use? The .vbp I used for VB 6.0? Thanks Nunina

Hi!!! I'm having the following problem: Tabla A & Table B have the social security field as the joining field of the tables. The thing is that the social security can appear as 123-45-6789 or 123456789 on either table. Obviously, when I try to join table A & B, it cannot find the records...

Hi guys! What does the (+) do in a query? Where does it go? Before or after the criteria? Thanks!!! Nunina [gorgeous]

Hi! We are developing a report which shows all the information of our customers in the form of a contract. We created the report using the wizard, and the Visual Linking Expert. Then added the fields to the report and a parameter to search the data by the customer id. The SQL Query that...