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

Hi Jack, That is part of what I need to do but my problem is with the remaining 3 or 4 records within the subform. I can reference the subform in an unbound control but it will only display the first record within the subform. How can the remaining records be captured? Many thanks, JONP...

Thanks Jack for your quick response. I appreciate that. But if my subform contains more then one record, how do I concatenate these separate records into one unbound field? 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

Thanks fmm! It worked brilliantly!! Have a good one, JONP

Hello fmm! I wasn't sure what the TEXT reference is for in the formula you provided yesterday. I could not figure out what to use in place of this. JON

Okay I placed the function in the query - but what do I use in place of TEXT? Thanks JONP

Thanks FMM for your reply - I appreciate that. However, I can't seem to get it to work. I am inserting this function into an unbound text box and I keep getting an error message dealing with the operator. Any suggestions?

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?

Is there a way to repeat a record on a report based on an entered value? JON

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

Thanks Sara...I appreciate your help! Have a great weekend. JONP

I think I have identified the problem. I forgot that when the dialog box is requested, the form is SAVED, then it will open the dialog box. Then when others use the form it thinks that the form has changed and asks them if they want to resave. Anyway.... I guess my question is this. How...

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 have tried that but no cigar. Here is a little bit more information. There is an unbound field in the footer of the form that keeps a total based off of payment entries on a subform. The unbound field displays total outstanding. When the total equals 0 I want a box to automatically be...

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