Recent content by Witchcraftz

So reports are unable to do what I want, I need to define the data recordsource and do my calculations there.

Despite Google I can't seem to figure this out. I have some data in a format similar to: Name / Style / description / speed / distance john / driver / careful / 80 / 5500 mary / driver / careful / 70 / 7000 pat / racer / reckless / 100 / 6000...

I wanted to get the autonumber ID before a record was saved to the table. My fields are on a form that is linked to the table. Maybe my solution is not the most elegant but it seems to work. I messed around and came up with this solution: it creates the next record and captures the autoID then...

From the lack of responses I'm guessing that this isn't possible. Since I must do this I will figure something out.

I have a database with confidential data (to be used internally only). I do not want a person opening the database to get access to the tables or other elements. All of the security setting on all computers are set to disable macros. So anyone who opens the application now has access to seeing...

Just found this place, looks like a lot of resources to help the newbies like me!