Search results

Thanks for all the help - I've just changed my form to use tabs and subforms - it works well and looks better now! What I did in the end was set up a main form based on my query qSelDrawingsAndRevisions. I put a tab control on the form and on the first page of the tab I put a subform...

Hi Pat, Am so sorry about that - that was the wrong screenshot of the query - I've attached the right one now. (Those 2 fields were the primary key before but I've changed that.) The relationship between tblDrawingRevisions and tblReceivedDrawings is definitely 1 to 1. When a particular...

Hi, I've been trying to get this working for days now but am not having any luck. I've got 3 tables: tblDrawingRegister DrawingNum (PK) DrawingName tblDrawingRevisions DrawingID (PK) auto-num DrawingNum (FK to tblDrawingRegister) Rev(PK) LatestIssueDate ElectronicCopy OrderNum DrawingStatus...

I really would prefer not to use subforms because I'll need lots of them if I do it that way. The master form would have to be the based on tblDrawingRegister. That would have the tblDrawingRevisions which in turn would have the tblReceivedDrawings subform. Then I'll need other subforms for...

Requery when form is based on a query that is based on another query! Thanks very much for that Neil. I've changed that to a compound index and tested to make sure it will not add dublicates. That works perfectly. I've added a new primary key to tblDrawingRevisions: DrawingID (autonumber...

Screenshots of relationships Hi, Thought it might make it easier if I uploaded a screen shop of the relationships and the query that my form is based on. : I just read that the error that I'm getting means that I have a foreign key which does not exist as a Primary key (or the foreign key is...

Thanks very much for your reply llkhoutx. Just to explain why I have a compound primary key in the tblDrawingRevisions. Both the DrawingNum and Rev are primary keys because both of those together makes each record unique. I import the drawing numbers and revision numbers from a spreadsheet and...

Hi, I've spend ages reviewing the relationships between my tables and changing my query but cannot get this to work. I've read alot of the posts on the subject also but trying to apply the suggestions to my problem hasn't worked. It is a database of engineering drawings. A drawing can have one...

Error with filters OK, I've actually changed it now - I'm using a continuous form instead - didn't know you could do that. It makes more sense in my case as the main form was not bound to the subform - it was not necessary for it to be a subform at all. I'm getting a different error now when I...

Hi Jibbadiah, Thanks for that. I have tried that and it looks great. The only thing is I will need to filter the items in the listbox in different ways. For instance I will need to show all drawings issued after a certain date, all superceded drawings or the latest revisions.. I would also like...

Hi, OK my main form is unbound and I have a subform in it which is shown as a datasheet. What I'm trying to do is have a list box control at the top that allows the user to filter the records shown in the subform. Q1. Do I need to have this set-up like this? Is it possible to just use one form...

Hi, I've been trying to get this for ages now - both in the design view and in sql: I have 2 tables - one called DrawingsRegister and a related one called DrawingRevisions. Each drawing has one or more drawing revisions. I want a query that will show each drawing (just once) that has more than...

Thanks very much for your reply. Thats exactly what I was looking for - I didn't know if using an SQL query to bring them together was the correct solution. I will do that to tie the drawing and revision information together because I will need to use a subform to show transmittal information...

Hi, I have just split up a table into tables so that has interfered with the form I had created for it. I have 2 main tables: tblDrawingRegister: DrawingNum DrawingName tblRevision: Drawing num Revision LatestIssueDate OrderNum I split them up because there was alot of dublication. One...

I know you've probally answered this before but why is it better to link? I think that I would rather to have all the drawings listed in one table rather than linking to numerous different spreadsheets. Also I need to add 3 extra fields e.g. the status of each drawing to the table - it seems...

Hi everyone, I would just like to get your opinions on this - I've been reading alot about importing from Excel and there seems to be several different options with it. Here is what I have found and the pros and cons with each method. I have an Excel spreadsheet that come in a specific format -...

Hi, I have a database of engineering drawings with fields such as drawing number, drawing name etc. I also have the corresponding image files but the filenames are different to the drawing names. I have code (thanks to ghudson!) that will open the image file and put the filename into a text...

Thankk a million for that RG - it works! Took me a little while to figure out the syntax - I had to put single quotes around the reference to the textbox because drawing number is a text field. This example explains that:http://www.blueclaw-db.com/access_findfirst.htm...

Hi, I have a table called 'Drawings register' that stores the names of technical drawings, the drawing numbers and their revision numbers. The idea is that the user clicks on the Add new drawing button on the form, enters the drawing number in the first text box and the revision number in the...