Threads Replies Last Post 44 Pages: <<  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  36  >>   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 8/5/2006 10:00:34 AM 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 8/5/2006 2:11:48 AM 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 8/5/2006 1:04:27 AM 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 8/4/2006 3:46:14 AM 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 8/3/2006 10:00:02 PM test1 test1 ... 1 8/2/2006 4:50:32 PM 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 8/1/2006 12:20:54 PM 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 8/1/2006 12:12:24 PM 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 8/1/2006 9:15:40 AM 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 7/31/2006 6:23:29 PM 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 7/30/2006 11:03:03 PM 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 7/29/2006 4:47:21 AM 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 7/28/2006 7:02:19 PM 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 7/28/2006 11:29:24 AM 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 7/27/2006 7:27:59 PM 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 7/27/2006 5:34:30 PM 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 7/27/2006 1:12:23 PM 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 7/27/2006 11:44:23 AM 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 7/27/2006 12:45:11 AM 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 7/26/2006 5:01:42 PM 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 7/26/2006 4:51:59 AM 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 7/25/2006 10:12:19 PM 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 7/25/2006 5:26:02 PM 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 7/25/2006 11:14:25 AM test this is my test for news group. ... 1 7/25/2006 11:12:52 AM 44 Pages: <<  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  36  >>