Recent content by Fireman1143

Thanks Andrzejek [thanks] Works like a charm. I will look at updating it to do the Trim in the query. Mike

Having a DLOOKUP issue where it constantly returns a null value. I have the following code on my form and the first part does work: Private Sub cboApptVehicleYMM_AfterUpdate() Me.txtVehicleMakeModel = Trim(Mid([ApptVehicleYMM], 6)) ' This Works Me.txtSvcPriceCode =...

Thank you dhookom and missinglinq With your info I was able to get this working correctly. [bigsmile]

Thanks for the assist Duane. Proj_ItemTotal is a field in the ITEMS table which is calculated by the expression =CCur([Proj_ItemQty]*[Proj_ItemCostEa])on the form. It appears to work as the table shows the correct totals for each line item. I have attached the database for your review.

The table includes fields for the Proj_ItemQty, Proj_ItemCostEa and Proj_ItemTotal. The item total is calculated by: =CCur([Proj_ItemQty]*[Proj_ItemCostEa]) This works fine In the footer of the subform I have a text field called ProjectTotal with the following. =Sum([Proj_ItemTotal]) It seemed...

I have used an example of Access 200 database examples to write the code for doing a total on the subform, then having it show on the main form. I had it working until I opened it with Access 2010. Now the Sum([ItemTotal]) causes a #Error in the text box in the footer. This also happened to...

I have a database which works great in 2000-2003 but when I take it to work and use 2010 it has a problem using the Find - Starts with filter provided. I have the form open and that box to find a record open by code. When a few letters are enter and I go to search it notes it cannot because...

That was it. So simple and obvious I missed it. Thanks Duane

I have a report which I call from a button with the following code: Private Sub btnPrintReceipt_Click() On Error GoTo Err_btnPrintReceipt_Click Dim stDocName As String Dim StrCriterion As String stDocName = "Payment Receipt" StrCriterion = "[ReceiptNo]=" &...

Thanks dhookom for the insight. I "inherited" this coding from a programmer that had done the work previously. He has it set to save values to a table, which is completely emptied at the start of each time a report is run. My thought was to continue his methods (which I need to admit are...

Thanks dhookom. I tried GROUPing and I must be well off on the syntax. Table Name: persStanding_TrnMtg fld_Total_Trn fld_Total_Mtg The code below works to get the individual count of the training attendence for each individual within the dates...

I am trying to have a SQL query update a table with the record count from another table which meets the criteria of between two dates from a popup date form. The date part works in other similiar coding where I am pulling individual records by an ID field. This is differnt in that I need the...

I have a basic In/Out form which on some workstations the user(s) will minimize it from their desktop all day. I have located the front-end in it's own folder on the c: drive of the workstation. Is there a way to have the form refresh when it selected from their tool bar? The complete...

Thanks Remou I will give it a try. This is the first I knew about the SelfCert. Fireman1143

When I open a database in Access 2003 RUNTIME it displays a dialog box that is a Security Warning. I know how tosolve this issue using Access but I can't figure out how to do it using the runtime. The application is status board for In/Out and only has one form, a continous form with only three...