Search results

Hi antonyx, First, the combobox is not inside the listbox. It’s on top of the listbox. Judging from the query, the listbox on the left is using this query. The listbox on the right using the table called “Driver”. What you are asking is called a listbox search or listbox to listbox. The use...

Hi jempie, Yes you can. If you have a existing table that has a Column with a “AutoNumber” First, do your “Make Table Query” as usual. Name that new table, right click the empty space above the QBE fields. Select the Table with an Autonumber. What you need to do is use that Table, put into...

Hi, Have you check the subform properties tab - Data - Link Child Fields and Link Master Fields?

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