I'd like to have a way to 'copy' certain data from our Sales Order so that
users can paste it into an online spreadsheet.
For example, users enters sales data into frmSalesOrders, then click a
button that copies AccountNumber, CustomerName, CustomerAddress into the

Is there any easy way to programatically test for a null record?  Testing for
null fields is simple, but I would like to test for a record that has had
nothing entered into it.

I need to add an additional criteria for the list query.  How do I
incorporate the criteria where List2 will query based on Fields 5 & 6
selected in List0.  It's works fine as is by querying just by Field6...but I
need to add Field5 to it.  

I found this code on this forum. Thanks John Vinson!!!, it works great. But
what I was wondering is what if one of the fields was a number field and not
a text field. What Im trying to do is look for identical addresses.
Thanks for the help.

I've been given an Access Database with a table.
It appears someone tried to do a calculated field within the table
(redundant data and didn't work).
My quick? solution was to:

I have a subform that is a continuous form of partnumbers and the status of
the part.  I was asked If I could make so if a person hovers over a
partnumber, the name of the part would be displayed like I do for the
Controltip on buttons and fields.  Any ideas?

I have an Access application someone else created and now have a
requirement from an end-user. I currently have a field called
"dbo_Field_Ticket_Header_Field_Ticket_Number". It's datatype is
integer. On the before update event there is this code:

I have some calculations in the form footer of the sub form that transform
yes/ no answers into point values.  The end result gives a percent score and
before the record set moves to a new record, i want to be able to move the
calculated text [score] box value to a field in the ...

Access Version 2002
I am desiging a routiene that will check development database lookup
tables for records proir to pushing them out to production.  I would
normally loop through a recordset loading the array (after re-

I'm trying to create an exe file to make updates automatically.
One condition to works well, the access database should be closed.
How can I close an access application from another application?
Thanks,

my task is to create a report as pdf that is automatically mailed
every day to several people.
So the following steps are necessary:
1) Create a scheduled task in the control panel that calls...    --->

Access 2003 / WinXP
I have a Form (Name: test) with (1) label on it so far (Name:
Output3_Label).  I am trying to make the text align vertically within the
label.  While searching for the answer, I came across what I believed would

I would like to develop a form showing rows for tasks and columns for dates.  
I have a table of tasks and a table of hoursWorked, one record for each date
/ task.
Any thoughts on the best way of accomplishiing this?

Im looking to verify a hyperlink entered in a textbox.
I would like the user to be able to enter project-1 or
http://www.link.com/browse/project-1 and it open a webpage with the correct
information.   Im really new so I dont know how to

dear sir ,
in a continues form basing on a query , say for eg :- studentid ,
studentname , classid.
i want to open a report by clicking on studentid field , basing on