Search results for query: *

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

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

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

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.

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

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

Hi, I am trying to fill a list with all user defined fields in a word document. If I loop through the activedocument.fields I only see the fields that have been added in the document text. I also want to list all fields that have been created in File --> properties --> custom and that have not...

Hi, I am trying to use string functions in excel like: trim(activecell.value) or replace(activecell.value, " ","") But these functions always return the same strings as the values in the activecell. So the spaces are not removed from the strings. It looks like none of the string functions work...

Hi, How do I find what tabcontrol on my form has focus? Two tabs: tabPackage and TabShipment If TabPackage has the focus a combox will have to show packages. Ig the TabShipment has the focus the combobox needs to show Shipments. Can this be done? Thanks. W.

Hi, I have a reports where the boxids in the following format: SHP_090604_14:42:30 In the subreport I want to show all articles in the box and the are identified with the same boxid: SHP_090604_14:42:30 I have linked the parent and child reports with the boxid column. However when I open the...

Hi, I hope somebody can help me with my insert problem. I have this table called tbl_currency and one of the fields is called currency (not to smart I know). I want to add a new currency by executing an insert statement: INSERT INTO tbl_currency (currency) values ('" & var$ & "');" This...

I have trouble with calculating some percentages. This is the code: all variables are declared as single sngPerTotal = sngTotalOrdered \ (sngTotal \ 100) sngTransCost = (sngTranport\100) * sngPerTotal The problem is that it sngTransport = 150 I still get a value of 1. So it looks like Access...

Hi, I have this datasheet view on a form. The user doubleclicks on the form and a pop-up form shows the details of the selected record. After closing the pop-up I requery the datasheet so the changed details are visible. So far no problem BUT requiring places the focus on the first record in...

If I execute the code underneath I always get a object no longer valid error. Can anybody tell me why? The variables are declared so that can not be the problem. I do not have a clue as to why it does not work. If I copy the query string into a query it runs without any problem so the syntax of...