Hi Folks - Currently, I am using the Error Event of my form to capture
duplicate key entry. However, this is not invoked until the form updates. Is
there a way to check for a duplicate after the user tabs out of the primary
key field? Thanks.

I am trying to get rid of dups from a table that I imported.
ID  Data
1    string1, string2, string1, string4
2    string2, string6, string2, string1

Hi Folks - I know I have done this before, but I'm stumped .... Currently, I
am passing dates from a form to query criteria. If I type the dates in, the
query works fine. However, I want all dates selected if they do not enter a
date. I thought I did this with the LIKE operator, ...

I have the following query with the following:
Query 1 has the following records:
Item
Store No.

I have three crosstab queries that needs to be placed at the different
ranges in the same excel sheet .
How can I achieve this with do.cmd.transferspreadsheet.
Dim strQName As String

Hello Access Nation, I'm having a problem rounding up to two decimals. I have
an IIF statement iin my query:
RegAmt:
IIf([Exempt]="Y",-Int(-[AnnualPay]*[Increase_Percent]),Round([PayRate]*[Increase_Percent],2))

I know this has been addressed many times here, but I can't seem to find
exactly what I'm looking for.  
I have frmReciepts that is used to enter buyer data into tblReceipts.  The
form has multiple fields, including CustomerLast and CustomerFirst. I have a

I have a short time field and I am trying to get the hour portion without the
minutes.
For 17:00 I would like to return 17 and for 07:00 return 07
I have tried the left function but that returns 7: for 7:00 (which makes

I saw the post from DB Girl about line numbering in a query which is almost
exacly what I want to do except the solution given isn't working for me...
What I want to get is:
VENDOR_NAME    VENDOR_SITE_CODE       SITEID (generated number)

I currently have a crosstab query where I request information by date with
the prameter as "weekendingdate". The query returns data for days Saturday
then Monday, through Friday. I would like to get the same information by
requesting information by week. Also how would I display ...

I can sort records by name within field but, how can I use Access to count
the number of times the field record is repeated?  For example: A field has
these records  blue, blue, blue, blue, red and red.   So my count total will
be 4 blue and 2 red.  I have hundreds of records ...

I have a Select Query where I want the user to be prompted to input the
specific date for records.  The label is called "Business Date" and is on the
form "Daily Input Form".  In the query design view, under Query =>
Parameters, I typed "Business Date" in the left column and ...

is it can be pass in the Access?
how to change?
thanks!
update       ta  

I have 1 query which is the basis for a datasheet and a report.  It seems
that no matter what I specify in the ORDER BY clause, the sort order differs
in the report and datasheet.  Same thing results if I ORDER BY more than 1
column.  It also seems that if I specify sorting by ...

In my report I have an unbound text box [Text25] that shows a percentage
based on the values in two other text boxes (ex: =[Text22]/[Text23]). In a
fourth box [Text4], I have the following conditional statement:
=IIf([Text25]>=".9500","Pass","Fail")