Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BNPMike
  • Content: Threads
  • Order by date
  1. BNPMike

    Updating from Calculated Field

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

    Is there a cross-compiler for Excel?

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

    WYSIWYG in WebMatrix?

    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?
  4. BNPMike

    Running Excel from a Web Server

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

    How do you add a row to an Excel Range?

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

    Excel - Lists and Tables

    Do tables (introduced in 2007) supercede lists?
  7. BNPMike

    Excel: How do you copy the contents of a cell?

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

    Excel - Sum by

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

    Excel - Evaluation Order

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

    How does Access use Indexes?

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

    Delete Records in a Join.

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

    QBE Anywhere Else?

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

    Multiple IIF in Query

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

    Options for Distributed/Grid Databases

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

    Open Office Base

    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?
  16. BNPMike

    Java to ASP.NET

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

    Do we Need Databases Any More?

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

    Application with Record-Level Access Permissions

    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?
  19. BNPMike

    Referring to Calculated Fields in a Select Query.

    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]...
  20. BNPMike

    Security in Outlook

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

Part and Inventory Search

Back
Top