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 derfloh 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: fiep
  • Order by date
  1. fiep

    multiple line output in function

    That is it. I knew it had to be something simple and lost lots of time finding this. Thanks a lot all of you.
  2. fiep

    multiple line output in function

    Hi, This is how I call the function: T=`checkmainstore $VERSION` if [[ $? -ne 0 ]] then echo "${SRV};;;Time Out on Command" exit 0 else echo $T fi Kind regards
  3. fiep

    multiple line output in function

    Thanks for the tip, but it does not work. Funny thing is that if I set -x in the function I see that the debug output is correct. i.e. all lines are printed seperately. My print statement does not show any newlines charachter though so still one line: ... +...
  4. fiep

    multiple line output in function

    Hi Feherke, Thanks for the reply. I use ksh on Solaris 10. In the main of the script I call the function calldb The functions looks like this: function calldb { SQLOUTPUT=`${ISQL} -l $TIMEOUT -U${AC} -S${SRV} << EOFSQLC15 -w300 | sed -n '7,$p' $(echo ${PWD}) sp_iqdbspace go EOFSQLC15`...
  5. fiep

    multiple line output in function

    Hi, I have created a function to do a database call: function calldb { OUTPUT=`some DB command` echo "OUTPUT =$OUTPUT" } But if I use the function the output is one line: Output = -------- IQ_SYSTEM_MAIN MAIN T T 21 1000M 0B 1 1 T 1K 1H,25568F,32D,128M N IQ_SYSTEM_TEMP TEMPORARY T T...
  6. fiep

    use collumn value in dateadd function

    Hi, I have a collumn that contains the first parameter for the dateadd function. (i.e. WEEK, MONTH, etc) I want to use this value in the where statement of a query but get the following error: ' + cast(T.AddString as varchar ) + ' is not a recognized dateadd option. Or Invalid parameter 1...
  7. fiep

    link to SQL view and list fieldnames: error 3420

    Works like a charm, Thanks
  8. fiep

    link to SQL view and list fieldnames: error 3420

    This is in the declaration part of the procedure: Dim qdfSelect As QueryDef Dim tblView As TableDef Dim strView As String Dim fldName As Field Dim arArgs As Variant This is part of the code works: Set qdfSelect = CurrentDb.QueryDefs(arArgs(1)) For Each...
  9. fiep

    link to SQL view and list fieldnames: error 3420

    Hi, I have linked my access front-end to an SQL server. Now I have linked to a view and want to list all field names in the view. I use this code: Set tblView = CurrentDb.TableDefs(strView) For Each fldName In tblView.Fields <-- gives error 3420 Me.kzlFieldNames.AddItem fldName.Name Next...
  10. fiep

    Find user roles

    That's what I need. Thanks very much. Here is a star.
  11. fiep

    Find user roles

    Thanks ptheriault. But I have seen that FAQ but that does not resolve my problem. It only selects the roles the user is added too directly. It does not does show inherited rigths through group membership. I hope that is somehow possible. Kind regards.
  12. fiep

    Find user roles

    Hi, I have an application that uses SQL to store the information. The authentication on the server is Windows Authentication and the users are all part of one or more Windows Groups. The Windows group is mapped to database roles in the database. So it looks like this: User is member of Windows...
  13. fiep

    select user database roles using SP

    Perfect, thanks. Strange I did overlook the FAQ.
  14. fiep

    select user database roles using SP

    Hi, Is there a stored procedure that retrieves all the database roles for the active user? I know how to retrieve all roles and the names of the members. But I want to list all database roles for a given user. thanks in advance.
  15. fiep

    Menu item firing 3 times

    The function only contains this: debug.print "function called" When I click the menu I have three lines in the debug window. What could be wrong with the function Furthermore the only action I can think of that can be used with a menu is te onclick. But there is no choice in when te function...
  16. fiep

    Menu item firing 3 times

    Hi, I have created a custom menu button to print reports on a form. If I click the (custom) menu item the function connected to the button is executed 3 times (and the report is printed 3 times). Of course it only has to run once. Am I doing something wrong of is it not possible to use custom...
  17. fiep

    pick color and use in excel

    Life can be so easy ;-) Thanks very much.
  18. fiep

    Frontend Local Tables

    ZOR, Did you try: DoCmd.TransferDatabase acImport, "Microsoft Access", <access file>, acTable, <remote tablename>, <local tablename> Works for me. W.
  19. fiep

    pick color and use in excel

    Hi, I have a color picker for the user to select several colors for several types of data. (Which data is not interesting). I get the color codes using the standard color picker. But when using the color code in a macro that exports data to excel: .ActiveCell.Interior.ColorIndex = <code picked>...
  20. fiep

    Cycling thru Records in Access

    Jay, To walk through all records in the form you could do the following. dim rstRec as recordset set rstRec = me.recordsetclone rstRec.movefirst while not restrec.EOF do ' do something with the record. wend W.

Part and Inventory Search

Back
Top