Hi everybody and happy new year :)
I'm looking for a method or an API to modify picture size and copy it in a
différent file.
It will work directly on the file and not on form picture control.

I want to refer to a recordset field like this :
   For IntA = 1 To IntX
          With rstMemoR
            .AddNew

I have a phone field and I have a default area code set and when I tab to the
field the area code is highlighted and I have to click off of it to enter
data. How can I have it so when I tab to the field I can immediatly start
typing the phone number after the area code?

I've got a table (tblMain) which stores information about people.  I have
another table (tblMainEvent) which stores events for each users.  There is a
one to many relationship between these tables as tblMainEvent stores a number
of events for each record in tblMain.  The way I ...

How can i hide tables from the users accessing them. Please let me know all
the options that i hagve. Either if i can hiode it or passwordprotect it or
even a better one.
Any help is appreciated!!!

I have an access 2007 database that was using a MS Flex Grid on 1 form to
display data.  After several requests from the users the form was modified to
include a tab control and there were 2 additional Flex Grids added to 2 of
those tabs to display specific data.  The original ...

hey all,
everytime i access a table from odbc acess pops up a sql server login,
anybody know a way to save the password so you dont have to type in
the password everytime you access a new server?

I have an acess DB with many user forms. I am using the user permissions
provided with Access. I have Access automaticly ask for a log in. I have a
Security file (System.mdb) Is there an easy way to set User Permissions for
each form.

when i set this to stop the annoying popups can i leave it set that way for
my app by doing it on the open of my "first" form, the first one the user
sees, and then close it off on the close of my "last" form, the one where the
user closes out the app?

I'm learning to create QueryDefs from a book which has the following code.  I
understand what everything is doing except the line "MakeQueryDef = True".  
Function MakeQueryDef(strSQL As String) As Boolean
Dim qdf As QueryDef

Hi - I have to edit data in a query result.  this query has a groupby clause
and lots more, may be that is the reason it is not allowing me to midify the
data.
I have build a form to display all the records of a query result, that i

How would I check the version of access in code.
I want to be able to check the version of access and if is access 2000
ignore some code other wise run the code
ie:

I have about 100 Access MDB's that have a reference to a table in
multiple queries that I need to replace with a new table. I've written the
following code to do so, but it keeps giving me the error about dependency
info not being updated. I thought adding  'oApp.SetOption "Track ...

i have an existing append query called qryTempPurchaseOrder which appends
data from another query qryPurchaseOrders to a table TempPurchaseOrder. i
have added a criteria within qryTempPurchaseOrder to the field
PurchaseOrderID as follows:

Does anyone know how to set the recordsource for a subreport within a report?
So let's say I have Report1 as my report and subrpt1 as my subreport.  Where
would I set the recordsource for subrpt1?
Thanks for any help.