Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   How to determine if a TEXT field contains all numeric characters? I am looking at a text field in a table and only want to determine if there is a string of numeric characters. What VB code will do this? Thanks in advance for your assistance.... 4 28.03.2006 16:58:07 Step through records? Hello All I have a fairly complex A97 mdb, which includes a macro which uses the SendObject command to email a report to an individual. The report is based on a query which takes as a parameter the value of a combobox selected by the user - this is in fact the name of the individual that the report is about. The individual's email address is also picked up from the current form. Is... 16 23.03.2006 09:38:01 Execute against mdb2 from module code in mdb1. Using MS access 2003... I am running code in mdb1. I want to execute some actions against another mdb, call it mdb2. If I have the following code (below) in one of mdb1's modules then when executed, it will operate on mdb1 (i.e. the linked tables will be created in mdb1): DoCmd.TransferDatabase acLink, "ODBC Database", rcs!ConnectString, acTable, rcs!SourceTblName, rcs!TargetTblName, ,... 3 22.03.2006 14:19:26 Error 2387-Deleting Tables Involved in Relationships w/VBA code Hi, I'm running Access2002 on WinXP and trying to programmatically delete tables, but keep encountering the following error message: "Run-time error 2387: You can't delete the table 'Acknowledged'; it is participating in one or more relationships." Is there a way to delete these relationships first using vba code and then delete the tables? This is a sample of the co... 2 20.03.2006 18:17:34 Query changes Hi I have a number of databases which contain a table called CLASS in which I need to change the field names. Problem is the table is used in a number of queries in each database, and I will need to change the field names of every instance of this table where it appears in a query and where the query lies in the database. I know to use the looping For Each Statement, but as I am new... 4 20.03.2006 18:02:08 Copy text from Memo field, paste into clipboard or directly into W I found this article on the KB:96900; but can anyone provide clearer instructions. It's been a while since I did any real programming and creating a function vs a module in vba has already got me stumped. Basically I want the field where my cursor is currently active to select all the text within it and copy it to the clipboard. Thanks... 3 20.03.2006 17:57:28 prevent user from opening an opened application twice how can i prevent user from opening an opened application twice? thanks ... 2 19.03.2006 21:53:03 How can I... How can I assign the next correct DO03 channel number and still have the DO02 channels numbered correctly? I have a query based on a table: tblSignals. tblSignals has the folowing fields: SignalName, chassis, slot, chan, devcodeID, cardType. The query describes a system that contains several electronic chassis, each chassis with circuit cards in slots (the slots are numbered), The cir... 3 17.03.2006 16:59:36 copyfile issue I need help. I am trying to simply copy a dll file from a server to a users system directory. I have looked around and it seems like I should be using copyfile to accomplish this. I can't seem to get the syntax right for using this command. Can anyone give me a real example of this? I'm struggling with the filesystemobject portion and what to put in that area. Thanks and pl... 6 17.03.2006 14:08:17 Create A Form Instance??? I am interested to learn if anyone knows of a method to dynamically create an instance of a form by use of the form name? This would be apposed to the standard method of Set frmVar = New_MyForm. An example of what I would like to do is something like this: Function OpenFormInstance(strFrmName as string) as Boolean Dim frmVar as Form Set frmVar = New ?strFrmName? ...... 8 16.03.2006 21:28:43 Sending email Hi All: I should say that I am pretty new with working with modules in Access. Should also say that I am running Windows XP and my version of Access is 2003. I found some code at the MS Knowledge Base that purports to do what I would like to do, and after fiddling with it a bunch, I do have it more or less working with a couple of exceptions. Below is the code I am using (sorry abo... 2 16.03.2006 15:13:21 Close A Distinct Form I am working with multiple instances of forms and I am interested in knowing if anyone has experience in using the Win API to close a specific form. Note that I am aware of how to destroy a form instance in Access by simply removing it from scope and otherwise close a form using the Docmd.Close method. What I want to be able to do is bypass the Docmd method since it only deals wi... 8 15.03.2006 23:10:13 MySQL ODBC and saved passwords Re-posted from microsoft.public.access.odbcclientsvr on 3/14: Howdy, Does anybody know a way to create a linked Access table without saving the username or password in the linked table's connect property? I am using Access 2002, connecting to a MySQL 5 server with MySQL ODBC 3.51.09. I would like my users to be prompted for username/password every time they try to connect. Whether I c... 1 14.03.2006 11:42:22 Check if file exists before TransferSpreadsheet Hello, In a VBA module, how can I tell if a file exists before doing the TransferSpreadsheet? What I would like is something like this: filename = <calculated from some values on the form> if filename exists then ask for alternate file name endif Thank you, Brenda ... 22 12.03.2006 13:35:43 Is it possible to numeration files... Is it possible to enumerate files in a given drive and adding files name to a tables for tracking purpose? Is anyone has a code for this? SF ... 4 11.03.2006 09:36:58 Execute Update Query in Loop I have an update query called 2UpdateExceptions that I'm trying to execute multiple times. There's a filter in that query that uses a value from a form that, in turn, gets its value from the table TEGLDesc. I'm looping through TEGLDesc and executing the query 2UpdateExceptions for each record but I'm getting a debug error (Run Time Error 5, Invalid Procedure Call) at the line reading qdf... 2 11.03.2006 06:58:21 Database copying itself I'm working on a system that lets nontechnical workers add data to a database that will drive an engine to display a multimedia course. We're nearing the end of development, and the database now contains both the original course and the next course on. It's been the plan all along that we'll develop a process to separate out just the one course we're delivering. However, the nontechni... 8 09.03.2006 03:09:37 any one can be my angel to help me with this code have this data access database which I modifed. In the Search form code I need it to modify code so, it look and match more then one field. If the record is not in one field then it should go and look for the second one or third. pl see the code. pl some one hlep me. Thanks. Mike Option Compare Database Option Explicit Private Sub Clear_Click() DoCmd.Close DoCmd.OpenForm ... 1 07.03.2006 18:48:19 quiting from application how can i force use quiting from application only by cliking a close butten and not on the windows X butten? thanks ... 3 07.03.2006 15:25:49 compressing db how can i control by code if application quit will be with compressing the current db or whith out compressing ? thanks ... 2 06.03.2006 11:48:17 How to check if a file exists? Hello, (I apologize if this appears twice ... I had a problem when sending...) In a VBA module, how can I tell if a file exists before doing the TransferSpreadsheet? What I would like is something like this: filename = <calculated from some values on the form> if filename exists then ask for alternate file name endif Thank you, ... 3 06.03.2006 11:40:34 Catching Events I have packaged up a part of my program and placed it into a separate mdb file. I then referenced it into my main program. I am able to transfer data from the main program into the packaged up program by linking it's tables into the main program and using an append query. I am also able to open and use the forms in the packaged up program, via a public sub that resides in the packag... 1 05.03.2006 23:36:27 Changing "Me.[fieldname]" to work from a Module I am new to writing Modules. I have a Form containing a Chart. There are a series of listboxes on the form that changes values and such on the chart as different selections are made. I have the same 20+ lines of VBA code attached to the AfterUpdate() event of the listboxes. I want to move this code to a Module so when I make changes or add listboxes I do not have to change ever incident o... 3 05.03.2006 15:18:37 Database Schema scripting At http://www.trigeminal.com/code/basScriptJetSecurity.bas Michael Kaplan offers a module to script out security permissions in a database. Does anyone know of a similar script for saving/restoring a database schema? Patrick =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Jackman Microsoft Access Developer since 1994 Vancouver, BC ... 8 05.03.2006 13:51:54 combo box Hi, I have two combo box on a form and I was trying to use the top combo box to determine the content of the 2nd combo box. i.e if the top combo box content is Car and Truck. If the user select Car, then the content of the second combo box will be list of Cars type in table and if the user selects Truck the content of the second combo box will be Truck in table. My question is if I... 2 04.03.2006 12:34:44 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17