Search results

  1. S

    Internet Explorer issues

    No, no different brower. I believe that it's version 7.0 of Internet Explorer. The anti-nasty software that we used to "fix" was through Windows. We didn't run anything else.
  2. S

    Internet Explorer issues

    Not sure if this is the right group to post this thread, but I didn't see anything that was specific to Internet Explorer. I was having a lot of problems on my home laptop, trying to access the Internet. I could open it once, and manuever all over the internet, but if I closed the window, when...
  3. S

    Need to have SQL INSERT INTO statement

    Also, I received a suggestion that I don't need to pull from 2 tables, since I have the link in my form/subform. Here is the code that I have so far: Dim strSQL As String strSQL = "INSERT INTO tblTrainingMatrixMaster(EmpNo, TrainingClass, TrainingStatus)" strSQL = strSQL &...
  4. S

    Need to have SQL INSERT INTO statement

    I have an Employee database, that tracks Employee information and training. I have a form set up, that captures all the Employee Information, with the Employee No being the primary key. In this form, I have a subform, that lists all the training for that Employee (rows of training can be added)...
  5. S

    Filtering field in 2nd subform based on selection in 1st subform

    I almost have this form done. I have a form with a combo box, and 2 subforms from it. When you select in the combo box (Group), it brings up the choices (Sections) for that group in a subform. Then there is another subform, that is supposed to bring up a series of questions that are related to...
  6. S

    Populating master table with info from list table

    I have a form that I am working on. When you open the form, it asks for a tool # (which will be a drop-down box). There will be a command button that will bring up a sub-form. In the subform, there are 2 combo boxes. One picks the group that the tool falls under, and the other has the...
  7. S

    Filtering on Combo boxes

    I have a question about filtering on combo boxes. I was able to set up a form with 2 sub-forms, but it's more than what I need. What I want it to do, is when the user makes the selection on the first combo box, I want it to filter on that selection and then drop that into the 2nd combo box...
  8. S

    Grouping Yes/No fields

    I'm in the process of setting up a form, and I have 4 yes/no fields that need to be in it. I want to group the fields so that only one of the yes/no fields will be able to be selected. The fields are: Pass, Fail, N/A, and obsolete. I tried setting up an option group, but I can't seem to get the...
  9. S

    Need to have Query Amend a Revised calculation

    I don't necessarily need to store it, but I do need to be able to access the revision, and if there are additional revisions to the line item, be able to call out the previous revisions and update the new amount of the line item. I have attached a copy of the my "work-in-progress" form...
  10. S

    Need to have Query Amend a Revised calculation

    I have a revisions subtable off of the main requisitions table, that would house all the revised info. There is also a subtable for the line items for the requsitions, which is has a one-to-many relationship from the line item table to the revision table. Where would I want to put a new record?
  11. S

    Need to have Query Amend a Revised calculation

    I have a query which calculates and original amount, looks to see if there is an increase or a decrease in the amount, and if it's an increase, it adds the original amount to the amount of the increase, and gives a "revised" amount. If it's a decrease, it subracts the original amount from the...
  12. S

    Using NetWorkDays in Access?

    Thanks for the information. I have printed off that post, and it looks like it will help. Going back and forth between Excel and Access gets confusing, with what needs an argument and what does not. Thanks again!
  13. S

    Using NetWorkDays in Access?

    Is there a way for Access to recognize holidays in a function? I found the DateDiffW function that counts just weekdays, but I also need it to count holidays as well, within the same function. Here is the coding that I have so far, and it's working well. What I'm using it for is a "on hold"...
Back
Top Bottom