Search results for query: *

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

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

Ryan -- Thank you for your help I don't follow you. The array has all of the information I need. When I try to enter the DIM statement to try to use the contents of the first field of the array as the name of the variable, I get syntax errors. I'm not clear what the redim will do for me...

Snoopy - thanks for the reply. I am using Access 2000. I have tested the array and it does contain all 26 records with the three fields. I cannot get the right DIM Statement syntax that allows me to define the first field in the array as a variable.

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

Paddyo, Thanks for your reply. I'm afraid I didn't explain myself very well. The ultimate result I am looking for is to create a new Schedule and append it to a Schedule table. User inputs will be a Schedule completion date and several variables that will alter a set of intervals (duration...

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

Kevin, Thank you for your help! Your solution is simple, but EFFECTIVE! Works great! Thank you again. Art

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

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

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.

Thanks Steve. I suspected that this was the case, but could not find it documented anywhere. The situation I am trying to solve is 3 multi-select listboxes, in which I would like to have one entry that selects all items in the list rather than having to manually select all. Thanks for your help!

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 (" &...