Recent content by TobyR

Bumping this, please help! :o

Hi, I have two main forms which are essentially the same apart from some command buttons, one form to enter data, one form to view data. These forms also contain about 8 subforms, in Data Entry mode (for the data entry form, funnily enough). Problem is, obviously when I open my form to view...

Hi guys, I have a form called frmVehicleData, this form contains about 8 different subforms all from different tables relating to various aspects of a car (Chassis, Engine, Brakes, etc). The main form is from tblVehicles, who's primary key 'pkCarID' is used in the related tables to link the...

Hiya, Thanks for all of your help, Looks like I will have to do it this way. Much appreciated :D

Hi, I'm still not sure how to do this... Say I have the fields in CarStats: 060speed laptime maxbhp maxbhprevs skidpadg600 And I want to add fields to say whether the data is factual, or estimated, would I add the fields to the same table so it looks like this? 060speed 060speedFactDerived...

Hi, Is there anyway to make the front end of my database standalone? For example, I would like to people to run it who don't have Access installed, what ways are there around this?

Hi Thanks for your help, I have the code to disable the mousewheel, but I've heard a mention somewhere that you can turn it off within Access 2003 without using code?

Hi guys I have a form with a large amount of subforms on it. The problem I am having is that I cannot tab between subforms when entering data. The cursor just moves within the subform and browses off of the current record (Creates a new record, like when scrolling the mousewheel). Anyone...

Hi, thanks, I see what you mean now, I will modify my design. Just done the form as well, D'oh.

Hi, Thanks for that, unfortunately, yes, most of them need a guess/factual/derived field... I can't see any way of doing it apart from creating a field for each piece of data in my table. Regarding the table structure you gave me, thanks, but its all mixed data, some of them are speeds, some...

The user needs to input whether it is fact, guess or derived, but I don't see any way of doing it apart from creating a field for each field that needs the fact/guess/deri information entering. They are all added to "Class" tables (I have a table for Engine, Chassis, Tyres, Brakes, etc) My...

Unfortunately I have 100+ fields, adding another 100 to colour code them is going to be mammoth task! Any workarounds you know of? Thanks, T

Hi, I need to colour code fields in my database based on whether the data entered is a guess, derived data or factual data... I have no idea how to do this! Apart from create a field corresponding to each field in my database with the values 1-3 in (1 for guess, 2 for derived etc) but I'm...

Will this disable tabbing a new record also? Thanks, T

Hi, I have a data entry form in Access 2000, and when people scroll the mousewheel or press tab enough times, all the data they've entered disappears! Is there anyway to prevent this? I have instructions on getting a .dll to block the mousewheel, but nothing for the tab, any help? Anyone know...