Search results

  1. T

    Adding field to existing subform prevents ability to move to next record

    Ok. Thanks for all the feedback Pat. I know it’s not great…learning as I go. This is my first crack at it so your info is appreciated.
  2. T

    Adding field to existing subform prevents ability to move to next record

    Figured this out. It's working now. I'm not sure how, but at the table I had lost my Autonumbering on the ID field??? I must have gone and looked at the table several times without catching it. I've set it back (on my og database) and changed the placement of the vbCode for the Code control...
  3. T

    Adding field to existing subform prevents ability to move to next record

    I've copied the necessary forms, tables and queries into a blank database and removed sensitive data to show you what's happening. If you open the Purchase Order Details form and click New PO, you can tab through the fields to see how it works. When you tab into the subform and put a line Item...
  4. T

    Adding field to existing subform prevents ability to move to next record

    I did actually.... "I have found that by adding this new "Code" control into the subform I now cannot tab or arrow out of the current record unless I press Escape." Just want to know why I can't tab or move out of a line (record) after adding in one simple field on the table and one control on...
  5. T

    Adding field to existing subform prevents ability to move to next record

    The hidden field is on the subform because this is where the line items come from for the purchase order. We assign project or "job" numbers to these line items to tag the material for a project so having it on the main form would be ineffective. Sometimes we will order material from a vendor...
  6. T

    Adding field to existing subform prevents ability to move to next record

    My bad....that should have read "Indexed: Yes (Dups Ok). So my issue still exists. Any other thoughts?
  7. T

    Adding field to existing subform prevents ability to move to next record

    I have a database that I've developed for Purchase Orders and project tracking that has been working great for the last year and a half. It has been asked of me to add in a hidden field in the line items for the purchase orders whereby a "code" is placed based on the input of the Job Number...
  8. T

    Subform Datasheet will not display all records in table

    OMG. Just looked it up.....feel like an idiot. :LOL:
  9. T

    Subform Datasheet will not display all records in table

    Hi Pat, So, I'm a self taught newbie. Can you explain this in layman terms? What is RDBMS?
  10. T

    Subform Datasheet will not display all records in table

    Thanks for the reply. I have combo boxes at the top of the main form that filter the subform. This is where I use the "Like" statement. For example: Private Sub Combo224_AfterUpdate() Dim StrFilter As String Me.Refresh StrFilter = "SKU like '*" & Me.Combo224 & "*'" Forms![Copy of...
  11. T

    Subform Datasheet will not display all records in table

    Database is full of sensitive info, such as employee information and projects. Can you specify what information might be helpful in assisting and I can send whatever info is necessary.
  12. T

    Subform Datasheet will not display all records in table

    I've made a purchase order system and am having trouble with a subform. My main form (Single Form) is unbound and has comboboxes set up to filter the subform. The subform displays as a datasheet. This works great except for one problem. My PODetail table has 17,000 records in it and the...
  13. T

    Display records by typing in "Like" items in combobox on Split Form

    I did manage to catch the missing "End If".....LOL I'll keep playing with it. Thanks again.
  14. T

    Display records by typing in "Like" items in combobox on Split Form

    Code works great, but the text disappears as you type. Might be a little confusing for a novice keyboarder. How can i keep the text from doing this? I'll try both scenarios and see which works best for this application. Appreciate the help!!
  15. T

    Display records by typing in "Like" items in combobox on Split Form

    The screen shots have been cropped. I work on two monitors. Not sure how I would get you better resolution.
  16. T

    Display records by typing in "Like" items in combobox on Split Form

    Not sure I follow. How would I set that up?
  17. T

    Display records by typing in "Like" items in combobox on Split Form

    Sure thing.... Here's the form (I've hidden a couple of columns for privacy purposes) I've typed in "Dover White".......The dropdown shows all the records that have "Dover White" in the description. That's great. But......I want the records in the datasheet to actually show all the...
  18. T

    Display records by typing in "Like" items in combobox on Split Form

    Hi all, I have developed a PO system in my database. It's all working well, but I have a "Search POs" form that i've developed where the user can select different comboboxes to search the PO items in different ways. I have used an If LEN() statement in the "Items" combobox and this works well...
  19. T

    My .accde file will not open for users that could open it before. Getting 32-bit error message.

    Turns out I'm the only one with a 32-bit install. IT is supposed to be coming to fix this, but haven't seen hide nor hair of him yet...... Thanks for the ammo The_Doc_Man!!! If I ever see him again I'll be sure to use it ;)
Top Bottom