Search results

Thanks charityg! It worked brilliantly. I really appreciate your suggestion.

Hi all! I have a form that has 5 pages that a user tabs through. On the last page they are able to open a dialog box that has print and email options. All of the forms work great except for one that relies on information on the last page of the form. If the user exits the form and reopens...

Thanks RedSkies. The advice worked brilliantly!

Hellow everyone! I have a small subreport that does not always contain data. How can I make this subreport shrink so that there is not a blank space on the master report. I have tried the CAN SHRINK option on both sides but nothing changes. Any ideas? Additionally, is it possible to...

Robert, I compared the selected references I had on my PC to the one that is causing me problems. They are both identical. I had many Reference options but I am not sure what options they enable. JONP

Hi Mike...yes it is something like that. Is there a way around it? JONP

Hi there! Hopefully someone out there can help me with this small problem. I have a code written that does a string conversion on a control. The conversion works great on my computer, however, on some computers it does not work at all. The program stops and highlights the this line of code...

Thanks KevinM and AlanS. The suggestions worked brilliantly. Have a fabulous week! JONP from Texas

Hello yall! Does anyone know the code to make a text field change to title case no matter what the user enters. I know how to make all caps and all lower case, but not title case. Any suggestions would be greatly appreciated. Thanks from Texas, JONP

Hi there! I too am working on a database with a similar feature that the CodeSmith has described. I can create two unbound combo boxes that will requery brilliantly but I am not having much success at make the second combo box bound to a field in a table. The field is available in the form...

Thanks Fornatian for the Nz function help. The function seems to work great but I found a problem concerning the query that generates totals for the master report. Like I mentioned earlier on this topic, there are 3 subreports with their own queries. The subreports have a footer that sums a...

Hi there! Hopefully someone can help me with this issue I have been kicking around the past few days. I have a report that contains 3 subreports. Each subreport has a hidden footer that sums a control. In the footer of the master report there is a control that is calculating simple...

I have a report that has several group headers. The maximum number of times a header will be repeated is twice. I was wondering if there was any way of creating a custom title for the header when it is displaed the second time? Any help would be greatly appreciated! jonp

Chris I am trying to establish an application that multiple customers use. Each customer is created separately. To uniquely identify each customer we use their SSN. So when all the customers are entered into the system with their personal info, then the user will begin creating the...

Okay...I think this is part of the answer to the question I posted yesterday. My table relationships are not set up correctly. Here is the deal...I have two tables. A CUSTOMER table, and an APPLICATION table. Lets say I have two customers that are applying through this application. The user...

I have two tables. A CUSTOMER table, and an APPLICATION table. I am trying to create an application that can be completed online. First a user will create a customer, then proceed to a different form to enter the application data. Each customer stands alone in the customer table. But the...

I would like to have a copy as well...in 97 format, please?

The only relationship I can build off of is the date. But the dates are WHERE criteria in the query. Any suggestions?

I have two queries that generate data from one table. One query sums a field based on a date range entered in the DATE OF RECEIPT field. The second query sums another field based again on a date range entered in a field called CHARGE OFF DATE. Here's the deal...I need a report with a...

Thanks PDX-Man for your response. However, I tried to use the GROUP BY function within ACCESS (not VBA) in a query. I need to view all 3 fields in the query results so I really dont want to group on each field. What do I set the other fields to so that query will look for duplicate serial...