Search results

Ok I think we are talking about (Indexed Yes (No Duplicates)) That being the case it wont work in this particular circumstance as the table holds names that populate three seperate listboxes on a form, an individual could potentially be in each list on a form and can be in more than one record...

Dont know how to, thats the problem!

I have a Listbox on a fprm which has a button attached to it, the button allows you select one of the items in the listbox and append it to a table. the problem is that it currently allows you to add the item as many times as you like. How can I check for duplicates? Private Sub...

Superb, many thanksI vcan apply it to the other places I have to use it now!

SELECT tblShootingTasks.IDTaskings, tblShootingTasks.ContactName, tblShootingTasks.ShootID, tblShootingTasks.Task FROM tblShootingTasks WHERE (((tblShootingTasks.ShootID)=[Forms]![frmEntries]![ShootDateID]) AND ((tblShootingTasks.Task)="1")) ORDER BY tblShootingTasks.ContactName;

Delete it from the table and then to requery the listbox, think I can do the requesry bit but not the delete from table (so much to learn!)

Could someone show me how to do a 'Delete from ListBox' please. my listbox is populated, but I want to be able to put a button on the form, select a record from the listbox and press the button to delete that record from the list. I should add that this is an unbound listbox so it needs to be...

I have a form (frmAddBeaterToShootDay) with a subform (frmChooseBeaters). I want the subform to show all the records of all the beaters in the contact list, which it does. I then want to be able to tick the box (AddToShootAsBeater) and associate that person with that record on the form...

Hi, I wonder if someone can help please. My DB is built and I now want to split it on my machine into two locations on my Desktop (TIR_FE and TIR_BE) I have put the whole thing into TIR_FE ready for spliting. I have decided that only some of the tables need to be split as not all hold common...

I've been working at trying to solve this but I'm getting nowhere fast, could someone please take a look? Many thanks

Not really what Im after I dont think as I want to do it from one form. Have a good trip:) I can wait till you have more time as there are other things to work on. Many thanks

Figured this one out after a search! Private Sub Sort_Click() If Me.List11.RowSource = "SELECT tblShootDates.ShootDateID,tblShootDates.ShootDate FROM tblShootDates ORDER BY tblShootDates.ShootDateID ASC;" Then Me.List11.RowSource = "SELECT...

Thanks for the reeply, but I dont really follow! I guess I need to make three sub tables for Shooters, Beathers and PickerUps. Thats about all I understand, sorry!

I have a Listbox that I use to find records in the Database. It has two fields, [ShootID] and [ShootDate]. It is curently sorted in the query by [ShootID] but I want the user to be able to change it to sort by [ShootDate] and then back again. Can someone give me a steer please?

I am building a database for running a shoot. I want to be able to add Firers, Beaters and Picker Ups to each day. All of those people are held in a [Contacts] form and have a checkbox to designate them as Shooters, Beaters or Picker Ups or a combination of them I have a form where I can...

I want to create a calander to show some bookings and have very little idea where to start! I have a table [tblShootDates] with some fields, the most important being [ShootDate]. I also have a [ShootDateID] which is an Autonumber and is the Primary Key. I should add that it has a Prefix...

I have a form (frm_Entries) with a textbox (BagCount) on it. I also have a subform (frm_Bag) which is a continuous form, there is a textbox on the subform called (Qty). If I have, for example 3 records in the subform with the (Qty) showing 3, 4 and 3. I want the textbox (BagCount) to show the...

This is the complete code without your adjustments. Im unsure where I should put the modifications! 'Checks for open records Dim WhereClause As String WhereClause = "isNull([CLS_Attended_At]) AND isNull ([AnalystAttended]) OR isNull ([Fault]) or isNull([Soloution]) AND...

I already have the export working thats fine. The form shows a bunch of filered records. One of the ields is a start time the other is an end time there is also a calculated lapsed time field. The lapsed time is calculated when the user clicks the checkbox which also removes the record from...

The form is made up of a bunch of filtered records, they are filtered by a checkbox. As soon as you click the checkbox to true it will dissapear from the form. There is a button on the form that allows the user to export all the records to a spredsheet. in order to do this all the records...