Search results

  1. W

    How to add a new record in a table by code or macro?

    I also learned a lot from your other posts. They solved my problems on ComboBox. Here's my code. When an user input a customer name that is not in my customer table, a message box will pop up and ask if the user wish to add it to the list. If yes, a new record will be added to the customer...
  2. W

    How to add a new record in a table by code or macro?

    This is great! It works. Thanks, Dolphin. :)
  3. W

    How to add a new record in a table by code or macro?

    I have a simple table of Customer names. It's as simple as two fields involved: CustomerID CustomerName How can I use VBA code or macro to add a new record to this table? I'm a newbie, so if possible, please provide a few lines of example codes. Thanks.
  4. W

    Wrap text in the Header columns

    :)Finally my solution is to add a duplicate column of what I wanted to freeze to the right side. It's not perfect but it works. The idea came from my boss. Still, it would be perfect if ACCESS can wrap text in the Headers in Datasheet view...
  5. W

    Access 2003 VBA reference problem

    Seems that I'm not alone in this problem. My solution so far is to use the online version: http://msdn2.microsoft.com/en-us/library/aa663079(office.11).aspx. It works just fine! Hope this helps.
  6. W

    Wrap text in the Header columns

    You're right. I'll give it up. Thanks.
  7. W

    Wrap text in the Header columns

    Well, I mean it's easy to do so in Datasheet view. Just right click the column and choose "freeze columns", but I can't do it in tabular view. It seems that I cannot get them all. For wrap text header, I have to use Tabular view; for freeze column, I have to use Datasheet view. Is it typical of...
  8. W

    Wrap text in the Header columns

    But now I get another problem. I'd like to freeze the most left column, and it seems that I cannot do it in tabular form. I have to use datasheet view for this feature. This is so bad...Excel can do it like a snap. I've spent a lot of time on this small thing. Is there anybody can help me out...
  9. W

    Wrap text in the Header columns

    Here is the best I can do with Tabular form. It's pretty good though. Thanks for all helps.
  10. W

    Access 2003 VBA reference problem

    I was about to post this question in Access FAQs under the following thread but it's not allowed. http://www.access-programmers.co.uk/forums/showthread.php?t=136543 I downloaded the Access 2003 VBA reference from the MS website. When it runs on my computer (XP professional), it will pop up a...
  11. W

    Wrap text in the Header columns

    Thanks, Libre, but I want to display full text in the column headings.
  12. W

    Wrap text in the Header columns

    Thank you very much for the quick response. Tabular form doesn't look as "neat" as a datasheet. We're transferring from Excel, and my users are expecting to see something looks like a spreadsheet... But I'll go with tabular form if there's no better solutions. Thanks again.
  13. W

    Wrap text in the Header columns

    I'm new to MS Access and this forum. This may be a silly question but I cannot find answer anywhere: can I wrap text in the header columns of a table in Datasheet view as shown in the attachment? BTW, I cannot make the column width wider because I want to display as many columns as possible...
Top Bottom