|
Change recordsource for a report through a macro
I would like to change the recordsource for a report by using a macro.
I have tried using the set value but can not get it to work.
The recordsource on the report is initially set to table1
I would like to create a macro the changes the recordsource to table2 etc.
I used set value as follows:
Item: [Reports]![Table1].[RecordSource]
Expression: Table2
I also tried [t...
|
14 |
30.10.2005 20:11:09 |
|
|
Access VBA add record
I have a form designed for timesheet entry.
it is a row by row based form rather that the standard top to bottom
oriented form.
After I have put in the staff number and date and hours, there are 4 fields
displayed with year to date figures that the system works out and displays
for the user.
The pen icon appears in the first cell onthe row to say that the record is
"dirty" but I w...
|
5 |
30.10.2005 16:05:09 |
|
|
Newbie how to open print window programmatically
Hi
How can I open the select printer window before I print a report, I want to
first select the printer then send the report.
Best regards
...
|
4 |
28.10.2005 20:52:34 |
|
|
Creating a Zipped Archive Problem
Hi All,
I have the following code which is intended to create an archive of the file
TargetDB.mdb.
The problem I am encountering is that my code to change the Application
Title isn't working.
Both the original and the copy have the "Target Database Master" as their
title.
The Archived version should have a title in the format "Backup YYYY-MM-DD"
I think the reason for this is that...
|
11 |
28.10.2005 15:02:48 |
|
|
Moving a Form Object with the Move Comand
Hi Everyone,
I want to run the following command on the MouseDown Command:
TextLabel.Move Left:=-0.1, Top:=-0.1
The problem is that I want to move the TextLabel relative to it's current
position, not relative to the edge of the page.
Is there a simple way to do this please?
Thankyou,
John Ortt
...
|
4 |
28.10.2005 08:40:54 |
|
|
How to execute a module?
Newbie question: How do I execute a module directly from within Access?
I've written a module that parses external data sources and uses the data to
populate a table. Ideally, I'd like to execute this module from within the
Modules window in Access, but this seemingly-intuitive way of launching a
module doesn't seem to work. The documentation talks all about modules, but
doesn't appear ...
|
3 |
27.10.2005 17:21:37 |
|
|
How to call code from a variable
I ahve completely forgotton how to call a function from the contents of a
variable name name.
Ie the string variable contains the function/Subroutine I want to call
Thanks in advance
Stephen
...
|
2 |
26.10.2005 01:26:33 |