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!

Register Log in
  • Congratulations IamaSherpa 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. DaveBenson

    SQL Database backup - append, overwrite or new file?

    Thanks guys. I'd probably just be doing it through SQL management studio at the moment, but will start using more script once I understand the process better, so code is useful.
  2. DaveBenson

    SQL Database backup - append, overwrite or new file?

    Thanks SQLScholar from what I know I'm inclined to agree with you. I'd rather have different backup in separate files so you can delete old ones etc. As I mentioned above I had a bit of trouble when trying to make a new backup file but I'll look into this further. In the meantime, any other...
  3. DaveBenson

    SQL Database backup - append, overwrite or new file?

    Hi, I am in the process of working out a backup strategy for an SQL database that uses the full recovery model and also looking for a better general understanding that I would be able to apply to future databases. I am clear (I think) about using full / differential / log backups. However I'm...
  4. DaveBenson

    logon event in SQL Server 2008 Management Studio express

    Hi, Yes it was my thread. Have found a way around it now. Sorry for not closing thread earlier.
  5. DaveBenson

    logon event in SQL Server 2008 Management Studio express

    Hi, Does anyone know if it is possible trap a logon event in SQL Server 2008 Management Studio express? I want to use it to activate a procedure every time anyone connects to the database. I have tried setting up a logon trigger and also tried to dabble with the service broker but without...
  6. DaveBenson

    Update an excel VBA userform from MS Access VBA

    Hi Skip, I don't quite follow (admittidly I'm a bit hazy on objects etc!) "txtname" is a textbox control within the userform "dk" I loosely thought that this would make "dk" the parent object of "txtname". Does there need to be something else in there as well? I had thought that the problem was...
  7. DaveBenson

    Update an excel VBA userform from MS Access VBA

    OK, there's lots of ways I will use this code once I get it working. But to give an example, the excel file that is open is called "pivot control.xls". Within this, there is a loaded userform called "dk", with a textbox called "txtname". From a module in my Access file I want to be able to...
  8. DaveBenson

    Update an excel VBA userform from MS Access VBA

    Hi, Thanks for this, although it doesn't seem to work. If I'm in Excel VBA and have the userform open it does. But with Access VBA I don't think it's recognising 'userform1' as an excel userform. I need some way of pointing MS Access to the userform in the MS excel file.
  9. DaveBenson

    Update an excel VBA userform from MS Access VBA

    Hi, Does anyone know how to update the value of an excel vba userform control from access VBA?

Part and Inventory Search

Back
Top