Search results

I have 17 unbound fields on a form which stores 1 character in which the user will enter a number or a letter. I have 17 more unbound fields that I need to translate the number or letter that the user inputs into a certain predetermined number. For example, "A" = 1, "B"=2 and so forth. Any...

Fornatian, Thanks for your help as always. BAC

I have a check box (yes/no) on a form that I have included in a query. I would like to count the check box and display how many times the check box is checked and display this info on a report. Any help is greatly appreciated. Thanks. BAC

Mike and TG Thanks to both of you for your help. Problem solved. Have a great weekend. BAC

Thanks Mike, Where do I place that function? BAC

I have a report based on a query. The report sums values from the query. However, when a certain value is "0" the field on the report is blank. I would like for there to be a "0" in the field instead of a blank. Any help is greatly appreciated. BAC

Thanks Pat, If I already have records in my tables can I still create the many-to-many relationship without affecting the current data? And also I only have the fields (primary kary A and primary key B) in my intersect table. I notice you have a third field. Do I need a third field...

I understand the purpose of many to many relationships and in the DB I have designed I need them. However I am having difficulty understanding how to use them. I have created intersect table that hold the primary key of one "tbl A" and the primary key of "tbl B". How do I get the table to...

If you set the memo field in the table to "Allow Zero Legnth" to YES that will fix your problem. BAC

I have a OLE object containing a picture on a report. I have created a Label box that reads "No Photo" and placed it behind the OLE box and I would like the Label box to show if the OLE object is null. The report that both controls are on is a subreport. Also I have an unbound field that...

Kim, I am glad this worked for you, if you need any other help just advise. Bill

When I include date range criteria the dcount() function just shows #Error in the unbound text field and in the status bar at the bottom it shows Calculating . . . Any reason why the DCount() function is affected by date range criteria? If I do not use a date criteria the unbound column that...

RD Hicks suggestion worked, however when I include date range criteria the dcount() function just shows #Error in the unbound text field and in the status bar at the bottom it shows Calculating . . . Any reason why I cannot have the DCount() function is affected by date range criteria...

Thanks RD Hicks. It worked. BAC

I am trying to count a field on a form if that field contains a certain word. For example, I want to count how many active cases I have. The fiel called [casetype] contains the word "active", "inactive" and so forth. I am using the =count([casetype])="active" but it doesn't work. Any help...

Not an expert either, but the control 'TabCtl97' referes to a Tab setting that you must have on a form. I have several forms that I have placed Tab Controls on them and they will show up in the taborder list. BAC

Matt, In the property setting in the form inwhich you wish to remove the restore and close button there are three options to set. The first is set the "control box" to no, the "Min Max Buttons" to no and the "close button" to no. This will remove all of the options that appear on the upper...

Jack, Thanks again, however I am not getting the right number. I have had a long day with this. Do I need to substitute any control names from your example other than the Me.[unboundtextfield] ? I am trying to count a text field on a query based form that is empty. The form is...

I was just gonna write you and let you know that the code didn't work for me. I am trying to count the blank fields on the form. Thanks again. BAC

Thanks Jack, for the quick response. I'm sure this will work. There's always two ways to skin a cat, huh? By the way the response earlier reference the uppercase function on after update worked. Thanks. BAC