in una maschera di "ricerca" seleziono il record da visualizzare usando
una "casella combinata", la casella combinata tiene memoria di un solo
dato da lei visualizzato, nel mio caso un id, come posso
contemporaneamente avere disponibile un altro argomento dello stesso

I seem to get confused with working out the following query in access
2000:
SELECT DISTINCT tblCust.Name, tblOrders.MyDate
FROM tblCust INNER JOIN tblOrders ON tblCust.CustID = tblOrders.CustID

I need an automated procedure to copy data from an Access table to a
SQL Server table. Speed is important. What is the recommended
technique?
I can export the data from Access, copy it via FTP, then import it into

I created an Access program using Access 2000 .
The program is using a Switchboard with about 10 items.
Starting from the very top of the Screen I have a line described as follows:
The bar istesl is blue.

I need to import a spreadsheet but the spread sheet has blank collums and
the first row contains abbreviations (e.g. DEPT. - with period). the
transferspreadsheet gives me field names "noname1", "noname2" etc and DEPT#.
How can I omit the blank field names and change the DEPT# to ...

I'm having a problem with a union query, two simple queries joined with
a union statement. It's created in code based on parameters. Users were
noticing some inconsistant data and when I analysed the query produced
and opened it from a MS Query it started giving strange results.

I have a product database that includes a memo field for product
descriptions.  That database must be imported into a legacy system that
has four text fields for product descriptions, each with a 250
character field length.

I have a report with multiple records and controls. There is one
particular control called 'Further Reference' which is part of the
report. It has a couple of standard phrases in it and what i want to
happen is when the phrase "see catalogue copy" is selected for that

I'm putting out some more experimental software.  When creating PDF
files from A97 I often have a static layout consisting of PDF commands
along with PDF commands that are dependent on the data that are added
dynamically.  I created PDFLayoutViewer.mdb for the purpose of editing

I have written an application to print data on to pre-printed forms.
However, I have data need to be printed on beyond the printable area
(as there are minimum margins at the report).
The right margin is defaulted with a 0.49" margin. Anyway to reduce

I have a form.
When a person selects a publication from a listbox, this snippet of
code is supposed to look up authors that correspond to that publication
and populate the Author List Box, but it doesn't work. I have been

I have a query with criteria that comes from a combo box on a form. I'd
like to set the query up so the user can either limit the criteria to
the selection in the combo box or the user can pull all records. Can't
figure out a way for the query to pull all records. Currently uses the

I want to add a command button which will add a record to an Access table.
I would also like to add another command button which will delete a record
from the same table.
I searched Google for ideas how to do this but came up empty.

I have put the following code in the 'After Update' of a combo box:
Private Sub ComboTeam_AfterUpdate()
lblSurnameNotify.Visible = True
Me!ComboSurname = Null

All, I have an append query set up that pulls records off of one table
and appends them to a linked table. However, when the query runs, it
gives me an error message saying that the records could not be appended
due to a validation rule error. The wierd thing is there are no