Search results for query: *

I have figured it out by importing the table from database-A into the Master DB and then exporting it to database-B and then deleting the table out of the master db. If anyone is interested here is the code as I used as an example DoCmd.TransferDatabase acImport, "Microsoft Access"...

Hi All, I am trying to copy/transfer tables from one database to another BUT doing it from a master database. For example, the Master database has a button that when clicked will copy/transfer tables from database-A to database-B (so 3 databases in total) I have searched for awhile and cannot...

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