Search results

I have considered reports, in fact those would make my life a whole lot easier. Unfortunately I am working with external departments who want the data I collect to be sent on to them using their word templates. Aside from copy and pasting into tables on the word documents the only way I can do...

To clarify, VBA code I put together exports data from each field in a form to my template document. The simplest method of getting each data field from multiple tables into one form was to create the query above containing all the data I wanted to export, opening it in a form and exporting.

Thanks for all your input, the advice you have provided is invaluable. I am working to normalise my tables, however, this is more of a proof of concept and does not represent my final design. Admittedly, access is new to me and this being my first project the design far from ideal. However, for...

Thanks for being so patient! See attached. :cool: (Query isn't working now I deleted data, not sure why?)

Put simply the purpose of my database is to collect information on clinical trials along with the names and details of the individuals involved with each study. There are up to 4 people involved with any one study. The investigator, the coordinator, the research nurse and a data manager. I want...

Having replicated your table structure I am not having any luck I'm afraid. See image attached. What you see here is returning four results for one trial, which is what I wanted to avoid. I need to create a query which has the coordinator, investigator, nurse and data managers contact details...

Thanks Jdraw, very helpful stuff here. Now I'm left scratching my head, how can I structure a form that allows the user to select a member from my table of staff and assign to one of the four roles I have created. I imagine it involves sub forms... and I want to do this from the main trial data...

Thanks, I'll try replicate this and report back how it works out.

See attached. You will see the queries that I tried to create in order to assign staff to a role within each trial. This was a work around to get each employee within one record but hasn't been working for a while. Any tips would be greatly appreciated, thanks for looking.

Thanks all for your replies. Yes there are many people associated with many projects, I think that's where I have been going wrong. I have tried to upload the database to the forum with no luck, will have to wait till I get back from work. I have 2 tables. tblTrial (my projects are clinical...

Hi Folks, I tried to explain my problem previously, but from a different angle and think I didn't get across what I needed to do properly. I'm at a bit of a dead end with my database. I want to use a query to collate information from two tables so I can export single records to a word...

Yes I did explain it rather poorly, for that I do apologise. I did fix it with a bit of trial and error, without the use of pks and fks... It was a one to many relationship, rather than a many to many, hence the confusion.

I tried that, but because all the contact details are coming from one staff table, when I try to obtain the address telephone number for the project coordinator, the minion (:P) and the mananger it doesn't query correctly, because they are all coming from the same table. I can't put a pk in a...

Hi guys, Trying to get my head around how to setup my tables and relationships. It's more complicated than any of the references and tutorials that I have read through so have no choice but to post asking for help. I did try to work it out on my own, honest! I have several tables and queries...

Thank you for such a detailed response, worked perfectly. Access 2003 doesn't have the elipsis icon, however I was able to use the expression builder from the toolbar prior to editing the form. Much appreciated!

Conditional formatting expression from a subform or table value Hi, I have two related tables and a form and subform. The main form [frmTrialInfo] contains data from [TblTrialInfo] and a subform [subfrmChecklist] with data from [TblChecklist] I want to use conditional formatting to bold a box...

Hi, I'm using Access 2003. Actually I was able to get around this issue by placing the milestones and comments forms in a subform within the main form, that way the foreign key was automatically entered in the related tables. Is this a limitation of access or are there means of doing this for...

Hello, I was hoping one of you kind people might help. I have come undone trying to simplify my access database. I have a built a database to record and collate info about clinical trials that are run within my department. I have one large table [Trial Info] which contains all trial info and...

Hi Access7, Thanks for the tip for using the Macro function, I have manually exported data from a report with excel, then recorded the macro and found the code, could you highlight the part of this code where you have done so? Haven't been able to get this to export the data! :S

I just want to say I have the same problem, haven't been able to find a resolution either, this seems like something someone, somewhere must have tried before! I just found this thread, which may help: access-programmers.co.uk/forums/showthread.php?t=143884&page=2