Search results for query: *

i solved the problem myself. i was using a wrong file in release mode where there were some fields missing

I have a Access backend for a vb.net 2.0 front end when i run the project in debug mode every thing goes fine, but when i run in release mode i get an error when i try to fill the items data table "No value given for one or more required parameters." Error code "-2147217904" Any help would be...

First of all THANKS for your help by now i've tried already everything that u can think of but i still had that problem so finaly i figured that i'll try to recalculate that field in the current event of the main form and it works now Thanks again

well i tried that one too and it gave me the correct result first, but then i closed the form and when i reopened it it gave me again the same old result #error

I have in a query a calculated field named dblSubTotal with the calculation "intQuantity * fltCost", then I have a field on my subform with a locked field named txtSubTotal with the control source dblSubTotal, then I tried to create a field in the footer of the subform with the name txtTotalcost...

I have inherited a MS Access 2000 DB in which the original designer stored .jpg images inside of the DB. Is there anyway to export the images as individual files? Any help is greatly appreciated.

Set the "Data Entry" property of the form to YES

use the following code currentdb.Properties("StartupForm") = "Your Form" Make a error trap for err.number 3270 (Property not found) enter the following code for the error handler: Set prp = dbs.CreateProperty("StartupForm", dbtext, "Your Form") dbs.Properties.Append prp Resume Next

http://www.lebans.com/conditionalformatting.htm Here you can download a sample mdb for highlighting the current record in subforms

1.In the eneter event of the subform control you can make the button visible and in the exit event make it unvisible 2.use conditional formatting to highlite the current record

Make 1 form with a Combo box to select a name and a comand buton to close this form and open the other form Make a 2nd form based on a the table with the tasks In the click event of the command button on the first form enter the following code: DoCmd.OpenForm "2nd Form Name",,,"Name = '" &...

1.Cut the label 2.Select the text box 3.Paste the label

Use DoCmd.OpenReport stDocName, acPreview, , "InvoiceID = '" & [Forms("frmPaymentInvoice").InvoiceID & "'"

Make a combo box with 3 columns Part Number; Description; Qty on hand then in the after update event of the combo box enter the following code: txtBox1 = combo box.column(1) txtbox2 = combo box.column(2)

You must include the Primary key of each table in the query of the recordsource to make the form updateble

How does the "Controls(0)" portion work? Every control that could have controls attached to it (Example: a Text box or combo box can have a label a form has controls on it) has a Controls property which is a collection of controls affiliated to the control. All collections in access start...

you can use the following code Me.txtName.Controls(0).Caption = "What Ever:"

Enter the following code in the after update event of the listbox Dim strResult As String Dim varItm As Variant For Each varItm In lstPP.ItemsSelected strResult = strResult & lstPP.ItemData(varItm) Next varItm TextBox = strResult

It should be = Me.[subform control name].Form![UnitPriceGT] = Me.[subform control name].Form![TotalPriceGT] (with Subform control name I mean not the name of the subform, the name of the subform control on the main form)