| Thread | Last Post | Replies |
|
| Import Txt files into an ADP | 21 Jun 2006 05:02 GMT | 2 |
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 changes | 21 Jun 2006 00:02 GMT | 1 |
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 identity | 20 Jun 2006 17:14 GMT | 1 |
how can i programmatically determine if a field (column) is an identity field?
|
| adp strengths? | 20 Jun 2006 16:22 GMT | 5 |
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 address | 20 Jun 2006 16:20 GMT | 6 |
Good afternoon, How can I get the IP address programmatically? Thanks, José Perdigão
|
| Problems copying and pasting decimal fields | 20 Jun 2006 06:16 GMT | 3 |
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 Descriptions | 20 Jun 2006 06:13 GMT | 1 |
Is there a way to add table/view/procedure/function descriptions in an ADP? Thanks Alan
|
| .ade runtime - SQL Connection issue | 20 Jun 2006 06:12 GMT | 8 |
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 Server | 20 Jun 2006 05:55 GMT | 3 |
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 2005 | 20 Jun 2006 05:54 GMT | 3 |
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 parameters | 20 Jun 2006 05:53 GMT | 2 |
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-SQL | 20 Jun 2006 03:05 GMT | 1 |
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.
|
| asdf | 19 Jun 2006 23:29 GMT | 2 |
|
| Hi! #Name? Problem on particular PC :( | 19 Jun 2006 21:19 GMT | 2 |
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 displayed | 19 Jun 2006 10:23 GMT | 3 |
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:
|