Search results for query: *

This is a basic question. I want to pull out some substrings and load two new fields. I get my values from: SELECT Interface_List.ID, Interface_List.Identifier, InStr(1,[Identifier],'_') AS Len1, Mid([Identifier],1,([Len1]-1)) AS T1, Len([Identifier]) AS LenId...

Have you seen a cross-compiler that turns Excel into something that can run on a server? Googling, all I can see is things that turn Excel into a package. The spreadsheet seems to still be/need Excel. I can see somethings would be tricky to translate (eg Pivot tables) but I guess the main...

I'm just reading through the WebMatrix notes. What I've not seen is anything that refers to creating your web page except by writing HTML. Does it not have that capability? If not, what are you expected to use?

Can you point me in the right direction? I'd like to have a web interface to Excel. The Webserver would pick up parameters from the web call and insert them into a corresponding Excel worksheet, read 'result' cells and reformat the information to display on the response web page. Let's assume...

On Sheet N I have a table/list/range with a varying number of rows. How do I add/append a new row? Obviously I could type it in - I'd look down the page and see where the first empty line is. However how do I do this programmatically?. I can find out where the last row is but that's a big step...

Do tables (introduced in 2007) supercede lists?

If I have Sheet 2: A1: 1 A2: 2 A3: SUM(A1:A2) Then I have Sheet 1: A1: 3 A2: 4 A3: =CONTENTS(Sheet2!A3) ie I want it to say =SUM(A1:A2) To clarify: I want to do this programmatically (ie not with the UI) and I don't want to use VBA or other programming systems.

I have the following data with the rows showing hours individuals have worked by columns showing the week-start date. The source data is split into a task breakdown so the same person can appear more than once. I need to consolidate the information. I would like to do something like SUM 1/4/11...

I'm looking at using Excel in a more general programming context, specifically for web applications. I know it sounds bizarre, but it's not the first time people have tried to view Excel as a functional programming platform, and no animals will get harmed in the making of this. Initially I was...

My understanding is if you have a usable index, Access will only fetch the index pages, locate the target records and then fetch the data pages associated with the target records, thus cutting down the need to fetch entire tablespaces. However my question is how does it manage to retrieve...

I guess this is simple. I have a table FQPK and an identical table SQLB. I want to delete the records in FQPK that are also in SQLB. The applicant_house_no is a determinant. There are no keys, indexes or relationships declared. The QBE Grid seems to resist me indicating I want to delete an...

Access Query By Example is brilliant, and can get you through lengthy office tasks without resorting to a single line of code. Using SQL without worrying about syntax is great, but being able to automatically get grids to manipulate your data is like Xmas coming every Friday. The problem is...

I'm trying to code a multiple IF statement to assign marks to a test. I'm sure I've done this before but I keep getting an error: An expression you entered contains invalid syntax The code (in the QBE grid) is: Mk: IIf(([Answer]='+' And [Response]='++'),5,( IIf(([Answer]='+' And...

I'm researching the area of desktop grids and wondering what options there are for running databases across many nodes. The sorts of applications you normally read about (eg SETI) don't have a typical corporate transactional model. I've used Oracle 10G in the past, which I think is a good...

I've just noticed that Open Office seems to have an Access look-alike (called Base). Has anyone had a look at it yet? Is it a contender?

Has anybody been involved in migrating java to dot.net using Microsoft JCLA, or suggestions where I can get metrics from? I've got a project which potentially involves translating a JSP package onto the 'strategic' platform but nobody has any idea how big a task it is.

Databases came in to store data in an accessible way for corporate processes to share. The database also to a degree applied some constraints on keeping data consistent through triggers, assertions, referential integrity, typing etc. At that point applications would be separate from data and...

Can you give me a rough clue as to the simplest way you approach building an application where several users each have access only to customers assigned to them?

This query works: SELECT MAS.[CAC-BUY-TO-LET-IND] AS Mval, Summit.[CAC-BUY-TO-LET-IND] FROM MAS LEFT JOIN Summit ON MAS.[CAC-LOAN-ID] = Summit.[CAC-LOAN-ID]; However when I try to compare the two fields Access doesn't understand; it asks for a parameter value: SELECT MAS.[CAC-BUY-TO-LET-IND]...

I'm just thinking about options for email-based services. I'm assuming a normal corporate user would be able to access them. For sensitive applications - eg bank account, purchasing with a credit card etc - you'd like mails to be secure. It looks like Outlook allows security features but I...