Search results for query: *

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

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

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

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

I'm stringing together a SQL statement in a loop that defines the new statement each time as strSQL = strSQL & ",[summaryFTEconfirmed].[countof" & strTEMP & "] As confirmed" & strTEMP & ",[summaryFTEnamed].[countof" & strTEMP & "]" I can't add an AS clause...

I'm stringing together a SQL statement in a loop that defines the new statement each time as strSQL = strSQL & ",[summaryFTEconfirmed].[countof" & strTEMP & "] As confirmed" & strTEMP & ",[summaryFTEnamed].[countof" & strTEMP & "]" I can't add an AS clause...

I'm trying to assign a variable as an integer and I'm getting a runtime error that the parameter query produced an error 'the object doesn't contain the automation object 'Apr2003." Apr2003 is a record in the table I'm looking up, but I wonder what the period or double quotes is afterward...

Is there a way to lock records in one field so that they can never be changed?

Is there a way to limit navigation to forms?. If a user wants to open a report, do it through a form, else they shouldn't be there. thanks

Is there a way to limit navigation to forms?. If a user wants to open a report, do it through a form, else they shouldn't be there. thanks

I'm trying to create an MDE and getting an error message that microsoft access was unable to create an MDE database. there's no information. are there normal reasons why? thanks

I'm trying to create an MDE and getting an error message that microsoft access was unable to create an MDE database. there's no information. are there normal reasons why? thanks

I'm trying to add a field to a query that will sum monthly entries of varying fields. For instance, now I'd add a total for monthly entries for march and april, but next month, someone will enter data for may, etc... My select statement that works is SELECT [MonthlyAssignments].phaseid...

Anyone know how to insert a comment in a form? I have a rather lengthy description of every button in a form that now appears as a message box and would look better better broken-up in several pop-up captionss. thanks

Anyone know how to insert a comment in a form? I have a rather lengthy description of every button in a form that now appears as a message box and would look better better broken-up in several pop-up captionss. thanks

I imagine this is very simple. I want to delete the table if it exists. I bet it's something similar to this If IsObject(resourcelist) = True Then DoCmd.DeleteObject acTable, "resourcelist" Else End If Thanks for the help. Also, as this being easy, can anyone recommend a good...

I imagine this is very simple. I want to delete the table if it exists. I bet it's something similar to this If IsObject(updateresourcelist) = True Then DoCmd.DeleteObject acTable, "resourcelist" Else End If Thanks for the help. Also, as this being easy, can anyone recommend a good...