|
|
HELP!!! Validation rule by
Chris
I have to introduce in a table some data, using a form with contrtols: combo
boxes and text boxes. The fields need to follow some VALIDATION RULES, and
to...
|
|
4 |
617 |
|
|
ADO Parameter Query by
Tony_VBACoder
I have a bunch of Parameter Queries that I have been
calling with VBA. But now I am converting my code to use
ADO recordsets. How would I change my old code...
|
|
2 |
332 |
|
|
|
|
1 |
557 |
|
|
Return Left Portion of a String by
Bonnie
Returning the left portion of a string in a query.
i.e. if the string is: "
What combination of functions would return only "anybody"
or...
|
June 1st, 2004 02:23 PM
by Newbie
|
3 |
304 |
|
|
qry-SalesAnalysysCollectData? by
Maureen
tblInventory + tblInvoiceDetail
I would like to collect sales history for analysys. I'd like sales for
various periods (based on tbleInvoiceDetail.date) for...
( 1 2)
|
|
10 |
828 |
|
|
Return most recent record [Repost] by
Jordan
I have a table of payments made by clients. It includes
the fields:
PaymentID
ClientID
DateRec
AmtRec
I was trying to use the Last function on the Total row...
|
June 1st, 2004 03:27 PM
by
|
2 |
565 |
|
|
How do I declare a variable as a Variant by
Sandy C
I am running an append query and get this error:
You tried to assign a Null value to a variable that is not a Variant data type. Use the Dim statement to...
|
|
5 |
811 |
|
|
|
|
5 |
704 |
|
|
Duplicated Query results by
Alex
I have two tables; "Orders" & "Cancellations". The Orders
table contains the following orders:
part# loc
1 a
3 b
1 a
5 d
The...
|
|
1 |
558 |
|
|
SQL Intersect by
Allan
I am going through a "teach yourself SQL in 21 days" and doing the examples
in Access. They are using Personal Oracle in the book, so I am noting...
|
|
1 |
294 |
|
|
pivot tables by
Stanley
I am using a privot chart where the underlying query
groups by the week.The problem is the weeks are not sorted
correctly (1, 10, 11,...2, 20, 21...). Any...
|
June 1st, 2004 06:05 PM
by Newbie
|
1 |
401 |
|
|
Empty recordset query by time by
larry cowan
I have a table where one field is date/time format. Only the time value has
been entered. When I enter query criteria such as 9:01 PM Access 2000
converts the...
|
June 1st, 2004 06:50 PM
by Newbie
|
1 |
405 |
|
|
dates problem by
bogi
Hi, I have a table with records each with a certain dates,
I would like to make a report that gives me dates that are
one year ahead from the dates in the...
|
June 1st, 2004 06:53 PM
by bogi
|
2 |
414 |
|
|
YearFrac by
Grace
Excel has a function named YearFrac() which allows you to
specify where a year calculation uses 365 or 360 days. I
would like to use this in Access, however,...
|
|
1 |
644 |
|
|
HELP with updateable query by
Jacqueline
Using an Access 2000 mdb with linked SQL tables.
I am opening a report (based on a query)...after the
report closes I am running a simple macro to open...
|
|
3 |
349 |
|
|
a bit confusing by
Andy Levy
Hi, apologies for the previous accidental post.
I currently have a table with the following values
ID Value GroupValue
1 ...
|
|
3 |
243 |
|
|
Concatenation by
Andrea
I have a query that I am trying to concatenate more than
2 fields. This new field is set up as a parameter that
asks the user for a value that equals the...
|
|
1 |
288 |
|
|
Date Range in Multiple Queries by
James Stephens
Here is the situation I am stuck in. I have 3 queries that pull data off of 3 seperate tables. I then combine them all into one. The problem is that there...
|
|
1 |
682 |
|
|
|
|
3 |
715 |
|
|
Subforms-Intriguing question by
Chris
I need to display on the same A4 page more pages of the same report, and,
after the A4 paper sheet is over to continue on the next A4 paper. Can I
insert it...
|
|
1 |
328 |