Search results for query: *

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

Is it possible to edit posts on this forum? The problem has started again about 10 minutes after importing all of the files. Sorry. Toby

Issue Resolved with PaulBricker's response. Importing all objects into a new database worked! (File > Get External Data > Import) Don't forget, if this is the frontend of a database split you will need to link the tables instead of importing them (File > Get External Data > Link Tables)...

I am using Microsoft Office Access 2003 (11.5614.5606) Thanks for the advice about importing into a new DBase, I will try that now. Regards, Toby Rodriguez

Hi all, I have tried googling this topic using: "Report Design Hang", "Access Hang", "Access Stops Responding", "Access +Report +Slow" and this form using "Report Design Slow", "Access Slow", "Access Hang", "Access Freeze", "Database Freeze" and I couldn't fine anything regarding my deviation...

Great example post. Helped me too, another star.