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: Sideline
  • Content: Threads
  • Order by date
  1. Sideline

    Array calc using count of distinct events in denominator

    Dear All, This has me stumped and I would very much appreciate any suggestions. Dataset is 220K rows. An small subset follows. Using an array calc with criterions Day = 1 and Hour = 1 summed on Elapsed Time returns 81 with an average of 11.57 for 7 events of which there are 5 distinct dates...
  2. Sideline

    RDP Citrix ICA Client Mac OS X keyboard not functioning

    Dear All I am trying to use rdp for a xp machine using citrix ICA client for mac os x 10.4. However, when the 'log on to windows' appears the keyboard is unresponsive. I can not enter a password to access the xp desktop. Using options at the remote desktop connection dialogue box allows me...
  3. Sideline

    Distinct row based upon date/time criterion

    I have little sql experience beyond the access gui and would appreciate any tips on how to get this started. Based upon my event dataset I need to create a query which returns for each day the first event of each day in the dataset based upon a data/time criteria. That criteria is a) the first...
  4. Sideline

    ClassNotFoundException: com.citrix.JICA.class

    Apologies if my terminology is astray. I am using IE on OS X attempting to log into my Windows XP profile at work and I get the following error when I try to boot an application. java.lang.ClassNotFoundException: com.citrix.JICA.class Searches on the web have suggested importing the security...
  5. Sideline

    Filter dates defaulting to American formats

    Using a form to contrust a report filter the result returns records between dates based upon an American format ie mm/dd/yy for the filter. This occurs even though the form and report control formats and the query field that provides the source data are all defined as dd/mm/yy. Thanks
  6. Sideline

    Converting Data Types

    All Does anyone know if it is possible to convert the data type of a text field to numeric with code. Using a create table query the destination field posesses the data type of the source field, being text. Using code I would like to convert the data type of the text field to numeric after the...
  7. Sideline

    VBA code to access Peoplesoft database for export

    I'd like to set up a module to query an intranet Peoplesoft interface to export data into excel for manipulation based upon parameters entered into an Access form. Can anyone advise where I should start. Thanks in advance
  8. Sideline

    Automation of Frontpage content from an Access mbd (??)

    Dear List, Having originally posted in the Access forums Junior 1544 suggested that I post this in the Frontpage forum. I would like to automate the cyclical creation of web content from a 97 Access database but do not know where to start. The database contains an organisational thesaurus...
  9. Sideline

    Automate web page production from mdb

    Dear List, I posted this in Access other topics without sucess. Was I in the wrong forum? I need to automate the cyclical creation of web content from a 97 Access database but do not know where to start. The database contains an organisational thesaurus and the objective is to produce pages...
  10. Sideline

    Automating web page production from mdb

    Dear List, I need to automate the cyclical creation of web content from a 97 Access database but do not know where to start. The database contains an organisational thesaurus and the objective is to produce pages with links that replicate an Access form allowing the user to browse the thesaurus...
  11. Sideline

    Access code to export to Excel worksheet collection

    I have some VBA code that loops through a collection of syntax files of a stats program and creates multiple output objects that I wish to export to excel. I have managed to copy a single pivot table object in the statistical package and paste it into excel but I am stuck on how I can access the...

Part and Inventory Search

Back
Top