Doug Steele gave me the following bit of code to relink Access ODBC tables
programmatically. It works great.
 For Each tdfCurr In dbCurr.TableDefs
   If tdfCurr.Connect Like "*adage*" Then

I can't figure out the logic behind what I'm trying to do.
I have a db that I use to log our Salesmen's Activity Summary Reports (a
summary of what they did the past week.) The data is logged in the db based
on category totals (e.g. total mileage, total new accouts, etc.) This

How to store multiple images for one unique ID in Access?

I have developed an application that is used in 4 different place to collect
data. Once in a while each center sends me back the data and after having
merged them all I perform some checking.
To deliver to each center the changes I make to data, I usually use another

I created a team nomination form with 3 command buttons, if users click on
any of the button I want the team member information to be inserted into
another table. I used the following code:
Dim SQL As String

I recently moved my file designed in Access 2003 into Access 2007 and now the
application.filesearch object, which allowed for the database to retrieve a
list of files in a particular folder, isn't working.  i tried to follow the
help instructions and have the Microsoft office ...

I have the code to delete sheets in excel however I get a warning message
which I would like to have turned off so that it just performs the deletion.
Any ideas would be appreciated.
I have tried docmd.setwarnings = false but this doesn't do anything and I

In my DB I have one table stockMaster table with fields Brand as text field
and  closingStock as number field. Another table tSstockReport table with
only certain Brand ont complete list of brands, In this table I want write
brand's closingstock from table StockMaster, due to ...

I have written a database in Access/VBA, (Windows 98; Access 97 SR-1). I
have now moved it onto an XP PC, and converted it to Access 2002 SP3. It runs
and compiles fine on my PC. I have 'secured' it by making it into an mde
file, having removed the startup options and allocated a ...

I have two sqls which are as
Set rst = CurrentDb.OpenRecordset("SELECT SUM(Closing) AS ClosingStock, BRD
AS Brand FROM " & txtTableName & " GROUP BY BRD")
above sql bringing correct record, 42 records with the grouping and suming

I have a table that contains an Id field (autoID), a start date field for a
service and another field that contains the number of weeks the service
should go.
I have another table in which contains an ID field (linked to the table above)

Could anyone show me a formula that converts hours and minutes into a numeric
value? Example: 7:15 (hh:ss) 7 hours 15 minutes.  I want to convert this to
7.25 hours. Any help would be greatly appreciated.
Paul

In order to be able to synchronize 2 databases, I need to convert an
autoincrement field to a standard integer field. I'm using the following
code:
  Set tbl = catProj.Tables("Termine")

i use the following code for import
DoCmd.TransferText acImportDelim, , "TempTable", Me.txtFileName, False
Me.txtFileName=New Raw Data.txt
TempTable = all fields(F1-F44) are type double

I am trying set the value of a textbox based on the value of another textbox
using the value 1 to get 10 as an example below but how do set it up is you
have several values?Is this code repeated each time for the additional values
like 2,3,4,5 to get 11,12,13,14? Is repeating the ...