Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RachelK
  • Order by date
  1. RachelK

    Blank Address Fields in Reports

    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...
  2. RachelK

    Blank Address Fields in Reports

    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.
  3. RachelK

    Validation before saving a record

    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.
  4. RachelK

    If a form is open close on open of another form

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

    If a form is open close on open of another form

    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
  6. RachelK

    Validation before saving a record

    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"...
  7. RachelK

    Validation before saving a record

    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
  8. RachelK

    If a form is open close on open of another form

    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...
  9. RachelK

    Validation before saving a record

    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...
  10. RachelK

    Blank Address Fields in Reports

    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...
  11. RachelK

    Combo Box Display two Values

    RoyVidar, Thanks it worked. Cheers again Rachel.
  12. RachelK

    Combo Box Display two Values

    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...
  13. RachelK

    Combo Box Display two Values

    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...
  14. RachelK

    Combo Box Display two Values

    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
  15. RachelK

    A unbound field to Populate fields in a form

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

    A unbound field to Populate fields in a form

    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...
  17. RachelK

    vbProperCase

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

    vbProperCase

    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...
  19. RachelK

    vbProperCase

    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...
  20. RachelK

    DCount No Data on Report

    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...

Part and Inventory Search

Back
Top