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   font size I have a report in a 2003 ADP (SQL Server Backend) that I need to enlarge the font size to 272. Access limits the font size to 127. Does anyone have a work around that I could use? Thanks in Advance ... 4 26.01.2006 03:44:30 Printing Pictures out of SQL Server I need to develop an ADP file that can print a few different reports. The one that I am having difficulty with now is a contact page that prints a person's picture and name below it. I have my pictures on a server and a link to the location in my SQL Server database. All of the pictures are 2.5" x 2.5". I want to have about 8 or so pictures on each landscaped page. I have built a vi... 2 26.01.2006 00:25:18 SQL 2000 + SQL 2005 Express Compatibility Hi everyone Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS jumped on the freeware train and gave us SQL 2005 Express Server. In my opinion it has just just the same key feature as the SQL 2000 developer edition: for developers (simple applications) to use on one single machine. So I was pretty convinced that it would be easy to restore a new SQL 2005 ... 5 26.01.2006 00:19:36 Highlight current in a form in an ADP database I would like to highlight the current record in a continious form in an ADP database. I found some solution for *.MDB but they are not working in ADP (recordset findfirst not supported in ADP). Any thought ? ? ? FRED ... 3 26.01.2006 00:17:01 Combobox not showing all values from rowsource Using Access 2003 ADP linked to SQL Server 2000. I have similar comboboxes in a couple of forms. The rowsource for each combox is a simple select statement on a table. When I open either form not all the values are listed in the combox. The tables contain about 15,000 records each, but the combox seem to list up to the 10,000 record. How can I make sure the combox has all the values... 3 25.01.2006 21:46:02 calc columns so who is the PM at MS that let ADP ship without testing calc columns? i mean-- from what i see that PM should be fired.. i've just had a bitch of a time with calc columns in ADP. SHOULDN'T THIS BE EASIER? SHOULDN'T ADP BE A GATEWAY TO TEACH MDB NEWBIES ABOUT SQL SERVER? ... 4 25.01.2006 19:02:48 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 2 25.01.2006 06:39:08 Images / Pictures All, I have to store some huge pictures in an ADP project. The current needs are : A small version of the image (ca. 100 Kb at most) A High-Res version (ca 3Mb, not depending on the hardware used to take the picture could go up to 30 Mb at least) I need to do the following : - Generate the smal image automatically when the image is inserted. - Display the picture properly - Be able... 4 25.01.2006 04:39:38 IPF Error after simple form change Hi, I have an ADP file created in MS-Access 2003 SP1 that is working very well. Unfortunately I have to deploy on workstations having MS-Access 2002 SP3. I have rarely experienced a problem with this risky behavior but today I think it has caught up with me. On my development box (Access 2003) I added a simple check box to a form. It's bound to a SQL server field (within a recordset... 9 24.01.2006 21:45:54 Write Conflict - cascading combo boxes ADP Hi everyone, I'm building a client/server DB with Access as the front end and SQL Server as the backend. I have a subform in which I'm using cascading combo boxes, however my design seems to be failing! I've found several examples, and have used them. The cascading does work, but everytime I insert a new record on the subform, I get a "Write Conflict" error, asking me to either un... 14 24.01.2006 07:09:26 Convert to ADO for SQL Server back end I've read through some posts on the ADO vs. DAO question. Most seem to be around a year or so old. So: I have an Access app that uses almost exclusively unbound forms and DAO for data access. A potential client won't accept the Jet backend and demands SQL Server. I did some preliminary work and upsized my Jet tables to SQL server. I also created ODBC links to the SQL Server tables fr... 3 23.01.2006 16:19:09 Access 2003 and SQL 2005 Hi, By creating a new project in Access 2003, which should be connected to SQL 2005, I get the message, that the SQL Server is newer than SQL 2000 and Access 2003 does not support this version. Is Access 2003 not supporting SQL 2005? Do we need a patch for Access? (Office Update Center tells me, that my Office components are up to date) Thanks for your hint. regards Patrick ... 11 23.01.2006 16:15:13 Running a Stored Procedure Using a Form Event I have an Access Data Project (ADP) in which: 1) I want to run a stored procedure (that returns no records) triggered by the AfterUpdate event of a form control 2) The value contained in the form control (after being updated) needs to be passed to the stored procedure as a parameter. What code do I need to put in the AfterUpdate form control event to trigger the stored procedure? Wh... 5 22.01.2006 18:05:50 COMPARE FIELDS QUERY Hi I need a query that searches 2 fields in 2 tables. Below is an example. There are 2 numeric fields in each of the 2 tables containing numbers such as 51.565842 in 1 field and -0.331336 in another . I need the query to search the other table and to compare the first 3 digits ie 51.5 and -0.33 and return a result, if that result returns more than 1 record then the query searches the nex... 2 22.01.2006 17:03:34 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 16:13:36 Free Hot Phone Sex +8613352960090 100% Free multi-lingual AnimalSperm Production elmar@digi-art.de ... 1 21.01.2006 15:35:09 No of queries in Batch Is there any limitition in no of queries, in stored procedure when we are working with batch queries? If so how many queries we can create in batch? -- Thanks and Regards, Senthil Kumar M. Cycus Technologies Pvt Ltd R-501, Remi Bizcourt Shah Industrial Estate Off Veera Desai Road Andheri(W),Mumbai 400 049, India Tel: +91-22-5675-6612/13 Mobile: +91-98 197 21911 Fax: +91-22-567... 1 21.01.2006 10:56:09 Concatenate Error I am trying to create a form with a concatenated field to solve a one-to-many relationship as explained in this example. http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic%20Function%20To%20Concatenate%20Child%20Records' The example works great, but I can't duplicate it. I've made (what I think is) an identical database, but I get an error in the field that should be ... 5 20.01.2006 16:36:03 Custom OnDelete in Adp Project Hi, I have a following problem in my adp/SQL Server project. Having two joined tables Invoice-Customer on a form frmInvoiceOverview in a Datasheet mode I need to delete just records from the table Invoice. In order to do this deletion I use the OnDelete hanler, so my routine looks like: Private Sub Form_Delete(Cancel As Integer) DoCmd.RunSQL "DELETE FROM Invoice WHERE InvoiceID = " & M... 6 20.01.2006 14:06:52 Error: Cannot create new transaction because capacity was exceeded Hi everyone, I have an adp project I have been using for some months now, but this morning I got the following error: Cannot create new transaction because capacity was exceeded. I get the error in a ADO code with a transaction block. Can anyone tell me why I get this, when previously this code had worked without any problems. And what the cause is of this error? TIA, Mart... 5 20.01.2006 13:23:38 Link to an image Hi there, I have a table that has stored images. I want to link those images to a form using a bound object frame, on update of a combo box (eg. If I pick "1" from the combo box, I want the image for record 1 to display). The table I'm pulling the images from is not the source table for the form. I am trying to use the AfterUpdate() method to do this. Problem is, the image isn't displa... 5 20.01.2006 08:19:06 ÎÊ£ºÍøÕ¾ÊÇasp+sql¼ÜÉèµÄ£¬ÏÖÔÚÔÚµçÐÅÓÐһ̨~~~ ÏëÔÚÍøͨÔÙ·Åһ̨·þÎñÆ÷£¬ÏÖÔÚÁªsqlÊý¾Ý¿âµÄ»°ÊÇÓõçÐŵķþÎñÆ÷ipºÍsaÓû§Á¬ÄØ£¬ »¹ÊÇÔÚÍøͨµÄ·þÎñÆ÷ÉÏ×°¸ösqlµÄ¿Í»§¶Ë£¬È»ºóн¨¸öʵÀý£¬Áª½ÓµçÐŵķþÎñÆ÷¡£ ... 1 19.01.2006 06:21:37 MSDE + SQL 2000 Newbie Question I am using Access 2003 and have installed SQL Express 2005. I don't know too much about the whole SQL thing but I want to start using ADP. I have tried to install SQL Server 2000 Developer Edition but am having error message come up that is stopping me. Ques 1: Do I need to install SQL Server 2000 or will SQL Express 2005 do the job that I need to in order to develop? Ques 2: Where... 5 18.01.2006 15:26:52 How to refresh current field/record only ? Hi :) I have an Access ADP bound to MSSQL 2005 EE. Some updates that I need to do in Access are performed thru server's stored procedures Access' form got interface like this: textbox 1(bound to table field and locked) - to display current data + commandbutton1 to open some modal form1, fill it in and update DB thru ADO Command object. After user executes that update I need to display ne... 1 18.01.2006 09:29:40 add new user in SQL server How can I add new user in SQL server through Access ADP? User name should be the same name of windows login and the password should be saved. Is it possible? Thanks José Perdigão ... 5 18.01.2006 06:51:55 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