MSDN Home >  MSDN Library >  Win32 and COM Development
Data Access
Microsoft offers many data access technologies to suit various
development needs. This section of the MSDN Library contains technical

I posted this question about two days ago, but for some reason it never
actually got put up. I couldn't' find it with searches, so I am
re-posting it now. I apologize if this is a double post.
Hello,

Can I change a text box to a combo box programmatically? Just wondering
if this is possible.

Hello! I'm trying to create a report, in which all of the textbox
controls in Detail section I'd like to resize to one size.
Here is a code (Access 2000):
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Access 2003
I need to create a query to view data by 3 - 24 hour shifts.  Ex: There
are 3 shifts, each shift is 24 hours starting at 0700 through 0700.
Each shift is designated as A, B, or C.  01/01/2006 is an "A" shift.

I have the following command.
SELECT A.STORE_NAME, A.STORE_NUM, A.ZIP_CODE, B.EMPLOYEE_ID, B.GENDER,
B.EMP_LEVEL, C.ITEM_CODE,
DECODE(B.ITEM_CODE,1, 'CHICK_BURGERS') ITEM_DESCR,

AC97 on WinXP, Image control on a Form and on a Report.
I have followed the advice on the following MVPS page:
http://www.mvps.org/access/api/api0038.htm
This states that after changing the Registry setting for the progress

I collect information from my clients with an xls file
I import the xls data into my access table.
I don't have them put info directly into Access, because, despite the
drop downs I have for data validation in my xls sheet, some fields are

I have a subform with some fields in them. i only want a customer to enter
a property ID, so how can i stop the user from editing the customer ID,
quantity, etc...
how can i stop the user from entering data into other fields in the subform?

I have an Access 2003 application which I have to enhance. The former
programmer isn't available any more. Does anybody know a good tool which
documents Access 2003 applications?
Steven

I am executing an SQL string in an ADO connection to an Access mdb that
updates 10 fields in one row:
SQL = Update table1 set fld1 = value1, fld2 = value2,...fld10 = value10
Where <criteris>

Hello All, I have a DB that have 6 tables - tblCreator, tblSummary,
tblPaper, tblProposition, tblContributor, tblPanel.  The tables are
linked in the following way:
      tblSummary is linked with tblProposition by ProposalID

I'm more familiar with MSSQL than Access syntax and have run into a problem
with correctly putting ( )'s around the joins in a 3 table query.  I want to
INNER JOIN lenders and accounts  and LEFT OUTER JOIN that result with
prospects.  (I want to receive all the results of the ...

To comp.databases.ms-access --
I have a questionnaire for which I would like to design a MIcrosoft
Access form.  I understand that the proper Access table structure would
be:

I have a database with a split front end/back end.  There is a key
table in the back end called Catalog, and it is sort of a central key
table for all sorts of things.  It's a list of all the jobs that have
ever been worked on at our company.  Records are getting lost out of