Syndicate content

Page list for MS-Windows

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

  • As I was writing a report using VBA in MS-Access, I needed to get a name from a table. Yet, once in a while, that name does not exist in that table (for good reasons) and yet I'd like a more human name than the default number that you otherwise get... The result was a need for two LEFT JOIN in my SQL command.

    1. Using the result

    I have three text boxes in my form:

    (a) The one that the user sees with the valid result, it actually includes a simple VBA script:

  • Today, as I was working with Coverity, I got this one message...

    Negative constant passed to a negative sink.

    Although I understood the meaning, I thought that this message was very confusing, How about:

    Unexpected negative value in parameter #<position>

Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

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

  • PAD File
  • cursor
  • feature
  • menu

    In the computer world, menus are sets of items that generate an action when activated.

    It is used in CUI, GUI and the Internet.

  • www-data