Re: How to use extract a data table from from

Right - have just had a play with an access .adp and your code works.
If your database is an MDB file, I would recomment doing it the way I
suggested earlier.
If your database is an .adp file, the following is fine (apart from the
'where' bit I mentioned before) - and don't forget to close your recordset at
the end.

Dim dbObject As Connection
Dim rst As Recordset
Set dbObject = CurrentProject.Connection

Set rst = dbObject.Execute _
("SELECT [Rcv Date], [Item No] FROM TblReceiving WHERE Lot_ID= " &
me![Lot_ID])

With rst
Me![Rcv Date] = ![Rcv Date]
Me![Item No] = ![Item No]
End With
rst.Close
End Sub


.

Relevant Pages

  • Inserting data in .adp database
    ... I am trying to insert data in .adp dtabase.But i am not able to insert ... it,but when i tried it with .mdb file i am able to insert data....can ... you help me what should i do to inset data in .adp database. ... This is my data declaration in database in .adp file which is not ...
    (microsoft.public.vc.mfc)
  • problem in inserting the data in sqldatabase .adp file
    ... I am trying to insert data in .adp dtabase.But i am not able to insert ... it,but when i tried it with .mdb file i am able to insert data....can ... you help me what should i do to inset data in .adp database. ... This is my data declaration in database in .adp file which is not ...
    (microsoft.public.data.oledb)
  • Re: Deploying ADP on IIS problem
    ... Sorry, I mean DAP, not ADP Project. ... database to which has direct access the http server. ... >> I'm trying to make the web application on IIS by using mdb file. ... >> I can get the data, but only on the machine where the IIS is installed. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... sufficiently fast response times, ADP may be a good enough client, ... Replication can be another solution, ... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Question on conversion to ADP
    ... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
    (microsoft.public.access.adp.sqlserver)