Search results

  1. B

    How do I copy fields from 1 record to the next?

    Thank you all, again! (If a little late...) I did go back to designing and now have related tables and subforms and it went so much quicker because of all the tips and advice i got from everyone! Thank you!
  2. B

    How do I copy fields from 1 record to the next?

    You Genius, Paul! You wizard! Thank you! You just saved me and others after me a ton of time! And it's for a good cause. Really! Thank you, thank you, thank you!
  3. B

    How do I copy fields from 1 record to the next?

    Thank you! But, sorry, uhm, beginner here, you mean this: ******** Code Start ********** const cQuote="""" 'Thats two quotes me!Control.DefaultValue = cQuote & me!Control.Value & cQuote '******** Code End ********** I put this: const Acquired_date="""" me!Control.DefaultValue =...
  4. B

    How do I copy fields from 1 record to the next?

    I have another problem that drives me insane. And here it goes: I have fields on a form for the Date, the Start time and the Finish time. These won’t change for the next 120 records. So, upon opening a new record, I’d like the Date and times to appear there already. But here is the crux: After...
  5. B

    How do I say "unless" in VBA?

    Boy, do I feel like an idiot now..... The default value was it! The true/false change to the code works, too. Not sure which is better as both, that one and mine seem to work now! As for the 'Me' construct: Thank you, I always wondered what that stood for. It'll make my next codes way more...
  6. B

    How do I say "unless" in VBA?

    Hello there! I have the following problem: I have a form that automatically puts a value into a field if I click a checkbox. So far, so good. I want the field to say 0, unless the check box is clicked, in which case it will automatically write 12 into the field. I wrote a piece of code that...
Back
Top Bottom