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
Thanks!
I notice that my network drives could not be slected when you attach the database ? Or are there another way to save a backup of the database to a network drive automatic ?
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)...
Thanks Combo. I have this solution that semas to work. I got an error if I press no/cancel on the question to overwrite an existing file, but I true that error away, I hope that it is oaky.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
On Error GoTo Error...
I notice that it is languge dependet .... I'm using a swedisk edition so it will be Falskt (instead of "False") on my computer ... it does not return a code that you can use instead ?
I have the code as below, but how to catch if cancel is clicked in the SaveAs pop-up ?
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
On Error GoTo Error
Dim filename As String
If SaveAsUI = False Then
fileSaveName =...
I found what I was looking for:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = False Then
Cancel = True
MsgBox "You cannot save this workbook. Use Save As"
End If
End Sub
Sorry for taking your time!
:) But the user can start from an existing document to make a new document and by mistake save the new document over the old document :( So I want to prevent/disable the Save Excel option ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.