Forum: Windows Software  Dec 12th, 2008 |
| Replies: 1 Views: 416 Hi,
Use the inbuilt function nz
Expr1: (nz([prod_group_name],"") & " - " & nz([model],"") .... |
| Forum: Networking Hardware Configuration Dec 12th, 2008 |
| Replies: 2 Views: 1,052 Hi,
Are you using XP and Vista on the same network??, if so this will be the problem. But I have browsed the internet for a solution for this porblem and found non that worked (thank you... |
| Forum: JavaScript / DHTML / AJAX Dec 8th, 2008 |
| Replies: 5 Views: 731 Hi,
Amend your code to look something like this
<html>
<head>
<script langauge=javascript>
function baby()
{ |
| Forum: VB.NET Dec 6th, 2008 |
| Replies: 1 Views: 400 Hi,
Not bad for a start but I have attached a full calc. code as a gift. |
| Forum: Visual Basic 4 / 5 / 6 Dec 6th, 2008 |
| Replies: 3 Views: 533 Hi,
Man i dont wana to dash your hopes, but what you r trying to do is quite difficult using such controls. I advise you to look for an alternative idea. |
| Forum: Windows NT / 2000 / XP Dec 6th, 2008 |
| Replies: 2 Views: 355 Hi,
Main two virus attacks are web and removable devices. AVG is not bad if it is updated frequently, but I advise you to pay for a Kasparsky for further protection. But in all cases avoid visitng... |
| Forum: Windows NT / 2000 / XP Dec 6th, 2008 |
| Replies: 4 Views: 748 Hi,
Mainly not starting in safe mode is resulted of either corrupted windows (you will need to reinstall or repair windows), or virus attack were some viruses will prevent you from going into safe... |
| Forum: JavaScript / DHTML / AJAX Dec 6th, 2008 |
| Replies: 5 Views: 731 Hi,
try this
<html>
<head>
<script langauge=javascript>
function baby(a,b)
{ |
| Forum: Computer Science Dec 6th, 2008 |
| Replies: 3 Views: 673 Hi,
Am not sure what is a far point but you will sure need datagrids, and other form controls like text boxes, buttons, labels... |
| Forum: Web Browsers Dec 6th, 2008 |
| Replies: 2 Views: 472 Hi,
Most probably you have a spyware or adware that trying to access internet, and ususaly for a bad purpose. Go to run then type msconfig and press enter, go to startup and check those processes... |
| Forum: MS Access and FileMaker Pro Nov 20th, 2008 |
| Replies: 6 Views: 2,518 Hi,
Your best and simplest solution is to use ASP which will require you to install IIS from windows cd. And for how to do it, there are 1000s of codes describing connecting ASP to DB on the web. |
| Forum: MS Access and FileMaker Pro Nov 20th, 2008 |
| Replies: 1 Views: 843 Hi,
Your example is not that clear but i guess that you need to transfer your query to a crosstab. |
| Forum: MS Access and FileMaker Pro Nov 20th, 2008 |
| Replies: 1 Views: 867 Hi,
If you are using access you have to include the code in the before_update event of the text box. |
| Forum: MS Access and FileMaker Pro Aug 15th, 2008 |
| Replies: 1 Views: 1,806 Hi,
Please check the attached example.
Hope it will work for you. |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 3,078 Hi,
What do you mean by table variable??? |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 2,902 Hi,
What are you using Access, MSSQL 2000 or MSSQL 2005 |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 2,775 Hi,
My friend, your question have nothing to do with MSSQL, you should have posted it in Vb.net forum and i think you will need to use Cellstye.forecolor=Color.green |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 741 Hi,
This is an excellent forum but it is not specialized in DBs. In fact you will find alot of sites only intrested in MSSQL but I don't think you will find those expert examples you are looking... |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 1,018 Hi,
I don't know if I got u but try:
SELECT TOP 1 part_no, curr_date, cost_layer_qty
FROM inv_tran
WHERE (cost_layer_qty < 0)
ORDER BY cost_layer_qty DESC
Hope this works for you. |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 609 Hi,
Try this:
SELECT CONVERT(varchar, BROUTE) + ' ' + CONVERT(varchar, BACCOUNT) AS [Group], SUM([VALUE]) AS Total
FROM tblExample
GROUP BY CONVERT(varchar, BROUTE) + ' ' + CONVERT(varchar,... |
| Forum: VB.NET Aug 15th, 2008 |
| Replies: 2 Views: 484 Hi,
As Narania said if u know VB6, shiftting to vb.net will not be that hard. You can even upgrade your applications created in VB6 to .net simply. Many of the commands are still the same but some... |
| Forum: Windows NT / 2000 / XP Jun 2nd, 2008 |
| Replies: 2 Views: 1,403 Hi,
Mainly this is resulted from either an infection or from conflicting installations or drivers. The simplest way is to log in safe mode and then restore your computer to earlier period (to the... |
| Forum: VB.NET May 1st, 2008 |
| Replies: 2 Views: 1,378 Hi man,
Did you notice that your post doesn't make sence???
Please re-clarify the question or attach your application. |
| Forum: VB.NET May 1st, 2008 |
| Replies: 1 Views: 385 Hi,
For this you will need to use a Binding Source which you can navigate like a recordset using: BindingSourceEmp.MoveNext()
for more information you will have to post your code |
| Forum: MS Access and FileMaker Pro Feb 1st, 2008 |
| Replies: 8 Views: 15,015 Hi,
I have used lately the developer extensions of access and they don't actually create you a stand alone wersion of your mde or mdb but:
It will create you an installation file with the ability... |
| Forum: MS SQL Dec 31st, 2007 |
| Replies: 2 Views: 792 Hi,
How are you updating the table. 10K is not that big number when speaking about data bases. |
| Forum: VB.NET Dec 23rd, 2007 |
| Replies: 8 Views: 923 Hi,
You can find some free ebooks over the web, but I don't think that enough. To be a pro in VB you have to test what you are leaning. I always advise to start developing a simple application... |
| Forum: Viruses, Spyware and other Nasties Dec 23rd, 2007 |
| Replies: 3 Views: 936 Hi,
Go to below link and download the AVG anti virus free addition. Its a greate antivirus, install it and it will catch some trojans that no other anti virus has even detected (name it macafee,... |
| Forum: MS SQL Dec 23rd, 2007 |
| Replies: 1 Views: 773 Hi,
Create a stores procedure (called ex: CustInfo) and forward it the customer code to search for. The body of the procedure will be:
CREATE PROCEDURE CustInfo(@CustCod int) AS
IF (Select... |
| Forum: Visual Basic 4 / 5 / 6 Dec 23rd, 2007 |
| Replies: 3 Views: 1,374 Hi,
Open the new form in a new application and change the form name preperty and save it. After that add it to your application and it will work. Or you can change the name property of the original... |
| Forum: Visual Basic 4 / 5 / 6 Dec 18th, 2007 |
| Replies: 4 Views: 2,210 Hi,
[code]xlApp.ActiveWorkbook.Close True, App.Path & "\gegevens.xls"
xlApp.Quit
Set xlApp = Nothing[/close] |
| Forum: Website Reviews Dec 13th, 2007 |
| Replies: 4 Views: 781 Hi,
For the first impression the site looks good but I have expected that the menus (both left and top) are dynamic or at least have a houver action (motion or changing color). I think this will... |
| Forum: VB.NET Dec 13th, 2007 |
| Replies: 2 Views: 1,502 Hi,
If IsNumeric(Me.txtInput.Text) And Me.txtInput.Text > 10 And Me.txtInput.Text < 100 Then
'you action
End If |
| Forum: Database Design Dec 13th, 2007 |
| Replies: 2 Views: 4,614 Hi,
I think the best setup is:
calender( calender_id, date)
reservation(reservation_id, room_id, client_id,calender_id)
This way you will have the max control over your database where for wach... |
| Forum: Visual Basic 4 / 5 / 6 Dec 13th, 2007 |
| Replies: 6 Views: 3,294 Hi,
I previously had a function that gets a screen shot but i can't finf it any more. Look on the internet for a function that perform "Print Screen" and then a function to crop that picture. |
| Forum: Visual Basic 4 / 5 / 6 Dec 13th, 2007 |
| Replies: 6 Views: 1,821 Hi,
When u say you have to build an internet application do u mean you want to create dynamic webs or what?? |
| Forum: MS Access and FileMaker Pro Dec 12th, 2007 |
| Replies: 1 Views: 1,111 Hi,
Add in the validation rule: <=999
and the required message in the validataion text. |
| Forum: MS SQL Dec 10th, 2007 |
| Replies: 3 Views: 1,356 Hi,
You have to ways either export data from MSSQL to Excel or import it from excel to mssql:
For the first choose the database >> right click >> All tasks >> Export data >> choose the data... |
| Forum: MS SQL Dec 9th, 2007 |
| Replies: 3 Views: 1,356 Hi,
There are 2 ways, detach, backup, and attach. Or generate Script.
First the first one you will need to right click database and in all tasks sub menu choose detach database. Now go to the... |
| Forum: Database Design Dec 9th, 2007 |
| Replies: 2 Views: 905 Hi,
I didn't get your point but it seems that there is some thing wrong in your relation between Rep and Employee table. Can you tell me what you need to do instead of what you are doing. |
