Search results for query: *

Is it possible to export unicode characters to a Tab Delimited format? I have a report built which contains a mix of Japanese data and English data. The data appears correct in the report viewer, however when the data is exported as a tab delimited file, the Japanese data is saved as a series of...

Thanks, I was able to get the data I needed with the running totals!

Trying to compare the overall average and median of a field in my report to the average for one of the groups. Field is # of months, and the data has been grouped by a group called Aging into two values fresh and aged. I want to calculate the average and median number of months for just the...

Use a formula to test if the value out of the database is less than 0, and if so return that value, otherwise multiply by -1 if yourvalue < 0 then yourvalue else yourvalue * -1

One other thing I forgot to mention is to minimize/eliminate any white space in sections where you have data. Generally, looking at your output will tell you where the extra space is coming from, if each row has it--check your details section. I also minimize or suppress where possible all...

The best methods I have found involve ensuring all cells in each section/row line up perfectly with zero space between them both horizontally and vertically. I do this using snap to grid, and the align/size tools. Some of the cells end up longer, but you don't want to have a header cell for...

I am trying to import a specific worksheet from an excel document into Access. The excel document contains two tabs, UploadTest, and UsageExport. I am trying to figure out how to import only the data in the UsageExport tab, which is the second tab in the document. The problem is that the code...

you could build an expression using the Right Function. In your case it would be something like: right(yourfieldname,5) place this in the field name in your query. hope this helps

Finally stopped getting error messages, but still do not get anything in the desired textbox. Not sure what OhioSteve means about knowing about EstDateSend. The form is intended to be used to enter and track marketing information for a single person. For ease of data entry, they want this...

Thanks Ron, I have all those settings checked off. Sure I am overlooking something simple.

Thanks for the help, however, after trying both of Ron's codes in the after_update attribute for txtEventDate, nothing happens upon tabbing to the next field. Not sure I can use the other solution, as this form is to enter data into a table. I tried it, but kept getting the #name? error in the...

Working on a form where I need to calculate a date in one text box based on data in two others. There are three textboxes involved. I have tried searching, but for some reason, the search function does not seem to work if I add a second word to the search. txtType (text) txtEventDate...

Ken, Thanks a bunch, I seem to be on the right track. In a nutshell, the combo box is used so that each time a product is selected, the button will append it to the productuse table, and then the list box will show it in the main form, correct? I am getting an error message run time error...

Need to find a way to store multiple values in my access 2002 database. Each record in the main table can be associated with multiple products. I have a table set up for product name, (tblProduct), my main table (tblMain), and a third table to store the values for products associated with each...

Great found the problem--thanks for the help. kirk

I have a form used for data entry by 2 people based on a table. Until yesterday, the form was set up so that the first record was record 1, and the form showed each record in ascending order. Yesterday, the form started showing records in a seemingly random order. The order is correct in...

Thanks for all the help--the replace function does not seem to be recognized by crystal... Trying to see if I can find it. kirk

Forgot to mention I am using CR 7 kirk

I need to figure a way to suppress vowels from a string of company names. For example, Ford would return Frd etc any ideas? thanks kirk

I am faced with the task of generating a report on the contents of our info desktop. There are 5 levels of folders/reports. Each report or folder has a unique id #, as well as a parentid #. The parentid is 0 for the top level folders. I wish to generate a report such that each level is...