|
error in table relation
I got this message
You cannot add
or change a record because a related record is required in table
I wonder why I can't this while first when I built the access forms and
tables seems to work fine. When I made some changes the above message show
up. How can I resolve it.
I have a table headmaster and master linked together. I made first a record
in headmaster and afterwards I use an sql ...
|
12 |
11/7/2005 6:42:42 PM |
|
|
Get a file name
I want to open with VBA the file open dialog box and to use the filename +
the path as input in my code. Is there any code in the internet that I can
use? Any links or maybe any code to provide me?
Thanks In advace
Kon
...
|
2 |
11/3/2005 8:14:21 PM |
|
|
Audit trail seperate table???
I got Richard Rensel's modification for MS KB audit trail. Great! But:
Trailing is stored in each table's update field. Updating memo fields and
copy-pasting changes in the update field (which is a memo field) quickly the
update field runs out of space. So I thought of a second approach that would
make everyone's life easier.
1) Wouldn't it be better to have a table solely for storing ...
|
4 |
11/2/2005 7:58:02 PM |
|
|
Index, appendix, the whole world....
ISSUE 1:
I have two tables with a one-many relationship.
I have designed a report with a group header for the one side and the many
side spanning to each detail section. something
like:
p.1
category header: food
---------------------
roast beef
chicken salad
category header: drinks
--------------------------
lemonade
beer
page break (using keep together: whole group)
p.2
...
|
4 |
11/1/2005 3:11:34 PM |
|
|
form's datasheet view
Hello all!
How much properties of form's datasheet I can use in Access, example
selected row, columns or range such as in Excel.
Thanks.
Stas.
...
|
2 |
11/1/2005 11:39:10 AM |
|
|
Dates - looking for insight
Hi all,
I've got a text field where someone COULD be putting in a specific date, but
not necessarily, and if they do, I want to grab the date they put in.
Sounds easy, right? Just use IsDate().
Well, that was all well & good until somebody entered "October 2005".
IsDate() picks this up as a valid date when I don't want it to, since it's
interpreted by VBA as October 1, 2005, which is...
|
21 |
11/1/2005 10:12:31 AM |
|
|
controlbutton
Hello all!
How I can create new button in my commandbar with special properties,
such as toggle button (example: bold font button in formatting bar).
Thanks Stas.
...
|
2 |
10/31/2005 7:45:19 PM |
|
|
Export access tables to sqlserver by code
DoCmd.TransferDatabase acExport for exporting a table to sqlserver raises
an error
while doing the same action manuely (file\export) is doing the job well
what is the correct code for this job?
tanks
...
|
2 |
10/31/2005 4:48:42 PM |
|
|
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 |
10/30/2005 8:11:09 PM |
|
|
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 |
10/30/2005 4:05:09 PM |
|
|
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 |
10/28/2005 8:52:34 PM |
|
|
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 |
10/28/2005 3:02:48 PM |
|
|
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 |
10/28/2005 8:40:54 AM |
|
|
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 |
10/27/2005 5:21:37 PM |
|
|
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 |
10/26/2005 1:26:33 AM |