Search results

My apolgies for not giving the error messages but I thought with all that knowledge out there that someone would just be able to look at the code and determine what needed to be changed for it to work in Access 2003. So here's what's happening. I have made changes to the field names to match...

Hi Everyone, I'm hoping someone out there can help me with this. I have found a great example on the web that provides code on how to autopopulate data in a subform based on info entered in the main form. This example is written for Access 2000 and when I try to use it in Access 2003 I keep...

Thanks for all your help! I finally got it work.:D

Good Morning - Hope you are still willing to help me out with this problem. :) Ok - I'll start from the begining again but using my actual data. I currently have a text box called "Hatch Date" that I want to equal "Midpoint Hatch Date" (which is also a calculated text box) most of the time...

The only way I know how to bind the text box is through the control source - that is, my calculation is located in this spot. But as soon as I do that then I can't update the field. I've reviewed your original idea and I see that it says that I could store the calculated result. Does this...

Thanks for the info Paul. The solution that you recommended seems to give me the same results as when I place my calcuation in the default value - all the instances of that field are replaced with the hard entered value. Any other ideas? PS - Boreal is not directly associated with the ski...

Hi Everyone, I'm still pretty new to forms so hopefully this is not a silly question. I have a text box field that needs to be a calculation based on other fields in the form. Most of the time this calculated value will be correct but the client wants to have the option to edit this field to...

Thanks Coach! It's amazing how many ways one can skin a cat! Just before you responded I also found that the following code works as well: ... Else DoCmd.RunCommand acCmdRecordsGoToNew End If Thanks so much for your prompt reply - I put the same question out on a couple of forums...

Hi Everyone, I am VERY new to VBA so please bear with me! I am using Access 2003 and I have a form that when it is loaded it prompts the user to answer a yes or no question. When yes is selected I want the form to open in Edit mode and when no is selected I want the form to open in Add mode...

Hello all, I am attempting to calculate the average of 7 fields of data (eg: DataColumn1, DataColumn2, etc...). The average field (DataColumnAVG) is included in the same table as the input data. I need the average to calcuate the same way that excel calculates an average of data cells - that...