Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ArtPM
  • Content: Threads
  • Order by date
  1. ArtPM

    Inserting ActiveX Calendar crashes Access

    I am trying to add an ActiveX Calendar Control to a form. When I insert Calendar Control 10.0 from the Insert/Active X/ menu, the application crashes with no error codes. I am running Access 2002 on an Access 2000 database file. Can anyone give me a clue on how to solve this problem? Thx Art
  2. ArtPM

    Access crashes

    I am trying to add an ActiveX Calendar Control to a form. When I insert Calendar Control 10.0 from the Insert/Active X/ menu, the application crashes with no error codes. I am running Access 2002 on an Access 2000 database file. Can anyone give me a clue on how to solve this problem? Thx Art
  3. ArtPM

    What's wrong with this code?

    I have a table with 26 entries and the first field contains a milestone ID that I need to reference in later calculations. I could explicitly creat a DIM statement for each one, but then I would have to update the program every time there are new milestones. I would like to define these...
  4. ArtPM

    Creating a list of variables from record data

    Is it possible to create a list of variables from a table? I have a table with 26 entries and the first field contains a milestone ID that I need to reference in later calculations. I could explicitly creat a DIM statement for each one, but then I would have to update the program every time...
  5. ArtPM

    Need Help with Form Filtering

    I am having problems filtering a form: The following code, using Access2000, works on the first execution, but not after that, unless I initialize (close then open) the form or execute the ShowAllRecords command twice. The qury itself seems to work correctly but the previously filtered results...
  6. ArtPM

    Why does code work on one PC but not another?

    The following code works on PC with WinXP/OfficeXP - Access using Access2000 file format: Private Sub cboAssignedTo_AfterUpdate() Dim DB As Database, Q As QueryDef Dim criteria As String, strSQL As String Dim ctl As Control Dim itm As Variant Dim strDocName As String strDocName =...
  7. ArtPM

    Use one form for multiple/identical tables

    Is there a way to use one form to navigate more than one underlying table (exact same structure)? The form I am using provides a combo box to navigate the autonumber field and another combo box to filter the records based on another field.
  8. ArtPM

    Problems with wildcards in SQL Where IN Clause

    I'm having problems getting wildcards to work in the Select Where In clause. All text inputs work fine; wildcards alone or combined with text do not. Here's the statement: Q.SQL = "(SELECT * FROM Combined_AR_Table_withAllDept WHERE (((Combined_AR_Table_withAllDept.C2PComplex) In (" &...

Part and Inventory Search

Back
Top