Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Mail merge problem When I try to run the following function I get various error messages or the system hangs: Function MergeIt() Dim objWord As Word.Document Dim strConnection As String Set objWord = GetObject("C:\MyMerge.doc", "Word.Document") strConnection = "Driver={SQL Server};Server=servername;Database=mydatabasename;Trusted_Connection=yes;" ' Make Word visible. objWord.... 7 03.01.2006 15:09:04 SQL tables and need to require a field in the form I am using Access as a front end for a SQL database, I want to require some fields in the forms we have. I cannot locate the code to that. Anyone have any ideas? ... 2 28.12.2005 16:27:45 parameterized sql statement doesn't work. Hi, I have a paramterized sql statement here, which fails to work, since -according to access- one or more values of parameters are missing. Strange thing is, I have about the same statement for another table, and that seems to work just fine. Here is the faulty code: Dim strSQL As String 'This is for the clients table... strSQL = "PARAMETERS KlantID Long, KlantSaldo IEEEDouble;" strSQL = ... 2 28.12.2005 11:12:08 transactions Hi, Here is my situation: I ask an end-user for a product name, then i insert that in my table(1st sql-statement). Then i ask that same user what price he sets for that product, which i insert in a related table.(2st sql-statement). And finally i ask the tax percentage on that product(3rd sql-statement). Now my problem: if a user cancels on the second or third statement, the previous st... 5 28.12.2005 09:18:50 running subs or macros in another database I have some VBA macros in Access that I let run overnight once a week. I would like to have them also run some macros that I have in a separate database. Can this be done? I have not been able to find any info on this subject. Thanks.... 2 28.12.2005 05:24:46 control a form from VBA I am running an update procedure from a VBA proc. The last thing that I want to do is to close the form that I am using to display the progress. I cannot seem to find the correct code to close the form ... I am using : DoCmd.OpenForm "Check SL Trans Chain" to open the form but have tried every combination of close command that I can think of to close it : Form... 3 28.12.2005 00:35:48 Check for "nothing" Is there some way to check for an object being set to "nothing" ... I have tried IsNothing() and ObjectVar.IsNothing but neither seem to be supported. I am certain that I have managed to check this before without having to resort to a clunky Function with an "on error" trap but cannot remember how. Any ideas anyone??? thanks, jON ... 2 27.12.2005 21:55:15 Change the caption of a field of a table using dao Res.All, Can I change the caption of a field in a table using DAO? Thanking you in anticipation, Sorry for taking your time Prashant ... 6 27.12.2005 03:59:54 Cell formats in Excel spreadsheet This is a re-post of a question I posted a couple of days before Christmas. I received no responses and thought maybe the holiday might have been the cause... Using the OutputTo method, I created an Excel extract of my Access database for a client. My database has several date fields (all defined in Access as "Short Date"), but these ended up in the spreadsheet with a format of "General".... 2 27.12.2005 02:45:00 Function to know the screen resolution Dear all, Is there any function to know the screen resolution ? Thanks. ... 3 26.12.2005 20:24:56 Date issues in table Hi, I have a field in my table called DDate of type short date. When I try to insert it into a table using the query below...I get an error messages like - Data type mismatch in criteria expression - Invalid use of Null ..CommandText = "INSERT INTO tblTime (DDate) VALUES ('"& Format (txtDate1,"\#mm\/dd\/yyyy\#")&"')" txtDate1 is a textbox name where the date is entered. Thanks ... 3 22.12.2005 05:43:46 Text Search Problem Hi, I've posted this in two groups since i don't know if my problem should be solved by code or can be done by a query. Situation: I have this publicity-thingie running, where people can gain points when they eat a lot of cookies. Afterwards they sending in a coupon + a certain amount of money and they get T-shirts or whatever sent to them. The coupon is encoded in a database togeth... 6 21.12.2005 20:28:44 Syntax error help - I rephase the question. I am getting syntax error message from this Insert Into query...this is a jet database. Accomplishment is a text type, ImsRef is a number type, [Key] is a radio button, [Date] is a date type, ProgramIPT is a text type. This different queries are all the same but I am getting error messages from them all. All the values are coming from a textboxes on a form. CommandText = "INSERT INTO tblA... 2 20.12.2005 18:00:57 Not showing "#Name?" Our application is deployed to many users and some do not have the same complement of fields in their backend data set. Is there any fast way to make visibility of the related control on a form or report false if the field is missing? RB ... 3 20.12.2005 10:15:10 export to html I have a maketable query in access 2002 which outputs the current months worth of data into a table. I can manually use the file export feature and output to html with a template. HOw can I do file export to html with visual basic? The html resides on an apache server so asp won't work for me. I see the exportxml function and have used it, but I don't see how this can be viewed and... 1 19.12.2005 19:08:16 login prompts I use hyperlink for open another access application when it run's on office 2000 i get an login prompt while there is no need for it when it runs on office 2003 i get a macro security warning while macro security is minimized how can i cancel those promps? sam ... 1 19.12.2005 08:36:43 DoCmd.TransferText acExportFixed - spec not found I'm using KB aticle 210001 and Access 2K to write a schema.ini file and that works fine on imports but, I can't use my schema.ini file to export a 70 field query. DoCmd.TransferText acExportFixed, "C:\My Documents\Shema.ini", "MyTable, strFile, False Gets error "The text files specification 'C:\MyDocumentsSchema.ini' does not exist..." It does exist, is properly formed and could b... 2 19.12.2005 03:51:21 Extra Large Database Growth - Compacting I am using access 2000 and DAO recordsets to query an Oracle Database typically with a minimum of 100K updates from Oracle onto Access. What I am finding is the database grows from around 100KB to 900KB or more - presumably due to the queries being stored in the database. When the database is compacted manually it returns to 100KB 1. Is there any way I can prevent queries making the d... 2 19.12.2005 03:00:06 Where do I run my event proceedure. With the help of a few of your guys/girls on these discussion groups I've been able to produce a "script" or peice of coding that does what I want. I originally added this to the "afterupdate" bit of the checkbox that I wanted it to run off. This is great, presuming that I always start with a cleared checkbox. I would like it to run every time I select a new record (using the naviga... 5 18.12.2005 21:56:35 Insertion in a database Error Hi, I have the following code, I am getting an error with the INSERT statement (not with the connection, I just paraphase the connection). What I am trying to do is; On a form I have about 13 textboxes on this form where the users can enter their text, and I want to insert this text in the access database tables. Dim cnn as ADOB.Connection With cnn ..CommandText = "INSERT INTO tb... 5 17.12.2005 21:23:16 This group is not replicated Is this group live - if so why is it not replicated? It isnt even linked from microsoft.com rgds stephen ... 2 16.12.2005 11:32:21 strip HTML I found this code for stripping HTML from a text string. I'm trying to use it in MS Access 2002. I'm getting the following error: Compile error: User-defined type not defined. I have the following references checked: Visual Basic For Applications Microsoft Access 10.0 Library Microsoft DAO 3.6 Object Library OLE Automation Microsoft AvtiveX Data Objects 2.1 Library Micorosft Visual Basi... 4 15.12.2005 17:03:46 DoCmd.TransferText - where is the specification file kept? I have a database where users manually import a text delimited file. I would like to be able to automate the process from a form, where they can browse to the file and press a command button to do the import without having to go through the import wizard. I found a message board item where it said to start the import wized, create a specification and save it, which I did. But I have t... 7 14.12.2005 22:08:00 Array as property to class module Access 2k3, WinXP Pro. Attempting to create a custom class "ReportSpec" to pass certain report parameters from user inputs for a given report. Custom properties include StartDate, EndDate, and KeyList (limits report scope to only those items in list of items referring to primary key; if null, then entire result set is displayed). My problem relates to the KeyList property; I'd like to... 5 14.12.2005 03:42:16 Problem Selecting Records from one Database, Inserting into another All-- I have a Microsoft Access database that I am moving to SQL Server. The Access database is poorly designed and is not normalized at all, and the SQL Server database is brand new and normalized. I have to copy the data from Access to SQL Server, but in the process I have to massage the data so it fits into the new structure. What I've done so far is this: I've created a functi... 3 12.12.2005 15:54:21 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17