Search results

  1. D

    help with crosstab report

    I have created a crosstab query and have created a report to out put the results. Everything works fine but in need to have a summary of the male and female per each course. I have attached doc for review if someone can help. Thanks
  2. D

    Need some help with fields

    I have a report which I need to and two fields in an unbound field. I have written an event to convert a field called rank to full name. example: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txtRank = "PO1" Then Me.txtShowRank = "PETTY OFFICER 1ST CLASS"...
  3. D

    access main tool bar help

    I have a database which I can not get to the normal tool bar to change the permissions on. The startup was set to not display this. I need to modify the security on a form. Help please. Thanks
  4. D

    Looking for Database or something

    I have be requested to find or create something that will track and reports meals served at the camp. They require breakfast,lunch,dinner and midnight meals recorded for each section and for the day. I have look for an access db or and excel spreadsheet samples but not able to find anything...
  5. D

    Now to change graphics automatic I a Report

    I have a report which prints out certificates for trade groups. I have two graphic images in this design and I would like them to change when selecting a different trade group. Example would be. I what to print the certificates for Sail Trade and put the sailing image in the certificate. Now I...
  6. D

    Switchboard Form

    I have the switchboard form in a database but need more items in the switchboard then is allowed. Does anyone know how to change the number of allowed items on a switchboard. Thanks
  7. D

    Upper and Lower case changing

    I have a field in the table that contains numbers and a mix of upper and lower case words. I would like to have this to it check for numbers and then makes the first letter in a word upper case and the remainder lower case. I know you can do it like this >L<????????? but that dow not work if...
  8. D

    Upper and Lower case mixed in table

    Is there away to change what is in the table field [surname] to the first letter being upper case and the remaining letters lower case. Thanks Sorry I found it. Just in a little rush.. Should have looked harder.
  9. D

    Display only one letter

    I am trying to get the firstname to only display the first letter in a report. I have put this format in the control source =Left([firstname],1) When I run the report I get error in the firstname field. Any suggestion. Thanks
  10. D

    Report output

    I have a table with a field for gender and iit is populated with "m" for male and "f" for female. I have created a report and would like it to display the word male or female for the m or f. Is there a way I can do this in stead of doing a find and replace on over 10.000 records. Thank You
  11. D

    Module Creation

    I have created a form that takes data from a table/query and displays the information in the form. I have some check boxes on the form for gender. The only thing is the table has this information in one column called sex. I would like to create a module that will look at the information in...
Top Bottom