3,481 Topics
 | |
| | Hi, I have an MS SQL 2000 database with a table that is used to store the header information on product returns. One of the fields in the table is a true/false field that indicates if the return has been processed (become a credit note). Can anyone tell me how … |
| | Hi Guys, Just Wondering if it's possible to choose whether to run a macro or not depending on which user logs in. I've got a macro which updates the database everytime it starts. I want to restrict it to only limited number of users. Thanks for your time |
| | Can a query running a selected database access a table on other database? How do I grant this kind of access? Going further, can a Foreign key be created among diferent databases? I'm running around this doubts for a while. Any help is welcome. []s |
 | Hi, guys! Got a problem here. :) I have a form that when it loads spawns a thread which in turn fills a publicly declared dataset with a table by a dataadapter and then binds a field from the table to a combobox. [code=vb]combobox1.DisplayMember = "fieldName" combobox1.ValueMember = "fieldName" combobox1.DataSource … |
| | Hi Guys, I'm having a bit of problem with my reports. I've got a report containing a subreport which has some headings in its report header. The subreport normally goes for 2 or 3 pages. The headings of the subreport appear on the first page but do not appear on … |
| | Hi Guys, Just wondering what's wrong with this coding UN = Form_MAIN!LOGIN_DETAILS.Value model = Form!COMBO_MODEL.Value stDocName = "MODEL_SELECTION" stCOND= "[MODEL_LN]='" & model & "'" And "[TM_NAME]='" & UN & "'" DoCmd.OpenReport stDocName, acViewPreview, , stCOND I'm getting a type mismatch error on the line where I specify value to stCOND. … |
| | Hi, when I installed MYSQL Developer Edition, a new invisible user was created called SQLDebugger. I was just wondering, can I delete this user. I just find it inconvenient that when ever I leave my computer idle for a few minutes, windows goes back to the user selection screen. If … |
| | [COLOR="DarkRed"][B]OBJECTIVE[/B][/COLOR] • Seeking a position of software developer working with Java/J2EE, Hibernate, Velocity, XML, … , telecommute • Able to work under stress, with tight deadlines [COLOR="darkred"][B]EXPERIENCE[/B][/COLOR] • 5+ year of experience as software developer at MaxIQ Computer • 3 year of experience as web developer at MaxIQ Computer and … |
| | I apologize if this isn't the correct forum for this issue. I found your site while Googling for similar issues and ended up here. The advice looks very promising so I'm hoping you can help me! I received the following error on a BSOD after burning a data DVD last …  |
| | Hi, since this morning, my mouse been very difficult to control on my notepad. Even if i fixed an additional USB mouse, the cursor just stay generally dead. Can someone pls help to advise? I am in urgent need to use my laptop for work. Hope for someone to help … |
| | [quote=AWebber;248590]I have a very annoying pop-up in my task bar tell ing me to download antimalware because of an infection. It keeps flashing between a "Question Mark" and a "No Entry" symbol. Here is my HiJackThis log: Logfile of HijackThis v1.99.1 Scan saved at 6:13:38 PM, on 9/1/2006 Platform: Windows …  |
| | Hi All I am hoping you may be able to help me with a general query I have, I am working on a small script to query our MSSQL database, it is basically a database of search terms, i.e. Term, Date help me, 22-10-2006 searchfor, 22-10-2006 What I want to … |
| | Hi all, I have a problem with an SQL-query and I don't know what the best solution would be to solve the problem. [code] /*INSERT INTO WERKS ( WERKS.Z8601, WERKS.Z8602, WERKS.Z8603, WERKS.Z8604, WERKS.Z8605, WERKS.Z8606, WERKS.Z8607, WERKS.Z8608, WERKS.Z8609, WERKS.Z8610, WERKS.Z8611, WERKS.Z8621, WERKS.Z8622, WERKS.Z8623, WERKS.Z8624, WERKS.Z8625, WERKS.Z8626, WERKS.Z8627, WERKS.Z8628, WERKS.Z8629, WERKS.Z8630, WERKS.Z8631, … |
| | I've run spybot S&D, and McAfee, to no avail. Here's my HijackThis! log (and thanks in advance for your help): Logfile of HijackThis v1.99.1 Scan saved at 4:11:24 PM, on 10/22/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\ibmpmsvc.exe … |
| | Hi All, I have a stored procedure which displays list of ADMITTED,QUEUED and DISCHARGED patients. The patient status is stored in a table. A represents ADMITTED patient, Q represents QUEUED patient and D represents DISCHARGED patient. I am using a dropdown to display the ADMITTED,QUEUED and DISCHARGED patients respectively. I …  |
| | Hi all, God Bless U, [B]Thursday, October 19, 2006[/B] [COLOR=red][B]first i am writing the my problem again......:!: [/B][/COLOR] i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer … |
| | Hi all,:confused: God Bless U, i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer 4 Goeffery Empl0yer ------------------------------------------------ Here the identity column is the first one. Now … |
| | Hi, how can i retrieve information from ms sql server using vb.net 2003 when i enter my id in my field? can somebody help me with it.. thanks.. |
| | I am having a hard time trying to get rid of hacktool.rootkit. I didn't find any of the common files on my system. Also, tried to run a online scan with house call and it just quits. It also does this with NAV in safe mode. Any suggestions would be … |
| | Hi I have a strange problem with my IE that I have not seen before, which is that IE 6 will not start whenever I attempt to start it from any of the common methods (clicking on the "Blue e" in the toolbar, start menu, desk top). However, IE will … |
| | I fell into a trap I always preach others how to avoid it! :rolleyes: I opened an attachment that came in a message of a receipt of a familiar purchase I presumably made. Now I get this message from Norton anti-virus that the "Hacktool.Rootkit" was found and quarantined. I have … |
| | [B]Intro[/B] Here is how to set up Microsofts MSDE for personal development. [B]Getting started[/B] Download the MSDE from: [url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url] Select 'SQL2kdesksp3.exe' and save it to your computer. Double-click on the SQL2kdesksp3.exe you downloaded. Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt. Start > Run … |
| | Just recently from time to time, my IE opens and goes to an advertisement page. (Everytime its a different ad) I am using a laptop and I have another monitor attached to it. When the IE opens up my laptop screen turns into movie screen and shows movie clips of … |
| | ahhh i've fallen victim to what i believe is that pain in the ballz OIN trojan. my sister got it from some stupid website. anyway, i hope you guys can help! here's my hijack this log: Logfile of HijackThis v1.99.1 Scan saved at 6:36:41 PM, on 10/7/2006 Platform: Windows XP … |
| | Hi all i have this problem İ was playing game in web browser then a massege come and told me that i must upgrade my java 5.0 to 6 and i updgraded that... When i close the browser my pc restarts... When i tried to delete this java it still … |
| | ##USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and … |
| | My Internet Explorer (Version 6.0, SP2) would work for about 5 minutes after boot-up, then I would get the "The page cannot be displayed" error, with "Cannot find server or DNS error" at the bottom. It does not matter which website I try to open. I get the same error … |
| | I'm trying to get the following query both functional and controlled via inner joins rather than this format, as the way it is now will be slow once the db fills up I've never been good with joins and this is the first time for me working with MS SQL … |
| | Can anybody ttell me the query for the question below, plz? [COLOR=#000000](a) Output the names of students and their addresses for those students who are living in Hunghom. [/COLOR] [COLOR=#000000]thx a lot~~~[/COLOR]  |
| | Hi Everyone, I just wanted to know if it's possible to create a chart in a report based on multiple queries. Thank you for your time |
| | [COLOR=#000000]Please help! When I click on certain links it closes out all the window(s) I have open (1 or 2). Thanks.[/COLOR] [COLOR=#000000][/COLOR] [COLOR=#000000]Logfile of HijackThis v1.99.1[/COLOR] [COLOR=#000000]Scan saved at 10:02:17 PM, on 9/22/2006[/COLOR] [COLOR=#000000]Platform: Windows XP SP2 (WinNT 5.01.2600)[/COLOR] [COLOR=#000000]MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]Running processes:[/COLOR] [COLOR=#000000]C:\WINDOWS\System32\smss.exe[/COLOR] … |
| | Hi, Everybody. I'm new to MS SQL Reporting services, and i've got some troubles with it. I cannot integrate my report with the site. I've tried to do it in such two ways: 1) using ReportViewer control. But the server where report is stored need authentication, and this control doen't … |
| | Hi, I need a view with weeknumbers according to ISO. This means 1-1-2006 is week 53. Now I created a function: [MS SQL] CREATE FUNCTION dbo.WOY ( @Date DATETIME ) RETURNS SMALLINT AS BEGIN DECLARE @WEEK SMALLINT IF DATEPART(dw, CAST('1-1-' + CAST(DATEPART(YYYY, @Date) AS VARCHAR) AS DATETIME)) > 4 IF …  |
| | Alright I've written a password manager before in Java, but it sucked pretty bad. I've decided to make another one in C#. My problem is I don't knwo what file format to use. I could use a text file and use des encryption, but I wanted to know if its … |
| | [COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over … |
| | I have a very annoying pop-up in my task bar tell ing me to download antimalware because of an infection. It keeps flashing between a "Question Mark" and a "No Entry" symbol. Here is my HiJackThis log: Logfile of HijackThis v1.99.1 Scan saved at 6:13:38 PM, on 9/1/2006 Platform: Windows … |
| | Hi, how would i be able to display chinese words by entering Sql? Can anyone please help me? Thanks, Jeremy |
| | hi, i have installed sql-server 2000 on win-xp pc . but when i am using sql server it requires authentication from server ,but i do not have any server ,by this i am unable to use sql database in my vb application .is any method to use sqlserver 2000 without … |
| | I am new with SQL Server 2005. Is it possible to store a column ALIAS at time of table creation? User wants business name and cryptic alias.:mrgreen: |
| | Hi everybody, i m qcdms21 , i would like to know can we update in views , i m been told select can be used but not insert. How about update? For ex: i have loanview1 as view , inside it i have loan , guarantor and student db tables. … |
| | I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write: [CODE] SELECT * FROM table WHERE field like '%$val%' [/CODE] this will list all recoreds that the field contains sub-string "abc". Now the question is: if I have a … |
| | I have 3 tables that need be joined. (Not necessarily needed info but might help: using Coldfusion with ODBC to Foxpro database) Table 1: Timecard -------- loginname date wrknum time ----------- --------- --------- ------ afrank 7/17/06 1 3 afrank 7/17/06 2 2 afrank 7/17/06 3 3 afrank 5/20/06 1 3 … |
| | Hello, I am trying to implement a fulltext search on a MS SQL database. While I can query each table independently for a specific word, I didn't find a method to query the entire collection of tables for my search key. Is there a way to do this (using the … |
| | Hi all, Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped. Here is the query [CODE] SELECT * FROM MOTORS WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR (CUSTOMERID = '62') OR … |
| | Hi guys, Need some help in some query processing... Here goes,this is the results i have obtained so far |id |cat | name | 1 .....a apple 1 .....b banana 2 .....a austria 2 .....b brazil 2 .....c china 3 .....a abraham 3 .....c clinton Column cat can have at … |
| | Hi, I've got a Dell Inspiron 9200 running XP Home SP2, 2GB RAM. I think I am being hijacked.... SVCHOST keeps connecting to a ip address and I dont know why... svchost.exe:1992 TCP 192.168.2.100:1151 207.46.253.157:443 ESTABLISHED svchost.exe:1992 TCP 192.168.2.100:1153 64.86.136.32:80 ESTABLISHED Enclosed is the Hijackthis and Silent Runners Log... Thanks … |
| | hello everyone, I need some help, [INDENT]I just rebooted my computer because it was running to slow. So when I rebooted it and basically put my computer back to where it was before by installing everything. It turns out that my computer is running at least twice as slow as … |
| | Hi guys, Let me describe the situation I am in. I have a table of 2000 objects and each object has a range of different prices associated with it, stored in another table. I have created a view which serves to list the objects as well as their average price. …  |
| | Dear Friends, I have posted my hijack log here. Please help me to get rid of Critical System Error message Logfile of HijackThis v1.99.1 Scan saved at 8:11:58 PM, on 9/6/2006 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe … |
| | Hi, Is there any way of finding the modal (most frequent) occurrence of a value. I know that mode doesn't exist in the same way that count, avg and max do but is there any way to combine count and max in such a way to find the most frequent … |
The End.