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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by hedidit

  1. hedidit

    Update XLS File

    Sorry yes I was being thick, rather embarrased... cheers!
  2. hedidit

    Update XLS File

    Hi Tarwn I've got round the problem by inporting into a DB and then updating within that. However it'd be far better to update the actual XLS file. When you say a connection object not a string what do you mean? Sorry if I'm being thick! Cheers
  3. hedidit

    Update XLS File

    Hi Sheco thanks for the response, I've already given ready, write and modify access to the IUSR and IWAM accounts on the file. The file is located within a folder that contains a database that my asp code can update etc. Any other ideas?
  4. hedidit

    Update XLS File

    Hi all, I need to update records in an excel spreadsheet, I'm reading the spreadhseet content using: csvcon="Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" & Server.mappath("\mypath\db\import.xls") & ";" Dim SQL SQL="SELECT [reportMAP$].ReportNum, [reportMAP$].RecNum...
  5. hedidit

    Linkled Table Exist?

    Yes it is different... in database A it's called Archive, in database B it's called TblArchive...
  6. hedidit

    Linkled Table Exist?

    Thanks for the replies, I'll have a go with both now... I'm merely trying to tell whether the table is linked... not so bothered about whether it's from database b... cheers again
  7. hedidit

    Linkled Table Exist?

    Can someone show me any example code of how to check whether a table is currently linked into my database? Example: I'm in database A, database B has a table called Archive... I want to know whether my current database (database A) is linked to table arbice in database b... Cheers
  8. hedidit

    VBA Recordset...

    Sorry i didn't have DAO checked in my references... doh!
  9. hedidit

    VBA Recordset...

    Can someone show me the code of how to open a VBA recordset? I have a query I'd like to mess around with via VBA... i know how to do this in vbscript with ASP but not in ms access. At the moment I have: Dim dbs As Database, rst As Recordset, strSQL As String Set dbs = CurrentDb Set...
  10. hedidit

    List AD Groups

    Typical, I finally decide to post after looking for ages and then find the answer straight after posting! Problem solved.
  11. hedidit

    List AD Groups

    Hi all, I've always used a seperate database for checking login credentials / logging users into my sites however a friend now wants me to set up an intranet site for him that allows access to various screens depending upon the users membership of active directory groups. I realise I need to...
  12. hedidit

    Date Format

    Thanks guys got it working after all using 'format' Thanks again for the help...
  13. hedidit

    Date Format

    Hi I have a form that a user enters various bits of data onto. , the data is then inserted into a table called 'TblInventory'. The code works fine accept that the field called D8Rec changes format from dd/mm/yyyy to mm/dd/yyyy once it's inserted into the table. The code I'm using for the...
  14. hedidit

    Frames

    Thanks for the responses... the site is mainly written in ASP so I can use a session variable to do this... Thanks trollacious i can't believe I didn't think of that!
  15. hedidit

    Frames

    Hi all, I have a site in two frames, a small top frame with naviagtaion bar in it and the main content frame below. My problem is that google is only picking up on the main frame content pages so when users try to visit my site they don't see the top frame that enables them to navigate the...
See more

Part and Inventory Search

Back
Top