Dear friends, your valuable help is needed again,
I have a table - T_Issues with the following fields:
RadioSN (text) - Primary key
DateIssued (date) - Primary key

I have a column of filepaths and a sub that steps through the table importing
each file. It only works if:
a: There is a filepath stored (and)
b: if there is a file on the HD at that path.

I am using Access 2003. On a form I have a button that duplicates a record
and when I click the button the form becomes populated ok except when the
date comes into the form it comes in as year 2020. It was working fine but
then yesterday it started doing this. I don't know if a ...

There is a calculated text box on a tabular form. Calculation is based
on other text boxes which are bounded to a table. Everything is fine
except that i can not filter the tabular form according to calculated
text box. When I select the calculated text box, filter button

I have an unbound form, frmClients, interacting with class Clients. On the
form I have a combo box, cboNationality, based on tblNationalities but I
can't make it work. Do I need to also create a class for nationalities and
then create a parent child relationship with class ...

Hi - i have several reports that i am creating for users to input their
required criteria - i.e. a report using query by form - they all work fine
unless the criteria a user enters results in an empty query.  the fields on
the form are all summed or counted e.g. =Count([loanID]) ...

I have decided to make the transition and apply object oriented techniques
in my database using classes but I have some difficulty.
The problem is that most books deal with the subject in a quite superficial
way, exposing the reader to the basic principles of oop only but fail to ...

I would love to display a form with a red/green light to reflect the status.  
I have searched, and can't seem to find any help on how to accomplish this.  
I have the status stored in a table as "Y" or "N", but I have no idea how to
come up with either the green/red light objects ...

Do you know if I can program Access to recognize hand writting?   Do
you know of good resources (libraries, sample apps, documentation to
program Access on the tablet?)
Thank you

Is there a simple way to make the selections in a listbox 'float' to the top
whilst still keeping the non-selected items sorted alphabetically underneath.

hey all, i have a subform which has 3 buttons.  i'm writing a function whose
sole inpt variable will be the name of the button.  part of the function
changes the caption on the selected button, and I want to use this variable
in there

I want to execute below code but it seems absolutely fail,
please help:
Private Sub AddSpec_cmd_Click()
On Error GoTo Err_AddSpec_cmd_Click

I am currently trying to create a database with the following
requirements but am finding it to be quite a nightmare............
Layout:
three tables ( one named product table, and the second named location

I set up a button control to start the import process:
Private Sub ImportData_Click()
DoCmd.RunCommand acCmdImport
End Sub

I have very little Access programming background and I am trying to
get the following to work:
I have a form: frmTenderDetails which has a bound control
ProposalRefNo to a table which displays the tender number for a