Search results for query: *

Greetings: Does anyone know how to assign an icon for the desktop, etc. for Access? Thanks, Sahaitu

This sounds great. Quick Question: How will I include the selection "All" in the combo box? Thanks

...which is a simple state lookup table. The rowsource is as follows: SELECT tblState.idnStateID, tblState.StateLong FROM tblState UNION SELECT "*", "<All>" FROM tblState ORDER BY tblState.StateLong; The bound column is "1". This combo box is linked to a subform by idnStateID that displays...

Thanks again...

I have two text boxes on a form. I have requested that they both grow and shrink. When the information is returned on the form, the boxes do not grow or shrink. They are both attached to memo fields. Can anyone help? Thanks in advance. Sahaitu

Thank you so very much, both of you... Sahaitu

Greetings: Is anyone aware of a simple way to format forms to fit a screen anywhere from 800 x 600 to 1024 x 768? Any help is appreciated... Sahaitu

Okay, I see. Thank you. One more quick question though. I have changed the code to reflect what you have provided. The "<ALL>" selection works only if the case has a state ID of 1, (Alabama), so, essentially, I still have the same issue. "<ALL>" is only pulling states with a state ID of "1"...

Thank you so much. I do have one problem though: The code has gotten rid of the Run-Time Error. Though when I select "ALL" from the drop down list, I only get cases listed for "Alabama", which is the first state in my list. I have the following code for the combo box: SELECT...

...Sub I then have the following code in the query behind the combo box: SELECT tblState.idnStateID, tblState.StateLong FROM tblState UNION SELECT "*", "All" FROM tblState; When I select "All" from the combo box, I get the following error: "Run-time Error '13': Type Mismatch" Can anyone...

Thank you sooo very much....

Thank you for your reply. Could you please explain a bit more...

Greetings: I have a database with a table stored on the backend and a shared server. These tables are linked to a form. I would like to have the information inputted into the form placed into tables on the shared server and tables on a more private server. I guess I forgot to mention, the...

Greetings: I have a database with a table stored on the backend and a shared server. These tables are linked to a form. I would like to have the information inputted into the form placed into tables on the shared server and tables on a more private server. I guess I forgot to mention, the...

I guess I forgot to mention, the information I want stored on both tables is the same, it's duplicative. For instance, I want to store the staff name and ID entered into the form on the table on the shared server as well as a table on the more secure server. The information has the same PK...

Greetings: I have a database with a table stored on the backend and a shared server. These tables are linked to a form. I would like to have the information inputted into the form placed into tables on the shared server and tables on a more private server. Is this possible? Any help is...

Thanks for your replies. Below is the SQL for the Main Form: Private Sub cboIssue_AfterUpdate() 'Update SubIssue after Issue combo box change. Me.cboSubIssue = Null Me.cboSubIssue.Requery Me.cboSubIssue = Me.cboSubIssue.ItemData(0) 'Allow form to be opened in data entry...

I have a form: frmMain and a subform fsubDevExac. There are three unbound combo boxes cboIssue, cboSubIssue and cboSubCategory on the main form that serve as lookup boxes on frmMain. Their information comes from tblIssues, tblSubIssues, and tblSubCategories. There is code behind each of these...

Can anyone offer any suggestions as to how I would link two databases on two servers. Scenario: I have a legal database that captures issues for different member associations. There is another database that captures issues for the same associations, though there DB will be installed on a...

...As String strMyData = Me![Combo42] strMyFilter = "[LITID] = '" & strMyData & "'" Me.DataEntry = False Me.Filter = strMyFilter ***** Me.FilterOn = True ***** (highlighted) End Sub When I select from the combo box, I get the error "Run-Time Error '2001': You cancelled the...