Am developing a module to allow end users, thru the Report Wizard,  to
generate custom reports (I know, I know! But they insist!) and I want to
offer them the option of deleting the report after printing.
Thanks

I have an application in Access 97 that uses DoCmd.TransferSpreadsheet to
get data from an Excel spreadsheet into a table. This has worked quite
happily with Excel 2000 spreadsheets for several years but the supplier of
the spreadsheets, who is completely outside my and my ...

I just need to do a simple thing, look at the value of a field from a
recordset, run some SQL using that value, move to the next and repeat.  
Here's what I've got so far.
Set rsZips = CurrentDb.OpenRecordset("SELECT ZIP from tblRTD GROUP BY ZIP")

I want to update the values (Budget) in a table (Budget 01) based on the
input of an input box multiplied by a percentage stored in the table
(Percentage).  This is initiated when the user clicks a button from a form.
The input box pops up, but after I enter the amount (30000), I ...

I am trying to create a program that cycles through a number of agencies that
have one or more items in a table.  I need to pull each agency separately and
am trying to do that by setting a variable (var5) equal to the agency number
that I want to process on this pass through the ...

I need to compare table 1 to table 2 and if different, write the entire row
from table 1 to table 3.
I can read an entire row from table 1 into a recordset using the following
strSQL_in = "select * from table1"   ( and i can refer to the columns as

I have several select queries which extract various different sets of records
from a database. The queries all include a sort order specification. I also
have several reports which can use any of the queries. The OnOpen method of
each report receives the name of the required ...

I'm trying to build a FROM clause from code, depending on the choices taken
in a form with multiple controls.  Basically, it goes like this (hypothetical
names):
if ctl1.value = true then

I am translating an Access Database into a DataProject using SQL Server as
the database.  I have a query with the following code
SELECT Sum(IIf([Date]<[Date1],[Amount],0)) AS OpeningBalance, Sum(IIf([Date]
Between [Date1] And [Date2] And [PaymRec]="Receipt",[Amount],0)) AS ...

I am trying to import an xls sheet into an existing table.  I found some
ref's to you and your answers but have not had any luck.  I am using the
below string; however, I get the err.msg that the jet db can not find the
input table .....

Good morning,
I have also posted this tread in the Form section.
I would like to create a form for a report where users can select the fields
on the form that they want on the report.  

I am in preparation of a database and for that I need some help.
The basis idea is to generate some reports based on the source data that will
come from siebel (which is my companies customised software).
Now I don't have any idea as to how I should link the siebel to access so

Hi all, i am not a programmer but a dabbler and batteling with the
following... I open a form that has a sub form on it indicating all the
previous requests. there is a comment field for each record on that i would
like to click on to open a pop up form with the full comment on.. ...

I have built a dynamic querydef from a form with a series of multi-select
listboxes. I would now like to create (via code) a form based on this query
to display the summarized results of that query.
I tried pre-building the forms.. but there are 7 multi-select listboxes and

Just to let you know I have little programming experiece.  Also Im new to
programming with Databases.  I have done bits and pieces of VB System Admin
scripting and Excel automation.
My question is: Could you please tell me how to connect to MS Access