Search results

I have users who use win NT and I want an automatic email to be generated. So I cant use the SMTP method, since it is Win NT. So I am resorting to using Private Sub Command0_Click() DoCmd.SendObject , , , "mmajewski@alliancebankna.com", , , "test Subject", "BODY" End Sub How would I add an...

behind the button put this code Private Sub yourCommandButton_Click() Dim answer As String answer = MsgBox("do you really want to run this?", vbYesNo, "Confirm") If answer = vbYes Then DoCmd.RunMacro ("yourMacroName") End If End Sub

no problem:D

sstreet, you stole my avatar;)

this is a Windows API call. Check out this site for more info on API's http://www.mentalis.org/vbtutor/tutmain.shtml

cool that would be great!

probably not possible just gives a syntax error

I was just starting to get into SQL and it was listed among the other commands so was just experiminating.

do you ahve to put the full path of when it is located?

database

OK Im the biggest idiot in the world:mad: I meant DROP DATABASE myDatabase This is what I actually to type

that was just a typo. sorry. I have tried this in Access. Do you have to put the path where the DB is?

How would I run this code to delete a database? "DROP TABLE myDatabase" Is this more a Oracle type DB command? ie not for Access.

works great thanks!

I am calling the windows calculator from my DB from a button using a shell call. IT works fine however if the user clicks the button again it will start a new instance of calculator. I would like to be able to stop this before they open it if it already running. How do I check if the windows...

could you post in 97?

I have two tables that you can see from the attachment. What I need to do is have a query that looks up the info from the two tables and returns the itemDesc, the AmtonHand and the ReorderAmt. I just dont know how to set the SQL up for this or if I am having problems because of my...

i dont even think you can run Acces on a Mac. I could be wrong. But anytime I have seen the Office Suite for Mac's it is never on there.

nevermind. I just added this to the "Total Days" textbox =(IIf(IsNull([Day]) Or IsNull([DayTo]),1,funWorkDaysDifference([Day],[DayTo])))+(IIf([check12]=-1,0.5,0)) Thanks for your help!

here it is sorry