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 Chriss Miller 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: HEMASUR
  • Content: Threads
  • Order by date
  1. HEMASUR

    Running a macro from a query

    Is it possible to run a macro on closing of a query. I have an append query, on close I need to run an update query. Thanking you. Hema
  2. HEMASUR

    S9(9)V99, convert to currency

    I have a currency field in the above format, the last digit is an alpha character, that indicates a negative number. I do not know how to write sql statements, but if someone can help me with a simple replace query, where the last digit can be replaced by a digit that would be of great help...
  3. HEMASUR

    Export a table as a text ffile, identify end of record

    I need to export a table that I created as a text file. The export specs requires the last column to contain a carriage return and/or line feed character. I would apprecitate any help that some one out there can provide me. Thanks
  4. HEMASUR

    Combine iif statements, is null and is not null

    I have a query with the following statement IIf(IsNull([DeceasedDate]![qry Compare 2006]) And (IsNull([Enrolled]![qry Compare 2007])),"New",IIf([DeceasedDate]![qry Compare 2006]="*12*","DECEASED")) The query is getting data from 2 other queries. Query1 has member #s and deceased date Query2...
  5. HEMASUR

    Record numbering

    I have a query that outputs duplicate records in a database, based on DOB and customer number. Due to data entry errors the same customer could have duplicate records, I need to print out this list out so that the names in the database can be fixed. I want to insert an index number to the...
  6. HEMASUR

    Add row number to query output

    I have a query that outputs duplicate records in a database, based on DOB and customer number. Due to data entry errors the same customer could have duplicate records, I need to print out this list out so that the names in the database can be fixed. I want to insert an index number to the...
  7. HEMASUR

    Application-defined or object-defined error

    I am trying to print query definitions through the Documeneter feature in Access and get the following error message. "Applicaion-defined or Object-defined error" I have compacted and repaired the database, and our IS person tells me that the full version of Access has been loaded. If some one...
  8. HEMASUR

    Replace * in a data field

    I need to replace an * in a data field Field1 4541106356*01 15106987 01 1107661*01 99210*01 1108474*01 1108474*02 1108474*03 15608474*04 1108474*05 1108581*01 19097 01 1109541*01 Since the * appears in different places, I am not able to replace with a Concatenate function. Could some one...
  9. HEMASUR

    Replace * in a data field

    I need to replace an "*" that is in the middle of a field, Field1 1106356*01 1344106987 01 1107661*01 1108210*01 5461108474*01 1108474*02 11208474*03 1108474*04 6789*05 18808581*01 1109097*01 1109541*01 Since the * appears in different places, I am not able to concatenate. Could some one...
  10. HEMASUR

    Report does not open, Access Freezes

    I have one macro "mcrOpenReport" that is attached to two command buttons on a main form. Button1, runs queries and runs "mcrOpenReport", that opens report in print preview - no poblem works fine!!! Button2, imports data and runs queries and runs "mcrOpenReport", that has to open the report in...
  11. HEMASUR

    if calculated field is null

    I have two fields that are calculated fields on my form Eg:Field4 = (field1+field2)/field3) Fields', 1, 2, 3 have a criteria set that if there is no data to show "NA". The calculation works fine when there is data, but when there is a "NA" in any one of the fields, I get an error "Num#". Can...

Part and Inventory Search

Back
Top