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!

  • Congratulations wOOdy-Soft 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: rorymurray
  • Content: Threads
  • Order by date
  1. rorymurray

    multiple user servlets

    I am developing a servlet that will be avilable to multiple users to create their own timetable. I store users classes in an array, then display the timetable array. My only problem is that when multiple users are using it at once, I need a new instance of the servlet to be created, so the users...
  2. rorymurray

    merge files in VBA

    I have used Access to create 3 separate text files. Now I want to append all the data from the 3 files into 1 file, bit like a union query in Access. Any ideas on how to go about it? Rory
  3. rorymurray

    date comparisons

    I am trying to get a date from a text box in a form, then use it in a query. Basically in the query I want to make the condition: <[Forms]![Main]![EndDate] . This gives me incorrect results. I realise that normaly if I knew the date I could put something like: <#01/01/02# , but what is the...
  4. rorymurray

    Keeping current session

    I am using a servlet to process information from an online survey. Basically the servlet receives parameters from different pages. With each page it stores the parameter values as session attributes, then forwards to the next page, which in turn posts more parameter values, the servlet stores...
  5. rorymurray

    Conditional display of subform

    I have a main form which has an area for a subform. I want to display one of two possible subforms in the main form's subform area based upon the result of a function. Eg, if functionx()=false, display subform 1, otherwise display subform 2. Is this possible? Thanks in advance, Rory
  6. rorymurray

    JDBC Io exception: SO Exception was generated

    Hi, I have been trying to setup a JDBC conneciton to a database so I can run an applet to add, remove and search a database from the web. The message:&quot;SQLException: Io exception: SO Exception was generated&quot; is output when I choose the particular option that tries to connect to the...
  7. rorymurray

    window.open, scrollbars=yes, resizable=yes in pre-version 6.2 Netscape

    When I use the window.open method and state the attributes &quot;scrollbars=yes, resizable=yes&quot; it works fine for IE 5.x and Netscape 6.2, but it doesn't work for version 4.x Netscape. It pops up the new window ok, but you can't scroll or resize. any ideas? Regards Rory
  8. rorymurray

    Using vba function in query

    HI, I have written a function that basically gets a translation value from a table and returns it. Now I want to use this function on a field in a query, but I keep getting a message of &quot;compile error in query expression get_costctr_code([pdept])&quot;. The code is below: function...
  9. rorymurray

    rename an external file

    Does anyone know how to use access to rename a file. I basically want to change something from &quot;filename.650&quot; to &quot;filename.txt&quot;
  10. rorymurray

    Can't delete more than 500 records at once

    When trying to delete all records in a table, either manually or by using a macro, if there is more than about 500 records in the table I get the message &quot;Could not update; currently locked&quot;. Is there some kind of setting I can adjust? Or is there another problem? It happens on more...
  11. rorymurray

    Access not recognising functions upon conversion to 2000

    When I converted my database from 97 to 2000, everything worked, except for the objects that use functions. If I use either a built in function, such as Format(), Left() etc, or one I wrote myself, Access says it doesn't recognise the function ..... Any ideas?
  12. rorymurray

    access reports - how to run nightly automatically

    Does anybody have an idea of how to set an access report to run on a nightly basis at a given time?
  13. rorymurray

    Functions returning Nulls

    How do you deal with a function returning a null value? I know PL/SQL has a function nvl() that can put something in place of a null if null is returned. Does VBA have anything like that?

Part and Inventory Search

Back
Top