Search results

  1. J

    Odd form behavior...

    I have a form (HappyForm) which opens up another form (VeryHappyForm): DoCmd.OpenForm VeryHappyForm Before closing, VeryHappyForm updates some controls on HappyForm: [Forms]![HappyForm]![HappyControl] = [Forms]![VeryHappyForm]![VeryHappyControl] Everything works and everyone is happy. I now...
  2. J

    Mehod 'Item' of object 'Forms' failed (run-time error 40036)

    I've encountered this error in the past. The last time I ran into it, I recall that I had the name of a column wrong that I was referencing in Form_Current... Something along the lines of Forms![MainForm]![Ooops] instead of Forms![MainForm]![Great Job] The odd thing about this error is that...
  3. J

    This subform's got me stumped...

    I have a form with two subforms. One of the two subforms works perfectly. The other just gives me a grey screen (like there's no recordset). The two forms are very similar and I've checked everything I can think of... Here's what I've done. If you can think of anything else to try, please...
  4. J

    When [How?] to close a form..

    I have a form that I want only to be opened from another form (i.e. the user presses a button from form1 and form2 is magically displayed). My solution: In form2, I check to see if form1 is open in "use" mode. If not, I display a message and close form2. The problem: The close code...
  5. J

    Using values from a text box in row source

    I have a combo box which has a table/query row source type. For the row source, I want to use a query that contains some data from text boxes on the form. I'm currently trying: SELECT [LAB],[COAT] FROM [University] WHERE [COLOR]=tbColor.value AND [TYPE]=tbType.value; Although this is a valid...
  6. J

    Accessing the database properties..

    Ok, Let's say I go into File->Database Properties from the "main" Access screen. This brings up a window with the title "<database name> Properties" where <database name> is the same as currentproject.name. This window has several tabs including "Summary" and "Custom." It looks like this...
  7. J

    Good design? Bad design? Problems..

    I'm going to make up names and values -- I'm interested in the structure. Table ALPHA: COLA DAT1 DAT2 DAT3 1 5 7 9 2 4 14 8 Table BETA: COLA_IND DAT1 DAT2 DATN 1 a b c Table CHARLIE: COLA_IND DAT1...
  8. J

    Using the lookup field...

    Let's say that I have two tables: Table Numbers: ID VALUE -- ------ 1 123 2 456 3 789 Table Letters ID VALUE NUM_LOOKUP -- ------ ------------- 1 ABC 1 2 DEF 3 Now, I'd like to use the lookup feature so that NUM_LOOKUP is a...
  9. J

    Wanted: Unique values from source column in query

    Ok, this query is driving me crazy. I'd like to get it so that there are no duplicate values in the [T1].Data1 column. Here's what I have: SELECT [T1].DATA1, [T1].DATA2, [T1].DATA3, [T2].DATA1, [T2].DATA2, [T2].DATA4 FROM [T2] INNER JOIN ([T1] INNER JOIN [T3] ON [T1].DATA3 =...
  10. J

    Filtering a sub form

    I have a subform on my main form. Note that there is no relationship between the recordset of the main form and the recordset of the subform. I need to be able to change the filter on the subform dynamically during run-time. I know this sounds a little odd because in theory I should be able...
  11. J

    The selected value displayed in a combobox

    I'm sure this is simple and I'm just missing something... I have a combo with two columns and the row source set up as a query which returns two columns. When I click the drop-down arrow for the combo box, I get exactly what I expect. What I want to do is initialize the combo box so that the...
  12. J

    Assigning control source at run-time..

    In design view, I have my record source set to a query. I use the data from that query as the control source for several text boxes on my form. At run time, I reset the control source for one of my text boxes (using VBA code) so that the control is unbound. I'd like to be able to reset the...
  13. J

    dbSeeChanges option required...

    I have a combo-box which is generating the following warning message: You must use the dbSeeChanges option with the OpenRecordset when accessing a SQL Server table that has an Identity column. It doesn't seem like I can trap this warning message and I'm not sure how to get rid of it...
  14. J

    Changing data before an update...

    I'd like to be able to format the text that a user enters before it is saved into a table, but I've been unsuccessful to date. I thought that I might be able to use the BeforeUpdate event. Unfortunately, Access won't let me modify the field that it is about to update (it generates error code...
Back
Top Bottom