Search results for query: *

As a beginer,Im trying to SUM values in a single field where they meet the critria below. The field is wish to SUM is "SERVICELEVEL" I wish to SUM the following addressbook.ServiceLevel='Officer' + addressbook.ServiceLevel='Senior Ranks' + addressbook.ServiceLevel='Junior Ranks' = x The...

Hi ... firstly ive searched through the previous issues of a similar nature with no luck ... Im using DW 8, MS Access running on WIN2003 R2 and IIS6. Ive simly used the built-in server behaviour and tp log in user, it just doesnt work. Im getting the user levels from the access database which...

Hi ... The following code warns me via an image that a date is greater than a year old. It works great but im looking to put a third image warning that the "safety_insp" date field in MSAccess is greater than '335' days old displaying the image file 'amber.gif' Also at the same time if the...

WINDOWS SERVER 2003 R2, STAND ALONE - NO AD Hi ... Ive just installed Sharepoint and trying to setup new top level web site but it does not like any user accounts that I try to use. I get user does not exist or user/group <> is unknown. There is only 1 domain on this standalone box . Any...

My first go at .NET .. Im building a datagrid to display fields in a database. One of the columsneeds to have this code running in it - not sure how to do it. The script works fine in classic ASP. Example:Cut out from main script <asp:TemplateColumn HeaderText="Warning"...

Got the following query, works great in MS Access, put it into my ASP page and returns .. Too many paremeters Expected 1' Checked all the spelling and fields - all ok, It works in MS Acess as a query Query .... SELECT DateDiff("d",[BoatPosition.PositionDate],[BoatPosition.EnterDate]) AS...

Hi .. here goes . Ive never written anything in VB . Im ASP and SQL. My boss wants me to write an applcation that will popup on desktops to alert when a crieria has been reached in our database. We input our boat positions everyday (tbl Positions.PostionDate )The alert needs to be triggered...

How do I trigger an email to a user, users, when a field in a database has an entry older than a day compared with Date() Any Ideas ? MS Access using ASP/VBscript IIS 6, Exchange server

Our datadbase holds Date information that must be updated every 24:01. + 1 day I want to have a warning on our internal web (ASP VB Script)page that gives a graphical warning that the date field have not been updated. Simple query returns any boats that have a ‘PositionDate’ entry today, its...

Hi .. getting the following error from this script ERROR . Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. Ive checked the names of the fields ect and all seems well ?? All input values are text. Head Script .. <% If Request.QueryString("update") <> "" Then %> <%...

Firstly im NOT a VB programmer, im into ASP and MS Access. Im trying to find out how to get a popup message on a clients desktop. The popup will be activated by a query on a access database. Basically it looks at a date field in a table and if that date becomes more than 24 hours old...

Im trying to write a query using 4 checkboxes (true or false). (vechicles used as examples only - point being 4 different checkboxes) I have (say)4 vechicle types , bike, car, van, lorry and would like the user to search for these items using some or all of the check boxes. so when they check...

Having Problems with the following query.. SELECT addressbook.InputWebb, addressbook.Q_67SKIP FROM addressbook WHERE (((addressbook.InputWebb)=True) AND ((addressbook.Q_67SKIP)=True)); The feilds - InputWebb and Q_67SKIP are yes/no checkboxs in the true/false format. It returns nothing but I...

Can anybody help.. this is the task. I have an Access Db that is used in our office. The interface is web based using ASP classic - not Dot Net. I now require our clients to logon via our public web site and manage their own details directly form this local Db. We have all the usualy security...

Im trying to write a query using 4 checkboxes (true or false). I have 4 vechicle types , bike, car, van, lorry and would like the user to search for these items using the check boxes, multi selecting the types, so when they check the box (true)they include it in the result set, not checked...

Im trying to write a query using 4 checkboxes (true or false). I have 4 vechicle types , bike, car, van, lorry and would like the user to search for these items using the check boxes, multi selecting the types, so when they check the box (true)they include it in the result set, not checked...

HI ... I have an access Db that runs in my office. There is also a copy online which people update via the web. I need the online Db to update the office (Master) several times aday What is the best way of updating the office Db with info added to the remote public Db. I can only link via...

Simple Code SELECT CourseName FROM Courselist WHERE CourseName='First Aid' Between#StartDate# AND #EndDate# There are many First Aid courses that run at random times across the month. I want to be able to find 'First Aid' courses that are running today and show any running 8 days +- of...

Ive used this code lots but this particular time its got the better of me. Im updating a field in a table called 'CStatusCode'. Its a text field in Access 2003.Ive cheked that the the data type is right. I get the following page errors 1) when the "CourseID" has numbers only -...

Heres the problem ... I have 150 seperate word documents that are read as as one large document. I dont have any control in changing this, not my dept. Document 1 contains an index which refers to the other documents in the pool of 150. I need these to be published on our web site. Any...