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

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

    I see what you mean now. If everyone has a copy of the front end, I can just update my copy and replace everyones.
  2. jimjaix

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

    I named mine Intake_BE and Intake (I changed the extension from .mdb to .mde on my front end, does this do anything? I read a forum and it says do that) Both Front end and Back end are saved on the shared drive. I will create a shortcu to the front end for user's desktop. Let's say someone is...
  3. jimjaix

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

    I did, I actually split the file, is it the best way to go with the issue I am having?
  4. 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...
  5. jimjaix

    Access Report Section

    Nvm, need to do it under unbound text, got it now. Thanks
  6. 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
  7. jimjaix

    Search Function (Problem with Date)

    Sweet, I did what you told me and created the code on my own. I am so new to coding : (
  8. jimjaix

    MouseHook on Subforms

    Um... it's weird cause the mousehook does work on my main form, but not the tabs subform. I put the code in the Load event, I guess I will double check. pretty sure I got all the stuff down...
  9. 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...
  10. jimjaix

    MouseHook on Subforms

    I have the dll in the same folder, Got this on the mainform Private Sub Form_Load()Dim blRet As BooleanblRet = MouseWheelOFF(True, False) and updated the mod to read Public Function MouseWheelOFF(Optional NoSubFormScroll As Boolean = False, _Optional GlobalHook As Boolean = False) As...
  11. jimjaix

    MouseHook on Subforms

    Do you have subforms?
  12. 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...
  13. jimjaix

    MainFrom Calling SubForm (validate true/false)

    Ooppss.. I got it, I used the Form_Load() function on my sub form and it works. Thanks
  14. 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
  15. jimjaix

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

    Thank you all for the replies, indeed my name convention is bad. I will update my name convention.
  16. jimjaix

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

    Omg it works, thank you so much I tried to play around with the code so many time and couldn't get it to work... [tblHx_Current subform].Form!past_medications.Visible = False This is what I used.
  17. 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