Recent content by AccessUser

  1. A

    CHECKING FOR FORM BEING OPENED

    If CurrentProject.AllForms("YourFormName").IsLoaded Then
  2. A

    Listview

    list view? Do you mean a list box? Because if you mean a list box, you can just create your query as the row source in the properties and this code will not be necessary.
  3. A

    list box justification

    I have several list boxes that display a field which contains amounts to two decimals (dollars). The list box left justifies these amounts. I would like these amounts to be right justified. Does anyone know if that is possible?
  4. A

    SQL on a button

    you need to add docmd.RunSql (strsource) before the end sub
  5. A

    Dynamic Default Value For Combo Box

    Try this on the form Open Event Dim varItm As Variant For varItm = 0 To Me.ComboBox.ListCount - 1 If Me.ComboBox.Column(ColumnOfMonthName, varItm) = Format(Date(),"mmm") Then 'select record Me.ComboBox = Me.ComboBox.Column(ColumnOfMonthName, varItm) 'exit...
  6. A

    Rookie User Problem

    Click once on the subform so it has handles. The title of the Properties box should say 'Subform/Subreport'. Click on the Data tab. You should find the properties you are looking for here.
  7. A

    Choose from more than one form

    Put a subform on the tab. On the AfterUpdate event on field X do something like this: If me.fieldX = old then Me.SubformName.SourceObject = "formA" elseif me.fieldX = new then Me.SubformName.SourceObject = "formB" else Me.SubformName.SourceObject = "formC" endif Where Me.SubformName is...
  8. A

    sub form total

    In the Form_BeforeUpdate event on the parent form, you can check if the fields on the subform have data entered. If not display a message then do a docmd.CancelEvent.
  9. A

    Searching List Boxes

    You can cycle through all the items in a list box. dim strSearchFor As String strSearchFor = "Search Criteria" For varItm = 0 To Me.ListBox.ListCount - 1 If Me.ListBox.Column(1, varItm) = strSearchFor Then 'do what you want Exit For End If Next varItm I'm not sure if you could...
  10. A

    Date Calculation on Form -- Please Help

    Is the name of your textbox is SDate? If that is the case, change it to something like txtSdate. If you use an expression in the control source and have the textbox named the same as a field in the expression, Access gets confused.
  11. A

    prevent modification of a single form

    Who do you want to prevent from changing it? If you create an .mde, it will prevent the users from changing the design.
  12. A

    Creating a form that updates a table, only if data is not already in the table

    If CustomerID is set as the primary key in the table, it should not allow duplicates because the primary key must be unique. The first 5 letters of a customers name is not a good primary key, because there could be lots of customers who have identical first five letters.
  13. A

    Is it possible to "deactivate" a report control?

    In the code module you can add code that says in the case of the Project subreport make the Resource ID control not visible (ResourceID.Visible = False) else make it visible (ResourceID.Visible = True)
  14. A

    Dlookup - I think

    Try renaming your text control. If you have modified the control source (used =), Access gets confused if the text control's name is the same as a reference in the control source. You said the text control is named FirstName and you have a reference to FirstName in the control source.
  15. A

    Maximize one form - all forms follow.

    Try docmd.restore in the close event
See more
Back
Top Bottom