Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: akirk
  • Order by date
  1. akirk

    Issues Exporting Unicode Data to a tab delimited file

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

    Accurately Calculating Average and Median

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

    Accurately Calculating Average and Median

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

    Number Always Negative

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

    extra columns/rows in export from CRXI pdf to Excel

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

    extra columns/rows in export from CRXI pdf to Excel

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

    Problem using TransferSpreadsheet

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

    Parse out data in a field...

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

    Calculate a date based on text box

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

    Calculate a date based on text box

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

    Calculate a date based on text box

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

    Calculate a date based on text box

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

    Problem with data entry form and multiple values

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

    Problem with data entry form and multiple values

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

    Order of records

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

    Order of records

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

    Extracting from a string field

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

    Extracting from a string field

    Forgot to mention I am using CR 7 kirk
  19. akirk

    Extracting from a string field

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

    numbervar question

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

Part and Inventory Search

Back
Top