Search results

SET @tablename = N'authors' What 's that means N'? Thanks.

Hi, If the user only have read permission in the SQL Server, can they still create the temporary table, eg. ##tmp, when they write T-SQL? Thanks.

Thanks. I have a question. Those images are loaded from MS Office library, right. If I design my own image (I design my image by using photoshop), how can I paste my image on the menu bar? Thanks.

Thanks. Will the MS Office library update new images itself? Thanks.

Hi, I want to create my own menu bar, but there are limited images, how can I add my own image on the menu bar? Please let me know, thanks.

Hi, I have a question. In Query statement, I create a new blank script, and then I want to write like this (select [employee] from [table1] where [Num]= 1) As [emp] select [Meeting Time] from [Time] where [emp].[employee] In the script, can I use this way? I know that when we run the...

Hi, I want to setup like this: dim frm as form if num = 1 then frm = "Forms![Main]![Content]" else frm = "Forms![Appointment]![Content]" end if .... if frm!seach1 = "Hello" then ........................... ... etc. Does anybody know about it? Thanks.

except is loaded, I want to check whether the form is active by user, because the user may open the multiple forms, I want the program to do something for the active form only. How can I check whether or not the specific form is activated by user?

Hi, I want to write a function, which is checking whether or not the form "Operating form" is opened? if [Form_Operating form].??? = True then msgbox "the form is opened now" end if Does anybody know that?

Hi, char: fixed-length character data with a maximum length of 8000 characters. nchar: fixed-length unicode data with a maximum length of 4000 characters. I have a question, from above 2 datatypes, except the length is different, what is main difference between them? can anybody list an...

Hi, Suppose I create db1.mdb and db2.mdb, each one has its own workgroup (I setup user-level security). db1.mdb with secured1.mdw db2.mdb with secured2.mdw I create a Account for username=John, pwd = test on both database each database with its own workgroups have same username, and same...

Hi, In table, dim db as database dim rs as recordset dim i as integer set db = currentdb set rs = db.openrecordset("Select * from [table1]") for i = 1 to rs.recordcount if rs.fields("Selected") = true then ' checked box ..................... end if next i If I make...

Hi, I made one database. Inside the database, I want to make a screen that show that which computer is in use of the current database. Can we do that? Does anybody know how to do? Thanks.

Hi, I have a question. When I click the button, I want the mouse picture to become processing, Docmd.hourglass True. After that, when I click Ctrl+ALT+Break to stop the processing, the program stop it, but the mouse picture is still shown processing. I don't like that, I want the mouse to...

Hi, In the label, I want to show the char &. But, it shows underscore _. How can I show the char &? Thanks.

Hi, I have a question. Environ("ComputerName") In this world, must every computer have different computer name? Will it be duplicate computer name? I want to make sure that, because I want to use Environ("ComputerName") as the unique value. Thanks.

Hi, I setup user-level security on the database. the workgroup file was deleted by somebody. How can I open the database? Because I create the same name for workgroup group file and input the same WID. It did not restore the original one I lost. Right now, the database cannot be opened...

Hi, I have a question. I create a custom menu, and then assign hyperlink for running Excel application (C:\Program Files\Microsoft Office\Office10\EXCEL.EXE). When I click on it, it has security message, ///////////// Opening C:\Program Files\Microsoft Office\Office 10\Excel.EXE Some files...

Hi, I have a question. How can I make enable Users and Group Permission on the menu bar when the tables/queries/forms are not opened? Because when I closed tables/queries/forms, the users and group permission is not enable. Thanks.

I did that. But, the error is that Command doesn't work in MS Access. How can I solve it?