Search results for query: *

Hi, I have decided to keep this simple. I have one unbound text box on the report called. Add I would like to say that if all has data then Add = StreetNo with vbCRLF (on each line) Add1 Add2 Add3 Add4 Country Postcode Else if Add1 = "" Then StreetNo Add2 Add3 Add4 Country Postcode etc. I...

Randy, I know it has been a while since I visited this problem. I am hoping to resolve it today. Where would I put this event on the report in the form open or load etc. Cheers Rachel.

RodVidar, Thanks works perfectly just one more question. I have to do this code for both Surname and DOB field would I combine the code or would I do two select statements. Cheers Rachel.

Mute, It was a global function I there in end. Anyway it worked fantastically. Cheers for your help. Rachel

Sounds like there was a race going on. Anyway I am just starting out so excuse me if I ask stupid questions. The function is that a gobal function that I can call at anytime? Cheers Rachel

RoyVidar, Thanks for your help I have this code so far:- On Error GoTo ErrorHandler If Trim(Me.Surname & "") = "" Then MsgBox "You have not entered a surname are you sure you want to go ahead and save this record", vbYesNoCancel + vbExclamation, "Missing Surname"...

Crowley, Thanks for your help. Could I just not use a on exit of the form for that record check to see if the two fields are used and display a message to warn them. Thanks again Rachel

Hi, I have had a dig around on the net and I can't seem to find what I am looking for. I have a form called "CourseProviders" that is open most of the time however I have another form called "frmStudent", upon open of the "frmStudent" form I would like to check the form "frmCourseProviders" is...

Hi, I would like to check that the surname and the DOB field has been populated before saving the record. I am not to sure where to put the code. I did try the form Before update event this did not work. All I would like is a message to advise the user they have not put data in these pretty...

Hi, I have an sql query :- This query basically selects, the add1, add2, add3,add4 fields which holds a persons address sometimes they may not have data in one of the fields. I would like the data to display the address like:- Add1 Add2 Add3 Add4 Country Postcode but if the fields are null I...

RoyVidar, Thanks it worked. Cheers again Rachel.

Hi, I have just created a combo box using the wizard. Both values show when you click the box to drop down number and Name ie 000 Name1 001 Name2 003 Name3 Once one is selected the value on the form in the combo box is just the number and this is the case with the combo wizard aswell. Cheers...

Crowley16 , Hi again. My Column count is set to 3 and I have the sql in the row source: SELECT tblCourseProvider.CPID, Format([CPNO],"000") AS CPNO1, tblCourseProvider.NameLong FROM tblCourseProvider; The 1st column width is set to 0cm; then the other two are visible to the user however...

Hi, I have a combo box that displays numbers and a name which you click on the drop down, however when you select one the box only displays the number can I have the combo box display the number and name of the one selected. Cheers Rachel

Crowley16, Thank you. You was right my Dlookup was the wrong way round. Thanks again Rachel.

Hi, I have a form that has a persons work address on it. I have a table that has address of companies that could possibly be there work address and the two are not related. I would like the user to select the combo box which is txtCentreNo that has the 1st colum bound to CPID if this textbox...

Bob, Thanks it worked fantasically. You are a star! Cheers Rachel.

Bob, Thanks for your help it was just what I was looking for. So I put this in a public funtion and where do I set IChangeType to 0 also then I go to my individual fields as before and set to :- Private Sub NameLong_AfterUpdate() On Error GoTo ErrorHandler Me.NameLong = StrConv(Me.NameLong...

Hi, I have set my fields to vbpropercase. I have this AfterUpdate procedure:- Private Sub NameLong_AfterUpdate() On Error GoTo ErrorHandler Me.NameLong = StrConv(Me.NameLong, vbProperCase) Exit Sub ErrorHandler: HandleError Exit Sub End Sub The problem is sometimes the user...

Hi, I am trying to do a count of records in a report if there are no records I do not want to run the report. StudentPin = 0050000 Me.ELFromPIN = D0050000 Me.ELToPin = D0050000 The student pin does not have a prefix of D however on the form they do to the users hence Me.ELFromPIN = D0050000...