Search results

  1. C

    Guidance on a Parts Tree Database

    Thank you @plog for your speedy and efficient reply. That has helped my understanding significantly, I guess sometimes its just helpful to have a second voice who understands this stuff better to explain it. The likelihood that I would want to expand it is small, but none-the-less, it's good to...
  2. C

    Guidance on a Parts Tree Database

    Here is a copy of the database .zip file, which contains the access file. I'll take a closer look into that link and let you know if it helps my understanding. Thanks for responding so quickly!
  3. 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...
  4. C

    Solved Formatting a field on a form

    Nevermind, I seem to have fixed the problem! I had to delete and replace the subform, but now the formatting is carrying over!
  5. 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...
  6. C

    Open form to specific record after status update

    I thought about doing something like that, but I'm not sure how to set the Where argument up so that the new form has the record which has had its status updated to "Completed"? Because I can't just open a form which has all records which are completed, as it wouldn't open to the correct...
  7. C

    Open form to specific record after status update

    I'm pretty unfamiliar with how openargs works, could you possibly give a very general example of how I might do this?
  8. 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...
  9. C

    Combo Box Troubles

    Apologies if I am asking too much, or am asking silly questions. I am just very much new to the Access scene. I was not looking to take up more of anybody's time than they were willing to give, and by no means looking to upset anyone. So, once again, my apologies if I have asked too much, or...
  10. C

    Combo Box Troubles

    Just one as far as I'm aware EDIT: I just found that I did have 2, I changed it to 1, and now I get a longer drop down menu from the combobox, but it is completely blank. Almost like the entries are there but displayed in white text or something. This isn't the case, because if it were then I...
  11. C

    Combo Box Troubles

    I was thinking that whoever is in charge of the database would be able to add a new category to the ProjectLead field, but this possibly wouldn't work as I think it might.
  12. C

    Combo Box Troubles

    Great, thanks for your response @pbaldy ! Do you have any ideas about what's happening when my combo box is missing options that it should have? I have 6 different employees listed in the Row Source section of properties, but it only shows employee 2, 4, and 6. Does it need a control source...
  13. 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...
  14. C

    SQL Injection on New Record Form

    Ok, perfect. Thanks for the confirmation
  15. C

    SQL Injection on New Record Form

    So in this particular case, I don't have to worry about it?
  16. C

    SQL Injection on New Record Form

    Sorry, I was a bit ambiguous there. I don't think that I'm executing SQL statements in the form. The Save Button has the following code behind it: Private Sub saveProjectDetails_Click() DoCmd.Close acForm, Me.Name, acSaveNo incrementMonthNumAndCreateEP End Sub Private Sub...
  17. C

    SQL Injection on New Record Form

    I don't think so. It's purely just a form to create a new record. I'm not entirely sure of the inner workings behind it. I've attached an image. The save button closes the form, and runs a couple of queries using one of the date fields to create a string of characters and numbers.
  18. 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...
  19. C

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

    With regards to the autonumber situation - as much as I would love to do this and make it more simple, I unfortunately don't make the rules for how the company wants the numbers formatted. I think the general gist is to have the project list be more organized, because with an autonumber, it...
  20. C

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

    Thanks for your detailed reply @The_Doc_Man Very helpful and great advice, and thanks for your patience with my lack of VBA and SQL knowledge. I'll be sure to make another comment when I come across more problems. Have you got any recommendations for any "How to get started in VBA" type...
Top Bottom