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   ´ó¼ÒºÃ Ϊʲô½ñÄêµÄÌìÆøÕâôµÄÈÈ£¬ÓÐË­ÖªµÀÂ𣿠... 1 16.08.2006 01:51:36 ´ó¼ÒºÃ Ϊʲô½ñÄêµÄÌìÆøÕâôµÄÈÈ£¬ÓÐË­Äܹ»ËµÒ»Ï¿´·¨Â𣿠... 1 16.08.2006 01:50:29 Prompt for SQL Login if no Windows Auth available Hi, I apologise if this is a question that's been answered everywhere else. This week I'm helping out the employer of a friend (Kelvin Wilson) who died recently. Kelvin has a nice .adp which connects using Windows Auth to a SQL box. I'm tasked with providing access (via SQL Login) to users who don't have Windows accounts. The SQL box is set up to allow both authentication methods.... 1 16.08.2006 00:50:28 Problem updating NText field and query timeout Hi there Has anybody experienced Timeout issues on updating NText fields in SQL Server 2005? Ive been using a procedure in an MS Access application, to read in the contents of an Ntext field used for notes into a local string variable. Then further notes are added to this and then an update statement writes it back to the NText field. Ive used an updateText procedure but this is a... 1 10.08.2006 21:43:53 Windows Vista & SQL server 2005 Does anyone have a clue how to get SQL server 2005 and express to work with WIndows Vista Build 5384?? They say there is a fix coming for this compatability issue, but that is not until the end or early next year. Is there something that can be patched or a work around. I am at wits end trying to solve this delima. Any suggestions or fixes would be highly appreciated. ... 1 10.08.2006 19:57:46 How to push data from local ADP to remote SQL server? I have been using Access for many years. I now need to upsize to SQL because my website is getting much more traffic than it used to. I want to continue using my existing Access forms to populate the new SQL database. I have tried to link my existing local Access forms to my remote SQL sever database. However, my forms have many lookups that pull thousands of rows of data; so performanc... 5 09.08.2006 20:31:21 Convert VB.Net Datatable to Access File So I've used ado.net to retrieve me a data table and I want to drop this as an mdb file. Does anyone know how to do this? Everyone seems to be going in the reverse direction. Thanks! ... 2 09.08.2006 10:18:13 ADP and SQL data concurrency One of my developers tells me when using an Access ADP against a SQL Server 2000 back in there are concurrency issues. He has seen one user edit a record while another user has the same record open and then the second user can make changes and save the record without receiving any "the data has changed" prompts. Any ideas here?... 2 08.08.2006 02:18:55 How does Access change primary key value in RI relationship? We are using .adp projects. Lookup tables typically have a single field for the key to a lookup table that populates combo box lists. These lookup values are stored "as is" in the detail data tables, and RI'd back to the lookup tables. Example: lookup table primary key values for a Color table, primary Key (ColorID): Red, Brown, Blue, Green, etc. Data table has a column named ColorID... 2 08.08.2006 01:57:55 recordsource i need to store a forms recordsource in a variable. when i use me.recordsource i get a SQL statement. the form is bound to a table - not a stored proc or view. ? ... 4 08.08.2006 01:50:25 DoCmd.OpenReport with Where condition - how to show Where value on report Hi, I'm opening a report from code and I'm using the Where parameter of the OpenReport method. Is there a way I can reference all or part of that where condition in the report itself and print it in the Report or Page Header? thanks, Bruce ... 4 08.08.2006 01:43:15 sql in access with date format hi. i want to group by date field and display it in format of dd/mm/yyyy. the problem is when i use the order by Format([dateCreate],"dd/mm/yyyy"), its not order by real date. any solution for that ? ... 2 07.08.2006 15:26:10 New to ADP and Confused on Parameters/SP I have been using Access for about 15 years now, have taught myself enought to fumble thru the VBA programming issues I wanted to use and now I feel like I am back to square one. I had been developing a front end for a SQL back end using linked tables that were giving all kinds of problems looking links and disallowing appends, etc. Then I came across the Access ADP which seems to be specif... 2 05.08.2006 14:57:41 Re: Get up to $2oo Free ,njas "ching" <ttn.alq@msa.hinet.net> ¼¶¼g©ó¶l¥ó·s»D:... > Casino Glamour > > Welcome New Players > > Double Your Deposit¡In > > Get up to $2oo Free > > http://www.casinoglamour.com/S13KV1 > > ... 1 05.08.2006 10:01:22 Get up to $2oo Free ,nj Casino Glamour Welcome New Players Double Your Deposit¡In Get up to $2oo Free http://www.casinoglamour.com/S13KV1 ... 1 05.08.2006 10:00:34 Select based on value of 2 fields I need to select data from a table that could come from one of two fields depending on the values. In Access query, I used the following and it worked: BN: IIf([BranchRandom] Is Not Null,[BranchRandom],[Branch]) Can anybody tell me how to do it in SQL for a form in a ADP Project?? Then I only pull records that match the Branch# entered in my form by using: [Forms]![frmCreateRandomsP... 3 05.08.2006 02:11:48 Open pop-up form for certain client I have a process that I need to move from an Access .mdb database to an Access .adp project and I'm having trouble with one part. I have a macro that opens a pop-up form for the client on the main form and shows a "count" of how many employees that client has. Then I copy that count, close the pop-up and paste the number in a text box on the main form. It works perfectly in the mdb, b... 2 05.08.2006 01:04:27 auto populate date field Greeting all. On a form I have 2 combo boxes, one for month and one for year. I also have a text box for a date. If I use the combo boxes to choose August 2006 on my form, how can I make the text box on the form to autopopulate to be 8/31/2006? Basically I want the date box to autopupulate the record with the last day of the month picked by the combo boxes. Is this possible? Thank ... 2 04.08.2006 03:46:14 Newly separated front ends progressively corrupt. We have an ADP that was converted from an A97 database maybe 3 or 4 years ago. Until recently, the lone front end was shared by about 10 users. Corruption got to be a very large problem in the front end. Recently, each user got his own individual .ADP. Corruption is still occuring: One of user a's forms will go bad and his .ADP gets replaced by user b's copy that isn't experiencing the pr... 5 03.08.2006 22:00:02 test1 test1 ... 1 02.08.2006 16:50:32 SQL Server Versions Hi Anyone here have experience with SQL Server 2000 and 2005 on the same PC? At the moment, there is SQL 2000 on the server. There is a live database and a test database. Now, I'd like to do some work with SQL 2005, and the new Access 2007. But that live database will not be updated for a while yet. I'm guessing there will be a problem if I install 2005 on the server. (probably wouldn't b... 4 01.08.2006 12:20:54 difference between 2005 sql server and sql server 2005 express Does anyone know what the differences are between the full version and the express slq server 2005 are? Or send a link to a site that might lead me in the proper direction. Thank you in advance. ... 2 01.08.2006 12:12:24 Recordset How can I bound a recordset to a graph? I try the following and didn't work Me!RowSource = myrecordset Any ideias? Thanks JosÉ perdigao ... 1 01.08.2006 09:15:40 At the end of my rope: can't change first record and move away I have a form in an ADP connected to a SQL Server 2005 backend, with a record source that is a view that includes two joins but is still updateable. The form has a list box control in the header section that is supposed to allow the user to select a record to show in the detail section, set up by the list box wizard, which created the following code to implement this functionality: Priv... 8 31.07.2006 18:23:29 Active Directory Username I would like to make the default value for a field the current logged in username so that on inserts it captures the creator. How would I update a "last modified by" field on edits? Using SQL 2000 w/ Windows Authentication THANKS... 2 30.07.2006 23:03:03 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