Search results

thanks No both male and female are in one field called gender. I did a crosstab query with rowheaders and colume headers and group by various fields and 1 count field. Thanks for your help but I figured it out on the report by doing sums of the fields I needed to add together. I have the...

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

Thanks All I was planning on creating some tables for the ranks and the courses after the summer camp is done. So for now I will do with what I have and then be able to work on a much better version of the database. Thanks again to all for your suggestion and assistance. This is the best...

MY Module to Convert number to Roman Here is my module for converting my numbers to roman. Option Compare Database Public Function dhRoman(ByVal intValue As Integer) As String Dim varDigits As Variant Dim intPos As Integer Dim IntDigit As Integer Dim strTemp As String ' Build up the array of...

Can you Assist How do I do this by creating a table. Do you have a sample I could follow and do I have to put some code in the report. Thanks Again

Need more Info Thanks For everything I have one more situation and would like to know if this can be done also. For each Trade Group there is a level of Trade (1 , 2, 3) I have a module for converting the numberic value to Roman II. When I put this on the report I do this =dhRoman([LEVEL])...

That works Thank you for the quick reply. I had tried that but did not work for me. My code was wrong as what you show works the way I want it. Thanks Again :)

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

Thanks I looked at this but not really what I was looking for. I need something where I can put in number of breakfasts served,lunch served, dinner served and mid night meals. I will see what I can do with this. I will have to do some coding to get what I want it to do. :)

Thanks Its been a while since I used this. Just forgot which key it was.:confused:

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

None that I know of But What are you looking for in Design. I like doing this and maybe can help you out if you have graphics or let me know any details. You can PM me with this info if you want. Dave

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

Solution I found Works I played around with this and I created an event procedure that works. There maybe an easier way of doing this. Like they say if is not broke dont fix it. Here is the code I am using: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If...

OPk Thank Just thought this would be faster. I am playing with this as you suggested but still can not get the image to change. I will see if I can find something to help me in this forum. Thanks for your help. Always appreciate any help.

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

You can find some great php editors that are free on the internet. Here is a link to the one I use. http://www.mpsoftware.dk/phpdesigner.php

Changed the Const conNumButtons = 10 Did in the event on current that but still get the message only 8 items allowed on switchboard. Where do I add the actions in the event. Thanks for the help

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

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