Search results

Can someone please help? I have a date filed in my db named dateclosed and another filed named outcome (that includes two different scenarios), how can I create a query and a report so that the user can select either outcome at any given time for say the month of October? Would I have to get...

Hey nIGHT mAYOR, I changed the code a bit and am close, can you tell me why I am getting the error type mismatch on the set of the recordset? Oh, I am looking for the applicant id to populate as soon as the user opens the form (adding Applicant form). Private Sub Form_BeforeInsert(Cancel As...

Hey nIGHTmAYOR, Thanks for the help. I think the code that you gave me is very close but still not working. I am assuming that with this code I will not have to use the AssignTemp button to assign the negative ApplicantId. Am I correct in assuming that with your code as soon as I click on a...

Thanks Ken, I will play with it a bit more.

Wondering if someone can help me out again. I have a field ApplicantId in a table Applicant which is a primary key and is displayed on a form frmCandidate. The problem is that the user would like to add a new applicant without having an applicant id for them, all of the other demographics are...

Hey, Can someone help me out. My database is set and working great. I want the user to be able to go in and select an existing candidate from a list of over 100 candidates. All candidates have a unique id named candId. If I were to add a combo box say at the top of my form that would...

Thanks Ken I will have a look.

I have 4 combo boxes, the first two are filled according to all of the records that are in the Brand and Year tables, the two that I need help with are the Set and Subset combo boxes, How do I code the click event of the set combo box to display just the sets in the set table that are from a...

Thanks DCrake, I added a blank entry to the tabe with ID of 0, works good

I have a eight combo boxes that are bound to a look up table. How can I give the user the ability to make a blank selection or change their selection from a valid selection to blank in case their selection was made in error. eg cboStaffing has one of 10 different shifts to choose from in...

Hi David, Sorry for the mistaken post above. My task is getting closer to being solved, but I still have two issues. I have a table that displays 10 different selections for nurses shifts to choose from when any of my combo boxes are clicked, my table looks as follows: Nurse_Id Description 1...

Hi David, My task is getting closer to being solved, but I still have two issues. I have a table that displays 10 different selections for nurses shifts to choose from when any of my combo boxes are clicked, my table looks as follows: Nurse_Id

Hi David, I have scaled it down to 4 combo boxes, when I get it working for them I can upscale to the 10 como boxes that are needed. Yes, the user will have to select on the combo boxes in sequence, eg: cboStaffing, cboStaffing1, cboStaffing3 then cboStaffing4. In the select case I don't...

Hey DCrake, I now actually have 10 different fields that the user can choose from and from your suggestion here is what I tried: Public Function TestDups(cbo As Integer, Contents As String) As Boolean Dim ChkStr As String 'This adds all the entries in each of the combo boxes into one long...

Thanks for such a quick response DCrake, I'll give it a try.

Hi there, Was wondering if someone could provide me with code or even sample code on how to validate for a user making multiple combo box selections. I have added 6 additional fields to my Staff table named Staffing1, Staffing2 ...thru Staffing6 which can store one of 4 different shifts of...