Search results

Hello everyone! :D Is it possible to have a query based list box default to the first selection? I need the first item to be selected so that an unbound field would be populated once the form is opened. Any help would be greatly appreciated. Thanks, JONP

There is probably a simple solution to this however I have yet to stumble upon the answer. I need to be able to take records from a subform (2 columns) and place them into an unbound text field so that I can reference this field in an email through VB. The email part is in the bag but the...

Hello All! I am trying to insert all records from a subfrom ( 2 columns) on the master form into an email message using VB. Is this possible? JONP

Hi there! I have a query based report that merges LAST NAME & FIRST NAME. The field on my report MUST contain 22 spaces which includes all characters and spaces. If the name only has 10 characters then I need 12 spaces at the end of the name. Is there a way to accomplish this?

Hi all! I have a report that users will print onto a pre-printed perforated form. When torn, users will have 4 equal size sheets of paper with the same information printed on each except for a special sequence number. Users will have a form where they will enter a beginning number and the...

I have a program that is used by many people on the network. I recently just created a new report that MUST be printed on legal paper. Whenever I call the report on my PC it is formatted correctly. However, when the report is called on a different PC, it reverts back to letter. How do you...

I have a problem that I hope someone can help me with. I have a form that has a command button that opens a dialog box to give the user printer and email options. I originally did not want to have a dialog box but when I ran out of room on the form (22") I had no choice. The dialog box...

Hi there! I have a form linked to a table that uniquely identifies each record with an autonumber field. The form contains many pagebreaks that the user tabs through. On the last page there is a button that opens a dialog box to give the user printer and email options for the worksheet they...

Hello! I have 2 combo boxes on a form. The user will select an option from the first combo. Combo 1 will requery the second combo box. This event works brilliantly but when the user selects an option from the second combo box Access produces run-time error number 3075, "missing operator"...

I know that there is a simple fix for this question but I have not been able to find it YET! I have an unbound yes/no box that has an IIf statment in its control. However, I have a bound yes/no box that I want to populate to duplicate that of the unbound yes/no box. Can someone point me...

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

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

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

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

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

Hi there! I have a table that consists of 3 fields. An account nbr field, a serial nbr field, and a date field. I have a query that will tell me which serial numbers are duplicated. However, I would like the query to only look for duplicate serial numbers for each account number. Is there...