|
|
Updating/editing two tables in forms by
Help me please totals on page in report
Please help: I am trying to manage land and properties in a small town.
I have 2 tables: Owners and Property
One owner may have one property or own several...
|
December 1st, 2005 09:30 PM
by tina
|
1 |
77 |
|
|
How can I get table data into a text box by
bayshore
I would like to be able to pass variable data (product name) from a Textbox
on a form to query data in a Table and then have that query return the
(price)...
|
December 1st, 2005 09:06 PM
by tina
|
1 |
95 |
|
|
Help With Expression Please by
John Spencer
How about the following?
DCOUNT("*","Clients","Therapy1='1' and Active='1'") +
DCOUNT("*","Clients","Therapy2='1' and Active='1'") + ...
Depending on your...
|
|
5 |
83 |
|
|
Subforms on forms and reports by
Alice
A subform which I use on a form and a report have recently stopped working
for users of Access 2003. This is a continuous form and sometimes the
information ...
|
December 1st, 2005 04:25 PM
by Alice
|
0 |
76 |
|
|
Duplicates by
DS
I have INSERT SQL code that I run. I'm not quite sure how to do this.
I need to search for duplicates either before or after the code is run.
All of the info...
|
|
3 |
86 |
|
|
Linked tables between db's by
kohai
Hi,
I have 2 access databases where one holds all of my underlying data (several
million rows) and the second holds all of the calculated info I need from...
|
December 1st, 2005 03:35 PM
by kohai
|
0 |
97 |
|
|
increase size of form footer by
Miguel Vivar
I have a large set of questions in my form and I want all these questions to
appear in my form, but because of the number of controls, only some of them
appear...
|
|
2 |
94 |
|
|
Drop Down List Question by
John Calder
Hi
I run Win2000 with Access 2000. I have created a table & form which has an
entry of a "First Name" and an entry of a "Surname". I would like to have...
|
|
3 |
102 |
|
|
Syntax to refresh subform by
Jack Sheet
What is the syntax, please, to insert into the
Private Sub Form_Current()
event of a parent form
in order to refresh a subform contained within that parent...
|
|
7 |
127 |
|
|
|
|
4 |
92 |
|
|
|
|
4 |
97 |
|
|
Overcoming #Error (Access 97) by
Jack Sheet
Hi all
A report contains a box (terminology?) in the report footer that contains
the formula "=Count(*)"
This works fine with the exception that it returns...
|
|
1 |
99 |
|
|
|
November 30th, 2005 10:38 PM
by LynneMc
|
2 |
69 |
|
|
|
|
2 |
90 |
|
|
text box by
Miguel Vivar
is there a way to write in a text box more than one answer?
|
|
7 |
132 |
|
|
Running A2000 and A2003 on Same PC by
Nancy
I have a need to have both A2000 and A2003 running on the same PC in order to
support my customers. Are there any compatibility issues with running both
A2000...
|
November 30th, 2005 08:01 PM
by Nancy
|
2 |
107 |
|
|
Subform problem by
Jack Sheet
Hi all, Access 97
Nearly there.
I now have two tables T_Clients and T_Tasks containing autonumber primary
keys ID_Clients and ID_Tasks.
ID_Clients is...
|
|
8 |
157 |
|
|
Continuing subform problem (Access 97) by
Jack Sheet
In the On current event of the parent form I tried the effect of typing
"me."
without the quotes, on a new line within the
Private Sub...
|
|
1 |
89 |
|
|
FILTER RECORDS by
SLOPES
I am having trouble with filtering a query. I would like to do a "invoice
filter" like in the northwind sample database where it only prints one record
at a...
|
November 30th, 2005 06:36 PM
by SLOPES
|
2 |
88 |
|
|
Expressions by
[email protected]
I am using =DatePart("yyyy", ) to pull through the month
displayed as mmmm format, from a field containing a date in ddd
d-mmm-yy format. I am getting an...
|
|
4 |
86 |