Search results

  1. A

    Extremely strange '2001' error

    Hi, I have a search form with some combo boxes and textboxes. Whenever I finish a search, clear the combo box, textboxes by clicking the 'CLEAR' button, and do a search again, it always gives me the '2001' error message. However, if I don't touch the 'CLEAR' button and keep doing my search by...
  2. A

    How to reduce Access file size?

    Hi, I have a db with some dummy data. After I delete them, the file size still won't go down. Is there any way that I can remove all the dummy data, and have the smallest file size possible? Thanks a lot.
  3. A

    Got Stuck with VBA+SQL.....(panicking, please help~)

    Hi there, I've been working on this simple DB for two weeks, but it's still far from completion. :( I had never done anything with Access+VBA+SQL before, so I'm wondering if anyone can help. This database stores the information of the 15 type of documents (i.e. Voucher, Invoice...), and...
  4. A

    Creating search form with SQL

    Hi, I don't know much about VB, and I'm wondering if anyone can help me with its syntax. I have a simple database that keeps track of a "tblDebitNote" table. It has the following attributes: -DebitNoteID (Autonumber, PK) -Date (date/time) -Reference Number (text) -CD Name (text) I've created...
Back
Top Bottom