Recent content by a98dsu98sad8sua

Hi, There's buttons I use on the view form that I don't want on the edit form, and vice versa. :)

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...

Thanks MajP, but unfortunately that's what I meant about using Developer Edition, you need this to distribute the runtime :(

Thanks for the info. The Database is going to be used on a LAN, I'll try the simulating subforms approch. Thanks very much guys.

Hi, Both, they're all fine :(

Hi My Primary key is 'pk' in the Vehicles table (My main form is based off of this table, and I have named it PkCarID as the foriegn key in other tables, The relationships are all set up too :( I don't understand why it's not working, but the parent/child relationships seem ok to me.

Hi, I have a form, with 8 subforms on, all linked to seperate tables, related by a shared foriegn key (The key is the primary key of my main form) If I create a button to advance records, or use the record selectors at the bottom, it only repopulates the data in my main form, the subforms...

Arg! I've spent loads and loads of time on this database, and then been told I have to distribute the Database to people who don't have access. So I have a few options: Completely rewrite this with a web frontend (Half the reason I'm using Access is because I'm not too good with that) Buy...

Hi guys, I have a form in my Access database which contains about 8 subforms (All links through a shared primary key, the 8 forms have 8 corresponding tables). I've been told Data Access Pages aren't that great, but I have limited coding experience with web based lanaguages. I know VBA, and a...

Thankyou :)

Hi, I have a data entry form, when the mousewheel is moved the data disappears (I presume it's starting a new record?) Same happens on my subform. Any way of turning this behavior off entirely? Cheers, T

Thanks for the input :) Glad it looks good, taken me ages! Just need to do the relationships now! I've reverse gear in a seperate table (As you can see from my example) this is because I don't think I will encounter vehicles with multiple reverse gears, and I'm only really interested in the...

Thanks, a helpful post. I have got a separate table with my final drive, etc as you can see (tblGearTuning) What I have done is created another table (tblGearInfo) with these columns: pk, pkCarID (the pk of tblVehicles), intGearNumber, dblGearRatio, dblGearTopSpeed. Sound right? Does my...

Hi, Thanks for the help, this is my table structure at the moment, but without the gear ratios, thanks for reading, it's quite big! :( tblVehicles (This is where 'pkCarID' comes from, this is my main table) pk, txtVehType, txtManfacturer, intYear, curCost, txtPrimaryCountry...

Hi, I am creation a table with gear ratios, the struction of my source data is as thus: Gear Number | Gear Ratio | Top Speed in Gear 1st | x.xx | xxx 2nd | x.xx | xxx 3rd | x.xx | xxx 4th | x.xx | xxx 5th | x.xx | xxx 6th...