Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Not enough space on temporary disk, MaxLocksPerFile, MaxBufferSize Hi, I have a problem with error mesage 'Not enough space on temporary disk' I want to edit a field in a table, that is a source in relations with 5 other tables. Editing this field changes its value in about 7 millions records included in the 5 dependant tables. With MaxLocksPerFile = 9500 (default value), I get an error: 'Too many locks. Increase the MaxLocksPerFile parameter.' ... 6 28.04.2006 01:01:44 Set control's visible property value on a nested subform From a public function in a module in Access I'm trying to set the visible property to false on a control on a nested subform. I have the main form (frmModuleWeeklyReport) with a subform (Workstream Name, Status & Comments). The subform (Workstream Name, Status & Comments) has a subform (Deliverable Detail) which contains a control (SBDelivTargetDate) that I'd like to make invisible wh... 4 27.04.2006 16:47:01 How to use cursor in select statement ? I have following statement. SELECT inv.PARTNO, inv.DESC from INV where inv.partno = me.partno.value I want to save this part no and desc so I can use it while inserting to the table. In SQL, I use INTO CURSOR XYZ and I can retreive my part number like this: SELECT inv.PARTNO, inv.DESC from INV where inv.partno = me.partno.value INTO CURSOR XYZ And xyz.partno usual give me part ... 2 17.05.2006 00:38:11 Populate table from recordset Can someone point me to a good example on how to populate a table from a recordset. I have a stored procedure on an MS SQL Server that links tables tables between an Oracle DB and the SQL db. Because of the size of the Oracle tables, it's most efficient to EXEC sp_ExecuteSQL in the MS SQL Servers stored procedure than to try and link the different tables directly in Access. The re... 1 18.05.2006 16:18:02 convert Lab colour to RGB Hi, I have the colour in CIE Lab coordinates and want to represent in a control of a form. Exists a function or module to convert Lab to RGB coordinates? thnaks david... 1 16.05.2006 17:24:02 Linking Oracle tables with primary index and another index Hi, I have created under Oracle 9i a table RIVERS containing fields RIVER and DESCRIPTION. RIVER is used as primary key. In order to avoid that a user could enter in the table two rivers with the same name but written with a different case (Oracle is case sensitive) I've created another index based on Upper(RIVER). When I link the table to Access 2000 manually, the Access assistant ... 2 16.05.2006 13:29:37 Substitution of variable contents in a command Some languages allow you to force the interpreter to evaluate the contents of a variable in a command before the command is executed. Is there a way to do this in VBA. Here is an example. The objective is to develop a common routine to apply a set of transformation rules to the contents of a field in a table. The name of the table and the name of the field is supplied to the routine... 3 11.05.2006 14:36:01 Multiple Attachments I am trying to 'sendobject' through Access with multiple attachments (both queries formatted as xls). I only seem to be able to attach one object though. Does anyone know how to attach multiple objects to one e-mail? -- Cheers. Paul... 1 11.05.2006 14:30:01 Can someone please help me ? I am using VB.NET. I just created a form where user enters information. Once information is entered, user clicks ok button. While updating the table, I am getting an error and it does not update. I am using 2 tables, INVSHIP and PARTSQTY. Both have comon column called part. Once it matches, I want to grab the quantity from PARTSQTY table. I would appreciate if someone please help... 3 11.05.2006 12:26:37 Loosing modules behind forms Databases in Access 2000 (originally created in 97). The modules behind the forms seem to be gone. I have created new DBs in Access 2000, turned off "Track name AutoCorrect info" and imported the objects from the old version. During import I am getting the message "Can not start transaction; too many transactions already nested." Can not import forms with their modules. What can I... 1 09.05.2006 21:50:01 Running Code flashes to Object Window This just started happening with an upgrade to 2003. How do I disable this?... 1 09.05.2006 15:10:02 Foxpro SCATTER/GATHER equivalent Does anyone know if there is a VBA method, or a third party tool that give VBA (with ACCESS) an equivalent to Foxpro's SCATTER/ GATHER commands. SCATTER will take the current record, and generate and populate variables for every field in the records, by adding "m." in front. So if you have fields A, B and C with values 1,2, and 3. Scatter gives you the equivalent of Dim m.a,m.b, m.c m.a... 8 04.05.2006 08:50:01 Multiple Recordsets How do I open more than one table at a time in the same database using ODBC and ADO? The following code abends when I attempt to open the second table. Sub MultipleTables() ' ' Create the Recordset attributes ' Dim rs1 As Recordset Dim rs2 As Recordset Dim rcd_cnt1 As Integer Dim rcd_cnt2 As Integer ' ' Initialize the Recordset attributes ' ... 3 03.05.2006 06:42:01 Database datatype Access 2003: If I wanted to create an object variable as a reference object to the CurrentDb object property of the Application object, other than the generic Object datatype, is there a specific datatype that will work? It would be a shame if M$ took away the ability to set those object properties with the aid of AutoList tips Thanks ... 2 02.05.2006 23:01:28 Relinking Tables with VBA Hello, Please see my problem as outlined below. Any advice/suggestions would be appreciated! (Also not sure if I posted this in the appropriate place, please advice if so) Goal: When my database opens, if the developers-version of the database front-end is open, I would like to have the database prompt the user to ask whether or not Test data tables should be used, or whether or not Liv... 3 01.05.2006 17:46:04 Add a field to an existing table using vba In a userform I have used vba to run a make table query. I now need to add an Autonumber field to this table that restarts at '1' each time the code is run. If I use the userform to make the table and then manually add my autonumber field it always starts at 1, which is why I want to use 'Make Table' each time rather than 'delete' and 'append' queries. The only problem is I can't wo... 10 01.05.2006 11:51:37 Compile Error: User-defined type not defined We added a Visual Basic Module1 to an Access Database that uses both Access Tables and SQL Server Tables. Within the first executable function in VB Module1, we are getting the following error message... Compile error: User-defined type not defined The statement its attempting to execute is... Dim MyDatabase As DAO.Database I am pretty new to Access and accessing SQL Server through... 2 28.04.2006 21:42:43 progress bar Hello, Can anyone tell me how I can show a progress bar while a module is converting data. I import large text files and this take up to 2 minutes. So it seams that the computer crashes when importing. I tried to give feedback to a form but the changes made to the form are not visible until the procedure has ended.... 4 27.04.2006 04:37:10 Shell command in Access Module dos not work on Windows 64 machine I have an application in Access 2003 that works fine on a windows 2000 server. Users access the application through terminal services. One feature of the application is using a Castelle Box for faxing information from the Access app. This is accomplished using Shell() in VBA fax via the Castelle Box (it came with a command line submitfax.exe). Now I am moving the application to a Win... 1 26.04.2006 19:10:02 y_board_Enter_function)_on_Form. Hi, I am using FORM to enter ID number and Employee number. For this I am using touch screen. We are not using key board. I just need to create Macro or VB code with a Command button when press this button need to do “Enter” . Then it is going to next field. Any help would be appreciated. Indu Create a button to do “Enter”(Key board Enter function) on Form. Indu ... 1 26.04.2006 15:55:03 Passing Arg Type of Control to a Public Sub I have a public sub that references a control from the calling form, Dim ctl as Control. The control happens to be a ListBox, however I have two of these on the main form and would like to use the same Public Sub with each. As both ListBoxes have different name properties how do I pass the reference in the subs arguments so that I can use it in the ctl variable? Regards ... 8 24.04.2006 22:37:39 Populating a Treeview Control Hi, I have tried using the knowledge base instructions on populating a treeview control, but cannot seem to make it work. Basically, I want to populate a treeview control with a list of 'Pot names' which are used to refer to collections of data. I then want a branch that will show a list of filenames for their relevant pot. Can someone show me how this is done simply? Cheers, Ste... 2 24.04.2006 16:02:38 ADO/DAO Form.Recordset Suppose you have two MDBs, one for the GUI, the other for the data. I do not want to use DAO, I want to use ADO. Probably simple question, but what do I have to do for using ADO inspite of DAO? I removed the reference to DAO, and inserted the reference to ADO. What more has to be done? For example, what about the Form.Recordset object? It is a DAO.Recordset object. How can this be ch... 8 24.04.2006 10:31:06 Invisible Break Point?!?!? I have got a strange occurance going on with a piece of code. It functions as it should with no problems apart from it goes into the debug window and execution stops on a certain line of code. It is a recently added piece of code and I would of placed a breakpoint on it. When the code goes into break mode, the breakpoint is not visible!!! I know the simple solution is to press F5 to ... 8 21.04.2006 09:13:01 Application window size change Is there a way to change the Access window size when I open my database. I have a small form, with very little data entry in this case. I would like for the application to open to a specific size. Thank You... 2 20.04.2006 15:32:32 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13