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!

  • Congratulations bkrike 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: mmasuda
  • Content: Threads
  • Order by date
  1. mmasuda

    Mobile Fax or Scan

    I am looking for device(s) that would let someone scan a document from a vehicle (or fax) using a mobile phone or pda. I have been searching through the Internet but have not been very successful. Thanks, MM
  2. mmasuda

    calculating a value based on a previous entry

    I am trying to calculate the difference between to values either in the query or on the form. The data is as follows: Id Odometer Reading Miles Driven 1 3081 ? 2 3481 ? 3 3751 ? This data is part of a table which relates to a...
  3. mmasuda

    displaying continuous data from a twodimensional array

    I am trying display information from two related tables out of a database. After creating an inner join query, I use the following to display the information MyArray = rsmastdetail.GetRows() Const Mydegree = 19 dim vartemp vartemp = 0 Response.Write("<p>") For x = 0 To Ubound(MyArray,2) If...
  4. mmasuda

    remove characters without knowing the length

    Hi, Is it possible to create a query other than using the trim function to remove some unwanted characters from a string. I have a delimiter in the middle of the string (#) and want everything removed following the delimiter. The number of characters before and after the delimiter vary. Thank...
  5. mmasuda

    adding multiple topics to one row

    Hello, I am trying to create a database which keeps track of bibliographies. Each bibliography is a table row and has one or more topics. The topics will be listed in a different table. The goal is to display the bibliographies related to a specific topic when a users clicks on the topic in a...
  6. mmasuda

    Confirmation page

    Hi, I have a form set up using dreamweaver. When the form data is submitted, it is added to an Access Database, which uses the autonumber function for this particular table. I would like to display the particular number that is assigned to the new record just entered on a confirmation page. Is...
  7. mmasuda

    To be NULL or Not To be NULL Help!!!!!!!!!

    I am trying to use an unbound text box in a report to display comments from a query. Sometimes there are no comments to display. In that case I want to display the message "No Comments were made". First I used this: IIf(IsNull([not_cur_there]), "No Comments were made", [not_cur_there) When...
  8. mmasuda

    Frequency Distribution

    Is it possible to use data from MS Access and form frequency distribution tables? If so, how?
  9. mmasuda

    Conditional statement in Word

    Is it possible to use nested If-else statements in a mail merge situation in word?
  10. mmasuda

    multiple textbox problem and lots of totals to report

    I am trying to create a report and based it on a table "caller," which contains a field "quarter." Throughout the report this field will be refered several times. First, I used an unbound textbox and entered a nested if-else statement, so it would detect the correct quarter. That worked fine...
  11. mmasuda

    multiple records from one form into one table

    I have a table "caller," "videoItems", "libraryItems," and "topicPackets," using MS Access 2003 "Caller" collects the demographics from people requesting information. Each caller may request up to 3 video items, 3 library items, and 5 topic packets. I created a main form for "caller" and...
  12. mmasuda

    count several colums, one query?

    I am not very experienced in writing queries. I need to count items in table "Brochures." There are five colums with integer data type. Example: moddrc sos tbi moddrc_sp sos_sp 100 50 0 0 0 0 100 25 25 0 I need to find a count for each...
  13. mmasuda

    Crosstab queries and parameters that are not working

    I have a table “caller” which displays among other info the type of caller, the quarter of the fiscal year, and the year. I want to run a crosstab query which displays the count of the type of caller and prompt the user to enter which fiscal year quarter and year should be queried. The crosstab...

Part and Inventory Search

Back
Top