Search results for query: *

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...

...trg.MoveFirst Do While Not trg.EOF trgid = trg!PID Set prstd = db.OpenRecordset("Select * from persStanding_TrnMtg where fld_id = " & trgid & "") prstd.Edit prstd!fld_member_totals = prstd!fld_member_totals + trg!Cnt...

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...

Remou and Rim180, Thank you both for the different approaches and ideas. Especially getting back to me so fast. This did solve the problem and is doing exactly what I needed it to do. Fireman1143 [bigsmile]

I am setting up an initial login screen which will have NO security function other than make someone relaize they shouldn't be trying to get into this particular database. All I want is to ask for the Username and then the Password and if both are supplied correctly it will open the main...

Thank you both very much. After removing the commas and putting a space where need, it works like a charm. It's great to have such knowlegable people to call on in a time of need.

I hve placed the following code on the OnClick button on a form. The SQL statement is to append the training records for a particular training session based on the employee name having a checkbox marked. When I tried the query it worked fine EXCEPT I had to manually type in the training session...

[2thumbsup] Thanks to both of you. Your input made it easier to figure how I wanted to format and get this.