Threads Replies Last Post 44 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>   test2 test2 ... 2 8/19/2006 3:42:07 AM DoCmd.TransferSpreadsheet acExport using a view as the source is there some reason i can't use a view as an export source with DoCmd.TransferSpreadsheet acExport? i gat an error message that says my view cannot be found. triple checked the spelling etc. tia, mcnewsxp ... 1 8/18/2006 2:24:22 PM Case When Greetings everyone. I need help with a stored procedure. I need to add a column to enter a value, either 1,2, or 3 depending on the value of another field in the query. For example, if the value of the independent field is 'apple' I need the new dependent field to populate '2'. I think I need to do a case when statement, but I can not get it to work. Is this anywhere close? case wh... 7 8/18/2006 12:54:51 AM Push and Pull I developed a database using access. One of the item requires that if an number is chosen the description of the material number must be shown with it. This part works for me; however, once the rest of the info. is entered the information of the both number and description are not displayed in the table. Can anyone help? I'd appreciate any advise. ... 1 8/17/2006 9:23:53 PM ÎÒµ¨´ó ÎÒµ¨Ð¡,¼áÇ¿,ÓÐÓÂÆø,³äÂúÐÅÐÄ,ÓйÇÆø,´Ó²»µÍÍ·. ... 2 8/17/2006 2:14:10 AM Global Variables for Query Parameters I am missing something very basic that I need so I apologize for my inability to grasp the obvious (because I'm sure it is) in advance. I had an .mdb that I have converted to .adp. There are many forms that provide the criteria for either the underlying queries or recordsets such as... PARAMETERS [Forms]![CallList_Frm].[BegState] Text ( 255 ), [Forms]![CallList_Frm].[BegState] Text ... 4 8/16/2006 4:14:19 PM Relationships - Cascade Update and Delete Hi I set up Cascade Update and Delete relationships in a Database Diagram, within SQL Entreprise Manager. The relationships were to a Clients table. If I change the Clients table design within Access ADP, I get message like the ones below. It removes the Update/Delete that I set up. 'Submissions' table - Relationship 'Submissions_FK00' is marked for CASCADE UPDATE. This attribute will... 1 8/16/2006 4:00:49 PM Problem after upsizing I've done the upsizing of my Access database with the SSMA wizard of Access. This has worked well, but I've got the following problem: On a lot of places I have this code: Set DB = DBEngine.Workspaces(0).Databases(0) Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE) When I run the code, it gives me an error: 'Illegal operation' (something like that, I have a Dut... 7 8/16/2006 3:02:17 PM SQL Tables I'm trying to convert a complex .MDB database into .ADP. This is all new to me so I'm learning. I have read here that ADp files don't have data. If this is so, where is the data? Currently all my data resides on an MDB file (I long ago split the code from the data). What do I have to do to get those tables onto the SQL server so my MDP front end can see/connect to them? Please be v... 11 8/16/2006 1:32:10 PM ADP - on each users PC? Hi When I used mdbs, I always put a local front end database on each PC, with the data on the server. I'm new to ADPs, but I'm guessing that the same idea applies. A workmate is suggesting that one ADP on the server will do the job. Now, I thought one of the reasons for storing the frontend locally, was to stop the forms and reports layout date being transferred over the network. Wha... 7 8/16/2006 8:27:13 AM Looking for recomendation for Web Based front end I have just converted several mdb's to adp's and now would like to migrate to a web based product like .ASP. Does anyone have any recommendations as to which product would be the most practical. I have about 150 users on military bases and it is a real pain every time I make a change to the front end and have to push a copy out to the server and have them grab it. I will still use SQL as the... 4 8/16/2006 8:14:59 AM ´ó¼ÒºÃ Ϊʲô½ñÄêµÄÌìÆøÕâôµÄÈÈ£¬ÓÐË­ÖªµÀÂ𣿠... 1 8/16/2006 1:51:36 AM ´ó¼ÒºÃ Ϊʲô½ñÄêµÄÌìÆøÕâôµÄÈÈ£¬ÓÐË­Äܹ»ËµÒ»Ï¿´·¨Â𣿠... 1 8/16/2006 1:50:29 AM 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 8/16/2006 12:50:28 AM 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 8/10/2006 9:43:53 PM 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 8/10/2006 7:57:46 PM 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 8/9/2006 8:31:21 PM 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 8/9/2006 10:18:13 AM 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 8/8/2006 2:18:55 AM 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 8/8/2006 1:57:55 AM 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 8/8/2006 1:50:25 AM 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 8/8/2006 1:43:15 AM 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 8/7/2006 3:26:10 PM 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 8/5/2006 2:57:41 PM 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 8/5/2006 10:01:22 AM 44 Pages: <<  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  >>