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 Chriss Miller 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: *

  1. ThompsonA

    XML export - excluding a single field

    Using MS Access 2003, I am using Export to send data from three tables to an XML file. The three tables are joined on a common key. Is it possible to exclude a field from the XML file? I need the field used in the join to appear in the XML output in only one of the three tables. The XML for...
  2. ThompsonA

    Removing security from a copy of a secured mdb

    Yes, there is a workgroup being used in the existing security database.
  3. ThompsonA

    Removing security from a copy of a secured mdb

    Hello! I currently have an Access database that has user level security. I do not want to change any of the security settings in the existing database, but would like to make a copy of the database that does not have any user level security. Can anyone advise the best way to accomplish this...
  4. ThompsonA

    Set RETURN CODE in Z/OS Mainframe Environment

    Normally when my SAS program executes without error, a return code of 00 is returned. I am running my SAS program via JCL in a mainframe batch environment with Z/OS. Is there a way in the SAS program to set the return code to a different value, say 20. I'd like to do this so that subsequent...
  5. ThompsonA

    Concatente function WebIntelligence

    Hello! I am attempting to do a simple concatenation of two variables in a Business Objects 6.5 WebIntelligence report. However, I am having trouble finding the concatenation function. Any help that anyone can provide would be greatly appreciated.
  6. ThompsonA

    Opening Powerpoint web page in full screen

    I have a Powerpoint presentation saved as a web page. When I open the web page thru Internet Explorer, some of the information on the righthand side of each slide is truncated. However, if I select the Full Screen view (PF11) in Internet Explorer, no information is truncated. Is there a way...
  7. ThompsonA

    SKIP input fields in a comma delimited file

    I am reading in a raw data file that is delimited by commas and quotes around text fields. My data looks like: "Smith",30,90,100,120,130,140,150,160,"Philadelphia" Most of the fields in the raw data file are not needed and I would like to SKIP the unused fields when...
  8. ThompsonA

    Alphabetize field names in query design

    I have an Access 2000 table with 80+ fields. When fields are selected for a query from this table, the user must scroll through the table to find the desired field. It would be much easier for the user to find the field(s) of interest if the field names were alphabetized in the pick list. Is...
  9. ThompsonA

    Display caption labels in query design

    When designing a query in Access 2000, is there a way to display, in the table box, the caption label for each field rather than the actual field name? My table includes field names that are hardly descriptive while the caption names accurately identify the field contents. When selecting...
  10. ThompsonA

    SAS Titles and Footers - centering one, not the other

    I am trying to use PROC REPORT and have my TITLE lines centered and my FOOTNOTE lines left-justified. I have used OPTIONS=CENTER at the beginning of the PROC REPORT step. It seems like this controls both the titles and footnotes. Is there an easy way to tell SAS to center the titles BUT left...

Part and Inventory Search

Back
Top