Search results

What you need to do is create one generic form, and on the OnLoad event use a logical argument to check the OpenArgs and from there determine which controls are visible, editable etc. Each button will send a different OpenArgs to the form. For example your add new record button might have...

I have combined the list box sort function discussed here with the Search tool discussed here. No problems thus far :) I'm using the following piece of code that activates on the OnChange Event of the text box that is feeding the search query. The code ensures that the first row in the list...

Sorry guys try this; Dim stDocName As String Dim stLinkCriteria As String stDocName = "Personal Details" 'Name of your form that is to be opened stLinkCriteria = "[Uniqueid]=" & Me![Uniqueid] 'The common key that links the current record and the record that is to be opened...

Put the following code behind your Double Click Event Dim stDocName As String Dim stLinkCriteria As String stDocName = "FRM_Name" 'Name of your for that is to be opend stLinkCriteria = "[PersonalDtlID]=" & Me![PersonalDtlID] 'The common key that links the current record and...

Is the search form in this thread the sort of thing you are looking for?

Thanks Mark Just what I was looking for :)

Have you considered a multi-select ListBox?

Stevo From looking at your DB, it seems to be a catalogue of various media resources. There seems to be many common elements to each table. Why not store all your records in one table and then have a field to differentiate each type of media? This will then greatly simplify the search process.

This thread has a solution to your problem

Combo# Represents the name of your Combo Box. Replace the whole of the highlighted phrase with your ComboBox name. I simply used # to represent any number.

My method will do exactly as you wish. The comboBox must be unbound and it must return a numeric value that corresponds to a recordID or similar on the record you wish to jump to.

You certainly can, put a command button on your form with the following code behind it. DoCmd.GoToRecord , , acGoTo, Combo# Insert your combo box name at Combo#

Use an append query activated by a command button to add your new record. Use [forms]![frmName]![ItemID] in the criteria of your query (under the ItemID or what ever you choose as the unique recordID) and choose the data you wish to copy into the new record.

Mark I have just discovered this thread and am just a little unsure of the coding to report the X and Y value in the message box, you describe above. I'm presuming that with this missing piece of code in place you would click at the left and right margins of each column header and the message...

You need to force the query populating the sub form to requery when ever the selected dimensions are changed.

Perhaps the search tool in this thread is what you are looking for?

The way I would approach the lending history; Is firstly I have a form that shows all the files that are available for lending (ie. they have an "IN" status) this you would populate with a select query. The form would have provision to select the file/s that are to be put on loan. This...

This thread might give you some pointers. Check out John's changes to the DB.

In the query Criteria (for RecordID) put [forms]![frm_name]![RecordID] that will select only the data relevant to the RecordID for the record currently displayed in the form.

Hi Dups The major problem with your form was that almost all of your controls where unbound. You also seemed to be storing the consignee name in the relationship table rather than the ConsigneeID. Please check how I have set up my comboboxes. I've made some changes to your form and linked it...