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

Greetings: I have scoured the internet and gotten several useful tips from the experts here, though, I still have the same problem. I have a form with a combo box with a rowsource connected to tblState which is a simple state lookup table. The rowsource is as follows: SELECT...

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

Greetings: I have a form that I would like to filter based on a selection in one combo box. I used the "Filter the Form Based on My Selection" wizard. I have the following code in the combo box: Private Sub Combo4_AfterUpdate() ' Find the record that matches the control. Dim rs As...

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

Can anyone help? I have the following situation: I am trying to open a form blank so I set the for to data entry allowed and typed in the following code for my lookup combo box: Dim strMyData As String Dim strMyFilter As String strMyData = Me![Combo42] strMyFilter = "[LITID] =...