Search results for query: *

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

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

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?

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

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

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

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

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

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

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

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

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

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

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!

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

Ok that's wired... the download prompt works fine in IE7 but Firefox downloads the file without the file extension... most of my users will be using IE so I'm happy but how odd!

Hi Oonpt, Thanks as always, unfortunately the site is on a hosted server however that article did help! Now the save file prompt appears but leaves the .zip off the name of the file... any thoughts?

Hi, I have a downloads page that lists files located ina folder not in the webroot. I've found some code that streams the file to the browser however I want the user to be prompted to download the file, at the moment it is shown on-screen... zip files show up as loads of random text... not...

Hi, I have a query that runs when a user clicks a button on my main form. At the moment the query uses one of the fields on my form as a criteria (users type a date into the field) and everything is fine. However my form also contains a field that holds an autonumber ID for the currently...

Hi MonkSnake, I'm afraid the date part does have an extra two )around it... sorry typo on my part...