The Linux Page

Page list for MS-Windows

  • When creating an unbound text in MS-Access it is not constrained in length. The text limit you get when the field is bound to the database table is really neat, but there is not direct way to access that code (it's probably something hard coded in the MS-Access system.)

    This means you have to re-implement the behavior.

    I found this page Unbound text box: limiting entry length which has a very good solution. Just in case the page disappears, there is what I use (a simplified version that doesn't manage errors because I do not like that — errors are not supposed to happen, when they do,

  • Problem

    One of my customers changed a report and all of a sudden was getting an empty page for every other page (it will look like the last page in case you print a single page, but it really is every other page.)

    Did you think about the margins?

    When you create a report to be printed, you must define its size properly. So if you are printing 8"1/2 x 11" paper, you want to create a report that's exactly (to about 1/100th) the same size.

    The total height must be 11" and the total width must be 8"1/2. However, the actual page that you create does NOT include the ...

  • Looked around on how to sort out a report properly as it was sorting on the wrong field (actually at first it did not even look like it was sorted at all, but I did not notice that other field was indeed sorted!)

    The sort in a Query Report form (opposed to just an SQL query) is defined by the Group & Sort feature and not the SQL results. Actually, you most certainly don't need it in the SQL because otherwise you'll be sorting twice.

    It took me a while, but I'm glad I found the solution. All the documentation I searched only talked about the wrong methods: use the Query sort ...

  • The MS-Access system has a limited way to lock records...

    This is done within what is called the Recordset object. That object has a field called LockType.

    Available lock types are Optimistic, Pessimistic, Table. The last one prevents all access from anyone else (read/write lock). Pessimistic locks let other users read the locked data, but not write (write-only lock). Optimistic locks do nothing (in other words, no locking.)

    The following is a synopsis for this locking feature:

  • Reports, Print and Load() Event

    I wrote many forms and in general everything works just fine.

    In this case, I wanted to enter the data with a function so I could properly format several of the fields (especially the billing and shipping addresses.) That was done on the Load() event. That function working great when looking at the report from within MS-Access (on screen report). However, when directly sending the report to the printer, it was not working well at all.

    [toc hidden:1]
  • Problem

    Today I ran in a problem where I created a new form and the sub-form inside that form would auto-resize itself. Strangely enough, all my other forms also have a sub-form and that sub-form is not auto-resized... so what gives?!

    I did not find anything about preventing an auto-resize of a sub-form. Found many pages on the net about how to write code to resize a form "manually". But that really did not help.

    Solution

    As I created that new form, I marked it as "Auto Resize" to No. This seems logical if you do not want a form to get resized. Think again! The ...

  • Problem

    I worked on a project with many functions that access the database. These functions will generally have a Recordset variable. Yet, when I tried to run a script with the recordset declaration, it would fail with the error Undefined variable type.

      Dim rcd As Recordset
    

    Since that definition was not required for the software to work, I ignored the error for a long time.

  • I started using MS-Access not too long ago, but this one is really getting me each time.

    Once in a while I get this error telling me that the Form is messed up, that a field or a macro just do not match. That macros are missing even though I ask the Form to call the corresponding functions. And some other strangeness like those.

  • If you were wondering how to make MS-Windows know about your Intranet computers, let me tell you, it's very simple, you just have to add the address(es) to your hosts file. Am I kidding?! Yeah! Right! Have a look for yourself, on NT and Windows 2000, XP, 2003, Vista, etc. you have a "network driver"1 here:

    • 1. For your information, the network stack comes from FreeBSD. That additional module you bought for $100+ for MS-DOS and then MS-Windows 1.0 to 3.1... was free software.
  • Okay, it has been a little while now, but each time I just have to search forever to find out how to create a multi-level numbering list.

    By default, a list will appear as this:

    1. Chapter

        1. Section

            1. Sub-Section

    Which may work for you, but in many cases you want to have all the list numbers appearing in your section and sub-sections as in:

    1. Chapter

        1.1 Section

            1.1.1 Sub-Section

    Okay, so that in itself it actually very easy, but it used to be that you could ...

Syndicate content

SMS From Me Logo

SMS From Me

To automatically start one on one conversations with your online leads.

     

   

Terms of Site Index

Find the page/content you are looking for with our index.