Search results

  1. C

    Increment number for each new entry, reset number at first entry of each new month

    I am very very new to VBA, so I apologize if I am going about this completely wrong. I need to create a form which can Create, Update, and Delete records from a table. Each record will have a title field, a description field, a user field, a start date field, an estimated end date field, an...
  2. C

    Sales & Subassembly Database

    It definitely does. Out of curiosity, and if you're comfortable sharing, what were the names of the apps your clients were burned by? Just so that if we decide to go that route we don't make a bad decision
  3. C

    Sales & Subassembly Database

    Thank you Pat. That is extremely useful advice that I hadn't thought of. While we are looking into perpetual license solutions, they are becoming more and more difficult to find, and so some of the options I'm looking into are web-based. I really appreciate the advice!
  4. C

    Sales & Subassembly Database

    Just out of curiosity, do you have any experience with any off-the-shelf packages, or any recommendations? I have been given a week to do research into different options, but from my research, it seems that the best option is an MRP. However, most of the MRPs that I have found are quite expensive.
  5. C

    Sales & Subassembly Database

    Thanks for getting back to me. I've done some digging and have found some useful articles, for which I'm very grateful for your help
  6. C

    Sales & Subassembly Database

    The company that I work for wants to potentially use an Access database to hold Sales IDs (lists of subassemblies to be compiled into a sale product) and to hold a list of subassemblies, which are grouped together in each Sales ID accordingly. Eventually, they are hoping to expand the database...
  7. C

    Auto-fill one table using records from another

    I have tried that, but I am still very confused. Any extra advice, however simple, would be appreciated
  8. C

    Auto-fill one table using records from another

    Thanks for getting back to me so quickly. I'm wondering if there is a simple way to auto-increment the number at the end of my project numbers (i.e. I have "PO" & "yymm-" & "00" currently), but have the last two digits reset at the beginning of each month? I have done lots of research, but I am...
  9. C

    Auto-fill one table using records from another

    I am extremely new to Access (started 2 days ago) so please excuse my ignorance for seemingly obvious solutions. I have a table with 3 fields, which I can then run a query on to combine the fields into one text field in another table (custom project numbers). 1. Is there a way to have Access...
Back
Top Bottom