Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   questions on access database application developed by someone else Hello, My name is Edward Letendre. I have been asking questions to this group about an access database application that was written in Access 2.0 but is being converted to access 97 and will become a split database. Anyways, I am testing the split part of the database. The split database seems to be functioning okay. What I need to know is how will my code be effected by the splittin... 1 21.12.2005 03:44:02 Field Query help I would like to insert text in a report like = Iff( [SIEquiSer] =E*, 0, "Serviced to manufacturer specifications") if the field [SIEquiSer] starts by E* then print "Serviced to manufacturer specifications" This field come from a query Regards Michael Clavien Indcontrol Electronics CAMPERDOWN NSW 2050 Australia Ph: +61 2 9519 6650 Fax +61 2 9519 7460 ... 2 21.12.2005 01:09:12 creating a Connection using ODBC Hello friends, I have a problem. I hope that you can help me. My problem is that I need to create a connection ODBC in run-time. The application is an Access file that runs a VB code. The code that I run is: #If Win32 Then Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" _ (ByVal hwndParent As Long, ByVal fRequest As Long, _ ByVal lpszDriver As... 1 20.12.2005 09:56:02 currentproject.connection.execute high severity error Hi, I do an abstract of my situaton. I have 2 machines for server. First (production) SBS 2003 SQL server 2000 SP3a & MDAC 2.8 Second (dev) XP SP2, MDAC 2.8 SP1 The errors i get are the same if i connect on the first or on the second server. I develop on Access 2003 SP2 , with mdb project format 2002-2003. Recently I have created a new 2002-2003 project and imported all forms, modul... 1 16.12.2005 09:51:02 Linked Tables Hi, I'm using an MDB that has to connect to several MDE's. I have worked out the automatic creation of all those links in VBA. This works fine, but only if the MDE's are not opened at the same time by another user. So, I have to ask at those people to close their MDE ... Is this a normal behavior? Is there a workaround? Thanks in advnace for any help. EDS -- edsPosted from - http:/... 2 15.12.2005 22:09:01 DAO 3.51 vs DAO 3.6 I am having an issue with various PC's and the references set in my Access DB. I am using Access 2002 and have DAO3.6 seleted as a reference but on ertain PC's I am getting an error saying "That command is not available." When debugging the error hits on the .edit of a recordset. What I have found is that on the machines where I encounter this problem, the only DAO available is the 3.6.... 8 14.12.2005 12:49:09 Converting existing MS Access Database to use MSSQL Tables I have a MS Access 2003 database that was originally created for one user to add data and run reports/queries. The problem is that there's a heavy push to modify this database so several people can read (and in some cases add) data to one central location. They also want the same reports ran. Anyway, I was able to copy the tables onto a MS SQL server. However, I'm trying to figure if I c... 7 13.12.2005 21:52:04 Trouble Updating Tables OK, I am a Access Rookie trying to teach myself Access using VBA. Undoubtedly, this has led me to DAO and ADO. A light has not quite gone off yet and I can seem to figure this out on my own. Any help would be greatly appreciated... I am using Access 2000. I can generate a recordset from a query using an SQL statement. I know it works because I can run it in the immediate window, w... 2 12.12.2005 19:57:41 Parameter Query for Multi-value List Box The following code opens an unbound report and applies selected values that are picked on an unbound user pick form containing multi-value list boxes to the query filter. The below code works great. I now need to add a total field on the same report. I've tried several ways to do this with no success. I created a new select query called TotalQry which has the following SQL: SELECT Co... 2 12.12.2005 17:48:02 SQL 255 character limit I'm using ADO within Excel. I have an Excel userform with a textbox that a user keys a long description. I assing that text to a variable in my SQL INSERT statement and add the record to a worksheet in a closed workbook. When the user keys a description longer then 255 characters, I receive an error. I know Excel can hold mor than 32k characters in a cell, how can I pass my users lon... 4 09.12.2005 21:51:54 Connecting to VFP Database I have a database that links to 2 VFP databases through ODBC Machine Data Source. I then have 2 make table queries that trim fields and replace the tables on demand. I recently discovered that the records can be modified if I open the linked tables - this is BAD. How do I make the connection read-only? Thanks LeAnn... 1 09.12.2005 20:50:02 jet error 3048 I am building an access app using the usual front_end.mdb - back_end.mdb model. As the app has grown, I have run into a problem that results in jet error 3048 when I try to open lots of forms with multiple subforms, list boxes, etc. The error text says "Cannot open any more databases" but since I am only using 2 databses(.mdbs), that can't really be the problem. I am using workgroup ... 3 07.12.2005 00:56:01 Using FindRecord & FindNext in VB modules Hi, I have a form that displays a recordset of data from a table. I have a textbox for users to enter a search string & a button labelled "Find" to do the search. The OnClick event procedure is defined as: Private Sub FindButton_Click() On Error GoTo Err_FindButton_Click Screen.PreviousControl.SetFocus If Me!FindButton.Caption = "Find" Then DoCmd.FindR... 7 06.12.2005 15:45:02 Add New Field from Access to SQL backend I have a client with an access 2002 frontend linked to a sql backend. I need to add a new field to the sql backend from access. I'm new to sql backends and work offsite so I don't have access to their sql server. I am tring to set up a wrkodbc.connection but am not sure of the commands to then add a new boolean field or if I even can. Thanks, Christine... 3 04.12.2005 16:58:03 Problem with CanShrinkLines module Any thoughts on the following problem? I LOVE the CanShrinkLines function, which works like a charm until -- it just doesn't. In one DB it is happy as can be, but in another it will work for a report and then arbitrarily give a #Name? error or ask for a CanShrinkLines parameter (and then #Error) in my report and divert to the debugger. I won't have changed a thing on the fields where it'... 4 29.11.2005 21:46:23 Fit to 1 by 1 pages In Access I wrote VBA programm to export a query to Excel and to change the page layout. DoCmd.OutputTo acOutputQuery, "Q_Totaal_Kruistabel", acFormatXLS, Left(CurrentDb.Name, y - 2) & "\Status" & Koptekst & "_" & Wiltekst & ".xls", True Set xlApp = GetObject(, "Excel.Application") For the Page Setup of the new Excel file, I would like to have the following settings: "Fit to 1 by ... 5 28.11.2005 15:45:01 Sending a Recordset in E-mail body I've hit a bit of stumbling block and hope someone can help. I'm attempting to generate an e-mail in access that has my company's release schedule attached as an RTF file and then put a list of specific products in the message of the body. My code for such is below. I'm having three problems with the data... 1.) I have to open the report before I run the SendObject command because of... 4 28.11.2005 15:29:06 ADO problems Hi All. This not Exactly an Access question but I figured this was probably the post appropriate group for this question. Background. I have an Excel spreadsheet that has a column of invoice numbers that need to be validated against a Great Plains database in SQL Server. As you might expect I am using ADO and VBA to acomplish the task. FYI: The spreadsheet is usually between 3000 and ... 1 28.11.2005 06:07:00 Help! How do I get rid of the confirmation messages Hi Hope someone can help me. I have a ms access program which I want to distribute, but users of the program a plagued with confirmation messages, so I have to talk them through manually switching the confirmation messages off: Menu: Tools | Options | edit/Find | then uncheck all the boxes in the confirm area: 'Record Changes', 'Document deletions' and 'Action queries'. Is there anyway I... 4 25.11.2005 10:28:36 What is the REAL difference between OpenQuery & the Execute method? The books say "DoCmd.OpenQuery queryname" and "cnn.Execute" statements run a store action query. However, the OpenQuery runs the same query we can run manually and the Execute statement runs some sort of stored query that is not always updated when the query is changed. As a result of this change running the query manually or with the OpenQuery appends to the the table the correct number... 5 23.11.2005 22:07:38 How to check the result Hi, all, In A2K VBA, after executed a select query command, how can I check if there is data in the result set? Thank you. GL ... 3 23.11.2005 16:07:14 Run-time error 2004 out of memory.Help I want to send e-mails in an automaitc way from Access 2000. I use Microsoft Outlook 2000. I have found the VB-code and sometimes it is working. Than suddenly I get an run-time error 2004 and cannot send any mail anymore. If I shut down access and start again 7 of the 40 mails are sent, beofre I get the error again. Sometimes I can sent 5 mails, sometimes 12. Here is the code: Private... 1 22.11.2005 13:10:57 Date Issues...Suggestions? Okay, so here we go again...the infamous issue with dates. I have a text file FTP'd to me every day. I have very little control over its contents, so please don't suggest that I "simply use an unambiguous format"...I can probably request that for next year, but meanwhile, I need to work with what I have. In the file (tab-delimited, no quotes, field names on first row), I have a date... 11 21.11.2005 19:12:13 Multiple choice quiz database Does anyone know where I can view examples of mutiple choice quiz programs done in Access? I'd like to create one but I need something to go on. Thanks!!! Jeff ... 7 21.11.2005 02:09:59 References code placement I am working on an Access 2000 project. If the user tries to open the db, there is a reference missing. I have the following code that I believe should reset the reference but cannot figure out where to put it to reset the reference when the project opens. I have put it in the OnOpen, OnLoad of the startup form, put as the first function at the beginning of the Autoexec macro. Any sugges... 3 20.11.2005 22:51:58 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13