Search results

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.

I have a database which keeps records of documents rec'd. Various information is held such as date rec'd, if the document has been reviewed, if the document was approved, etc. I want to produce a single page summary report showing how many documents have been rec'd, how many awaiting review...

OK, I've started again. I've copied the code and associated it with a button. I've made a query with a drawing title field and a date rec'd field (rec'd). Generated a report, datetry. In the query I have criteria 'Between [txtStartDate] And [txtEndDate]' I know that the query works and I...

Syntax error The original post was exactly the problem I was having. I've copied the code into my application with a change for the report name and field name but get run time error 3075 syntax error in query expression '([rec'd]>=#1/5/5# And [rec'd]<= #1/6/5"#)'. Any suggestions please

I have a field document number which auto increments with a format 0000. I also have a revision field. I want to produce another field with a format 0000 Rev 1. I've entered control source as =[document]&" rev"&[rev] and want the result to be 0001 Rev A but the result drops any trailing zeros...

I have a main form of jobs and then a subform for drawings held on that job. Can I easily make the sub form display 10 records and then have a <next page>, <last page> at the bottom of each page.