Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Office Links - Analyze w/ Excel Access has a great feature in menubar. The "Office Links" the "Analyze with Excel" that exports a table to Excel. How do I use this feature in VBA code. I want to run a Select query off a table and then run code to use export to excel. Unless theres a better way to do this in code. thank you.... 2 06.05.2006 00:25:03 Import Text file (*.csv) Thanks for taking the time to read my question. I have a .csv file that I want to import into my db. I can do that no problem. My issue is that I don't want/need the first line in the .csv How can I get rid of it or skip importing it? Thanks, Brad... 3 04.05.2006 19:09:02 Splitting database Hi, Can some please share with me, the instruction on how to split a multiuser database into front end (FE) and back end (BE) databse. I create a access vba interface with form for work and I put it on my work's intranet....but I will like to make it a multiuser database without recreating the application again. Thanks Tiger ... 3 04.05.2006 06:23:18 Error When Opening Any Module (A2000) I have a fairly large application that recently started throwing an error (Error loading file, network connection....). This happens every time I open a module or a form with code behind. I've compacted and repaired several times, and even imported all the objects into a new database. Problem still persists. Also this is a stand alone pc not on a network.... 3 03.05.2006 16:31:06 Running code for another application Is there a way to write code in a word document then can be executed after criteria has been met when running access code and the word document is active? Thanks Craig ... 6 02.05.2006 22:08:57 Multi-User Hi, I created a access base tool using VBA form for the front-end GUI, and I put the tool in my work's intranet, why question is how do I make the tool a multi-user tool. The extension of the my tool's file is *.mdb. Thanks Tiger ... 2 29.04.2006 21:04:44 Update a field base on a selection of another item I have a button in a subform which runs a module The module is a mail merge which allows selecting of a number of letters in a list (another form). and then merges the selected document. strActiveDoc = wordApp.ActiveDocument.Name If strActiveDoc = "Redback Invoice.doc" Then WordDoc.MailMerge.OpenDataSource _ Name:=strDataDir & TextMerge, _ ConfirmC... 1 29.04.2006 17:27:59 Concurrent Acess into MS Access Hi, I created a tool that uses VBA to create a front-end (Gui) in Microsoft access and after creating this tool I put it on my works intranet for people to use.... My question is how can I make it a multi-user tool that is concurrent access to the tool?... Do I have to recreate this tool over again from scratch? The tool extension is *.mdb. Thanks Tiger ... 1 29.04.2006 01:25:01 Command Button to simulate the Spell Check button I have a form frmEditLegalDescription that is for the expanded editing of a memo field. The client thinks it will be too difficult to train the users to press {F7} to spell check the text. Well never mind that or the fact that the spell check button is on the tool bar. He wants a button on the form that will launch spell check. I have tried a KeySend in the click event and a domenuit... 6 28.04.2006 16:49:02 On error Resume Next Problem The following simple function works properly on one of my computers. I then move the database to my production computer and it stops working. If I change the backend location, the running code gets to the "Set.." statement, produces the error, and quits. The On Error Resume Next does not resume next. I have the options set to break on all errors. I have uninstalled and reinstalled... 12 28.04.2006 13:49:28 Launch Word and populate with contents of Memo Field I would like to create a button or a double-click event that will launch MS Word and populate the Doc1 with the contents of a memo field. Any suggestions would be greatly appreciated. Bill... 8 26.04.2006 21:16:27 Need help with memo field printing I would like to be able to double-click or use a command button to open a form with a large text box and populate the box with the contents of a memo field in the calling form. The user should be able to spell check the text and then click a print button that would print the text to the selected printer. I created a form and bound the text box to " =Forms![FormName]!Text195". When I ... 2 26.04.2006 20:49:30 Create Table Hello All, I have some code that creates a table. I keep getting a Type Mismatch error when running it on some computers but not all. I have checked the refrences and they are identical. Does anyone have an idea why this error pops up? Function BuildTable() 'This builds the temporary table "tmpInterpChanges" to hold the recent Interpreter changes 'CustID as Integer 'FG as date 'Chan... 5 25.04.2006 21:33:02 Some helpful UDF's Below find some helpful UDF's I wrote recently. I'm wondering if there are other ways you guys might approach the tasks they accomplish. Word wrap will probably be a problem as some of the lines are wide. -Jeremy ---------------------------------------------------------------------------------- Function GetConnectionProperty(ServerOrDatabase As String) As String ' Returns name of conne... 1 25.04.2006 19:06:28 how i can know when FileCopy action is done when i use FileCopy with big files i have to know that action is done how can i konw it? thanks ... 6 25.04.2006 12:40:11 Checking if a form is open? Hi everyone, I am using code to open forms and fill in pieces of data. The problem is that one form may be opened by lots of other forms. I would like to put some code in the opened form which does the following: onclose - If form x is open in the background then refresh it. otherwise if form y is open in the background then refresh it etc Can anyone suggest a way of doing this pl... 5 25.04.2006 12:03:41 Expression Builder Hi, I used to have Expression Builder from Trigenimal.com for my Access 2000/2002. When using with Access 2003, I got error message "The input string is too long.@@@1@@1". Does anyone use this utility with Access 2003 SF ... 1 25.04.2006 02:50:05 DCount and DLookup acting on sql server linked tables what can be the reason that on some machines, functions like DCount and DLookup acting on sql server linked tables gets "ODBC connection failed"? thanks ... 4 24.04.2006 06:17:13 References order issue I have an access 2000 database that uses attached tables to a SQL 2000 database and a Pervasive SQL 2000 database. I have been adding functions to this for several years so there is a lot of code in this. I have a problem were the order of my references can prevent certain functions from running. For instance the database references: Microsoft DAO 3.6 Object Library Microsoft Active... 9 21.04.2006 14:14:08 Create Word doc from Access doesn't work reliably hi, I wonder if anyone has any idea what's wrong with what I doing. I am trying to print labels, letters etc. In order to have better format control, I generate the output as Word documents. I generate several types of Word docs. Several work without any glitches ever. The problem seems to occur with labels (which uses tables/cells in Word). The pattern is repeatable, but the pattern... 10 21.04.2006 02:36:11 Who Is Logged Into Database I am using the following code in MS Knowledgebase article 285822 to determine what users are logged into a database; the code works fine, but the Login_Name displays "Admin" for each user and not the actual userid; is there anything in the code below that needs to be changed or added to have the results display the actual userid and not "Admin" -- I am using Access 2003. Thank you. S... 3 20.04.2006 16:45:02 Autonumber Hello, Can anyone tell me how to reset the autonumber to 1 in an autonumber field in a table. I have tried the method of appending a number to the autonumber field and it doesn't work (from the help file). I need to be able to rank the rows in a table based on a sort order and autonumber seems like the best way to do it. If there is another way that would be great too. Thank you f... 6 20.04.2006 13:12:39 Find/Replace Command Button Hello, Wondering if there is a way to have the Find/Replace pop up default to Match: Any Part of record, rather than Whole field. This would be very useful to me. Happy Easter (if applicable), if not Happy Day, Thanks, VL ... 5 19.04.2006 23:52:52 Access - Executing code when a record is changed in a form Hi, I'm trying to get a bit of code to run when I change the data displayed in a form. I realise you can put in your own navigation buttons, and attach code to the mouse wheel up and mouse wheel down events, but isn't there a more simple way to run code when a record changes? Thanks in advance, Jim... 7 19.04.2006 16:16:02 Age Calc Hello, I have a field [dtmDOB] and a field [txtAge] in the same table. On the form, I want to Calc the persons age. I am using the DateDiff function to do this. But the reults are one year over. I read some articles on the issue and there are many fixes, but I just cant seem to get it right. Additionally im not sure where to atttach the code (onClick or after update, etc). Any hel... 27 19.04.2006 03:33:55 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17