Search results

Hi, Insert a PageBreak from the Toolbox menu. Put the control just after the last tab control and the the last control’s LostFocus Event key in this Me.GoToPage 2

Hi, This is what we called one to many relationships. For example, you have the Donations Table and Donors Table. Donors contained the Idnumber, donorName, adresss etc. Donations contained the idnumber, donateAmount, DonateDate. Donors table have only one unique idnumber where as Donations...

Hi, Else try http://www.lebans.com/toc.htm Look for ConditionalFormating or here

Hi Josh, Try Allen Browne's version. http://allenbrowne.com/ser-62.html

Hi, Please refer to Moniker post. =DLookUp("[StartDate]","[tblJobHistory]","[EmployeeID] =" & Me.[EmployeeID] & " AND Min([StartDate])") Try the "Me.EmployeeID" without the square brackets. Access is saying that the control is missing or misnamed.(if you named the control as "EmployeeID")...

Hi Gary, Not the Record Source of the subform, it’s the Source Object. To Change it Me.Child0.SourceObject = “Query.YourQueryNameHere” Child0 is the default name of the datasheet subform. It does not have any bound fields so it doe not have any problems when you change the query or even...

Hi, Try Lebans at http://www.lebans.com/toc.htm Look for ConditionalFormating

Hi Gary, (Lights just came on) Actually, you can create an unbound form with a subform. Adjust the width of the subform to fit the width and height of your form. I believe the query is name and since it is name it will be easier. 1. Create a new form 2. Click the subform/subreport icon 3...

Hi Gary, I see, what actually is a query, not a form’s datasheet view. You got me confused on that. I don’t know how you design your database. So I can only suggest you try the Security options. Go to Tools – Security – User and Group Permissions List Groups – uncheck the permissions of your...

Hi, The checkbox is always hidden from the user. Set the checkbox property to Visible = False. Have the Form’s AfterInsert Event (not the checkbox or other controls event) to change the Checkbox value to True like, Me.CheckBoxName = True The Current Event will take care of the Edit Property...

Hi Gary, Not sure what you're asking. Here’s a sample for changing the form’s properties. Put it into a module or new module. Not into the form’s module. Function ChangeAllowEdits(strFormName As String, booAllowEdits as Boolean) Dim frm As Form, prop As Property On Error Resume Next For...

Hi accessman2, Try Lebans, look for ListBoxEnhance. http://www.lebans.com/toc.htm

Hi Abbos, Here is a sample from somewhere. I have lost the original web site where it come from. Option Compare Database Option Explicit Private Sub ClearIt_Click() On Error GoTo Err_ClearIt Me.Search = "" Me.Search2 = "" Me.QuickSearch.Requery Me.QuickSearch.SetFocus...

Hi, Where is the command button “cmdCloseSave” located? If it’s on the Main Form, than Me!frmHoursTimeInvoice.Form!InvoiceHours Me!frmHoursTimeInvoice.Form!HoursBilled When referencing forms/controls go here http://www.mvps.org/access/forms/frm0031.htm

Put this into your afterupdate event of the combo box Me.TextBox1 = Me.ComBoBoxName.Column(0) ‘ your first column Me.TextBox2 = Me.ComBoBoxName.Column(1) ‘your second column Me.TextBox3 = Me.ComBoBoxName.Coulmn(2) ‘your third column Your not inlist event, go to...

Hi systemx, It’s the MouseDown and MouseUp Event of your control named “lstResults”. Having both events running together is not feasible/advisible. When you click the control “lstResults” on a row, the MouseDown event fires up, the “Docmd” opens your form “frmEnqDetails", once the mouse...

Hi systemx, Your code here doesn't make any sense. You mean the user has to click and hold the mouse button down, then do something with another hand than release the mouse button to close the form when done? The user must some kind of freak with three or more hands? Private Sub...

Hi antonyx, You need to run and test the code. I wouldn’t say the code would work. But I will ask you; does it work according to what you have designed it to do? Don’t ask me because I can’t see your database and how you develop it and you didn’t even test it. Did you read post #16? Did you...

Hi giedrius, Looking at this, >However when I put code into On_Keypress event for control B, it fires >when the user hits Enter in field A. Did you put the code at the Form's KeyPress Event? Sounds more like the Form's event to me.

The code I post will not work. But look at post #9. Look at the If ElseIf, it should work except the missing End If. As there aren’t any error messages, I won’t conclude anything, as the ElseIf was incomplete in the beginning. Usually, a beginner doesn’t understand what Compiling code means...