Recent content by vig

Got it going. Thanks to Elizabeth and Jim.

The routine below is in the database.&nbsp;&nbsp;I changed the dates to reflect test data.&nbsp;&nbsp;I searched for &quot;Is Loaded&quot; and found nothing. <br><br>Private Sub Form_Load()<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;'&nbsp;&nbsp;Used by Developer Solutions to return...

How do I know if the &quot;Is Loaded&quot; function is in my database?? Thanks.

I need help with the above.&nbsp;&nbsp;Since I am not a programmer, I used this process. 1. Created crosstab.(Project#=Row Head) (Work Date=Column Head) Hours=Value. 2. Named it EmployeeSales. 3. Copied the Developers Solutions &quot;Employee SalesDialogBod&quot; Form and EmployeeSalesReport...

Thanks for your help. I have a few follow up questions...this process is new to me.<br><br>1. Form in Access finds a record with all the fields including the month and date needed for the mail merge.<br><br>2. Query looks at form not prompts: How is this set up. Filter by selection in form...

I set up a parameter query that prompts for month and year. I need these fields and additional query info in a word mail merge. Even after saving, the run will not export into a txt file...I get &quot;too few parameters, expected 2&quot; as an error in the export text wizard. Using this other...

I originally created the field as a numeric so I could make the format 0000.&nbsp;&nbsp;Of course this didn't work in export.&nbsp;&nbsp;and the new field in the query didn't translate to the .txt file though it looked throughout as it would. I was afraid to change it to a text field since it...

What is the criteria needed to get a return receipt for mail?...People on the same browser or on the same ISP or some other factor? Thanks

Let me try to clarify--The values came out just as shown above by you but when I exported it to an external fixed width text file, even though the zeros showed throughout the wizard, in the text file that was created the zeros were gone and the numbers reverted to <br>123<br>2<br>23<br>and not...

Elizabeth--<br>(The good news is) I almost got it to work.&nbsp;&nbsp;The leading zeros showed up throughout the external fixed width text file export...but (the bad news is) the zeros did not follow nor was it left justified in the actual .txt file. Any ideas?&nbsp;&nbsp;Thanks for your help.

Elizabeth--Where do I place the expression?--in the Update Query as you mentioned before.<br>Thanks.

I am exporting a query in a external fixed width text file.&nbsp;&nbsp;One of the fields is a 4 digit numeric. How do I get leading zeros included so the number is right aligned. How do I setup the property for this numeric in the table.<br>Not...

This is a form opened by a command button in the main form. It is not a subform. thanks.

I need to keep a running count on a form of the number of times a L code appears in the 31 fields of the form, the number of times a C code appears in the 31 fields and etc.(There are other codes.) A field can be empty. Only one code will appear in any cell. I have added a calculation box for...