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...
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...
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
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...
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...
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...
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...
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
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.
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()...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.