Search results

  1. J

    Ticked off P/C while trying to Import Data

    I've used the Import feature at least 77 times, to bring in data from excel spread sheets. I guess either I overworked my P/C or it just got mad! So now it is just refusing to give me the questions that allow me to complete the import of the data. This is what happens; 1. Open Access...
  2. J

    Ticked off P/C while Importing Data

    I have done this atleast 77 times, and I haven't had a problem until now. I am trying to import data from an excel spreadsheet, but when select the file I want, all it does is give me the hour glass for a few seconds, and then returns me to my original screen. The questions that normally come...
  3. J

    Macros or Micros?

    Aloha, I am trying to output to a table, records, that have been selected in a macro, however, if I use CopyObject, or TransferDatabase, it will take the entire table. Is there a way using the Macro to copy the selected records? Thank you again for all your help..........jo-
  4. J

    Find/Replace

    I'm trying to use the Find/Replace from the tool bar, but the field that I am working with contains nothing. On the FIND WHAT: line, I have tried everything that I have found in the help sections, but nothing works. I have tried NULL, IS NULL, " ", 0, IS BLANK, BLANK. Does anyone have any...
  5. J

    Data Splitter or shoud I say Data Spitter?

    I have used the Data Splitter option on tools, to try to protect my data from ME! And guess what, it works, however, I need to change and add fields to the tables, and now I can't do anything. It says "Table "X" is a linked table, with properties that can't be modified". Does anyone know how...
  6. J

    DUPS, dups, DuPs, dUpS.....

    I'm trying to print a report from 3 separate tables that are linked by a government number. When there is a blank in a field, it will duplicate it from the previous record read. Also it does a level break for each record, rather than by the a stipulated program id. I know that I can use the...
  7. J

    multi selections from a combo box

    Is there a way to select more than one record from a combo box? I have a field that is called Targeted Population, but it requires that the user be able to select more than one of the options, and to be housed in a single text box. Does anyone have any ideas.......thank you!
  8. J

    Zipping Files

    I am sending out an Access Program that requires the users to send back their data, and due to diffent setups, I get a 3170 error, which stops them from backing it off on to a diskette. Does anyone know how I can embed the WINZIP program into my Access Program, so that it would automatically...
  9. J

    New comer to Access/Report

    I am new at this game, so please excuse my ignorance. I have a table that contains two types of records. Each record has a code to distinguish what it is. Those that are coded with the letter "L" should be printed on the left side of the report, and those that are coded with an "S" should be...
Back
Top Bottom