Search results

  1. C

    Guidance on a Parts Tree Database

    I downloaded a template parts tree database from the internet, just to try to get some intuition about how I might be able to create my own, or potentially modify the one that I downloaded. However, once I opened up the query, it completely goes over my head. I am hoping that someone can try to...
  2. C

    Solved Formatting a field on a form

    I have a subform in datasheet view on my main form. The table that I have stores dates as UNIX timestamps. I then have a query, which takes the UNIX timestamps and converts them into readable dates. There are 2 number fields on the table: UNIXDateCreated and UNIXDateDeprecated. On the query...
  3. C

    Open form to specific record after status update

    I have a main form, and on that form I have a combobox with employee names, and a button which when pressed, will open a new form with the project that the employee selected has worked on or is working on. On this new form, there are 8 fields, of which all are disabled except for a project...
  4. C

    Combo Box Troubles

    Hi, I'm having some troubles with a combo box on a form. I want to be able to select an employee from the combo box list, and then open a new form which will display all projects which this employee is associated with (I have a table which keeps track of projects and lead employee on the...
  5. C

    SQL Injection on New Record Form

    I've got a form which a user can enter a new record's info on. I'm wondering if it is possible for SQL Injection to occur with the user input on this form. The new record in the datasheet is also updated to a subform on my main form. If it is possible, then can someone suggest a way for me to...
  6. 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...
  7. 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...
  8. 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...
Top Bottom