Search results

  1. R

    Dynamic If statement

    You may have seen this but I thought I would pass it along to you. It appears to be what you are trying to do. Sub DeleteDuplicateShippers() Dim dbsNorthwind As DAO.Database Dim rstShippers As DAO.Recordset Dim strSQL As String Dim strName As String On Error GoTo...
  2. R

    Alignment of text in form fields

    Check for spaces in the data. And for some reason I have seen in WORD that text will not completely align to the left. Also select all of your text boxes, click left align in format off then click it back on again. Dale
  3. R

    Setting Focus to Control on Single Form Side of Split Form

    Where is this code setting? What event. How do you call it. WHAT, WHERE,WHEN and HOW. Dale
  4. R

    Alignment of text in form fields

    Under the format tab, make sure all of the text is left aligned. Aligning the text box does not align the data within it. Dale
  5. R

    eliminate scrolling to find add a new entry

    Yes It would. Did not see in you post where this was wanted. I thought you post was about entering new data. Sorry, My mistake. Dale
  6. R

    Dynamic If statement

    May I ask why you would want to delete records in the first place. This defeating the one purposes of a database, storing history data. Dale
  7. R

    eliminate scrolling to find add a new entry

    On the property sheet for the form. Under the data tab change Data Entry for No to Yes. Dale
  8. R

    Setting Focus to Control on Single Form Side of Split Form

    If the above is a copy and paste remove the period after SetFocus. Post your complete code. Dale
  9. R

    On Got Focus move to new record

    This works. Every time you hit the tab key it makes a new record and 1 is stored in the Qty field. Private Sub numTest_GotFocus() Me.numTest = 1 Me.Testtext.SetFocus DoCmd.GoToRecord , , acNewRec End Sub Dale
  10. R

    On Got Focus move to new record

    me.Qty = 1 works. Impossible to control, but it works. DALE BTW. AfterUpdate will fire only after a keyboard entry.
  11. R

    On Got Focus move to new record

    Is txtOrderNo on the same form? Try The After update event for QTY. Dale BTW. Your query is not the problem.
  12. R

    On Got Focus move to new record

    what is happening now? What doesn't work?
  13. R

    How to make hierarchical structure for the flat table

    Please read this. http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters Dale
  14. R

    C001 Type Primary Keys

    RuralGuy, the link dos not work. Dale EDIT: Link works now. ?????
  15. R

    Calculate my income tax using Access

    I think it would work great. It would be the same as a company using the outputs from invoices. Dale
  16. R

    unlock diffrent fields on my form, when check Couple is on

    Try the .enable = true in the check box after update event. Have the fields set to enable = false by default. Dale
  17. R

    Query to show entries from 2 tables not in third table

    Quote: Originally Posted by rzw0wr Also I never use inner or out joins in a relationship. Do that in a query. When you set up table relationships, these ARE joins. Never said they weren't. I said I never use these types in a relationship. I...
  18. R

    Cumulative total error in query

    Please read the following. http://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters Dale
  19. R

    Query to show entries from 2 tables not in third table

    Question, How would Access know if something is missing? You can compare 2 tables for missing data in 1 table. You need something to compare to. Do you see what I am saying. If the data is not there Access does not know this. Example: If you have 4 steps to a process and 3 people have not gone...
  20. R

    Update a form field using VBA

    What do you mean by "Update"? Store or display the data in the combo box? Dale
Back
Top Bottom