Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sahaitu

    Create Custom Access Icon

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

    Adding "ALL" to My Combo Box

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

    Adding "ALL" to My Combo Box

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

    Text Box - Can Grow, Not Working

    Thanks again...
  5. sahaitu

    Text Box - Can Grow, Not Working

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

    Sizing forms to fit screen

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

    Sizing forms to fit screen

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

    Bookmarks and the UNION SELECT

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

    Bookmarks and the UNION SELECT

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

    Bookmarks and the UNION 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...
  11. sahaitu

    One Form, Two Tables, Two Servers

    Thank you sooo very much....
  12. sahaitu

    One Form, Two Tables, Two Servers

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

    One Form, Two Tables, Two Servers

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

    Two Tables, Two Servers, One Form

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

    Storing Information in Two Separate Tables

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

    Storing Information in Two Separate Tables

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

    Still Have SubForm Blues!

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

    Still Have SubForm Blues!

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

    Linking two Databases on different servers

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

    Run-Time Error '2001'

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

Part and Inventory Search

Back
Top