Search results

  1. C

    Run Time Error 3794

    I'm getting a run time error saying that the database is locked by the Admin on my machine, which is me. How do I allow the current database be opened and updated? Private Sub cmd_Execute_Click() Dim dbs As DAO.Database Dim Form_Number_Insert As String Dim State_Insert As String Dim x As...
  2. C

    OpenDatabase VBA

    I need to run some VBA behind a command button which will run some insert sql. However, I dont know how to open the database. What code do I need? I have the following so far: Private Sub cmd_Execute_Click() Dim dbs As DAO.Database Dim Database As DAO.Database Set Database = CurrentDb...
  3. C

    Checkboxes updating table

    I'm just after beginning on a new project, but have a basic requirement that I'm unsure how I can do it. On a form, I will have a document number. This document can be associated with a number of different states ie one or many. I have set up check boxes so the user can check which state it...
  4. C

    Sorting

    I want to create a query which sorts results based on two fields. I want to sort by Project Status first and then by Project Number. Within the first field, project status, which is either open, pending, halted and closed, I want to order them in the above order. How can I do this? Any help...
  5. C

    Cumulative Total

    I want to graph cumulative totals. I have a query with week numbers 1 to 18 with the number of bugs opened during that week. I want to do a cumulative total of opened bugs which I can then use to draw a graph (ogive) I'm trying to do a query using DSum, but cant get it working. Any help would...
  6. C

    Summing in Cross Tab Query

    I want to be able to total each of the rows and each of the columns in the attached cross tab query. The query currently shows the total number of bugs per functional area. The bugs can be either 1,2 or 3 depending on their severity. I want to be able to total each of the 3 levels separately...
  7. C

    Form w/ subform Problem

    I'm currently trying to fix a bug in a form. On a subform within a form, there is a command button to open up another form. Based on two conditions, it will open up the new form showing the details of that record. (Project ID and Project Date) It works fine mostly, but sometimes it throws up a...
Back
Top Bottom