Search results

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

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

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

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

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

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

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.

I need to have a database that users can add actual files into, not just a link. These files could be Autocad drawings (1MB - 2MB) , Word documents, PDF or Tiff files. Any suggestions.

I am writing a drawing management database. I have the first part working which allows entry of job, drawing number and revision. I now want to add the facility to record issuing the drawings. Drawings are issued with a transmittal form and I want to add pre selected drgs (between one and all)...

I have a form of current jobs which has a subform showing a drawing list for the selected job. I have tried displaying this as a datasheet and a continuous form but they both appear 'a bit naff'. Is there another alternative to show the drawings as a list without dividing lines etc. However I...

I have a combo box on a form which allows me to pick from a pre-entered list. I can enter my own values into the combo box but this doesn't save into the combo table for use in other records. Can I update the lookup table from the form / combo box

I've written several simple databases succesfully but am now trying something a little harder and not sure if I'm missing the point somewhere. The database is a drawing management tool and the structure seems to be a job can have many drawings, drawings can have many revisions, revisions can...

I am writing a skills / contact database. I want to select a discipline from a combo box and then select a specialism from a second combo box. This works in table view and in querys but I am not sure how to do this in forms. At the moment the second box displays all the specialisms what ever...

I am a fairly new user of Access and need some help with some code. I have a date field which is filled in by the user containing the date a drawing is received into the office. I want a second field to be automatically generated for the date the drawing needs to be processed by, date in + 14...