Is there a difference in preformance between the two;
TblNme has 36 fields across a record
a query that selects all fields and the report only uses 75% of the
fields, ie; Select TblNme.* where OffCde='123'

Is this possible by in MS Acess by VBA?
Input:
------+------+---------+---------+---------+
id1  |  id2 | 001.7  | 002.7 | 003.8 |

The following is a snippet from a procedure that prints
a batch consisting of 30 different forms/letters/memos...
1430 If AOCSP905M = True Then
1440     DoCmd.OpenReport "rptSeparatorSheetSP905s"

i have a report that contains several sub reports
sub report1
sub report2
sub report3

Suppose I have a situation where I need to include the word "All" as
an option in a combobox.  I have:
tblPGroups
PGID AutoNumber

Friends,
Here is an absolutely free tool to download any video from YouTube.
This software downloads videos from YouTube and converts them to MPEG
format, which is supported by almost all media players and devices.

I'm using the following expression in the query grid to show the Month
and Year of the date field "TxtDate":
Week: Format([TxtDate],"ww yy",4)
I am grouping the results on this field.

I have created many shortcut/popup (aka context, or right-click) menus for my
application - instead of toolbars or standard drop-down menus.
Within my custom menu, I am using =ShowMainMenu("item") in the On Action
event where ShowMainMenu is a public function in frmMain, and ...

I have a Access database of email addresses that I would like to mass
email to customers. Can Access be used through Outlook? or can it just
be done with Access? I know it is possible to use MailMerge for
snailMail.

Is there a way to populate sequential numbers in a field using SQL or
VBA? If yes, how?
Assume the following is my existing table:
Fruit         ID

My client has moved their back-end database from Access to SQL Server,
and now the following query doesn't work (Operation must use an
updateable query):
UPDATE tblbookings INNER JOIN tblREFUNDS ON tblbookings.TransFromID =

To append a single record, without getting a warning if a record
already exists, I found out the following syntax works fine as Query
in MS Access:
first create a simple 'products' table...

I am trying to figure out a DAO connection to an unknown database
type. I have an app that uses single file 'databases', and during the
install process for this application DAO3.5 is installed - presumably
to read these files. Then again I could be very very wrong here.

I would like that my subform is immediately filtered as soon as one types a
letter in an unbound searchbox in the form.
If one types an 's' the content of the subform shows only records starting
with s

Hi I use access 2002
I want to use the squirrel sql client with it via the jdbc/odbc
bridge. does anybody know the url i would use to point to the odbc
driver I've setup for this database? (everything is on the same pc).