Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gustaf111

    Database visable for all users

    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
  2. gustaf111

    SQL 2012 Express, move database to another location

    Thanks! And I can not make a automatic beckup to a network drive either ?
  3. gustaf111

    SQL 2012 Express, move database to another location

    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 ?
  4. gustaf111

    SQL 2012 Express, move database to another location

    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
  5. gustaf111

    Excel plot XY

    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...
  6. gustaf111

    UNIX decimal to timestamp

    :) Just what I want :) But way does this command shows: 2012-10-17 18:18:08 and not 2012-10-17 20:18:08 2 hours diff ?
  7. gustaf111

    UNIX decimal to timestamp

    Could you give an example :) ?
  8. gustaf111

    UNIX decimal to timestamp

    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)
  9. gustaf111

    Save As dialog, Tools option missing

    Okay, Thanks! I have been seraching a few hours :(
  10. gustaf111

    Screen flicker

    Ohh, autozizing the column ?
  11. gustaf111

    Screen flicker

    Hello Gavin, At the row c.ColumnWidth = MrgeWdth :(
  12. gustaf111

    Save As dialog, Tools option missing

    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)...
  13. gustaf111

    Screen flicker

    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)...
  14. gustaf111

    Excel. Two questions, Save as, enable macros

    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...
  15. gustaf111

    Excel. Two questions, Save as, enable macros

    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 ?
  16. gustaf111

    Excel. Two questions, Save as, enable macros

    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 =...
  17. gustaf111

    Excel. Two questions, Save as, enable macros

    But how to open the save as dialog instead... ?
  18. gustaf111

    Excel. Two questions, Save as, enable macros

    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!
  19. gustaf111

    Excel. Two questions, Save as, enable macros

    :) 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 ...

Part and Inventory Search

Back
Top