Recent content by tbaxter

Well, here's an odd development. I made a minor adjustment and now the failure mode field is populated, based on the paragraph numbers, I suspect. But I need to update them to further identify them. As I mentioned, one paragraph may have both insulation and continuity checks in it and I want...

In the table, queries, form and reports, it shows up as 6-66.2, etc. It's just in the drop-down list (combo box, whatever it's called) when I'm trying to associate the paragraph with a particular failure mode on the input form. I want a quick recognition - I don't want to have to stop and...

Actually, I do have that field set as a text field. Was my mistake in setting up the input mask? By using the mask, does that do away with the dashes and periods? The data type is text, field size is 8, input mask is #9\-99.99;;_. I thought I had set it up to store the dashes, etc., in the...

Looks like I need to pull out my old textbook or Access Bible (it's a 97 Bible and my Access version is 2003 but the method is probably the same, right?) as I don't remember how to do this (so that it will work, that is)! That old saying "if you don't use it you lose it" is definitely true . ...

I have my database done, for the most part. But I want to add a lookup to a field in my Component table so that I can associate a particular number (paragraph number in a pub) to a failure mode description. In the Failure Mode table, I have associated a paragraph with a failure mode: Example...

Well that explains it! LOL! Now I feel REALLY stupid! For some reason (unknown even by me), I had it as a text field but with a date input mask. I made the change and it sorted beautifully. :cool: Thank you!

I've done a quick search but haven't found a solution. I am trying to sort within a query before making a report from that query. I need to sort by date. Currently, it is sorting by date but by month instead of by year. So my data is being sorted similar to this: 11/30/2004 10/18/2005 . . ...

Wow, Rich! Once again, you saved the day! :D (we need a smiley that is jumping up and down for joy) My little database is complete. My life will be much simpler. I am content. Tina

Wow, I learn something new every time! I've never even heard of parameter queries. I'm off to run some searches on that topic. Thanks again, Rich. :)

Okay, now for my next question . . . with heartfelt thanks for Rich for helping with my last question in the Forms forum. I wish to make this resource (db) that I'm working on (purchase log) available to my certifying official(s) to assist in official audits of the purchase program. Therefore...

It worked! Yippeeeeee! Rich, you're a life saver. :D

Geeze, that's what I forgot! The footer. Argh! Thanks a bunch, Rich - I'm off to try to fix it now . . . :p

I used to know how to do this so it’s doubly frustrating for me. I have a small database with 2 data tables, Purchase Log and Transaction Details. Purchase Log has the following structure: Transaction # - this is a text field (and my key field) because it will be assigned elsewhere – I’m just...

Wow, I must not be as much of a lost cause as I originally thought! What you are saying almost makes sense to me! Would it be possible, if doing it this way, to "assign" class numbers for each show? Argh! I'm having trouble articulating this. Okay, let's go with making a short story long...

I seem to have all the "off the wall" questions but here goes anyway. I'm building (or trying to!) a database for our local 4-H club (at no charge -- they don't even know it yet). I'd like to present it to them later this winter to use for their 4-H shows. Generally, the class list will be...