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   Get Login Good morning, To get computer name I use HOST_NAME() Is it possible to get the windows login through a sp or udf? Thanks José Perdigão... 10 30.01.2007 10:02:09 oø' lm'ø' ... 1 30.09.2006 21:14:56 ISA 2004 server firewall service not starting after memory upgrade HI, I have upgraed my ISA server 2004 with sp2 (installed in a PC) memory from 512mb to 1Gb . After that the ISA firewall service is not starting. If I remove the extra memory it works fine.Please let me know anybody having any clue!!!! thanks BM ... 2 30.09.2006 14:43:48 Adding a new record to the recordset of a form using ADO (adp file) I get the following error when adding a new record to the underlying recordset of my form: data added database won't displayed form because doesn't satisfy criteria underlying record source. The reason is because i am selecting the record set based on a specific ID, which is an autonumber in my sqlserver database. When i create a new record the error above appears because the new record... 4 29.09.2006 16:32:03 Capture a SQL server's return value in code Can someone off me some starting air code for the following? How do I have a stored procedure send a return value, then have my code capture the result? Here's what I'm trying to do... in a form's code, I need to check if a user is a member of a permissions group. I can call a stored procedure that uses this T-SQL: IF (IS_MEMBER('CRRR\HR-AllAccess') = 1) Begin --... 2 29.09.2006 16:24:29 What is ADP and what it stands for? Hi. What is ADP and what it stands for?... 7 29.09.2006 14:39:30 SqlServer2005 with Win2k workstations running Access 2003 Hi Has anyone out there had any problems running Win2k (SP4) workstations/Access 2003/SqlServer 2005 in combination? I have a client reporting connection dropout when loading our shrink-wrapped Access ADE app, preceded by an error message saying 'class not registered'. Not sure if this is an Access problem, or a Win2k problem run against the SQL Server... Any relevant comments gr... 4 29.09.2006 13:58:02 Cross join query Greetings everyone. I am having trouble understanding how to get a cross join to work properly. I am experimenting with a running total and grand sum feature using cross joins. My problem is that all the help articles I have read make reference to 'tablename a' and 'tablename b' or something to that effect, basically calling the same table two different names in the query and sub-quer... 6 28.09.2006 21:09:01 Controls disappear when form's recordsource returns no records I have a form with two unbound combo boxes from which a user selects a month and year of interest. The form also has textboxes whose control sources are populated with the names of fields in my (as yet unrun) stored procedure (actually it's a function). The form itself does not have a recordsource defined. There is also a command button on the form: Private Sub Command4_Click() Dim ... 3 28.09.2006 20:39:29 ADE Read Only why do i get a read only message when more than one person is using my ADE? i thought one of the perposes of using the ADE was to make it multi-user.....? tia mcnewsxp ... 2 28.09.2006 19:36:54 access adp, sql server and recordsets Hi, I have an access application with an SQL server backend database. Recently it has started throwing errors. When I investigated I found that the command used to retrieve database information through a recordset was the problem as below. Dim objrs As Recordset Set objrs = CurrentProject.Connection.Execute("exec ComplaintIdentifier_INS") CCID = (objrs!NewCCID) The stored proc... 9 28.09.2006 07:45:39 Error in docmd.transferspreadsheet? I have SQL Server 2000 with access 2003 frontend. The following line of vba code in access gives an error: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel3, "dbo.TM_ProjectMembers", strInputFileName, True, "sheet1!" The code worked perfectly in Access 2000. After conversion of my front end to Access 2003 I get an error. I get runtime error 7874, error message stating that o... 10 28.09.2006 07:32:44 Field order in view using Access GUI When I create a view in Access, it seems to choose to order the fields differently than from top to bottom in the view. example Field1 Field2 Field3 Field4 When displayed it comes out like Field2 Field1 Field3 Field4 This may not seem important but from an extract to excel point of view, it is. Curiously though, when you create the same view in Enterprise Manager it formats... 1 28.09.2006 00:51:55 ADP Main Form Disabled when Editing Subform I have an adp project that includes a main form tied to a query that is manipulated by a criteria string to filter records when opened. The subform is tied to the main form, the record source is the table to allow editing. The problem is this.....when you open the form the buttons on the main form work fine. As soon as you edit anything in the subform, none of the buttons will work unless y... 3 25.09.2006 15:14:45 Views not keeping diagram pane layout Hi I'm working on a new SQL 2000 database. Views that are created keep their SQL, but the diagram pane window will be blank when the view is re opened in design. This happens in an ADP and in SQL 2000. Makes it very awkard to change the view. Any ideas? Thanks Vayse ... 2 25.09.2006 12:11:11 Fakers and breakers Someone is interfering with the proper running of these newsgroups. They are coming on in various guises. So far all the ones I have seen have been Hotmail accounts They all have similar message headers. I do not think that blocking the email address will work because they hop from identity to identity. I use my real name. I started to use some of these newsgroups recenty to refresh m... 6 24.09.2006 17:08:01 Data Encryption Issues with ADP and SQL2005 I am new to the arena of Access 2003 and ADP. I am converting an Access DB and application to ADP and SQL 2005. As a test I created a DB on the SQL 2005 remote (not on my LAN) server and then created a new ADP in Access that links to it. I see the tables OK and can operate on them just fine so far. I have opened the tables while looking at the network traffic with Ethereal and it see... 1 24.09.2006 17:01:02 Using VBA in an ADP to generate an ID value The table in the database has a field called LabID. That field is an integer and consists of the year plus a counter. For example, the first record of 2006 would be "20060001," the second record of 2006 would be "20060002" and so on. Originally, I tried to create an Insert trigger that could generate the ID value when a new record is inserted. An MVP in another forum was kind enough to ... 2 24.09.2006 02:09:06 Access 2K3, SQL Server 2K5, "Instead of" Trigger Problem The front end is an MS Access 2003 ADP. The back end is an MS SQL Server 2005 database. I have a form that is based on a view. The view is based on a couple of tables. The primary table in the view has an "Instead Of" trigger. The trigger automatically generates a value for the primary key of the primary table if the new row has a null value for the primary key field. As a result, when ... 3 22.09.2006 20:57:04 ADE & SQL Server 7 Looking for any comments about incompatibilities between an Access ADE (2002 format) & SQL Server 7. One of my clients is reporting data dropout with an ADE against SQL Server 7/SP3. The ADE has been running with later versions of SQL Server for over 2 years without problems of this sort. Any (relevant) contributions welcomed Steve ... 2 22.09.2006 18:48:37 Passing a Parameter to a Stored Procedure From a Form CBO For the life of me, I can't get this to work. I have 2 combo box controls. I want the value selected in the first box9cboCarId) to be passed as a parameter to the query underlying the second combo box(cboPrevWeightEntry). Here's what I've got. First Combo Box Properties: Name - cboCarId RowSourceTyoe - Table/View/StoredProc RowSource - qry_list_active_car#_unreceived BoundColumn - 1 ... 2 22.09.2006 18:35:55 Access 2005, Adp and SQL Server I don't know if this was posted prior, but it was recently sent to me from Microsoft regarding A2005 & sql server as well as other pertinent info.. http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true Lar ... 3 22.09.2006 01:37:58 Lookup Columns in ADP/SQL Server 2005 combination I have an ADP that was linked to SQL2K, now to SQL2005. There are tables that contain lookup columns (the data was an integer link to a record in another table) that displayed values in easy to read formats. The columns that were created in SQL2K still work and have the lookup information. New columns that are created since the conversion cannot be changed to lookup columns. Is there a wa... 4 21.09.2006 20:54:14 AllowBypassKey in adp for certain SQLServer role I am using Access 2003 adp. I've read the posts on this site on how to set the AllowBypassKey property. If I understand it correctly, you have to execute CurrentProject.Properties. Add "AllowByPassKey", True after the adp is opened, and then exit and enter again before the shift key actually works. I would like to have the adp allow the shift key only if the user is in the "db_owner" rol... 1 21.09.2006 18:43:31 Exporting query or report to Excel results in Text field data loss Greetings I have created a query in Access containing some Text fields (ie data type Text or NText) with large text values. If I export the results to Excel using File/Export... the large text fileds are truncated to 255 characters in the resulting excel cells. I have noticed that exporting a table in the same way does not truncate the data. Is there any way around this truncatin... 7 21.09.2006 09:37:58 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