Search results

Hi, I want make to run a function when the database application is closed. When the user close the database application using Ctrl+Alt+Delete keys, I want the function to run it at that moment. How can I make that? If I create a hide form and put the function of the Close_Event, it will work...

Hi, I created a Role "Students" in db1 in SQL Server, right now, I have another database db2, I want to copy the Role "Students" from db1 and paste it and its permission in the db2. Do we have T-SQL to do that?

Stored procedures are different from functions in that they do not return values in place of their names and they cannot be used directly in an expression. I found this statement in the book online. Does that means that only User Defined Function can return the results, whereas Stored Procedure...

Hi, In SQL Server 2000, we have Encrypt, and pwdencrypt password. Do we have Decrypt password? select Encrypt('test') => 0x5400650073007400 select Decrypt('0x5400650073007400') => test do we have function similar like this? Because if the user forget the password, i can use decrypt...

Hi, In SQL Server table, which datatype we can use for password char (*), even if the user have read permission to see the table information, they can see * char only.

Hi, In Stored Procedure, can we make For loop statement? Is there For Loop statement in T-SQL?

Hi, Every time, when I write the comment in the modules, I will add ' (apros) at the begining of each line such as ' This is function 1 ' This function calculate sum of the numbers ' And, it will returns the value back to form Do we have a comment symbol for paragraph? For example: /*...

Hi, I create DTS Package, when I do the Transform Data Task Properties, the Table/View (Source Tab), and Table Name (Destination Tab), how can I see the whole table name? Especially, Table Name in Destination Tab, it show [database name].[dbo].[table name], I only see the 1st char of the table...

Hi, I am using VB2005 Express. I want to create the DataTable to store the temporary data (select * from table1 where [score]>90), the table variable name is tmp (dim tmp as New DataTable) And then, I want to use this table to match up another table Using Inner Join/Left Join/Right Join...

Hi, In MS Access, I create many queries to do calculation of the data, and also the queries contents have been changed depend on the user what criteria values input on the form. And then export the final results to the Excel worksheets. In VB2005, can we do that? For example: qry1: retrieve...

Hi, In VB 2005, I know that we can connect MS Access database, can we use the codes to modify the queries in MS Access. Because, I use MS Access as backend, VB2005 as frontend, I need to use 15 queries from MS Access to do calculations, and also, the queries contents have been changed everytime...

Hi, I used this way to export data to Excel worksheets, and do some formatting on the Excel sheet Set objXL = CreateObject("Excel.Application") objXL.Application.Workbooks.Add Set objActiveWkb = objXL.Application.ActiveWorkBook ................ It works fine. I have a question. When...

So, VB6 cannot make exe file with command line argument itself, right. We have to manually place command line argument into the exe file. Is it correct?

In VB6, I go to project properties->Make->command line argument, I input some values over there. After that, I go to make exe file. Why the exe file doesn't have command values? Can we make the exe file with command line arguments?

Hi, In Visual Basic 6 application, can we make multiple fields of the ListField of the Listbox, DBList, DataList controls?

Hi, I create the form, and insert ActiveX Control for showing PDF file. It works, but how can I show the print button from pdf. Because I want the user can print the file.

Hi, I am using VB6/VB2005 (Visual Studio 2005)/VB.NET application. I want the user to input the information, and then submit it, the program will create one exe file with commands, and then attach the exe file to the email and send it to his manager. So, when the manager receive his employee...

Hi, Will MS Access 2007 easy to corrupt?

Hi, In the MS Access database, I let the user create the shortcut, and the shortcut have these values "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "\\share001\USERS\accessman\mdb\db1.mdb" /cmd "12345_p" After that, the program will attach this shortcut to the email, and then send...

Hi, I created the database, which shared by multi-user. But, my user have a problem to open it. When user1 open the database, user2 cannot open it, I did not remember the error message, it is said that Admin (computer name) prevent you to open the database. But, if the user1 switch another...