Search results

  1. 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...
  2. 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...
  3. 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...
  4. T

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

    I've all but finished working on this database and have rolled out the front end to a couple of users. They have been able to open the files no problem until this week. I rolled out a new version and now they are getting this error... "This database was created with the 32-bit version of...
  5. T

    Solved Command Button to Update Recordset in Subform

    I have developed a PO system in my database that works beautifully, however, i'm stuck on the proper code for a command button. I want the command button to "Receive All". I have a Mainform: Receiving that has a Subform: PORecSubfrm I have placed a command button on the mainform that I...
  6. T

    How to set a Textbox in the Footer of Subform to look up text values in a column and choose outcome based on Criteria.

    First time posting here. Hope I've got this in the right place. My experience with Access is limited, however, with alot of "googling" I can usually get things figured out. I have used the Northwinds template db to create a database here at work that ties together Projects, Opportunities...
Top Bottom