Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / SQL Server / ADP / June 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Import Txt files into an ADP21 Jun 2006 05:02 GMT2
Anyone has the solution into how to import text files into a ADP using code?
I found something, but dont know how it works.
Thanks!
Private Sub Comando0_Click()
canceling adp changes21 Jun 2006 00:02 GMT1
I am looking for a way of canceling any changes a user may have made on a
adp form if they cancel out of that form.
I have found that if the user is unhappy with the changes they have made
hitting escape before they leave the page will undo all their changes.  Is
is identity20 Jun 2006 17:14 GMT1
how can i programmatically determine if a field (column)  is an
identity field?
adp strengths?20 Jun 2006 16:22 GMT5
Hi, I have a SQL 2005 database that I wanted to quickly deploy a
front-end to.  I was happily surprised that Access 2003 seems to be a
great RAD tool for SQL when using ADP.  I am a .net programmer but I
wasn't looking forward to creating a new application from scratch so
IP address20 Jun 2006 16:20 GMT6
Good afternoon,
How can I get the IP address programmatically?
Thanks,
José Perdigão
Problems copying and pasting decimal fields20 Jun 2006 06:16 GMT3
I have a problem copying or exporting from the adp to excel for any
field/attribute formatted as decimal.  When I paste or export into
Excel, excel thinks that it is a text field, and I have to convert to
number every time.  However, if I load the same query in SQL Query
Table Descriptions20 Jun 2006 06:13 GMT1
Is there a way to add table/view/procedure/function  descriptions in an ADP?
Thanks
Alan
.ade runtime - SQL Connection issue20 Jun 2006 06:12 GMT8
I have packaged up an .ade project. Everything installs OK and when the
Splash screen opens the project tries to connect to a SQL server and then
fails - this OK. I was using a button to open the SQL Connection dialog in
the .adp project (which worked fine), but with the  ...
Access Query Transform.. Pivot to SQL Server20 Jun 2006 05:55 GMT3
Hi group i have this sql in a MDB that run perfect.
TRANSFORM Count([dbo_Incidencias tecnicas].Clave) AS CountOfClave
SELECT [dbo_Clientes y referencias].IdCliente, [dbo_Clientes y
referencias].Empresa, [dbo_Clientes y
Access 2002/XP Access Project (ADP) and SQL Server 200520 Jun 2006 05:54 GMT3
Access 2002/XP will not allow me to design any SQL Server 2005 objects. An
error appears saying my version of Access is older than the version of SQL
Server I am running. I'm instructed to go to Microsoft Downloads for a
solution, but cannot find any solutions on what to do.
Changed all objects from dbo to non dbo, now cannot send parameters20 Jun 2006 05:53 GMT2
due to some tables not being owned by dbo, i needed to change all other
objects to the same owner.  I have since updated the db to do this as
well as the ADP.  However, when i run the adp, it fails.  For some
reason it fails when either refreshing the stored procedure parameters,
Moving to MS-SQL20 Jun 2006 03:05 GMT1
I am moving a MS-ACCESS application to the Web and using MS-SQL 2000.
Obviously the Access form is replaced with a Web form. I need to know how to
pass parameters from the Web form to MS-SQL. Any tips or direction on this is
greatly appreciated.
asdf19 Jun 2006 23:29 GMT2
what is yor naem
Hi! #Name? Problem on particular PC :(19 Jun 2006 21:19 GMT2
I have a format date command in an APD ie (Format[DataBooked],"ddd
dd-mmm-yy") Works perfect on my compiled ADP on my PC, but on another
PC it comes up with the usual #Name? error as if it cant find the field
or somet :(
The data was added to the database but the data won't be displayed19 Jun 2006 10:23 GMT3
When Microsoft Access 2003 tries to retrieve a fresh inserted record on a
table with automatic identity handling, on a subscriber of a transactional
replication with queued updates (SQL Server 2005), it always shows the
message:
Pages: 1 2 3 4 May, 2006
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.