Search results

Hi, I have two tables. A is master PK is TractID, B is Relational with a One to Many with A. I am trying to run a query that will show only 1 PK with all the associated records in B in one field versus multiple records. So for example, right now when I run the query it will add a record for...

Hi, I have a query that has two fields, si_Permitting_Status_Lookup and si_Grantee_Acres It is a totals query so field #1 is grouped by value and field #2 is a sum field. I have a report that uses this query to show the results. What I am trying to do is place a txtbox on the report that...

Paul, You always come through. Perfect! Thanks a million. Cheers, Fen

Hi, I am using this to calculate a % in my query. Expr1: Format([SumOfNMA]/[Surface_Acres],"Percent") It works great execpt where there are zeros, it shows error. Is there a work around for this? Thanks. Fen How

Hi, I have a DB that has a field in a table called "LETTERHEAD1" the datatype is a OLEObject. Many reports call this "LETTERHEAD1" to the header of the page as a bound object frame. Any Idea on how I can modify the data that is showing up in "LETTERHEAD1"? On the report it is blank and i...

Hello, I inherited a job for a client who had purchased a Access Database in about 2003 - 2004. It looks like the DB was created in Access 2003. The problem is the company that made it (some small outfit) is no longer in business and no one can get in touch with anyone for help. They need to...

Hi, I am trying to run a DSUM using more than one variable. Is this possible? Here is the code I Have so far =DSum("[Surface Acres]","QRY_MINERAL SUMMARY DSUM","[Mineral_Status]='Unit Designation HBP' and 'Title Received via Mineral Ownership Report'") It does not error out but will not...

That was it, thank you so much!! Fen

Hi, I have a subform. The form acquires data from a sum Query. It has about 6 items A, B, C, D, E etc.. I am trying to add an unbound txtbox on the header of the form to show me the sum total of say A, B only I have this code but it is not adding up? Can someone please tell me what i am...

Hi, Is is possible to format this ([Fixed Minimum Price Per Acre]) to Currency inside the following code? It currently shows 25 when I want it to show $25.00 ="Minimum Payment Of " & " " & ([Fixed Minimum Price Per Acre]) & " " & "for a total of " & Sum([si_Grantee_Acres]) & " ac. " Thanks...

Bob, if you are still willing to help I will be happy to email you the DB. Thanks Fen

To Large to Upload.

Here you go. Split DB. Area in question. Surface Tab, Payout Details Tab, Subform Header. Thanks. Fen

Sure, rather send private versus post public are you okay with that? Fen

Thanks, I am dev in 2003

Bob, For simplicity sake I tried this. On the subform I have a txtbox bound to the query called OWNERINT it has either a 1 or a 2 value. I have another txtbox called DividedInterestPayout so what I want is, if OWNERINT is 1 show the txtbox if not hide it. No luck, anything obvious? Private...

Thanks, I placed it there and for some reason it will not go. Not sure why because it seems pretty straight foward. Can I call a control by its field name? versus its control source? for and example the field TotalGranteeAcres is a calculated field on the form. Fen

Thanks, all the fields are in the subform, not calling anything in the main form. The Subform shows data as it is related to the record selected in the main form but thats it. The subform is driven from a query. In the subform for an example, if I am in a record that the TotalGranteeAcres is...

Thanks Bob, I did that but when I load the main form, the code does not run or refresh in the sbuform, where to I place the code? Here is the revised. Private Sub Form_Load() If Me.TotalGranteeAcres < 1.25 Then Me.MinimumAcreagePayout.Visible = True...

Hi, I have this subform I am trying to run this code on, I have tried placing the code on the subforms Onload event and other areas but it will not work properly. Can someone tell me where to put this code please? If Me!TotalGranteeAcres < Me!FixedLessThanValue Then...