Search results

I unchecked "Utility.mda", but not "MISSING Utility.mda" I unchecked that and it recompiled without errors and all is working now. All good for now. Thanks for all the help! Learning as I go...

When I try to recompile the code I get a new error. see pic. Suggestions? Oh, again many thanks for all your input and help :)

MarkK - tried moving a couple references around - no change ridders - pic attached, and yes 2036 is probably about right. (small aside, my new machine is Core Quad 9850, running XP Pro. I had to source the parts myself, before IT would build it, as they can't find New XP compatible...

Ok, back to this. They finally build me a faster machine. It has Access XP(2002) not 2000 installed. When I enter data in the field what was working from above I get an error. Please see attached pic. I did some quick googling and checked the VBA References between the old machine and the...

Thanks everyone. A lot to digest. I will probably have questions in a few days. Until I fully grasp everything above, I'll just use Ridder's solution. It works, it's quick, and I understand about 90% of it. The advise was good to know too. Thanks again everyone!

Thanks everyone, Very much appreciated for the quick responses! Dlookup looks like it might work, but I'm unsure as to how to setup the parameters. I made a quick DB1 with my dates, and a small form with a date and fiscal qtr fields I added an After Update event expression with dlookup for the...

I'm back for more help. I have an Access 2000 database form that has a field to enter the fiscal quarter number from a date. I currently look up the qtr number on a piece of paper. I think to myself, why can't Access do this. If I type in the date field, how can access look up and auto fill...

Pbaldy, thanks. Got it to work. Had to find the right event trigger, 'after' works Thanks everyone!!

Thanks everyone for all the hand-holding, very much appreciated. See screenshot of what I did. In expression builder are the 2 fields I'm actually working with. Like I said above, I did not build this database, and this form is a mess, sorry. I'm going to learn one thing at a time to clean it...

Thanks for the reply. I'm not 100% what you mean. I think it is: right click form, select design view, right click purchase store field, click properties. In new popup box, click event tab, click '...' three dots to the right of 'after update'. Then Expression builder pops up. I click [repair...

Thanks for such a quick reply. I have to enter store number where it was purchased, and where it was repaired. 95% of the time they are the same. How can I have the repaired str number autofilled when I enter the purchased str number? Again, thanks

I just had a fairly complex Access database dropped in my lap to use at work. I know little about Access, but they gave this to me because I know a lot about Excel & Excel macros. The person that wrote the database left the company some time ago. We use Access 2000. ( ya, I know it is old, but...