Search results

Perfect. Thank you very much!

here ya go. Just a summary of where data is coming from in these sheets: NL: pulls names from write-ups. Names are filtered from last month. Roster: pulls from a complete roster minus supervisors. Thank you for your time.

Attached the code to a button, but it doesn't remove the duplicates. It just switches to the sheet I want the duplicates removed from.

Hello. I am using Excel '07. My spreadsheet has two tabs that get data from access. How do I get values (Employee Name) from the 2nd tab (Roster) removed if they show up in the first tab (NL)? The NL tab is filtered as well to show names from a previous month. Will the code work with the...

Doh. That is correct. What I meant was every week. Alright made the query. Where do I put it in your code? Private Sub SelDate_AfterUpdate() Dim StartOfWeek As Date Dim i As Integer StartOfWeek = DateAdd("d", -Weekday(SelDate) + 2, SelDate) For i = 1 To 6...

I'd like to keep using the form, but I want to save the results to a table to bring up a report. The problem is that a new 6 week schedule can be made every day, which throws the pattern off. I'm probably making it more complicated than it needs to be.

@CJ_London, sorry to bother you again, but the boss has another request. Is there a way to get the data made by the form to be saved, then I can bring the data up in a report? There seems to be a loophole to where anyone can put a date in the form, and of course the schedule will display on...

That's even better than what I imagined. Thank you very much for your help!

I'm sorry, I might not have explained it correctly. In Access, under help>about, it says the version is 2002.

I wish...for some reason or another, our Access doesn't mirror what version of Office we have. Everything but Access is Office '07.

In the About MS under the help tab, it says '02 SP3. Running Windows 7.

:/ The start menu say xp...about file says '02. Says it is an unrecognized file format.

xp. dern work computers.

I'm afraid I cannot open it. :(

Perhaps I was a little hasty with the first suggestions. They are not showing up like the spreadsheet. I added fields to the table ScheduleItem1-6, and added the data like in the spreadsheet. That is data that I would like to stay the same (and repeats in 6 weeks) with the employee names...

Thank you for the help. Although these suggestions did produce, I was wondering if there was any way to make this somewhat perpetual (ie: automatically insert the date based on the beginning of the week). This way the schedule won't have to be manually updated.

Yeah, I don't have an email for your 2nd reply @CJ_London. If I remember correctly, you hit enter by accident. lol Could I pick your brain again for that info? Thanks again for your help.

I have your first reply, but the 2nd doesn't show. :(

I know there was a reply by @CJ_London to this, but got wiped out after the back-up before I could implement his suggestion. Please see the enclosed attachment. What I would like to accomplish is to make a report similar to this, except make it automated so I won't have to change the dates...

so far, so good. Thanks for all the replies!