Search results

I have a union query I am using (for now) to combine several tables. If you would like some background on the setup, read this: http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=169358#post169358 I query this union for counting three items: Findings, Resolved Findings and...

Pat, thank you very much for your time. You've been a great help. It is quite possible that I will have to use a make table query. I expect each database to have at least 7500 records in it, but it should max at some point because the data will only go back three years. Then when you do that...

You have talked me out of focing another ID, Pat. I didn't want to find out what would happen in splitting them again. (What would happen, by the way?) Between our posts, I did some exploring with a union query and I was able to pull my assessments together that way. Then I built three...

Seems to me when you change the format, the field is purged when you go to data view. You could copy that data into Excel, change the format of the data there and copy it back into the table after you change the table format. Make a copy of the table and change the format just to see if it...

OK, Pat, that made for some interesting reading. My boss has a few topics that get him going when I press the "button". It seems I just found a button of yours, but I think I'll stay away from it. :) Let me back up a bit and explain my situation. I have a database built for assessing a...

Thanks, Pat, I'll try those searches. One thing I did yesterday was make an append query that concatenated the the data and appended that number. Disadvantages? Thanks and I'm off to search.

I have a numbering question. In my database, I generate a table from a query. Right now, I am using the autonumber property as the unique ID. I would like to concatenate three fields to create my own ID still unique. I want to join a Division ID (ABC) with the year from my date field (yy)...

I posted a new with more details because I forgot I had posted this. I'm not well. Anyway, I set mine up a little different and would like an opinion. It sounds like you set up a recordset to loop through as opposed to setting criteria on a query. True? Also, did you set your report to open...

Hi, all. I have a report that lists items that are overdue. I would like this overdue report to be emailed to the responsible person on the due date. I have a macro that will handle the email portion and I am using Task Scheduler to open the database daily and I have a report that lists items...

In my assessment database I have a DueDate when resolutions for findings during an assessment are due. I would like an email to be generated as a reminder 30 days from the due date. Any ideas? Thanks.

Thanks, Wayne, I couldn't see what you were saying for looking. Finally it sank in. Derrr! Anyway, that did the trick.

Sorry for the cross posting, I intended to post it here in the forms forum originally. I would like to populate a date field across a range of records by entering it one time. Any ideas? Thanks.

I would like to populate a date field across a range of records by entering it one time. Any ideas? Thanks.

Absolutely beautiful! It worked great. Thank you! Any idea why that happens with the code?

I have a button on a form that when pressed closes my form and sends a report to email recipients. This works great the first time, but if I reopen my form and try to send it again either nothing at all happens or I get a SendObect error. Should I have something else in the code to clear it...

Great! It works! Thanks, Mile and Pat. I also resolved the issue of having my statement appear when the option was selected. I kept placing the code in the form itself. I finally placed it in the AfterUpdate property of the option group and POOF there it was.

Query that table with criteria of 'true' in the checkbox fields.

I do something very similar to this in a database of my own. I run an 'append query' to my archive table, so I just keep adding records to it. Am I on the same page with you?

If I understand what you have, you need a checkbox field in your table for each checkbox on your form. Connect each checkbox on the form to the corresponding field in the table. Like I say, I think I understand what you are trying to do. Hope this helps.

The comments are manually entered after the Finding is updated. It works fine to make a selection, go to the next record and the go back to the previous record. I would like to see the Finding 'magically' appear before my eyes. I'm interested why the Select Case is a better option than If...