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   User Defined Function criteria/default problem I have a udf with a date column and I would like to be able to filter returned records by passing NULL as a criteria. I set the column default value to NULL. When I open the function and select either default or null from the drop down I get no records returned. This in not a data problem, I verified there are records with null values. I'm using MS Access2003 and SQL Server 2000. Thanks for ... 7 24.04.2006 10:09:46 ÄãÃǺÃ! Ö»ÒªÄ㿪ÐÄ£¬´ó¼Ò¶¼»á¿ªÐÄµÄ ... 1 26.04.2006 02:51:24 Connect to SQL Server over the internet Hi, Computer A is where is installed SQL server 2000 and the BE. Computer B, I have the FE (ADP in access 2003). The both computers are connected the internet. So, how can I connect to SQL Server over the internet? I mean, I want connect my FE Computer B) to BE (computer A). I listen something, we can do this connection trough IP address, but I don't have idea how can I d... 11 25.04.2006 22:35:04 Network Printer issue 4/24/06 I run an electronic medical record in my office with SQL datafiles on separate server. If I try to open a template from a workstation, to enter patient note, it opens in about 2 seconds, if separate workstation that has attached USB HP network printer, is powered on. If my receptionist turns off this PC, before I'm done working on my other Dell, it takes about 30 seconds to lo... 1 24.04.2006 17:43:35 subform data not displaying with non sa account Hi, I have developed an application that displays data from a query in a subform. This worked fine when I developed it with the SA account but when creating specific accounts for users, no data is displayed in the subform. I have granted rights to all tables and stored procedures. Is there any other difference between the two accounts that could cause this problem. This may or may... 10 24.04.2006 05:34:56 Use ADO Estoy trabajando un Adp, acces 2003, sql server 2000 estoy tratando de adecuar este codigo para que me copie en una tabla fecha las los fechas que encuentre entre dos fechas... estoy empezando... la he modificado pero me envia un error.."Variable de objeto, o bloque with no establecido" Dim fecha1 As Date Dim fecha2 As Date Dim FECHAPRINT Dim dbs As Database Dim rs As Recordset ... 7 24.04.2006 01:19:47 Sorting not available on text box with combobox column as recordsource I have a text box which uses a combo box column value as it's recordsource. A user wants to be able to sort on the text box but it is unavailable because of the recordsource. Is there some kind of workaround for this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200604/1... 1 23.04.2006 18:11:13 Multiple Access sessions appearing during amil merge from SQL Server OK, I'm baffled. I have an Access applicaiton fronting SQL Server and used by 15-20 folks at any one itme. One of the features is to fire off Word sessions to open documents which are mail merges into the active record. The key peices of VBA code looks like this: sSQL = "SELECT * FROM wherever WHERE whatever " = " & what2 sDSNName = "what3.dsn" Set gobjWordApp = Create... 9 22.04.2006 21:23:39 Is_Member question I need to know how to pass the current user and a specific role to the Is_Member function on SQL Server using VBA and then have the true or false value returned back. I'm trying to determine if a user is a member of Job Control or not so I can make a command button visible or not. Thanks for any help. -- Message posted via http://www.accessmonster.com... 2 22.04.2006 11:07:37 Programatically Overwriting ConnectionString in an adp Hi-- I am a developer looking for a way to allow clients to deploy updates at the click of a mouse. I have the batch files done as far as the sql statements and copying the new adp to the correct network location. What I would like to do is overwrite the connection string the first time the adp is opened and set it to the correct local settings. I have had to set the connection to a valid ... 2 21.04.2006 21:34:58 Two expected records missing from SQL Server table after write I have a Microsoft Access ADP that goes against an MS SQL Server 2000 database. Within this MS Access ADP I have a recordset (forward only, read only, cachesize 1) that is the result of a SELECT. . .WHERE EXISTS query. This recordset is gone through to create corresponding records (1-for-1) in another recordset which is open for write (forward only, optimistic locking, cachesize 1) to a... 9 21.04.2006 19:01:05 Form Current - iif [Ignore]=Yes DoCmd.GoToRecord , , acNext I want to write code that will skip any record that displays 'Yes' in the [Ignore] field. Since this field may change throughout the day, and my employees are in the system nonstop, I cannot make it a filter. This is what I came up with, but it didn't work: Form Current: iif [Ignore]=Yes DoCmd.GoToRecord , , acNext It doesn't work, but is there something that will? -- Mark M... 3 20.04.2006 15:43:15 Adding records using form based on stored procedure? Hi, Is it possible to base a form on a stored procedure that has 2 or three joins and be able to add records back to the database? I have a fairly straight forward SELECT in a stored procedure that when run in MS-Access ADP does not offer a "New" row in the results grid but if I cut and past the same code into a View it does. If I remove the joins from the SP then it looks like it's g... 4 20.04.2006 15:42:36 Interactive input into SQL view in adp I am converting an existing change request app from an mdb to an adp. The mdb has an existing query that has an interactive keyboard entry built into it. For ReqID field the query criteria has [enter ReqID] which works fine in the mdb in a popup form. That syntax does not seem to work for the equivalent SQL view though. How can I accomplish the same thing in the view? Note, I'm not allow... 5 20.04.2006 15:39:12 What would you like to fix in Money? Hello, please respond to this thread with the annoying things you would like fixed in Money. I will try to reproduce them in the next Money Beta, so there will be a chance to have them fixed. Ideally, please post in the form of steps to take/expected result/real result. regards, Vadim Rapp ... 2 19.04.2006 22:17:32 Form with Disconnected Recordset, Will not allow edits. I have a form that I want to have use a disconnected recordset. The disconnected recordset works fine, but I am unable to update or even type in the textboxes. When I try I get a "Recordset is not updateable message" My intention is to have the recordset reconnected and for it to do a batch update when the client pushes the "Save" button. I know I could have the text boxes unbound, l... 2 19.04.2006 19:07:07 Wizard How do I tranfere old files to a new computer,I have XP home addition,is there a wizard needed Les ... 1 19.04.2006 16:04:33 test test -- Serafim Bernardo web designer manager free lance 01614857737 ... 2 19.04.2006 15:50:31 Form: Invoke a change when record is left In a form, I neeed to invoke a change when a record is left (next, previous, or exit). How do I do this? -- Mark Matzke... 9 17.04.2006 10:37:29 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:30 Estrategia para administrar usuarios en inicio de sesion Buen dia Estoy desarrollando una aplicacion, mi primera sobre SQL Server, ya que lo demas lo hice con Access, en el cual para cuando desarrollaba una aplicacion tenia una tabla con los usuarios, contraseñas, permisos, etc de cada uno, ahora necesito poner seguridad en la aplicacion que estoy desarrollando, para que solo un empleado con user y psw validos pueda iniciar sesion, pero no ... 1 15.04.2006 07:40:23 SAVE THE BEE WITH GOOGLE ADSENSE! <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P> </P> </BODY> </HTML> ... 1 14.04.2006 03:07:54 ImportXML => "Run-time error '31550': Not all of your data was successfully imported" This is a multi-part message in MIME format. ------=_NextPart_000_0087_01C65CAE.B081CF80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear MS Support, I get the error=20 Run-time error '31550': Not all of your data was successfully imported. Error descriptions = with=20 associated row numbers of bad records can be found in the... 4 13.04.2006 09:01:02 8 ... 1 11.04.2006 19:16:25 Express 2005 to 2000 Hi, I've created a new database in Sql express 2005, only to find out later that my hosting doesn't support 2000. So i need to recreate the database in sql 2000. I tried a few different ways from *.bak to script to file.. sql 2000 doesn't seem to be able to excute them. I'm pretty new to sql server altogether, how can I do that? I'm running out of solution and I can't seem to goog... 2 10.04.2006 03:21:02 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