Search results

  1. O

    List multiple fields in one field

    OMG, how stupid can I be. Of course a union query, why didn't I think of that. But subreports, now there is something I don't know about. I am going to have to research that.
  2. O

    List multiple fields in one field

    I am trying to combined the data from multiple tables into one list in a query and everything that I have tried isn't giving me the result that I am looking for. I keep getting Err#, -1 or it merges all of data together. I've tried Nz statements with an &...I get the data merged together Tried...
  3. O

    Value cannot be added to this new row

    I am using Access 2010. I have a form with subforms and I am getting "Index or Primary key cannot be Null value" when I try to enter the data in the subform. When I open the subform directly and try to enter the data in that form I get "The value cannot be added to this new row until the row has...
  4. O

    Scheduling Assistant Form

    I have a database that we using for a catering business. Some of the things that we have entries for are the time that we leave, that we arrive, the start of the event, etc. I want to create a popup form that has slider bars to select the time instead of having to type each one in manually...
  5. O

    hide extra columns in datasheet form

    Dstone, you are exactly right. The only data in the RecordSource is the product, Qty, Price and Total.
  6. O

    hide extra columns in datasheet form

    I have a subform, sbfMeals, that is in datasheet format. The problem is that although I only have four columns of data, I have extra columns that are empty. Column 1...Product Column 2...Qty Column 3...Price Column 4...Total Then there is column 5,6,7,8 that have nothing in them. The only...
  7. O

    On an Access Rebound

    Used to work with Access on a daily basis and then moved on to other opportunities. Now I seem to be working with Access again. Live in Sandy, OR.
Back
Top Bottom