Threads Replies Last Post 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29   A problem with getting ID of a just inserted record Hello, Here is the typical code pattern (after inserting a record into a table with identity column, the code tries to retrieve identifier of that record; the identity column is called "ID"): Set rs = New Recordset rs.CursorLocation = adUseClient rs.Open "select top 0 * from SomeTable", CurrentProject.Connection, adOpenDynamic, adLockOptimistic rs.AddNew rs("NonI... 10 29.07.2006 04:47:21 Access 2003 and SQL server express 2005 has any one encounted this problem?? When I try to modify the row source of a form element I get this message. This version of Microsoft Office Access dosen't support design changes with the version of Microsoft SQL server you Access project is conneted to. the message goes on to tell me to check the webstie for updates.. can anyone help thanks... 3 28.07.2006 19:02:19 Grouped Query to Table Hello, I have a access project which monitors invoices payment received. Each style is a new record and 4-5 such records make up one invoice. i have grouped these on a query to get a combined invoice total. My question : is it possible to move this grouped invoice to a new table (sumarized form). the reason I need to do this is because i receive the payment in a lumpsum with deduc... 4 28.07.2006 11:29:24 When is a NULL Not a NULL ? I have a Table that I am inner joining with a View. However, the inner join is not returning records for which the joined columns both contain a NULL. The Table column is typed as nvarchar(50). The column in the View is populated with NULL as a literal (e.g., SELECT NULL As ColumnA, ColumnB, ColumnC FROM TableB). Anyone care to guess as to why two NULL's don't form a match within this... 41 27.07.2006 19:27:59 View specific data in a form I have a SP qOrders (orders of clients). I have a form FClients and I want to create a button to execute this SP and view the orders of the loaded client in FClients. Any help is appreciated. Thanks ... 3 27.07.2006 17:34:30 SQL Book Hi, Does anyone know a Good SQL server book that covers: Programming,backups, restoring, Replication etc... I looked in the internet but it was overwhelming, too many books to choose from. Thanks in advance -- Message posted via http://www.accessmonster.com ... 1 27.07.2006 13:12:23 Getting around having no temp tables hmm ,this lack of temp tables makes things a bit trickier! There's 3 tables I'm working with. I'll just give the simplified versions here Renewal - RenewID, RenewYear, RenewClientID RenewProcess: ProcessID, RP_RenewID, RP_Stage Stages: StageCode, StageDesc Stages is just a list of Stages that the Process can go through. So, come a new year, create Renewals via SQL. What I used to was c... 3 27.07.2006 11:44:23 ODBC Timeout Our office uses Access 2000 as a front end to a SQL server 2000 database. Each client has it's own copy of the access .mdb file on their computer. It has been up and running for about a year and half but recently have been getting sporadic ODBC timeout errors. The syntax of the error is: ODBC -- update on a linked table 'tableName' failed. [Microsoft][ODBC SQL Server Driver]Timeout ... 4 27.07.2006 00:45:11 ADP freezes when it can't find SQL Server I have two issues that are probably related: First, none of the connection strings for my adps work anymore when trying to connect to the local server via the name, like ServerName. Instead I have to use the IP address. When I went to test connectivity via an ODBC connection, I discovered that the name of my local server shows up 3 times in the dropdown list to choose a server. I don't kn... 5 26.07.2006 17:01:42 adp application hangs Hi all We have a product we developed in AccessXP - an adp (ade for end users) which connects to SQL Server 2000. Some clients are using it at the moment and are experiencing intermittant freezes while typing text into text boxes on bound forms. ie not while moving between forms or between fields. There are 65 users all connecting to the same Server and databse. All hardware seems to be ... 4 26.07.2006 04:51:59 Finding Database Objects Assigned To A Role Is there any way of finding all of the database objects that are assigned to a role in SQL 2005? THANK YOU VERY MUCH!!! ... 1 25.07.2006 22:12:19 New records not visible i have one table in my adp that will not show newly added records. also some of the columns are not visible. anyone experience this? ... 2 25.07.2006 17:26:02 Updating Combo box if Table is in SQL Backend I have SQL 2000 back end and Access 2003 front. I am able to update the tbl via the Combo Box if it's created in Access with primary key as Autonumber see code below. I cannot update the Combo Box if the tbl is created in SQL. What code must I include to achieve this ? Private Sub Competitor_NotInList(NewData As String, Response As Integer) Response = acDataErrContinue 'Propmpt user to v... 3 25.07.2006 11:14:25 test this is my test for news group. ... 1 25.07.2006 11:12:52 Create Link To SQL Server Table Forgive my ignorance about this, I may not even be asking the right questions. Through the remote connection program shipped with Windows XP I am able to log into the machine holding the SQL Server and execute queries on the database. What I want to do is just have a tool with a link to this table so I can execute queries and pull reports using live up to the minute data. I have tri... 2 25.07.2006 02:10:05 error =Iif([SHIPTERM]="LDP",Round([INVQTY]*[LDPPRICE],2),Round([INVQTY]*[FOBPRICE], 2)) Please help me frame this in a Access project data base. i get error validating formula. Help Help... 7 24.07.2006 21:42:20 Users Not Prompted for Connection Password Not sure how this happened, but my Access 2003 ADP database is not prompting users for a connection password. I looked in the database Connection properties (i.e., Data Link Properties dialog) and noticed that a password is being saved such that users are never prompted to enter their own password. I didn't mean to save a password and it won't allow me to blank out the password field. Ho... 4 24.07.2006 17:58:51 Finding a developer/tutor, value of MVP qualification. I do some work for an small, but growing, international organisation on a vouluntary basis because I believe it helps a lot of people enjoy life better. I want it to prosper. It is using an Access Database being developed by a buddy of the Chief Exec which I regard as woefully badly designed, implemented and tested. I believe that the task they need it to do probably requires an upgrade... 4 24.07.2006 14:17:02 Create My own Menu Buttons I have looked at creating a Custom Tool. However I can't see where I could create my own buttons. I want to create a tool bar like a form that stays at the top of the database window. When the user clicks the button1 it open the form in the lower section of the database area directly below the tool bar. If they click button2 it closes the form that is open and opens the corrisponding form ... 1 22.07.2006 01:15:46 Refreshing Views List Hello! In my adp, I have a VBA function where I need to create a view dynamically and then open it. But meanwhile I need to refresh the views list somehow, otherwise it will bring up an error opening the view. I don't have the database window open, so I believe the RefreshDatabaseWindow is out of question. Currently, i make the project reconnect to refresh the views list but that c... 2 21.07.2006 22:47:05 update form view I need help in just these couple of issues: 1. In the same project, which has a form "ENTRY FORM" I have used the fields [invqty], [invprice], [invval], [poqty], [poprice] [poval], where invval = invqty * invprice.....poval = [poqty]*[poprice]..... I am able to calculate the value, however, the invval is not displayed on the form unless I save the record. How can I make this work so that ... 1 21.07.2006 13:50:29 Updating Data I'm using sql 2000 and Access 2003. I have a adp database that contains about 200 clients. Part of the data is the client's doctor, nurse and other staff. I'm trying to figure out a way to develop something so someone other then me can update the information. I'm need a way to update lets say if Dr. Smith leaves and Dr. Jones takes his place and 75 clients. With an mdb could create an... 4 21.07.2006 13:41:12 Check Boxes Hi I read that Binary in SQL is the equivalent of Yes/No field in Access. Yet I can't get a check box to the update the binary field. How do I go about this? Thanks Diarmuid ... 8 21.07.2006 08:12:52 Pointless debates on the finer points of naming your objects (moved from Combo Box Requery thread) I still don't buy that this is either product-specific or amateur-specific. I've seen countless numbers of experienced, formally trained (and who learned it on their own) database programmers on every platform I've ever used who use "tbl" for tables, "vw" for views, "usp" for user stored procedures, not to mention "frm" for forms, "rpt" for reports, etc., ad nauseum. Personally, I don... 61 21.07.2006 00:18:56 Hyperlinks take forever to open from a message I have Outlook 2003 on Windows XP with all the latest Windows Updates. When a message comes in with a hyperlink to say www.google.com, it take about 30 seconds before IE will even show up. Once IE opens, the page is show quickly but they 30 second delay is consistant. Opening IE is fine on its own. Opening the link by Start-Run and filling in the link is also almost instant as well. ... 3 20.07.2006 23:13:44 29 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29