Recent content by Lancer

bob fitz - sorry, but they are school records, and I would have to rewrite all the names, marks etc in order to not breach professional confidentiality. Besides this, I'd then have to talk everyone through a very detailed "how school records are marked" process and I'm trying to keep the...

Thanks for your input, though the method you described doesn't fully work for me The science_grade is actually a few numbers added together. When I try to link science_grade to the lookup table.... I get the error, "Calculated columns cannot be used in system relationships". What I have done...

Is there a way that I can make a field in a table (I don't mind using a query if you can show me how) which is a calculated field and gets its value by performing a look up (from a another table list) based on another numeric field for that person? e.g. In school grades, the student might get...

Thanks John - I'd been there in my search... what it seems to be is apparently different from any of the suggestions. I'm not sure exactly why it wasn't working. Is there a way to mark these threads as solved?

I've fixed it (somehow). There was an @ symbol in the Format property which seems to have made all the difference. Once I erased this, and then reinserted the field onto my forms, it all started working as expected.

I am making a database for student reports where I need field size to be more than 255. Googling has led me to an answer that text fields are limited to this amount, but a solution is to use type "memo" instead as the base datatype of the field in the table. The problem is, that while this does...

Sorry man, I'm completely confused by your answer. Look up? I went to the table "Chemical In" and tried adding a lookup column containing price per unit. It gave me the error "You entered an expression that has an invalid reference to the property |" and refused to add the column. I'm thinking...

Please look at my simple Access 2000 business database: http://www.bestsharing.com/files/6YcsupN277234/chem.mdb.html On the form named "Chemical In"... ...this is where someone enters the amount of product they are purchasing along with the purchase date. At the moment, the form also expects...

Well, thanks to both of you. Problem solved by adding a form to ender the dates, no extra tables needed. Format was =[Forms]![MyForm]![MyDateControl]. I'll hit the scale icons on you both for your speedy replies. EDIT: Sorry, did not know I could not hit scales on both of you... gave credit to...

Yes, I'd tried that. Did you look at the database before answering? The "prompt" asking for the dates comes from the query. I'm not sure that it goes to a field, and if it does I'm not sure how to link to the field in the way you say. ...but then I'm not good at Access... could someone please...

I've added a new report to a simple business type database. My report (useage by crop report) asks a user for start and finish dates for a time they want to see outgoing costs... try inputting the dates 1 Jan 2005 and 1 Feb 2005 to get the idea. The form works but... ...how do I get it to put...

Oh yes. Sorry about that. I've been working on the main database for a long time now and I've had some of those many late nighters especially of late. I guess I'm starting to sound cranky like I feel. Actually, I'm not really being paid as such for this work, I'm doing it more as a favour for...

Aha!!!! Thanks neileg.... I have a problem with the wizard (it doesn;t always fire up) but it went and I see what you mean!!! :) And y'know what? mtabrams wasn't off track at all - he actually hit the nail on the head! (I just didn't understand his solution enough to be able to implement it)...

Yes maybe, I agree with you for my own business practise... ...but then I am making this database for a very difficult customer who's dictating her own business terms. Not me. Mine is not to question her terms. I'm just supposed to get Access to do what she wants, not argue why I shouldn't...

Sorry mrabrams but I think you're way off. I've attached a simple example to this reply so you can more clearly see what I'm talking about. Please let me know if you find a solution. Thanks for replying btw.