Search results for query: *

thanks. that works great when the form is open, but on closing the form, all variables are lost. I declared save1,... as public. is there something else I'm missing. Is it necessary to store the values in a table for later use?

Access 2002 I should also mention that employeeone is the name of the control

I imagine this should be pretty simple. I'd like to save the source values in several combo boxes on closing a form. I set up a button that prompts a subroutine to save the value of a combobo, ie, Private Sub closeform_click() save1 = employeeone.Value DoCmd.Close acForm, "employeeselect"...

Thanks. I've done both and I still can't select the data. When I change the table look-up, all is fine. I wonder if there's anything terrible about using a comma?

I have a combobox looking up names(last name, first name)in a table, but I'm unable to select from the list. Are there specs for the underlying table or query that limit the data that can pass through? the table has two fields, name and id, and the name field is expected as smith, bruce. thanks...

thanks cosmo, the header method works, but when you have a group header summary and report header summary it looks silly. the article mentions sums in group and report footers will be included in the download. It says further that if you have more than one sum per field (which I do, group and...

I have several report footers that are not included in the report when I download it to excel from a macro, and they are also not in excel an outlook attachment. does anyone know why? thanks

i imagine this can be posed as a renaming question. can I rename crosstab column headings?

I have a crosstab query that breaks out monthly totals, but I'd like a more decriptive nanme for the column heading than 1/1/2003. I have a field containing a text value jan2003 and I'd like to use that as a heading, but access sorts the column headings by the text value so apr2003 is ahead of...

I have a button that locks a field ( in another form) selected from a combobox, but the design changes are not saved when I re-open the form where I lock a field. This seems simple, I must be missing a setting that allows editing changes. any ideas? thanks could it be my form view? If...

how would I prompt for a field to be locked. I imaginme it's pretty easy, have a combobox to select field to be locked, say combobox then a button would run an event like Me![combobox].Locked = true thanks

thank you

the start-up option works great. I'd like to allow access to most menus and toolbars, but not design. can you disable design mode as the default start-up option?

Private Sub Form_Current() If intnewrec = True Then Me!employeeID.locked = false Me!firstname.Locked = False Me!lastname.Locked = False End If End Sub is this getting closer?

I imagine I need to declare the recordset and the current record Dim rst As Recordset dim x as current (or something) Set rst = currentdb.OpenRecordset() If x = New Then unlock Else End If am I off?

thanks Tony.that's exactly what I'd like and I'll take your offer of help. I'm not sure where to start.

I locked the fields that I don't want to be edited and selected allow edits for the form properties, but I can't enter a new values in the locked fields for a new record. the form is based on a query and I can add records through the query. any ideas? thanks

thanks John, one of my quotes was misplaced so the sql read select fred & as jim

thanks

I disallowed edits in a form, but there are a few fields I'd like to allow edits to. is there an easier way to do this defining it in a module? thanks