Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   What's the SQL syntax to COMPARE records in 2 tables? Please excuse my lengthy subject line... Here's where I need help. I have this form, that, when it loads, I want it to compare 2 tables, and not take forever doing it. Here's my question: Is there a way I can compare each record from table "A" to the record that has the same ID in table "B" using SQL syntax, in some kind of looping structure? If so, what is it? Thanks, Kan... 6 08.08.2006 20:53:02 Why doesn't this work on my coworkers computer I'm trying to write code in an Access module which is working with Outlook email messages. It works fine on my machine. If I save it to the network and then have him save it to his desktop to do testing, I get a "Type Mismatch error". Here is the code. I'm not sure but I think oFldr.Items.COUNT might have something to do with it because of the way COUNT is in all caps. Option Comp... 3 06.08.2006 20:43:44 Compile error Greetings! I am running into a strange problem. When I try to run any query that uses some of the built in functions, I receive the error: "Compile error . in query expression 'val(nz([proj_name],0))'" The above line is just one example. If I remove the val statement, then I still receive it on the nz. Now, I looked all over, and found that many people have ra... 3 03.08.2006 13:55:55 Outlook issue when access open's Outlook for sending email there is a message: "A program is trying to access e-mail addresses you have stored in Outlook ....." how can i cancel the message thanks ... 5 03.08.2006 12:28:47 Import a route into Streets & Trips through MS Access Code Can anyone help me find a way to import a route into Streets & Trips, set up the route planner to show the route in the order that the import tells it to, and then display the map? I am writting a dispatch database that I need to be able to import into Streets & Trips in the order that the client selects and then display that order on Streets & Trips. I have a sql that will give me the di... 2 01.08.2006 20:10:45 WithEvents syntax Hi I have written a DLL that raise several events. I want to use this DLL and the associated events within Access 2003 but cannot seem to find the correct syntax of the WithEvents. In VB I would just dim the dll using the Withevents and then the events would appear in the procedure list which I could select and use. This is not the case in Access. Any ideas please. Chubbly ... 16 01.08.2006 15:13:02 Number of rows in Excel file From a module in Access I am opening an excel file and doing some calculations but I need to know the number of rows. Can you help me with this? Thanks.... 5 31.07.2006 17:58:16 Run-time error '3011' Hi Guys, Anyone Help with this error please. I am running some code that imports spread sheet data and keep getting this error: Run-time error '3011': The microsoft Jet database engine couldnot find the object 'C:\database\Appointment_456_fred Bloggs.xls', Make sure the object exists and that you spell its name and path correctly. When I go to Debu the error were it stalls it shows... 2 30.07.2006 15:52:30 sending emails from access through outlook express i found in http://www.granite.ab.ca/access/email/mapi.htm a code for sending emails from access through outlook express. how can i add to this code the option for sending attchments? Option Explicit Type MAPIRecip Reserved As Long RecipClass As Long Name As String Address As String EIDSize As Long EntryID As String End Type Type MAPIFileTag Reserved ... 3 30.07.2006 08:25:05 Inherited module - exclude bank holidays Hi All I have 'inherited' a part complete Access 2000 database which has in it the module shown below. The idea is, I think, to take a number of days and a start date then give the finish date excluding weekends and bank holidays. The problem is that while it is excluding weekends it does not appear to be looping through the dates in the table tbl_BankHols and excluding any dates in t... 12 29.07.2006 16:54:38 Turn Off AutoCorrect How can I programmactically turn off the autocorrect feature? Thanks, Lou ... 5 25.07.2006 15:37:13 API Shell at work we use an access database that calls various executables that run our routines through an ODBC link. the problem comes from running the executables. this has been an evolution to say the least. 1. Shell ... this worked great i think it still works but my boss had heard that due to security stuff that the shell routine was going to be removed from access. well it hasn't an... 3 25.07.2006 00:03:40 sending email attachment with outlook express is there a way for sending email attachment with outlook express? thanks ... 2 24.07.2006 11:39:52 references question i work with a database at work and we have a few references defined. the problem is that when we send the database out to many people that if they have an older version of access some of the references are "Missing" the prime example is... "Missing:Microsoft Access 11.0 Object Library" then i get a phone call and have to talk them through unchecking the missing and to go down an... 8 22.07.2006 10:08:28 LDB Viewer Form Hi all, I have downloaded the 'LDB Viewer Form' at http://www.mvps.org/access/modules/mdl0055.htm. This should enable me to monitor how uses a certain DB. When I execut it, I constantly get the error message subscript out of range. Extending the range generates even more complicated errors. Can some one tell me what goes wrong? Thx, Ludovic ... 1 21.07.2006 06:08:31 Text strings in function I have a module containing a public function named FaxText that evaluates vendor data regarding CertificateType, ExpirationDate, UpdateRequested, and so forth. If a certificate's expiration date is coming due, the code generates an integer (intStatus) of 1. If an update has been requested and the expiration date has passed, intStatus is 2. There are maybe ten possible intStatus number... 13 20.07.2006 11:30:30 Adding a New Record and Bookmark Hello All, I am adding a new record using the following code and need to set a bookmark to this new record: Dim dbf1 As DAO.Database Dim rst1 As DAO.Recordset Dim rstClientID, rstSPVID As Integer Set dbf1 = CurrentDb Set rst1 = dbf1.OpenRecordset("Customer", dbOpenDynaset, dbSeeChanges) 'add the new client rst1.AddNew rst1!CustFirstName = FN rst1!CustLastName = LN rs... 3 19.07.2006 13:55:02 Add Hyperlink field to table through code I would like to add a hyperlink field to a table through code. I have been trying to use the following command--which fails: DoCmd.RunSQL "ALTER TABLE tblSCR ADD SCR_Hyperlink HYPERLINK" If I use TEXT instead of HYPERLINK, the command works. But I need a hyperlink field! Thank you for your help, Judy... 4 18.07.2006 23:01:38 Commenting problem Hi. I have a module that should loop through a table of reports, prints each report, and close each report. I know the code below works if I were to replace the code, '" & rs!ReportName & "' with the actual report name. The problem is that, as I have the code written, the line DoCmd.OpenReport '" & rs!ReportName & "', acViewNormal is commented out after the first ' and the line DoCmd.Cl... 3 18.07.2006 15:58:02 Generating Word documents from access Hi everyone, I'm using a slightly modified version of the code kindly provided at http://www.tek-tips.com/faqs.cfm?fid=2379 to automatically generate a customer mailing based on a particular form in my Access database. However, the customer form has a subform on it that shows a number of related parcels of land as a datasheet view. I need to find a way to have the data (grid co-ordinate... 5 18.07.2006 14:26:01 Linking FE and BE dynamic Hi all, I do have a Access data base with is build up with a Front End and Back End. Now I would like to choose which BE I use once i do start-up the FE. This could be the BE on the network or when I travel the BE on my memory stick which does not always get the same drive letter assigned? The ideal solution would be that I do create a menu which starts up as first event when opening ... 3 16.07.2006 22:15:24 Append Query to add unrelated info from one table to another ... I have 1 table (Called Paths) with data that has 2 columns of data [ID (Primary Key), Source Path] -- the other table is my (Import Buget) table (from my EXCEL spreadsheet), which does not contain the field Source Path. Here's what I'm trying to do ... I created an Append Query with the Import Budget table, and Paths table -- since there isn't a common field in both tables, I'm having... 4 14.07.2006 15:53:14 Saving listbox selections I posted this previously, and didn't get any answers, so here goes again! First of all, I have an option frame that filters the listbox based on which option is selected. That works fine. Then I click on the selections in the listbox and put them in a second list, with a cmd button, and using this code snippet (this is not all of the code, but it should be familiar to most of you)- Fo... 7 14.07.2006 10:18:32 Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? I have an Aggregate Transfer Spreadsheet Macro that runs a series of Delete Queries and Individual Transfer Spreadsheet Macros to import my EXCEL data into ACCESS. I've been tasked with additional criteria that I'm having problems with: At this point, I'm not even sure if a Macro can handle all these additional criteria -- Is there a way (In ACCESS) to accomplish the following: 1. ... 2 12.07.2006 21:50:34 Untick option in Windows Explorer programmatically Dear all, In Access, how to untick option in Windows Explorer - Tools - Folder Options - Hide file extensions for known file types programmatically ? Thanks. Vensia ... 3 12.07.2006 10:00:23 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17