Search results

  1. S

    sendkeys alternative

    Correct, it works when I open the form directly from the navigation pane. But when I open the form using a command button in a dialog window, clicking the buttons does nothing. I'm using a command button Onclick data mode: edit window mode: Dialog
  2. S

    sendkeys alternative

    go to the next page for one button, previous page for the other button
  3. S

    Limit items in a combo box

    Make a find unmatched query using the wizard using the table as the first one and the query with the entries you want to exclude
  4. S

    sendkeys alternative

    So I have a binder with pages of cards, 3x3 on each page. I created a form with entries displayed also as 3x3 per page and command buttons for next and previous pages. I was using a report but switched to a form so I can update the inventory for the cards as I go from page to page. It's much...
  5. S

    createNew record macro

    I have a Product table for cards, each card has a foil version and a regular version, so I'd like to automatically create an entry for the foil product. I was trying to run a macro (CreateNew) in the after insert section of my Products table. CreateNew would create a new (almost duplicate)...
  6. S

    Create new duplicate (almost) record

    I'm trying to create a new record in the same table that is a copy of itself except the original would be regular, and the duplicated one would be foil Basically if I insert a new Product, it checks if the product was a regular or foil card. If it was a foil, then Products.CreateNew runs, with...
  7. S

    duplicate values in form

    so while trying to convert to mdb format, I had to delete data macros, and then I realized, it was working! apparently this is causing problems, I started with a template, which had built in macros, I must have broken this one: Products: Before Update <?xml version="1.0" encoding="UTF-16"...
  8. S

    duplicate values in form

    is it showing the error? just in case https://docs.google.com/open?id=0B0RLVeeWAtNxX0wwRVQtVGtVT3M 17th time's a charm, I've renamed this one to smaller version and tried to simplify it. It should say smaller version instead of cards that way I know we're both looking at the same file
  9. S

    duplicate values in form

    scroll down, I thought I had deleted the rest, all of them don't work though. Innistrad has data to experiment with though, anything you click, should give the error if you edit the binder checkboxes or color, number etc
  10. S

    duplicate values in form

    I uploaded a newer version, I think i've altered the layout a little bit since I uploaded the first one. The table structure and relationships and such should be the same though https://docs.google.com/open?id=0B0RLVeeWAtNxbkN5Wk8tRWN5cDg
  11. S

    duplicate values in form

    Main, click cards at the top, select Innistrad, click edit and try to edit any of it, errors, but when I edit the inventory table it works fine
  12. S

    duplicate values in form

    I started with a template, it already had two of the three primary keys. I made the last one myself, but I forget how with a webform. When I looked at the query to check, in design view where the tables are, it had the primary key symbol next to the id's that I mentioned. not sure what you...
  13. S

    duplicate values in form

    blah, http://www.filefactory.com/file/2edwa3dd7pv3/n/smaller_zip maybe google docs doesnt like zip files
  14. S

    duplicate values in form

    zip file 8mb https://docs.google.com/open?id=0B0RLVeeWAtNxYWhMcTJtclFqV3c or rar file https://docs.google.com/open?id=0B0RLVeeWAtNxaU5qaDg0c2tWXzA
  15. S

    duplicate values in form

    I've uploaded a .mdb version: https://docs.google.com/open?id=0B0RLVeeWAtNxRkdSa05mak1kRUk These fields are not the primary key and do have many duplicates. One of them is a checkbox called Binder. Also, the changes are saved even though the error says they are not, and I am able to make the...
  16. S

    duplicate values in form

    I have forms that when I edit them say: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship I tried creating a new database form, any based on queries cause the error, but database forms based on my...
  17. S

    subform allow additions works sometimes

    Access 2010 web forms yup. I am using macro tools, pretty sure I can't use vb code because it is a web form
  18. S

    subform allow additions works sometimes

    anybody? bump
  19. S

    subform allow additions works sometimes

    I have a form (edit inventory) with subform (inventory levels) that when first displayed, does not allow additions (inventory levels does not allow additions). However, once I filter my subform by fields, it allows additions The filter's code is paraphrased to: browse to: inventory levels...
  20. S

    subform based on combo field

    I am trying to alter a template (Desktop Product Inventory Database). I have it pretty much set up the way I'd like it, however I am having problems with my PurchaseOrderDetail form. I'd like to be able to select a category, and have the subreport only show cards from that category. I tried...
Back
Top Bottom