This code should do this:
1st: Update selected Standard-values of all records of one order except the first record, where these standards are saved. The button for setting the standards is only visible if the first record is shown.
2nd: loop through all records. if one record is loaded in the...
This is the code:
Private Sub cmd_SetStandards_Click()
'set Standardvalues
yesno = MsgBox("Are you sure, you want to set these standards for all positions?", vbYesNo + vbQuestion)
If yesno = vbYes Then
Forms!Auftrag.Fensterposition_Unterformular.edit...
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
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'm using both, Draw and Illustrator cause I need both. I don't know, if it is Corels inability to export files correctly or it is Flash's inability to import, but I have to save Corel10 files as Corel 8, open it with Illustrator and export them wo .wmf or any other vector format. If I export it...
My problem with imp/exp is, that the "SYS" objects are not exported and the import of the users don't work correctly. I hav 2 users with tables. 1 user work without errors the other one is imported but his tables are not. Also the grants don't work correctly.
Isn't it possible to...
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.
I pasted your complete example into sqlworksheet and got these results (at end of post). Are you sure, that this work? I didn't find "ACCEPT" in the reserved words-list of the Oracle HTML-Manual. Maybe it don't work in my version 8.0.5 or not on NT 4.0?
SQLWKS> set serveroutput on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.