Search results for query: *

Is there a way to manipulate BO from other applications? example: using CreateObject(Excel.Application) I referenced the BO 5.1 ObjectSet and tried CreateObject(Busobj.Application) with no luck.

IS THERE A SWITCH FOR RUNNING A MACRO FROM THE COMMAND LINE IN BO? IF NOT IS THERE ANOTHER WAY, LIKE AN ON_OPEN EVENT SO MACROS CAN BE RUN IN BUSINESS OBJECTS USING SCHEDULED TASKS?

I'm pretty new to business objects but have been working with MSAccess for a few years now. Is there more functionality with business objects? Is there anything in business objects that compares to using recordsets in MSACCESS? Is automation possible between business objects and MSOFFICE...

The only drawback is the process won't be completly automated. it only brings up the exchange dilog box and fills in sender + subject + attaches open worksheet It doesn't actually send the message. Still looking for a better way

I checked the help file for Excel VB a little better and found this: Application.Dialogs(xlDialogSendMail).Show arg1:="Test@test.com", arg2:="Subject Here" Is there a better method to use?

Oh, and the mail client is Exchange, using Exchange Server

I did try recording a macro and using the SendTo - Mail recipient Command, Which generated this code: Application.Dialogs(xlDialogSendMail).Show But Unlike Access SendObject there is no where for Subject, Body text, TO: , And CC: Is there an easy way to do this in code? I'm pretty new to the...

I was wondering if there is a simple way to Automate sending a spreadsheet via email to someone in Excel In Access I use Docmd.SendObject. Thanks

I have a data entry form with record controls disabled but users with scroll mice can scroll through records with the wheel bypassing the control box property. is there any way to disable the scroll wheel from doing this without confiscating the scroll mice?

...SUPPORT THIS PROPERTY OR METHOD" This is the code that I have attached to the ON_ENTER event Dim STRSQL As String STRSQL = "Select * from ORDER_PROCESSING where" STRSQL = STRSQL & " ORDER_= LIKE *" & Me!ORDER_SEARCH & "*&quot...

The code docmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 works fine, it was generated by the command button wizard I was just curious about the visual basic equivelent

Mental block here, how do I update a record on a form? for example, instead of scrolling up a record then back a record just attach some code to a button to refresh.

Are you getting copies of the report or extra blank pages?

Sure you can do it, just not with an access default button. you need to design 2 images in photoshop. 1 button in normal view & 1 button in pressed mode. then place the normal button image on your form and change the image property with the on_mouse_down event. you can also make more...

The only way I know of to properly export access reports is to use the snapshot format. The only darawback is that users who wish to open the snapshot files will need the Snapshot viewer installed on their machine, available free from the microsoft web site.

I am trying to convert a query into a comma deliminated format and then email it. However when I use the SendObject command and specify a txt file as the source I get only a text version of the table. is there a way to use access built in text output or will the text have to be manipulated in code?

thanks will5 I think that will work even better!

Not a true fix but I converted the date into a text string and worked fine

I am trying to export a query into a comma deliminated text file. however my date field is outputting strange results. Example: ,10/1/00 00:00:00, I want only the data output without the time. I tried changing the format to short date with no success.

It does look like it doesn't work with access tables (I always use SQL tables linked in access) You could try a TOP 25 query but anything else would have to be in VB. OR you could set up an ODBC driver for ACCESS (I think windows95 includes these.) And then link your tables Via ODBC (You will...