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!

  • Congratulations strongm 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: *

  • Users: jimjaix
  • Content: Threads
  • Order by date
  1. jimjaix

    Create an File to open DB (w/o exclusive access)

    Hi, I would like to create setup file or some simple code to open my db without exclusive access. I Googled this kind of question, and people suggested to split the database into 2, one that points to the database table to update. How do I do something like that? If someone has the db open and...
  2. jimjaix

    Access Report Section

    Hi, I created a report using a query. On the query criteria I am using "Between [Start Date] and [End Date], I want the two dates user input to show up on the header of my report. How do I do that? Thanks
  3. jimjaix

    Search Function (Problem with Date)

    Hi, I created the following function on a button. Private Sub Search_Click() If (IsNull(cboType)) Or (IsNull(txtCriteria)) Then MsgBox "Please select search type", vbOKOnly, "Please select search type" ElseIf [cboType] = "Last Name" And [txtCriteria] > "" Then DoCmd.OpenForm...
  4. jimjaix

    MouseHook on Subforms

    Hi, I trying to apply the mousehook function on my database so it doesn't scroll down between records when I use the wheel. I use the following code and it works on my main form but does not work on subforms. Can someone tell me how to apply this to all my subforms under my mainform? Private...
  5. jimjaix

    MainFrom Calling SubForm (validate true/false)

    Hi, I want the main form to check to see if a subform's checkbox is true or not if it is then I would like it to display a text box. my main form's name is frmMain my sub form's name subCallLog How do I code it on my main form, I believe we have to use Private Sub Form_Load() function? Thanks
  6. jimjaix

    Subform Fields (show/hide) Based On Main Form Rb, Office 2003

    Hi, I have two radio buttons that's driven the form to show / hide certain fields. The main form also has 4 subforms, I want the subforms to hide/show fields based on the radio button on main form, how do I make it work? I am very new to coding. Thanks Private Sub frameSelect_Dept_Click()...

Part and Inventory Search

Back
Top