Search results

  1. P

    Update error

    Can someone look at this update statment i just wrote? It's giving an error. i.e. UPDATE [Upload Trades] LEFT JOIN UploadAccts ON [Upload Trades].CustAcct = UploadAccts.CustodyAccount SET [Upload Trades].Client = [uploadaccts].[client], [Upload Trades].Account = [uploadaccts].[account] WHERE...
  2. P

    Check writer sample

    Hello, Does anyone know where i can get a copy of the check writer sample database for ms access 2000? thank you.
  3. P

    Date Format

    Hello Can someone help format the date correctly? I'm currently linking a flat file in access and then creating a table afterwards. The date comes in the following format below: i.e. 30102006 - txt type I wanted the date to look like - mm/dd/yy. Thanks for the help.
  4. P

    Creating Forms

    Hello, I'm trying to create a form or some kind of database that does a comparison between a flat file i get and what the system has. Can someone guide me in the right direction on it? Any example would be great. Thank you.
  5. P

    Date on report

    Hello, I'm trying to show the date when i run my report on the report header. I'm not sure on how to do that, can someone help?
  6. P

    Date on report

    Hello, I'm trying to show the date when i run my report on the report header. I'm not sure on how to do that, can someone help?
  7. P

    Importing Error

    Hello all, I'm fairly new at access and have been stumped at this problem. I download a csv file from the internet and what i wanted to do is just imported straight to a table from access. Some how the csv file contain some excel function that looks like the follwoing - i.e. =T("SOME TEXT")...
  8. P

    Help in building a database

    Hello all, I need some assitant in building a simple check reconciliation database. I was wondering if anyone can guide me in doing so? Or if anyone has some kind of sample i can use that would be great. thanks
  9. P

    Error Appending records

    Hello, i'm new with access and was wondering if i can get some help with an append query? I'm getting an error message that state the following below: *Microsoft Access can't append all the records in the append query. Microsoft Access set 36 field(s) to Null due to a type conversion...
Back
Top Bottom