Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Access Runtime - Reinstall Compiled Project with Data I am starting over explaining a problem we have - please disregard previous posts as they are misleading. We designed a VBA Application using Office 97 Developer Tools. We distributed this as an ACCESS RUNTIME application. The database was split into MDE & MDB, we ran the ODE Setup Wizard to create installation floppies. The customer added data to the application. If relavant, our custom... 3 07.12.2005 18:09:53 back end relative reference in a distributed application I have a split db that my client needs to distribute to vendors. The zip file contains a folder, MSDS, that contains a folder, BE, that contains the BE.mdb. In addition to the MSDS folder and its contents, the zip file has the Hazmat. mde FE file. How do I link the FE to the BE when I distribute the zip file? The links all refer to my desktop. Is there a way to create "relative" links in Acc... 3 05.12.2005 22:41:01 Maximum Number Of Records Hello, can smb tell me where i can find information about what is the maximum number of records, that can be stored in Access 2002? -- Thanks:)... 2 05.12.2005 11:05:37 how are you? l like make friends. ... 2 05.12.2005 06:25:40 Licensing: Distributing Office for dynamic report generation in vb6 app. Office 2003 (11.0), 2002/XP (10.0), 2000 (9.0) I am looking at Office XP/2002 developers edition to allow for some dynamic Access report generation from with a VB6 app. I read that 2003 starts to require Visual Studio Office Extensions or something of the sort, is this yet a new name for ODE ? Is Office 2003 ONLY capable of being included in a .net app ? From what I read on the groups here, it implies it's only available through .net. ... 3 02.12.2005 19:24:17 Package and Deployment Wizard - where is it? (ACCESS 2000) Hello -- I feel stupid asking this question: I can't find the PDW that I thought I installed. I installed what I thought would include the Package and Deployment Wizard from an MSDN subscription CD (Disc 13) 0100 Part No. X05-34801 Dated: January 2000 Can someone tell me if the PDW is included in this CD? If it is, can you tell me what is the file name that it installs on my ha... 3 02.12.2005 06:59:26 Querry by current month I would like to have a querry that displays data for the curent month only without having to always update the query on the first of each month. ... 3 02.12.2005 03:06:01 If only runtime is installed, what happens when double-clicking an mdb I've never tried this; anyone know, will the Access runtime be invoked to run an mdb file if retail Access has never been installed? I know there would be many limitations (no design etc) but I'm curious about the basic question here, does the Access runtime (2000-2003) act like a regular copy of Access in that it takes over the mdb extension as it's own? I mean a simple mdb that wasn't ... 2 01.12.2005 21:49:22 Problem with limit of DoCmd.RunSQL Hi, I use the command DoCmd.RumSQL (select * into tempTB from table1) in VBA. The command runs fine but only insert 199 items. (tabel1 has 3000 items) How can I run the command, so that all 3000 items are insert in tempTB. Thanks Otto ... 2 30.11.2005 22:31:58 Update Excel Spreadsheet from Access VBA I want to read in an Excel spreadsheet (multiple sheets from a workbook), update some of the cells, then transfer that range of cells back to the spreadsheet. I don't mind treating the whole sheet as a table, but the ADO Update method doesn't work and I can't find any other ways other than "export spreadsheet" method, which requires transferring the whole sheet at once. Strategies? -- ... 8 30.11.2005 21:42:01 Fails to Sort in subform on chosen field I have a main from based on a table, sorted in ascending text order, with a subform, based on a temporary table sorted on Surname. When actioned the subform sorts on a different field, the 1st in the subform irrespective of what I try and do. I need to keep the temporary table to identify changes to data and not use a query based subform. The field in question does not form part of the P... 2 30.11.2005 02:35:52 ÎïÌå ... 1 30.11.2005 02:34:20 Excel and Access user permissions If i'm importing and exporting excel from access, I can do this until the cows comes home. Where I have the probem is I need to either pull or update a particular cell in a table or have the ability to format the cell. From what I found (trial & error) is that the user must have power or admin user rights on the local pc. Is this correct? If it isn't, what kind of permissions neede... 4 28.11.2005 21:30:18 Hi everybody! I'm very like studing networking but it's very difficult. Someone help me? ... 1 26.11.2005 07:47:06 ??????? ????? ... 1 25.11.2005 07:07:55 Access a table via VB I am trying to access a table using a module in Access 2003. The help documentation tells me to add this line: Dim dbs As Database I get an error that says "User-defined type not defined" Dim cnn As New ADODB.Connection works in another sub routine. What am I missing? Tim... 4 23.11.2005 20:20:54 X button I'm developping a small software that i want to run on a stand alone workstation. I've used the runtime pakaging wizard from access developper extension tools. I want to disable the Access main windows X button. i've disbaled the menu bar and tool bar but i cant seem to find the wait to disable the X . I'm also looking for a way to disable the alt+tab, control+alt+delete, etc... O... 3 22.11.2005 22:10:04 Cannot Right-Click in Access Database Hi, We have numerous Access 2003 Databases. When we install the full access version on a user machine all works fine, i can view employee details etc. When i install the Development package that i have created from Developer Extensions, i cannot right-click within a Database. Is there some button i missed to allow this or a tick box? Please help Kevi Dunne... 2 22.11.2005 19:39:11 ÊÔһϠÊÔÒ»ÏÂÐÂÎÅ×é ... 2 21.11.2005 02:34:25 ÈçºÎѧºÃÍøÒ³ ´ó¼ÒºÃ£¬ ÎÒÏëÖªµÀÔõôѧºÃÖÆ×÷Ò»¸öÍêÃÀµÄÍøÕ¾ ... 2 21.11.2005 02:34:03 List, Select, Show I'm creating a database in Access 2000. I've creted parameter queries to prompt the user for a job number prior to showing the records in a data sheet. What I need is code to: 1) After prompting the user to enter a "job name", list all the job names in my own form; allow the user to select a name from that form and then display the results in another form. Thanks in advance.... 3 19.11.2005 01:54:03 Order Details Form Hi, I am a beginner. I am running Access 2003 on XP Pro sp2. I have a form based on the table Orders. In that form, there is a sub form based on the table OrderDetails. The idea is to do much like what the NorthWind sample does, namely, allow the user to add lines in orderdetails. My table OrderDetails has a column of type Currency called 'LineTotal'. This column is the last on... 1 18.11.2005 23:29:02 Access 2003 and SQL Server 2005 I tried to use Access 2003 in combination with SQL 2005 Express, but it seems like it is not possible - unlike SQL 2000 - to create/edit SQL Server Objects within Access 2003-Projects. Does anyone know wheater there is an patch exisiting or microsoft will implement the edit-features only in the next version of access. Furthermore has anyone made expirience with access and sql server 20... 1 18.11.2005 16:35:54 How to call crystal report in access application can anyone help me in my problem? I made a report in crystal version 9 and i want to call it in my Access database. In viewing the report is it possible to make a toolbar that the user can only viewed and used. First question: How to call crystal report in access application and second how can i make a toolbar in crystal that specifically for the user to view and used. thanks. -- Message... 1 18.11.2005 03:42:33 VFP 9 SQL connection sharing A database accessing SQL via ODBC with sharable remote view 'A' will share the connection (IE have the same connection handle) only when view 'A' is opened multiple times. View 'B' in the same database, with the same connection name that is also sharable will create a new connection handle when used. A second use of 'B' will share the connection originally used by 'B". But 'A' and 'B do n... 1 17.11.2005 17:16:11 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12