Search results for query: *

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

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

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

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

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

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

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 all, can someone please point out whats wrong with this where clause? WHERE (((IIf(IsNull([revisedduedate])=True,[duedate],[revisedduedate]))=#01/01/2006# AND ReportMAP.Priority='H' ORDER BY Clients.ClientName, DetailsofPlan.PlanCode, ReportMAP.RecNum My sql runs fine until i add this...

Hi all, I have a problem with a report on my dbase. The report is often a few pages long with page headers and footers. The records on the report consist of various field types including a couple of memo fields. The problem is that if either of the memo fields on the first record listed in...

Hi all, I'm using ASP to upload images to my website, problem is some of the images are very large (they're from digital camreas). The images are shown in a popup window from ym site but some of the larger images don't fit in the popup, i tried setting the width of the image on the page so...

Hi all, I've written a set of forums for our company intranet that are working great however users want to be able to easily add hyperlinks into their posts. I sometimes use TGML on tek-tips and was wondering how they work as I'd like to do the same thing but with just hyperlinks ? Can anyone...

Hi all, I've searched this forum and couldn't find anything that I've managed to make use of so here goes... I've got two select boxes on a screen that are populated by values from ASP. I want the values displayed in select box 2 to be filtered and only show those relating to the value...

Hi all, I've got a popup window that I want to list all the images showing in the parent / opener. Can anyone tell me whether this is possible? Cheers in advance

Hi all, I've got a date field in an ms access database that needs setting back to null after a user has previously entered a date. I'm trying the SQL: "UPDATE Tab1 Set D8Complete=null WHERE ID=499" But am getting the error: Microsoft OLE DB Provider for ODBC Drivers error '80040e10'...

Hi, I've got a popup window that users click a link to open... thing is that the window often loses focus and disappears behind whatever else people have open. They then call me saying the window won't open when it's actually already open but behind their other apps / windows etc. Is there...

Hi all, I have a form with a subform. The subform lists all records associated with the main form. The continuous subform has a list box that lists records from a table based upon a value in each subform record BUT the content of the list box isn't updating for each subform record...

Hi, I have a report that is based upon a crosstab report which lists data relating to three seperate years. Prior to the report loading the user selects the first of 3 years that the report is to be based upon, e.g. they select 2006 and see data relating to 2006, 2005 and 2004. The problem i...

Hi I have two select menus on my page, I want a cell color to change depending upon what values are chosen. The javascript code was kindly supplied by someone on this forum and looks like this: <script> function changeCol(){ if(document.getElementById('currlikli').value != "" &&...

Hi I have a query that feeds into a report. The field names in the query change depending upon criteria chosen by the user. e.g. the user may select to view data from years 2004, 2005 and 2006... but they might select different years etc. The query is a crosstab so I'm wondering how can I...