Search results

OK Cheers Jack.

Its Ok Jack I will do battle with it in the morning, eventually I will conquer it though. Thanks for your time. Charlie

Good and bad news The good news is the name IS diplayed, the bad news is the name does not change with the rest of the form displaying different records. Charlie

Still Blank Private Sub txtFirstLast_AfterUpdate() Me.txtFirstLast = Me.Combo24.Column(1) & " " & Me.Combo24.Column(2) End Sub I used this code and it remains blank, I think I am cursed. I am sure I have done this before too. Charlie

OK The text box is unbound, and this is the code I put in the event procedure. Me.UnboundControlOnForm = Me.Combo24.Column(1) & " " & Me.Combo24.Column(2) when I use the form the box shows nothing, no error or names. Charlie

Bound Has this text box got to be bound or unbound? If it is unbound it wont cycle records with the rest of the form will it. at the moment it is bound to Processed by. Charlie

did that The text box shows the staff code in the display. the Initials eg: JJ. In the combo box I have initials, First Name, surname. Charlie

Re: The First Name and Surname are in the tblStaff. I already have a combo box on my form that displays the code and staff names. It goes like this, SELECT tblStaff.[Staff Code], tblStaff.[Staff Forename], tblStaff.[Staff Surname] FROM tblStaff; I dont know if that is relevant though. Charlie

Ive Tried Ive tried to use =[First Name]& " " &[Surname] in the control source of the text box but all I get is #Name? So does anyone know what the problem is. Charlie

Im working with a form and want to include the staff members forename and surname in a textbox next to the checked by box. In the properties i can select either forename or surname but not both. I thought about the expression builder and tried using Staff Forename And Staff Surname but this did...

No Problem No probs jack, just trying to avoid any misunderstandng. Charlie

Questioning I am not questioning you superior knowledge Jack :) I acknowledge you know far more than I do, its just someone told me to use that method. Charlie

Jack, I was told the input mask method changes the behaviour of the edit keys (backspace,delete,etc) I was told it can confuse the user. Charlie

Already Done Thanks anyway boys. Like"[A-Z][A-Z][A-Z]###" Voila.

I am trying to set up a validation rule for a field of data. I am using the following rule: Like"[ABC]###" I want the user to be able to enter 3 letters followed by 3 digits, though whenever I enter data like ABC123 I get the error message. Why is this? Thanks Charlie

brilliant Great, thanks, ive been suffering for hours. Charlie

what If what if I want to search for a number 1. how do I do that, I am not too sure now that the first name field is included in my query for this. I think I only included the ID number. SELECT tblInPatients.ID_Patient, tblTreatment.TreatmentHistoryID, tblNurses.NurseID...

I am trying to build a query that will produce the records for one person from my database. The query I have got produces all persons results, I have tried adding Where [FirstName]="Jack" But this produces a single row of empty cells. can anyone show me what am doing wrong? Charlie

Success Ive taken a look at the way you structured yours in the thread, I must say mine is now much better and works, thank you so much. I must remember to follow the basic structure you have used there in future projects. ;) Charlie

Thanks Im going to try that right now, fingers crossed :) Charlie