I have a form with a number (=the number of the current week)
Next to this number I have 2 pushbuttons: + and - to increase and
decrease the number (getting next or previous week.
On this form I created a subform. I get data from a table matching the

I'm running SQL statements to delete unwanted records.
Is there a way to do this without bloating each time a deletion is run?
Thanks
DS

I have an access 2000 application.
I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.

Below is the SQL for a query that I have that sums how many documents were
issued to a department for a specific month.  The users select the month and
year from a form via combo boxes (that way they cannot select more than one
month for a date range).  Then I have hidden text boxes ...

Hello.  I am trying to handle the apostrophes during this NotInList event:
I cannot get it right and am at my wits end.
Any ideas?
Thanks!

i\'m not sure whether i\'m right here with my problem or not, but i try.
Situation:
I have a table with just one field \"myfield\" date-type is \"LONG\"
I also have a form with just one textbox. The form ist bound to the

Is there away to export a filtered selection of a table (which is on a
form) to excel? I'm reading some of the posts, and it appears I would
need to have the filtered selection dump into a query then export it.
Is that correct? What would be the best approach?

I have a field that has total time spent on job and now boss wants a
"countdown" of time left to finish job. If I have a number type field for
hours given to complete job, how can I work a calculation to subtract the
time spent (which is a date/time field) from the hours given so ...

I would like a message box to appear once the user has filled out the form
and wants to close it or move on to the next record.
It's a simple reminder message and does not require any input, nor does it
rely on data in any other field on the form.  

Hi,
Dim rs As Object
   Set rs = Me.Recordset.Clone
   rs.FindFirst "[Location] = '" & Me![Combo58] & "'"

What's wrong with this, I get an error here.
Private Sub Form_Open(Cancel As Integer)
Me!cboxVendor.RowSource = "Select en_vend_key, en_vend_name" & " From
tblAdageVolumeSpend Order By "" & " "tblAdageVolumeSpend.en_vend_key;"

I have a function in Access 2000 which is called by F6 as follows:
Public Function BonaFideFormation()
Forms![Enquiries]![Type] = "FORMB"
Forms![Enquiries]![Price] = "£77.97"

I have a database with a form called "Workorders". We send technicians out to
customers to perform service based on the created workorders. Sometimes the
technician return notes (i.e missing 1 screw, replace at next service) for
the next technician to perform at the next service.

i have 2 problems with sending emails from access through outlook:
1. outlook reports that the email has not been sent even it in sent items
folder.
2. how can i format the email (font, color, align)?

I am having a problem getting the button wizard to open the correct forms. I
have my main form (form 1) that is defined by a Unique Primary (ex. CaseID)
key and it is related in a one-to-many relationship to another form (form 2)
that has a primary key (StructureID) and a foreign ...