Forum: Windows Software  Dec 12th, 2008 |
| Replies: 1 Views: 418 Hi,
Use the inbuilt function nz
Expr1: (nz([prod_group_name],"") & " - " & nz([model],"") .... |
| Forum: Networking Hardware Configuration Dec 12th, 2008 |
| Replies: 2 Views: 1,087 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: 740 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: 412 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: 541 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: 360 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: 766 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: 740 Hi,
try this
<html>
<head>
<script langauge=javascript>
function baby(a,b)
{ |
| Forum: Computer Science Dec 6th, 2008 |
| Replies: 3 Views: 679 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: 477 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,568 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: 849 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: 874 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,833 Hi,
Please check the attached example.
Hope it will work for you. |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 3,143 Hi,
What do you mean by table variable??? |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 2,997 Hi,
What are you using Access, MSSQL 2000 or MSSQL 2005 |
| Forum: MS SQL Aug 15th, 2008 |
| Replies: 1 Views: 2,820 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: 744 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,047 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: 614 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: 490 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,423 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,402 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: 392 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,374 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: 798 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: 928 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: 952 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: 783 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,411 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,245 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: 787 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,542 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,696 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,355 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,838 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,120 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,388 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,388 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: 911 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. |
