Search results

Hi, it is populated through code, how can I explicitly call it? Thanks a lot. Fen

Thanks, I have a formula that calculates a percent. Bound data txtTractAcres, Bound Data txtPermittedAcres. Unbound txtPercent (this is the % of the Tract Acres that is permitted) =[TextTractAcres]/[TextPermittedAcres] Unbound txtStatus (If Tract Acres is >1% Shows Yes, If Not Shows No)...

Hi, Can anyone tell me how to write the value of an unbound text box to a bound textbox on a form. I have this code and have put it into the after update event but it will not work, but if i add it to the on click event it does. I want it to be automatic. Private Sub Text573_AfterUpdate()...

Hi, I have a txtbox that has a percent in it, (txtbox1) I have another txtbox (txtbox2) that I want to place a value in based on a condition. If txtbox1 is > or = to 1% Show "Yes" in txtbox2 Can someone please help me, I am trying to do this with a conditional format on a form. Thanks...

Hi, Looking for a way to hide a label if a textbox shows a value and show the label if the textbox value is a Null. Thanks. Fen How

Ok, this works but when I add this code to an unbound text box on my form it still shows blank. Any idea what I am doing wrong? =DSum("[si_Grantee_Acres]","qry_siDSUMSurfaceAreaPermittedOnly","[si_Permitting_Status_Lookup] = 'Permitted'")

Thanks I got it to work, any way I can show a 0 (Zero) if no matches? Fen

So I would use two queries, but call the results from the copied query into the main query. Fen

Ok, so in my Query I would add an expression say: SumOfsi_Grantee_Acres: Sum([tbl_siSurface_Seismic].[si_Grantee_Acress]) This does sum them up but they are not filtered. Can you show me how to use the DSUM in this situation? Thanks.

Thanks, I agree with that however in my form I want to show all of the records not just the ones that are Good To Go. Can I still show all records but only sum the Good to Gos in the Query? Thanks. Fen

So far I have this to work but I cannot figure out how to only add those records that are Good to Go. =Sum([si_Grantee_Acres]) Thanks.

Hi, I have a subform that has two cols in it. Acres and Status In the header of the sub-form I would like to show the following: Total Acres where Status is = to Good to Go. I was thinking I could put a unbound txtbox on there but am not sure of what to put as the control source. Can...

Hello, I am using his code to export data from a query into a .dbf file. The .dbf file gets created great however the data drops to 5 decimal places when in the Query it shows 10 decimal places. Any way to make it export with 10 decimal places in this code? Dim access As access.Application...

Hi, I have two worksheets. Worksheet 1 has Col ID and Col Name and Col Address Worksheet 2 has Col ID and Col Address Is there a way I can write a formula where Worksheet 1 Col ID and Worksheet 2 Col ID match It places the Worksheet 2 Col Address into the Worksheet 1 Col Address. I cannot...

Adam, Nice to hear from you. Thanks for you help. This is what worked. IIf(Sum([si_Total_Surface_Tract_Acres])<1,25,Sum([si_Total_Surface_Tract_Acres]*20))

Thanks, that looks real good, I am getting a data type mismatch error? So close..

Thanks for your input, I think I will run a DeleteQuery first, clear out all records, then run the append query second and re-populate. Seems like this may work. Thanks again. Fen How

When I run it it says you must have at least one destination field. Thanks. Fen

Thanks, in the update query I am not sure how to do that, do I just change the existing query to an upate query and run it? Will it update itself from the existing data? Thanks. Fen How

Hi, I have a query that runs a sum value based on a group. in the same query I take that value and multiply it by 20 to get a number. Table Calc Payout: Sum([si_Total_Surface_Tract_Acres]*20) It works great! What I am trying to do is if the total of the sum value is less than <1.25 then...