Determine lastest minor version of A2007 in VBA
Wed, 24 Dec 2008 09:38:13 -0800
I have the latest Access 2007 Version (12.0.6211.1000) SP1 MSO
(12.0.6320.5000)
My filedatetime() works on my machine but not other machine with SP1. I
guess it's the minor hotfix (12.0.6320.5000) makes the difference.
How to detect user's Access version and MSO number in VBA?
Thanks
...
|
Setting focus to main form
Wed, 24 Dec 2008 12:45:29 GMT
Thanks for reading this. Here is my problem. I have two forms I'm working
with. Main menu form {frm_menu} and a sub form called frmbkbox which is
hidding.
The way the subform works is when I get to day 7 that subform appears and has
a button that you click on to perform the backup/copy. Clicking on the button
d ...
|
Linking a field to a Query in VBA
Wed, 24 Dec 2008 02:00:01 -0800
Dear all,
I'm trying to use VBA to output the results of a list of Queries to Excel
spreadsheets using the TransferSpreadsheet command.
What I have is a source table with the Query names, and a relevant
department code, so I'd like to use this table to create only the queries
that match a specific depart ...
|
Using a stored procedure as record source of a form - does this wo
Tue, 23 Dec 2008 14:45:01 -0800
I am converting to an ADP and I am trying to replace a sql statement in a
form record source with a stored procedure. I added the parameter needed by
the stored procedure to the Input Parameters. Everytime the form opens I get
an error. It is not a problem with the stored procedure because it runs fine
from ...
|
Synchronize 2007 with runtime
Tue, 23 Dec 2008 14:27:05 -0800
Is it possible to distribute a form in a runtime environment and create
functionality to update a Sharepoint server?
If not, what is the option with 2007 to synchronize data in a distributed
runtime environment? ...
|
Parent reference
Tue, 23 Dec 2008 12:01:14 -0800
I've addressed this question in the reports group, but I have a more general
question.
The ID field in my database uniquely identies a customer. For different
applications in my database I want to the user to supply the info to
determine the ID, either an ID or a last name or a last name and first name.
...
|
2007 Ribbon: minimize using code
Tue, 23 Dec 2008 11:47:05 -0800
Hi. Does anyone know if the ribbon in Access 2007 can be minimized using
code? I know that it can be hidden using this code:
docmd.ShowToolbar "Ribbon", acToolbarNo
But I just want to minimize it.
Thanks much! ...
|
|
|
Year prefix on primary key autonumber, but restart with '1' yearly
Tue, 23 Dec 2008 11:46:00 -0800
Basically keeping the original autonumber and create another auto added one
with the prefix, have all foreign tables use the auto added number while the
autonumber runs in the background....?
All in Main table:
1. Rename and keep the existing autonumber (ProjectID_orig) in order to keep
all existing records ...
|
Using the $ after functions
Tue, 23 Dec 2008 08:19:00 -0800
This is a general question...Is there any difference using a function in the
expression builder that ends with the $ and one that does not?
--
Ken ...
|
print form
Tue, 23 Dec 2008 07:47:01 -0800
hi,
i have the following print code which works in excel, but i am trying to
figure out how to modify it to work in access to print a form:
ActiveWindow.SelectedSheets.PageSetup.Zoom = 80
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
thanks in advance,
geebee
...
|
