Search results for query: *

HI Andy, Haha, yeah the code is aligned properly, I had to copy it in a hurry and send it after pasting it in notepad; it lost alignment when I did it. I will check everything and see if it runs. Thank you for looking at it. Rick

HI Andy, sorry for the delay but was dealing with a TS/Hurricane from Debbie. Anyways, here is the code on form load and what I have in the module Private Sub Form_Load() DoCmd.ShowAllRecords Dim strMsg As String If Weekday(Date) = vbFriday Then strMsg = "Please Run Your Weekly Report at...

Thanks Andy, I will post it Monday evening, I am currently out of town now but I appreciate all of your help. Rick

Hi Andy (and everyone else [bigsmile] ) Unfortunately the Month end popup did not come up, however the Weekday Friday worked perfectly. I am not sure why it didn't work as I made sure all was put in properly as stated above; there was no error it just never appeared. Thank you again!

Thank you so much for everything I will put the code in and try it in real world this month end coming. One of the reason it isn't automated like you suggested (as I wanted to do as well) they wanted to make it manual and up to them to complete. Please check back on or after 8-1 and see the...

Hello, I tried the code and put the function and all seems to work except the "Please Run Your Monthly Reports at EOD!" , it just gives a blank message Microsoft Access popup box. This was putting my date and time to July 31 which is a Wednesday. I also tried it on June 28th which is a Friday...

Yes, the popups are just reminders for them to run them manually and you're correct they do not work weekends. I Want the msg popup to appear every Friday for the weekly report quote. When the last day of the month comes around I want it to appear on the day it is as long as it is Mon-Fri , if...

Andy, I did test it and it worked but I found a flaw in my own logic once it worked. What if the last day of the month was on a different week day, Or if its on a sat or Sunday I need it to show up on the Friday before that Sat or Sun. I still will need the weekly report to run every Friday...

Thank you Andy, I will try this out... you're amazing !

Thank you Andy for the reply but I am confused... Is the code you provided replacing my code or am I adding it in between somewhere?

Hi All, Maybe someone can assist me in trying to get this code to work? I have half of it working but not the month end part. What I need: When launching the database or if it is already loaded and you show all records and it is a Friday then show the message in a popup box saying "Please Run...

Zelgar, I couldn't get it to work but I found a work around by doing a vlookup+match and naming the cells to make like a table and it I am now able to get the values to come in. Thank you all for your assistance.!!!

I did include it in the information. Like i stated before, basically on sheet 1 you would type in column a the year, and select from the drop-down list in column e. the formula i am needing help on will go in column d on sheet 1. Based on what you type in column a and pick from column e sheet 1...

Hi Skip, I can't use a pivot table as I will be using the value to calculate another field in another sheet. I wish it was that easy, I know how to do a pivot table but it isn't practical in this situation. Thanks!

Good Day All ! I have an excel question and not sure how to get it to work properly. I have tried both VLookup and Index but can't seem to get it to work. To give a brief description of whats going on here is a break down of what I am trying to do: Sheet 1: Column A Column B Column C...

I couldn't get the setfocus to work properly anywhere once it tried to load the form after the password was entered. So what I did instead was on the forms that have a password I put the Modal to YES and it seems to work just fine for what i need it too. I want to thank everybody for all the...

Awesome!! That works, but one question... How do I get it to show the form or report that it opens instead of having to go up top and click it? To be clear here's what it does: I click the button from the menu and a popup form opens asking for the password; I type in the correct password and the...

its what you had earlier; the textbox is labeled whats below as well as the table ..wasn't sure on the DoCMD.Openform Me.OpenArgs, acNormal though If Me.OpenArgs & "" <> "" Then If DLookup("AdminPassword", "PasswordTable") = Me.PasswordTextBox Then DoCmd.Close DoCmd.OpenForm...

dhookom, I tried your suggestion and put everything in place but i get an invalid procedure call or argument error run-time error '5' when i type in the correct password from the admin form (where you type in the password) thanks

Yeah, that sounds awesome and would work perfectly IF they logged into the computer with their own credentials but as it is now there is only 1 login and thats the way they want it..I know stupid but, i didn't make that command decision [mad]