Search results for query: *

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

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

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

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

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

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

Works like a charm, Thanks

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

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

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

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.

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

Perfect, thanks. Strange I did overlook the FAQ.

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.

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

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

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

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

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

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.