Search results for query: *

Hi my problem is this: I'm using a Form with a subform to add/change records. I have a button which opens a form, where I can update some values for all records of the subform with one click. It takes the values of the 1st record and applies these values to the other records using...

Hi I use somw views to calculate a "Status" over some Tables. The explain plan shows one Full Table scan and I tried to make Indexes but I didn't find the correct index. Does anyone know an easy manual on how to make indexes? Andreas p.s.: here's the view CREATE OR REPLACE VIEW...

Hi I have a little Acces-DB to add Customers. I have to Forms which communicate. Now I want to "link" the smaller one to the bigger one: If I move the bigger, the smaller sould also move (like the forms of Winamp). Does anyone has an idea? I do not find any x/y Coordinates and...

Hi how can I connect a Recordset as Datasource to a MSFlexgrid? hope anyone could help AndreasAuer

Hi I want to get the Real Username of a Domainuser. I know, how to get the Loginname, but I need the real one. How can I do this?? I hope somebody can help me greetz Andreas

Hi my problem is the following: I have to create a report with Centura Report Builder which is very long. To be able to store the Statements (cause its longe than 2000 chars), I want to store Information in a variable like select column1, column2 into var1,var2 from table. how can I do this??

Hi my problem is, that I have to send a daily automatic email out of an access databse. This Database generates a text-file which has to be sent every weekday. I tried to make a mailto-hyperlink, but how can I add the attachment and send it? Is there a way to do this? Please help

My problem is that if i copy something in Autocad and paste it into another open Autocad drawing, its pasting some other things too, which i pasted some time before into this drawing. it seems that autocad has an own clipboard for each drawing. where's the mistake?

I have an Oracle 8.0.5 Server running on Windows NT 4 and I need to make a full copy of an instance to make a new one. How can I do this? With exp80 and imp80 it didn't work correctly. Please help!!

Is it possible to get the current loginname with SQL? Its not important, if its the Windows-Loginname or the loginname of Oracle. It would be nice if it would be possible.

Is it possible to create a input-dialog with SQL? In Access I can use the PARAMETERS clause. Is there something comparable in Oracle?

My problem is the following: I need to convert a date into week and year. I use to_char(date,'yyyy.iw'). The problem is that, if the date is in the last days of december but is in week 1 of the next year. For example: 31-dec-2001 should be 01.2002 but it returns 01.2001. How can a solve this...

I need to convert a weeknumber of a year back to the beginning date of this week example: '08.2001' -> '19.02.2001' week 8 of 2001 should return feb 19th of 2001

I have to do a select on a table called produktion. The primary keys are bezugnr and lfdnr where bezugnr is the number of an order and the lfdnr marks the number of the position in the order. Now I have to get max(berende) from all positions per order except the one with 'VERSAND' in column...

I didn't find this in my tutorials, so I ask here for help: I need to get the actual Windows-Date into a select-query. How can I do this?