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

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?

I am trying to create a form to apply filters on a subform but I keep getting the error "438 OBJECT DOESN"T 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&quot...

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.

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?

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.

What is the best way of going about updating an access frontend? is there a way in access to automatically update the frontend when the user starts access? For example if I make a change to the front end I want the database to automatically update itself without having to email everyone the new...

How would a fields datatype in access be changed in VB code using DAO? Just need to change a text field to a numeric field

I have an Inventory table that is uploaded from a data collector. I am looking for a way in code to strip text from a whole field Using Vb. here is an example of my table PRODID QTY PART1 Q1 PART2 Q2 PART3 Q3 PART4 4 I originally tried LEFT([QTY],2) but that won't work on the...

Is there an easy way in VB code to print to a specific printer? for example.. If a Report that prints out labels is ran, then instead of printing to default printer the labels will print to Networked label printer. (Assuming user has drivers set up on his/her computer.) Or maybe A way to set...

Is there an easy way in VB code to print to a specific printer? for example.. If a Report that prints out labels is ran, then instead of printing to default printer the labels will print to Networked label printer. (Assuming user has drivers set up on his/her computer.)

I am trying to create a recordset that will take PkId And find the line in ORDER_PROCESSING table with the Same ID. this code works fine when using TEXT fields but when removing the quotes from PkdID I get an error ("Too few parameters, expected 1") PkdID is a unbound field on a form...

Need to to set up a barcoding system for access. Features<br>would include shipping/recieving/inventory. does anyone<br>have some sample db's? sample code? I have some code<br>to print barcodes if anyone is interested but need some<br>serious help with tracking.