Search results for query: *

Hi I am trying to create a view in my SQL 2000 database from a table of data that is constantly being updated on a a SQL 2008 database. Is it possible? and if it is how do I reference them? I am brand new to Management Studio and SQL 2008 (training scheduled for April!) so any info would be...

I have to try and create a view on transact sql (2000) The view needs to show the values of the past 5 days data by metric. Example of what i require Metrics Today -4 Today -3 Today -2 Today-1 today 1 A&E Attendances Value Value Value Value Value 10 AvgLos 30 WARD Value Value Value...

Hi Within my web application I have included the open source javascript file: 'tablefilter.js', which enables filtering on the table however, the drop down filter lists are not in any order making it difficult for the user. Does anyone know how I can get the filter lists to display in...

I need to capture the id of the record set to enable the edit button to go to the edit page displaying details of that record. It is in an array which writes out the headings of the table then each row with an edit button (hyperlink with image - which should capture the id of that record...

Can anyone help - on the edit screen I need to prompt the user if they try to exit without clicking the save button. The save button validates the data and if ok submits the form calling another .asp page which writes the data to a sql database. I have used the 'onbeforeunload' javascript...

Can anyone help - on the edit screen I need to prompt the user if they try to exit without clicking the save button. The save button validates the data and if ok submits the form calling another .asp page which writes the data to a sql database. I have used the 'onbeforeunload' javascript...

Can anyone help. Within a table I have an address field which has 3 parts of an address split by a comma e.g. 132 Sunny Ave,Barns,Chester. This data needs to be split in an automated manner to enable a report which displays the address as 3 separate fields - Address1 Address2 and Address3...

Hi I am still a beginner and know that this is proberably really simple but does anyone have sample code that will enable me to email a specific workbook to a specific person and c.c. to four other people - but running the code in another worksheet. Many thanks in advance

I am trying to capture (in a drop down box) the list of tables contained within a database. I want the user to select one - that name is passed to a variable and used in SQL to return data within excel. The error I am getting is: Record(s) cannot be read, no read permission on MSysObjects. Sub...

Please can anyone help. Data is input onto a worksheet, on closure of the spreadsheet I would like to loop through the data and append it to the bottom of an access db table. Has anyone got any example code? Many thanks

Hi I am familiar with Access VBA and basic VB not really excel vba. I have been tasked with a problem and I am a little stumped - can anyone help? An object is scanned and the bar coder opens a new workbook(1) and enters the barcode into cell A1. When the next scan occurs it opens a new...

Can anyone help please? I am trying to populate a combo box within excel that lists the tables in an access database(the selected table name goes into a variable that is contained in a SQL string). I need to have the tools/options/"system objects" option button selected in Access database for...

Can anyone help. I am using a version of Access that doesn't support the '.additem' function. I wish to populate a combo box with the date and the last 6 days. I cannot use the .additem can anyone suggest what I can do? Thanks