Search results for query: *

Hi All, I've been using code that was posted here to send emails automatically through VBA. Works beautifully by the way, thanks. The only missing item is to close the actual email client. The CreateObject("Notes.NotesSession") does the opening work but I haven't seen anything that can in turn...

Thanks ecwcee. I did just that ( Request.Form ) and it worked. I had tried this earlier but to no avail. I must have misspelled something. Thanks again for your help.

...MY_MOVIE_RIPPER, MY_MOVIE_ACTORS, MY_MOVIE_NOTES, MY_MOVIE_PLOT MovieTitle=Request.QueryString("MovieTitle") If MovieTitle<>"" Then SQL = "Select * From Movies" SQL= SQL & " Where Title = '" & MovieTitle & "'" SQL= SQL & " Order By Title" Else SQL="Select Top 1 * From Movies" End IF Set...

Thanks for your reply Pascal...I was afraid that this was going to be the case. I have an Access module that I am using to do this and our IT dept was giving me grief. Looks like I will have to fight my case for Messenger service access.

Hi, I am trying to create a simple MessageBox pop-up from an agent. I want the agent to check all incoming emails as they arrive and if the Subject field matches a condition, create the pop-up message box. I am having a helluva time getting this to work with LotusScript. I have the correct...

Thank you both for your responses. TheFitz: Did you shell the command for SQLLDR.exe and call it from VBA ? If so, what did your VBA look like ? jmeadows7: I am unfamiliar with PassThrough queries. Do these work for all ODBC databases or is it restricted to SQLServer databases ? Thanks

Hi All, I need some help in figuring out if there is a faster way of appending data to an Oracle BE table. I have an Access database that opens a recordset and reads a field. The VBA code then needs to convert the field data ( which is a series of ASCII characters ), convert this ASCII...

Way to go vbsun !!! 2 stars for you. I have been looking for this encryption method for a long time. Thanks

Sorry folks, Don't know much about arrays... What would this code look like using Craig0201's comment about "Change every returned array to a variant and replace every call to an enum value with the integer equivalent. I've done this and it works fine."

Hi All, I have run into the same issues where importing the MSysObject table into a blank database provided all of the information required to access my data. There are a number of things you can do to help prevent unauthorized access. Because of the many add-ins available that will provide...

I use a similar code but one that does not necessitate the use of the AppActivate command. I have created an initialize module that sets the communication between My Access database and the CICS session. This was, regardless of what I am doing, the send.keys command will work, even if I am not...

...AS Expr1 FROM qryCrediteringenVT WHERE (((qryCrediteringenVT.Product)= &quot; & txt_WHERECLAUSE & &quot;)) GROUP BY (Year([Datum])*12+Month([Datum])-1), (Format ([Datum],&quot;mmm&quot;&quot; '&quot;&quot;yy&quot;)) PIVOT qryCrediteringenVT.Product; DoCmd.RepaintObject acForm,&quot;Your...

Take a peak at this thread...there is a link to a site with code that may help you out. http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=350

You can automate the linking of tables from Oracle or any other ODBC database to Access. The simplest approach that I have used is to use the DoCmd.TransferDatabase method from Access. A word of caution here...some databases will require you to still make some kind of manual selection ( for key...

Don't want to be sacrilegious but you can check out this link... http://www.mvps.org/access/modules/mdl0007.htm

Hi, I am using the TransferDatabase command to reconnect to an ODBC database ( Sybase ) from Access. I have no problem at all with the code to connect however, I want to perform the database update through my scheduler on WINXP. Each time I reconnect to the database, I get asked to &quot;Select...

Try this... Go to the subform in design view. In the form properties change the form's Default View to Continuous Forms instead of Single Form. This will create a new series of fields for each record you want to display. Just make sure you have enabled vertical scrollbars on your subform incase...

I ran into the same issue myself. Make sure to change the properties of the field in your table to a number. And you will also need to select Standard in the Format property for the same field. This will take care of your decimal issue. nashman

Hi nivlac, I have just today completed and submitted an FAQ on this very issue. I have seen it often and offered the solution that I have used. Look for it soon in the FAQ section with the heading &quot;Automatically logging out idle users&quot;