Recent content by mistercormell

Yes, that sounds right. However the only reason I need to take data from tblprojects is because I want the title of the project rather than just the ID that can be found in tblasso_projects. I will give it a try later tonight

THanks for your help so far, it is appreciated. I altered the SQL for qryneeded and solved that problem. However with the other three it won't let me just change inner joins to left joins (or even do it by clicking on the join lines in the query design view) because for those, three tables are...

How would you go about creating one of those in my project, plus how do you know when to use right and when to use left joins?

I have had alook into this problem and I can understand now why Accding this, and as you say it is a design problem. In the database I have 3 tables: Associates (staff, volunteers, funders or just general business contacts), Clients, Projects. Both associates and clients can be assigned to...

I have a real issue with my database and a large number (not all) of the queries that make up the database system. The information is presented as reports but it is a problem with the query not the reports. It seems that I have a simple select query that does a few calculations and other stuff...

Just asking to see whether it is possible to run a report that creates a chart, and then copy the whole object into a word document. There is no copy and paste option, and I have tried exporting it across, but it only transfers the title and the report header, not the chart object itself. Any...

Problem solved: I had a look on Microsoft's site, and found out that I just needed to add the line: SQLStatement:= "SELECT * FROM [name of query or table]

I have got a little further, but have not yet found a solution to this problem. In my code, I only want it to load up a mail merged document as part of the coding. What is happenning when it is loaded up by VBA, is the data source is not opened and so that is why most of the mail merge toolbar...

has anyone got any light to shed on this problem?

I have created a variety of mail merged documents that are opened by a visual basic procedure using VBA from within my database system. e.g. the document is selected in Access from a drop down box in a dialogue box. The 'OK' button is clicked and visual basic loads up the document selected, my...

Yes that's right, it dpeends on how you want to go about it: the final solution you gave was what I tried to do originally- which was to set the allowable data, but since I had no success with that I decided to set the validation up so that it flagged up when incorrect data was entered (ie. when...

so you can use, the same line of code (except in parenthesis) for the form events in the table properties- that way they do the validation for you?

I had a long journey this afternoon and hadn't seen your answer at that point so I worked it out for myself! Instead, I used a macro and attached it to the Before Update event of the form. I used a condition that showed the two incorrect options (number and no date, and date with no number)...

How would you go about doing that in the forms then?

Hi, I have a table of associates, that have two important details stored about them: CRB Number and CRB Issue Date. Not all of the people need to have a CRB check (so won't need to store either the number or the date), however some do. What I want Access to do, is to validate at record level-...