Search results

g'day, this is one of my old projects which, all of a sudden (dont'ya hate the 'all of a sudden' event?), gives me problems. I have subforms frmDocs and frmFiles in tab control pages which are linked to the main form, frmProject, by field ProjectId. Records in frmFiles are displayed properly...

g'day, I have a form with a text field (txtDirName) from which users can select a directory. The directory can be selected at random but must partially contain the value of either "Imports" or "Clearances" (eg. V:\ManufacturingData\Imports). I want to make 1 of 2 buttons visible based on the...

g' day, I want to find a record in form B based on a value selected from a combo box in form A. I have cboSearchInd in frmCompany (which consist of a number of tab controls) based on qryContactNames which include fields ContactFirstName, ContactLastName, CompanyID and ContactID. The cbo...

G'day all, I have a form consisting of 3 tab forms (frmCompany which is the main form, frmContact, and frmSubmissions) based on tblCompany, tblContact and tblSubmissions. Major fields are indexed as follows: tblCompany tblContacts tblSubmissions CompanyID (no dupes)...

g'day, I put a button on a form to add records but, before doing so, I want to check if a record with the same id numbers is already in the table. To do so I use the following code: If (DLookup("[CompanyID]", "tblBranchAddress", "CompanyID = " & Me![CompanyID] And _...

G'day, I have an unbound form that I want to use for adding records to one of a number of different tables according to the user needs. I do this by hiding/displaying different fields for different data (eg. Type of activity, Contact name). The Save button would have code that saves the data to...

Hi, I have a form with 14 checkboxes on it. Currently I have a lot of If...Then...Else code behind each AfterUpdate event of the check boxes to perform appropriate action. I would like to centralise this code in the form module and use Select cases to do the same. So far I have this code which...

Hi all, maybe I am going about this the wrong way, if so I would appreciate some advice. I have a popup form (frmSearchPubs) with a field (txtTitle) in which I enter a string to be used as the criteria for a record set to be displayed in another form. After the users enters the string they had...

Hi all, I have used queries by form before but this is a variation that I have never used before and I can't find a solution quickly. I have a form (frmFilterPublications) which I use to enter a value (txtTitle) and filter data contained in another form (frmPublications). Normally I would...