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.
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...
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
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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.