Search results

Hi Wayne, I did the same thing and created a query using the two tables making one the dominant table . In my case I have two tables one called customer and the other called customernotes. Both have a field accountnumber and I joined accountnumber to accountnumber making customer the...

Nope, Have to store the value in the table. Long Story. It goes way back and way deep on how I initally built the data base. ( Too late to change it now). If there's no other solution than I will manually do the changes. It's only a one time thing. Thanks anyway. Gary

Hi Curtis, I already have searched Access help, this forum and another I belong to. Since the form I am using is doing a calculation and the setvalue macro is causing the results to be saved on a table I need the update to happen from the form. I didn't see, and I certainly could be very...

Hi, This may be a stupid question, but, If I make a change to the design on a form and I want to update previous records to incorporate the change I made how would I go about making this happen automatically without having to go into each old record manually? An example is I just changed a...

Hi Matt, I have attached a link to another forum that has an article of a work around to allow editable autonumbering. It allows you to modify an automated number and it will store the modified number on a table. Hope this helps. Gary http://www.vbaexpress.com/forum/forumdisplay.php?f=91

Thank you both Ruralguy and Jman for your quick response. Jman the link you supplied did the trick. Thank you for the insight. I will mark this solved Gary

Hi, I know it breaks all the rules to store a calculated field on a table, but I've painted myself into a corner with the way I built this particular database, not good, I have repeating groups and basically the whole database is built this way. I need one form to store a calculated value on a...