Search results for query: *

Hello all, I have created a SQL database. I notice when i logged in with another account that I can not access that database ? How can I make the database visable for all users ? Thanks Per

Hello, I have created a database in SQL 2012 Express. The database was created in the directory: C:\Program Files\Microsoft SQL server\MSSQL11.SQLEXPRESS\MSSQL\DATA I would like to move the database to another location, how do I do that ? Cheers Gustaf

Hello, I plot a table of date/time and values. Is it possible to just have a label once per day at midnight ? For example 20/08/2012 00:00:00 and next label on the x-axis 20/09/2012 00:00:00 ? What is the max number of rows in excel 2010 ? I get an error when I write to row 65 537 ? Thanks...

Hi, How to do a conversion from UNIX decimal to timestamp ? UNIX decimal: 1350497888 should give 2012-10-17 20:18:08 (http://fmdiff.com/fm/timestamp.html)

Hello all! I have the code below which open a SaveAs dialog, it works BUT, the Tools Options at the bottom only allows tou to look at mapping the drive ... ? I'm using excel 2007 What do I need to add to see the Tools options ? Set fileSaveName = Application.FileDialog(msoFileDialogSaveAs)...

Hello all, I got the code below, are there any way to disable screen update during the function ? The code make my sheet flicker The code adjust the row height of merged cells. (The area Name1 are meraged cells) Gustaf Private Sub CommandButton1_Click() WrapText Range("Name1").Offset(0)...

Hello all! I have two questions ... 1. I would like to force the user to input a name when the excel document is saved, i.e to disable the save button and only allow the Save as, is that possible ? 2. Is it possible from vba to enable marcos when a excel document is opened ? or check if...

Hello, Public Const ConnectionString = "DRIVER=SQL Server;UID=rfd;PWD=password;SERVER=ETE0349\SQLEXPRESS;APP=RFD;DATABASE=RFD" I have this connection string: DRIVER: Will that always be SQL could it be something else ? APP: Is that alwas the table name ? DATABASE: Is that Always the table...

Hello, a simple question I think ... How do I select the last line in a multiline textbox from vba ?

Hello, I have this problem: I would like the user to enter text in a textbox, to be able to use tab. The Textbox under the ribbon meny insert->Textbox got these features, but is it possible to access that text from vba ? The textbox under the ribbon meny developer->insert->Textbox, can you...

SELECT DISTINCT (Name), Computer, FROM table1; Hello, I have a table that contains two colums, Name and Computer. I would like to list the name only ones and display the corresponding value to the Name. Example Name Computer ===== Andy Data1 Andy Data2 Nick Data1...

Hello, I have date format issue. The date: 25 th of December 2011 In spain they write the date: 25/12/2011 In USA they write the date: 12/25/2011 In Sweden they write the date: 2011-12-25 They problems occur if people change the region settings. I write the date to an MS SQL Server database...

Hello, I would like to have a datepicker in my excel form. This form will be used by other users. I do not want to run into the problem that the need to install the activeX to get it to work. Are there any way to do this without to be able to install something to get it to work on all platforms...

Hello, How do I change the position on a userform used as pop-up form ? I would like to pop-up the userform just after and below F4. Thanks Gustaf

I have a userform as a pop-up, is it possible to remove the header ? And it is possible to move the form so the upper left corner if just under cell K1 ?

How do I declare and use a global array/matrix ?

Hello, I have two problems that are connected that I would like to solve. I hope anybody that knew this have time to help me! 1) I have an application that requests a new ID from my MS SQL Server Express 2088. I would like the application to get next avaiable ID. e.g if the ID's are 1,2,3,5...

Hello, it is possible if you have a series of values round them up/down so the values get a fixed number ? In the case below I have used the ROUND function but the sum became 201, I would like the sum to be 200! Thanks Gustaf 17,64705882 + 61,76470588 + 67,64705882 + 52,94117647 + = 200...

Hello, I can not get the Exit event on a textbox working on Excel 2007. Private Sub TextBox1_Exit() MsgBox ("Test") End Sub I would like to validate that the input in the textbox is a valid date, are there any system functions ? Thanks Gustaf

Hello again, I have another problem also ... I have an excel file that is write protected. 1) I would like to open the file protected and with help of a button be able to save the changed of the contect and with the file still write protected so I can not use the save button within excel...