multiple printers
Tue, 22 Jul 2008 20:13:01 -0700
Is it possible to send a report to two seperate printers at the same time. I
would like to have our sales staff to be able to print a report on our office
printer and the report to print at our service managers printer as well.
Thank you. ...
|
Is there a way to tell if a certain Access application or instance is open?
Tue, 22 Jul 2008 23:45:29 GMT
Hello all,
Is there a way of determining if a cerain Access app is open?
I have a number of Access apps I've written for an office and at any given
time any number of those app's could be open at the same time by various
users doing their daily work.
So now I'm building a generic front-end updater to update a ...
|
How can I get sendObject to open Outlook instead of Outlook Expres
Tue, 22 Jul 2008 15:18:03 -0700
sendObject is opening Outlook Express. I do not use outlook express. I use
Outlook. How can I cange the settings so that it opens Outlook? ...
|
set text box value to result of query
Tue, 22 Jul 2008 14:47:01 -0700
Using VBA, how do I set the value of a text box control on a form to the
result of a query that returns one value? I'm sure I knew this at one point,
but I can't remember and I can't figure it out again. I can do this with a
combo box by setting the RowSource property to the SQL statement, but I can't
figure ...
|
Is it possible to use multiple recordset objects in a query?
Tue, 22 Jul 2008 13:56:39 -0700 (PDT)
I am wondering if it is possible to query two recordsets into another
recordset object. I haven't seen examples of querying an ADO recordset
in the source property of the recordsets open method, but I believe it
is possible. Below is the psuedo code for what I am trying to
accomplish:
rst2.Open _
Source:=" ...
|
Rounded textbox/label, circle control?
Tue, 22 Jul 2008 13:37:03 -0700
1) Is there a way to round the edges of a textbox or label?
2) Is there a control that draws a circle with a specified radius or diameter?
Any help is appreciated. Thanks.
Jim B ...
|
IF statement with array
Tue, 22 Jul 2008 12:51:07 -0700
I'm sure I've seen something in these threads but my searches are coming up
empty. Is there an IN or NOT IN statement, and if so, is it tied to an array?
Here's what I want to do - perform the same function(s) if the user is one
of five authorized; if not, everyone gets an "Access denied" message. What
is ...
|
|
|
Create TBL SQL error
Tue, 22 Jul 2008 19:49:32 GMT
In the following code, I get an 'Item not found in this collection' error.
When I debug this error it points me to the SQL code. I am not sure what
specifically is causing the error. I have copied the code from SQL view and
pasted it into my overall code and added the 'rst' criteria filter code.
Thanks for the h ...
|
Access 2007 - Recordset not updateable after splitting
Tue, 22 Jul 2008 11:36:01 -0700
Hello -
I created a database in Access 2007 and used the database splitter. I put
the backend on a shared network drive. I can see the tables via the Linked
Table Manager.
My Front end is called Variance.accdb
My BackEnd is called Variance_be.accdb.
However, the fields on the forms on my front end ar ...
|
Classes and Collections
Tue, 22 Jul 2008 11:04:02 -0700
Could someone point me to some good tutorials on using classes and collections.
Thanks
Neal ...
|
