Search results

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...

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.

Thanks a lot for the reply, but I'm still unsure about (3) 3) Do you have any example on how to do this? I'm not very familiar with queries. Can you help me with that? Thanks a lot

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...

Hi, Thanks a lot for the reply. I'm wondering if you can help me with the following few questions: 1) When you say I need to put values into the variables, do you mean I need to initialize them to blank value? 2) I'm not familiar with query, is it possible to make this search form work...

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...