Recent content by crescent-centre

Thanks. I'll give this ago.

Sorry, I'll try to make things a little clearer. The database is for an inhouse drawing review project. Firstly each drawing is booked into the database. For each drawing it can have many actions, that is table2. Table 1 [number, title] -------->> Table 2 [date, action, status] The data is...

I have a database with 2 tables. Table1:drawing number and drawing title and Table2: date, action, status. Table2 gives the complete history of our internal review process. Example: Number=001, Title=Drawing001 date=01/01/07, action=drawing received, status= date=02/01/07, action=drawing...

Another problem. The db is for a document review project. I have a form with doc ref and title and then a sub form which has date, action, status. Typical would be. Doc 001 Title=Layout 1) 1 Jan 07; Doc recieved; 2) 1 Jan 07; ; Awaiting engineers...

Thanks, will give both of these answers ago

I have a form which is the main data entry for a document control db. Some of the documents have a status of approved and some not approved (also a few other possibilities). If I open a report in design view I can filter the report with a line docstatus like "approved". I have added a...

I have a database of documents with title, reference number etc. I want to generate a search from the input form on any one of a number of fields. Currently I have to have a number of boxes on the form, one for each field then pass this into VB in the following format Dim searchstring As...

OK, followed your advice and have spent the last couple of hours reading up on cascading combo boxes. Followed a link www.fontstuff.com which gave a good example and easy to follow. However although I select the discipline from the first box, which then displays the volumes in the 2nd box...

I have a database to record drawings received. On the form there is a combo box to select discipline (Civil, Electrical, Mechanical) and a combol box to select the volume the drawings are in (Volume 1 - foundations, Volume 2 etc). The disciplines are stored in tblDisciplines with a...

I have a database with a table containing drawings recieved. Each drawing can have many actions, first action is sender detail, date, and letter ref. Second action is sender detail, date, letter ref and status (ie acceptable / not acceptable) I can run a query which looks for all drawings with...

A simplified version of what I have is TblDocuments counter [autonumber, pk] docnumber [number] title [text] TblActions ActionCounter [number] refnumber [text] date [date] originator [text] relationship is each doc can have many actions. example: doc-1, Ref-a, 1 Jan, john...

I have a docuemnt control database which registers documents in with number, title, date. Then in a sperate form records each department review, date, reference number, etc. All this works entering the date. Have now been asked to produce a spreadsheet type report. I need to filter the data...

Thanks Len Needed to make a few minor changes to incorporate my structure but your solution works great.

I have a database to record documents received on a project. 2 main tables, documents and revisions, each document can have many revisions. I have now been asked to add a section in for actions against each revisions, that is each revision can have many actions. Am having problems...

Ken Can you give me a little bit more of a clue. I'm new to this side of access and would really appreciate a little more help.