Search results

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...

Lots of views but no responses! :eek: Just bumping this up to see if anyone has any ideas that might help . . . Thanks! :)

I haven't been here for awhile since I haven't had time, lately, to "play" much with Access. However, I recently started working on a new database that is geared toward a new club. The club will eventually be holding competitions. I'm hoping to already have a solution in place for us to use...

Hi Pat, In an earlier response you said: "Your code is in the wrong event. If you want to stop an update, the correct place to put the code is in the BeforeUpdate event." I got to thinking about this and still am not clear - I don't want to stop the event, I want it to work! The location is...

Hi Pat, I put the following in the AfterInsert event procedure of the Location Form (which adds the new location): Private Sub Form_AfterInsert() ' Requery the table to recreate the recordset in the Clearance ' Detail Subform combobox Forms!Clearance Detail...

Thank you, Pat and Rich! I will try that later today - will have to work on it at home since my youngest was sick all night - just dropped in to work to pick a few things up. I'll report back as soon as I can. Tina