ispaydeu

Done, thank you.

Sorry, wasn't sure if this should be own topic, or if it should be under the original annoucement of version 3.8. So I posted it under the annoucement of version 3.8 and am also posting as a seperate topic. ******* There is a bug with version 3.8 that was not in prior versions. In one many of my macros, they are setup to send out emails with an attachment. The attachment is often derived from variables that determine what the attachment should be. These macros have always worked fine. Then yesterday, I upgraded to 3.8 (previously on 3.7d) and the attachments stopped working. All of the emails had an error at the end of the email that said the following: "begin 660 \\shared\filename.zip ` end" Where "\\shared\filename.zip " was the filename that was going to go into it. But the attachment was never there. Never seen the "begin 660" or "end" at the end of the email before. I downgraded back to to 3.7d and it fixed the problem. Just a heads up

There is a bug with version 3.8 that was not in prior versions. In one many of my macros, they are setup to send out emails with an attachment. The attachment is often derived from variables that determine what the attachment should be. These macros have always worked fine. Then yesterday, I upgraded to 3.8 (previously on 3.7d) and the attachments stopped working. All of the emails had an error at the end of the email that said the following: "begin 660 \\shared\filename.zip ` end" Where "\\shared\filename.zip " was the filename that was going to go into it. But the attachment was never there. Never seen the "begin 660" or "end" at the end of the email before. I downgraded back to to 3.7d and it fixed the problem. Just a heads up

Is there a way in a macro to easily go back to a different part of a macro and start from there? For instance, I have a macro that some users use in which they fill out a series of prompts and multiple choices, and based off of what they fill in certain things occur. The users have requested the functionality of some sort of a "back button" and the idea I had was just to make that an additional option on the multiple choice menus. Then, if they selected that I wanted to be able to send them back up into the macro the the previous prompt. I am sure I could probably find some way to do this using repeat commands, I just didn't know if there was an easier way. Any recommendations? Is there a go to command I am just not aware of? Matt

Anyone know how to go about sorting a text file based off of a field in it? Lets say I was using the ASCII processing, and wanted to sort off the 3rd field in the file using ME, is this possible? Matt

Nevermind, I am an idiot, I had a rule setup that was removing the emails. Matt

Everyone, I am trying to send an email within ME using the "E-Mail Send:" command. I need to use a variable as the TO address. The variable is being stored correctly as an email normally would (@something.com). But, when I go and put in the TO: line "%T62%", it shows up in the TO box, but when I go back in, it disappears. When I run the macro, it will not send out the email. But if I look in my email log, it shows up as though it did send it out and the TO that is used is the contents of the variable I was trying to use. But nothing is sent!!! All I am trying to do to test this is email myself, so the variable is populated with my email address. But I do not receive the email. Now if I go in and actually type in the email, instead of put in the variable, it comes thru just fine, so I know it is setup fine. Any work arounds any body knows? Matt

Paul, I took the avi off for now, there was some product info on there that should not have been recorded. I will try to get a reivsed avi soon. If you could look this over with a nonhalting autoexec it would be appreciated. Matt

Paul, I am positive this is an error. My guess would be if cause a dilberate error in your autoexec macro that would halt the macro completely, then it will allow macro express to move on immidiately. I would recommend setting your database autoexec macro in a way where it has to do something and completes succesfully, however, set it up so it has to do SOME sort of modifcations or something so that it takes time to do it, that way it is more obvious to see the fact that ME can't move to the next step until access is done. I tried to recreate what your talking about, where all the access database does is have a function in it that is not a valid function. First, I wasn't sure if you meant that you put that in as your line in your autoexec macro, and just made the function "testit", or if you meant you used your macro to run a query that had a bad function in it called "testit". Either way, I am not getting the results you have. I would say to confirm 100% that this is a user issue on my end, first try to setup your autoexec so that it does some sort of process, but set it up so that it doesn't diliberatly crash. I think you will still see what I see. I uploaded/attached a avi recording of my screen. You will see I only have 2 lines in my ME, one that opens the .mdb (access file) and the other that just puts in a pause display box immidiately after it. but you will see when I open my access file it will not pop up with the pause prompt until access has completely finished. You will notice that instead of using the "launch" option I am using "Open Folder:" command with a direct link to my access file. This same error occurs regardless of using the launch option or folder option. I just use the folder option because some of my autoexec access files process so quick that macro express can't determine they are open and then errors ME off, but thats whole nother thing unrelated. So, please view my avi and give me feedback. Also, if you could try it again on your end but this time without a diliberate crash. Also, you will see that in the lower right corner of my screen the running man goes the entire time the access is running and that the pause prompt will NOT come up until access is done, yet I do not have any wait commands in at all. Please provide feedback, this is stumping me. Matt

That would work great, except that it cannot get to the point in which an if statement would read. The second I call up the access program that has an autoexec, it will never allow macro express to perform any actions at all (evaluate an if than, open a program, move the mouse) until the access finishes its autoexec. Matt

Paul, did you have a chance to look at this? It's a doosey. Matt

There is nothing special to my macro at all, if i just set it up with 2 commands as follows... Program Launch: "Access database that has an autoexec macro inside of it" Program Launch: "notepad.exe" The notepad.exe will not be launched until Access's autoexec macro completes. Try it, you will see what I mean. With anything else, if I was to launch excel then notepad, it would open both immidiately, but with access, if the access has an autoexec, it will not open immdiately. I am not trying to do anything special, ideally I would like to set it up so that if an error message were to come up that I was able to press enter using the macro. But it will NEVER occur because once the error message comes up, macro express will still not move on until access's autoexec is done. And since Access autoexec is never complete until enter is pressed on the error messge, it will just halt and never finish. Matt

My problem is not knowing when Access ends or not. To answer your question, my autoexec macro does quit out of access automatically. My problem is not knowing whether or not access is closing. My problem is being able to perform actions while the autoexec is performing. So, if a null error or another error was to present itself, I can take the appropriate steps to fix it. Regardless of that, I don't even need to use a "wait for terminate" command because the next action in my macro will not perform until the autoexec is completed, so if it never completes, it will never move on in my macro, which is what I need help with. Matt

Also, I can start the Access database with the autoexec in it, then start my macro express, and it will perform actions just fine. Its just something about launching a database with an autoexec in it. Matt

I am aware that, in the Autoexec macro I can select "SetWarnings" and turn off all of the warnings. However, I would still like to be able to do things while access is processing. For instance, if I have a long Autoexec macro that takes more than 15 minutes to process, I need to ensure that my computer will not be getting locked up or else the rest of my macro will not run (normally I have my macro move the mouse in between events so it won't lock up. If I cannot move the mouse because access stole my macro process, then it will lock up! Please help, Matt