Recent content by Ciaran

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...

I figured it out, it was the characters in my table name that were screwing things up. I renamed the table and now it works.

I have most of it working now with DAO. I'm getting a sql syntax error with : dbs.Execute "INSERT INTO tbl_M:M_Form/State (Form_Number,State_ID) VALUES ('Test','Test_State');" Ciaran

Well, I'm not using DAO or ADO. All this is sounding familiar, but its been a while. Thats all the code I have, so should I just change it to ADO and activate the reference? Ciaran

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...

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...

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...

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...

Attachment

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...

The reason the conventions are bad is because I'm trying to fix a database created by someone before using only wizards. I tried that code, but the same error occurs. When you open the form and if you hover over a combo box with project id in it, you get a generic validation error. I usually...

Help! Can anyone help me with this problem? Alot of people have been looking at it, but no help yet. Any help would be greatly appreciated. Ciaran

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...