Search results

The is the code for doing it with a loop: 'Set focus to subform [Forms]![frmOrder]![frmSUBProducts].SetFocus 'Goto first record DoCmd.RunCommand acCmdRecordsGoToFirst 'Get the total number of records Dim TotalRecords TotalRecords = DCount("[ProductID]"...

Glad I could help! :)

There is no real 'nice' way to do this: Add a textbox that takes in the entire details-part of your form. Change the textbox's properties to Locked = True, Tabstop = False and add the following code to your form: The textbox's name in this example is Text1, change it accordingly to your form...

Open the query from the database window (data-view). Try editing or adding a record over there. If it returns the same error, or if editing isn't possible, then the cause of your problems is in fact the query's design and not the form's coding or settings.

You can do this by performing this check just before you open your report. If IsNull(WODate) Or WODate = "" Then MsgBox "Required Field", vbCritical + vbOKOnly + vbDefaultButton1, "Missing Data" WODate.SetFocus Else DoCmd.OpenReport ...

The errortext is "Object variable not set or with block variable not set". What would be really usefull for us is to know what code triggered the error. Can you post them?

DoCmd.OpenForm "NameOfTheForm" That should do the trick...

Check your recordsource. I think it isn't returning any records (Could be caused by faulty linking of tables).

Yeah, but he also has it when he opens it with acFormAdd...

First off, make sure that the saving is causing the problem. Try adding a ' in front of DoCmd.RunCommand acCmdSaveRecord If the error doesn't occur anymore, try replacing DoCmd.RunCommand acCmdSaveRecord with Me.Refresh Greetz, Seth

Yes, OK, but what is the recordsource? Is it a table? A query? ... Please elaborate.

Oh! We thought you actually wanted to calculate the value. In that case, yes, on the form, that's where you set the field to percentage.

The way to calculate the value is this: [Total_Actuals]/[SA_CDI_Money] The question now is, when do you want this calculation to take place? I would assume you would want to do it after both fields are filled in by the user. You could do something like this: Use this code: Private Sub...

In this example: The field that determines the inputmask is called : Field1 The field that has to receive the inputmask is called : Field2 In the "After Update"-code of Field1, place following code: If Me.Field1.Value = "OA" Then Me.Field2.InputMask = "LL0000" If Me.Field1.Value = "OT" Then...

What is the recordsource for the form? If it's a query, that might be the reason. Otherwise, please post your DB so we can take a look. Greetz, Seth

There is, provided that all forms you want to link have 1 field in common, for example a clientnumber, ordernumber, etc... I don't know how your database is set up, but I assume that you open the second form with a button on your first form. When you use the wizard to create the button, you can...

Please be more specific or post your database so we can take a look. Greetz, Seth

First off, you'll need to create a macro called AutoKeys. In that macro, create an empty line for the function-key F10, because it's default action is to open the menus in your toolbar. Next, in the code of your form, add following code: Tekst0 is the field with the propercasing. Tekst2 is...

Can you post the code behind the forum so we can take a look? You can do this by opening another form's code in the editor and double clicking the forms name in the list on the left-side. If it's possible to post the entire database, that would be easier for us. Greetz, Seth

Refreshing isn't a good idea eather... :rolleyes: