Recent content by ronrsr

thanks Rick, that worked really well. -rsr-

Hey, that worked great -- only one small problem left -- When I change the category, the choices in the pull-down part of the combo box change -- but the current value of the combo box doesn't. for instance: Category Subcategory Drop Down Milk Beverage Beverage...

can I use it in the DEFAULT property of a FORM element? =rsr=

the number need only be unique -- preferably the next sequential integer, but even that's not necessary -- If the db were stored in access, i would use autonumber, but it's in excel, and I'd love to be able to generate this automatically when a new record is created. -rsr-

How do you force the form to refresh? -rsr-

How can I generate an unique integer key? I can't make it an autokey field, since it's a linked table - is there some way I can generate a unique key, say, max(other_ids)+1? thanks, -rsr-

I am working on a form that has a combo box for category, then another one for subcategory -- it works fine, except that when I change categories, I'd like to have the subcategory list updated -- now, i only get the original subcategory list displayed. Does anyone know how to update this...

that does sound an awful lot like it - I will check it out tom'w at work. bests, -rsr-

When I create a form in Access 2000 at home or on my laptop, i get help from the Form Wizard and the Combo-box wizard and a whole host of other wizards. When i do this at work, the wizards don't come up, and Access appears not even to know that they are not available. I get nothing -- no...

Thanks, Rickspr and other-- i discovered the problem. The Excel spreadsheets that were emailed to me were READ-ONLY. I clicked off the READ-ONLY attribute, and it worked. Thanks very much, -rsr-

thanks, will investigate that further. The error message is : Recordset not updateable. The data is a simple excel spreadsheet with simple values -- no data protection, no file-level protection - no SQL as far as I can tell. how do i tell if the worksheet is the result of table joins...

THE error message (in the status area) is; recordset is not updateable. -rsr-

I developed an application that uses data from excel spreadsheets -- during development, I imported the data, and everything worked just fine - i could edit, change, delete data in all fields. Now, I changed it so that it works with linked tables from excel spreadsheets -- all of a sudden, i...