Search:

Type: Posts; User: MarkD; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. Replies
    10
    Views
    650

    Re: Compact / Backup (XP)

    John,

    No really haven't made any changes since code was originally posted. One thing to note, at that time was using Access 2000 (aka A2K), am now using Access 2003. AFAIK there's been no...
  2. Re: Link to FoxPro With DSN Less Connection (2002/SP3)

    I sometimes work with Visual FoxPro databases (under duress) but do not know of any way to link a VFP table in Access w/o specifying an ODBC DSN (Data Source Name). One Access app I maintain needs...
  3. Replies
    2
    Views
    1,354

    Re: Table in design mode to Excel (2003)

    Attached text file is exported code module with example of a procedure (ExportTableDesign) that will loop thru all tables in current database (excluding system tables, linked tables, etc - can modify...
  4. Replies
    25
    Views
    1,247

    Re: Tabbed vs MultiPage (Access 2003)

    John,

    Thanx for additional info -- I tried suggestion to turn off the "Use Windows Themed Controls" setting but still got screen flicker if any "unassociated" labels on form. Not sure if this has...
  5. Replies
    25
    Views
    1,247

    Re: Tabbed vs MultiPage (Access 2003)

    As usual, a day late & a dollar short, but we just upgraded from Office 2K to Office 2003 at work, and while converting one of my Access front end databases to 2003, noticed for first time the same...
  6. Replies
    8
    Views
    433

    Re: Access Version (????)

    Not sure if "Application.Version" works in Access 2K??

    <code>? Application.Version</code>
    ' generated error

    I usually use the SysCmd function for this purpose:

    <code>?...
  7. Re: string represents a shortcut link? (VB/VBA any

    On my system (Office 2K, running on WIN XP) the FileSystemObject methods correctly listed files with the .lnk extension. Not sure why your system did not reflect this. Anyway if interested see...
  8. Replies
    2
    Views
    517

    Re: option button in toolbar (Access 2000)

    There's no such thing as an "Option Button" or Option Group for toolbar, the Office CommandBar object model does not provide this functionality. Your choices for toolbar controls are limited to...
  9. Replies
    1
    Views
    419

    Re: Invisible toolbars (Access 2000)

    Attached is example of a VBA procedure that will hide all visible toolbars, with an optional parameter that allows you to specify an "exception" (toolbar or menu to keep visible). There's a second...
  10. Replies
    8
    Views
    567

    Re: Automatic Dates in Access

    Louise,

    Glad worked OK. One final note I neglected to mention earlier, if for some reason did not want to use functions, as alternative could use the following expressions as the Control Source...
  11. Replies
    8
    Views
    567

    Re: Automatic Dates in Access

    PS - attached is copy of your sample database, I modified the report to illustrate how to use the functions in report textbox - see textbox ControlSource property:

    =GetFirstDayOfWeek(Date(),1)
    ...
  12. Replies
    8
    Views
    567

    Re: Automatic Dates in Access

    Below are examples of some user-defined functions you could use to calculate the beginning of week and end of week dates, relative to a specified date:

    <code>Private Const DAYS_IN_WEEK = 7</code>...
  13. Replies
    1
    Views
    225

    Re: Query by Form (2003 allSPs)

    <!profile=NYIntensity >NYIntensity <!/profile> posted an example a while back, see <!post=Re: Query Design view context menus (XP),533808>Re: Query Design view context menus (XP)<!/post>. You may...
  14. Replies
    3
    Views
    383

    Re: set the number of the picture (Access 2000)

    As Hans noted, the command button bitmaps in Access aren't same thing as the Office FaceID commandbar button images. If interested in determining what images correspond to the FaceID numbers, see...
  15. Replies
    5
    Views
    1,542

    Re: Age Function (MS Access 2003)

    As noted you could use a query expression rather than user-defined function to perform this calculation, but the expression will need to be somewhat more convoluted. Attached db file (A2K format)...
  16. Replies
    4
    Views
    862

    Re: Macro Definition (VBA/Word/2000 & 2003)

    Just for "fun", as experiment, ran the attached procedure in VB Editor, with Normal.dot as the active VBA project:

    InsertMacros 20, 1000

    This resulted in creation of 20 new code modules, each...
  17. Re: Development Time Estimate (Access All Versions

    I would agree with John Hutchison - take your original estimate and double it. Testing & debugging may well take more time than the original design & development of the application. Joel Spolsky,...
  18. Replies
    5
    Views
    381

    Re: Continuation Character usage (2003)

    FYI - Buried deep in the MSDN, amongst all the VB.NET and VB 2005 documentation, you can still find archaic, "legacy" VB 6.0 (aka VB98) documentation. Some links below:

    VB 6.0 Code Basics
    ...
  19. Replies
    4
    Views
    438

    Re: Select Columns Command (Access 2003)

    If you really need to select columns in a datasheet form (or subform), you can use the Form SelTop, SelLeft, SelHeight, & SelWidth properties for this purpose. The attached database (A2K format)...
  20. Replies
    36
    Views
    1,932

    Re: IE 7 Beta 2 released (IE 7)

    I installed the IE 7.0 beta a few weeks ago w/no problems or bugs - a big improvement but still think Firefox does the tabs better (they can be re-arranged) & the "Organize Favorites" dialog is still...
  21. Replies
    3
    Views
    6,309

    Re: Opening MDB files without Access (not known)

    The attached file (Excel 2000 format spreadsheet) demonstrates one possible method for doing this by "capturing" the data in Access database from Excel using ADO in VBA to open a recordset and...
  22. Re: Making 2 option sets work as one (Access 2003

    <P ID="edit" class=small>(Edited by MarkD on 28-Nov-05 22:20. Replaced attachment with revised demo file.)</P>Note - just because the socalled wizard only allows you to create 20 option buttons, it...
  23. Re: Object library references (2003 SP1 (11.6355.6

    In reference to your first question, recommend refer to this MSKB article for Microsoft's explanation of how library references are resolved in Access:

    How Access 2000 resolves Visual Basic for...
  24. Replies
    15
    Views
    1,085

    Re: Hex to Decimal conversion (2002/SR1)

    BTW, if you want to "round" a number up or down to nearest multiple of a specified fractional or integer value, you can use this simple function:

    <code>Public Function RoundToCustomVal(ByVal...
  25. Replies
    15
    Views
    1,085

    Re: Hex to Decimal conversion (2002/SR1)

    To add to HansV's reply, you also need to divide result by 2^20 (1048576) to convert bytes to megabytes:

    ? CLng(Replace("0x1ff3a000","0x","&H"))
    536059904
    ? 536059904/2^20
    511.2265625
    ...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4