Threads Replies Last Post 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   invoking add-in function from another add-in or VBA module I have a VBA module and want to use the =WORKDAY function, which is part of the analysis toolpack add-in. When I try to use the VBA statement application.worksheetfunction.workday(... it can't find the function. How do I specify the add-in to find the workday (or other) function which is part of an add-in? I'm using Office 2003 but would like the solution to work under Excel 2000 or be... 3 25.07.2006 19:24:14 Zipping files I am processing hundreds of till files at regular intervals and I would like to be able to this automatically from within my code. Does anyone have an ideas on how to do this pleae? Stephen... 2 27.07.2006 13:16:07 Can Access extract data automaticly with a macro and post to PPT? I am trying to build a monthly Power Point slideshow from Access database information that is the same every month. Certain fields are extracted and placed in the Power Point slides. I want to creat a macro or set of macros to automate this process. Can it be done and where would I learn how to do it? ... 1 27.07.2006 03:11:01 Is there a way to assign a shortcut key to an existing macro? ... 2 26.07.2006 23:11:30 How to bypass having to ok the prompts in Access Macros I have an Access 2000 db that I have a multi-step macro that runs several make table queries. It takes approximately 15 minutes to run. How do I prevent or bypass the prompts for deleting and overwriting the existing tables? I want to run the macro without any manual intervention if possible. Thanks... 5 25.07.2006 22:45:31 Finding the create data of a file I have hundreds of files in a folder that I am reading using the File System Object. I want to find the CreateDate of the file (i.e the file date as you see it it Windows Explorer). I don't seem to be able to get it from the FileSystem Object. Is there another object that will give me this info please? Regards Stephen... 2 25.07.2006 19:06:01 How can I use a calculation macro in an update Query? The macro has quite a few conditional clauses but it works on the form keying from field to field, but when I try to use it in an update query, it doesn't. My current solution works but is tedious. Thanks for any help, Mike H... 2 25.07.2006 18:50:34 macro run conditions Hi, I'm trying create a macro to start from a when a check box is ticked, but only when another check box is ticked. I've tried creating one and attaching to the click command to a box, but the macro runs everytime, not just when the other check box is ticked! Sure i've made this sound more complicated than it actually is, but does anyone know what the condidtion on the macro should b... 5 25.07.2006 08:45:24 Macro to open a toolbar command I would like to open the "File...Get External Data...Import..." toolbar commands with one click on a command button in a form. How do I create a macro to do that? Thanks, JimAA... 3 25.07.2006 08:30:01 Move existing data to another field- use macros? Hello- I'm trying to streamline a really old and poorly structured database, and I'm trying to avoid some tedium-- I have 2 fields that I want to get rid of by combining the data seperated by a "-" into a new field. There must be a way to do this without manually copying and pasting the thousands of records... -- Jolene L.U. Smith Virginia Department of Historic Resources... 3 25.07.2006 08:26:28 deleting files based on a list This is a multi-part message in MIME format. ------=_NextPart_000_07E8_01C6AF22.7BFDD760 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable I want to delete files from a list that i have in ms access database how can i do that? i have a list of files that have to bo deleted,all files are in same = folder. thx rene deleting files b... 2 24.07.2006 14:19:02 What is the Sendkey for Alt? I am needing to set up sendkeys in a macro to minimize the Access application. I need the sendkeys for Alt, Shift and Ctrl. Shift is + and CTRL is ^. What is ALT?... 4 24.07.2006 13:48:02 Command Button I am creating a quick and easy "Job Logging" Database, where we enter incoming jobs; where they come from; who they are from; date received; and when the order is filled, when they are logged out. I would like to use a Command button to "log out". My objective is to be able to have a specifice job on the screen and then click the "log job out" button and have ACCESS automatically enter... 2 24.07.2006 08:00:51 macro condition I wanted to know if there is a way to create a macro that can send a message when data in a specified field is duplicated. I don't want to restrict duplicates, nor do I want to delete or append them. I simply want there to be a flag when a duplicate is entered in a specific field. Please help... 23 24.07.2006 03:19:01 How can I create macros to open and print a number of documents? I want a macro that opens and prints a whole bunch of documents in a specified directory. Could anyone help me with that? ... 5 22.07.2006 23:36:02 Fixed width import spec doesn"t work with macro Hello-- When set up a fix width spec to import a certain text file, it works fine when I use the import query manually, but when I set up a macro to bring in the text file and include the spec name in the macro, I only get blank rows. Thanks for your help with this. --Bev... 2 22.07.2006 22:06:50 Disappearing Macros ! I created some Macros to run in Access. I uploaded my .mdb file to free web space provided by my isp. When I download the file back to my local computer all the macros were gone! I tried to zip them and the same thing happened. Is it possible that the ISP is set up to strip macros out of access? ... 2 21.07.2006 12:18:35 How to merge columns? I want to merge 2 columns of email addresses (some are dupes).... 4 20.07.2006 18:42:13 A database created in Access 2000 and 2003 shows "replica" I need to create new macros but it is not allowed (it is greyed out) - how can I change this database from "replica" to regular?... 3 20.07.2006 18:37:02 Can I open an access database with criteria using a hyperlink? I was wondering if it is possible to create a hyperlink which opens a specific Access database and navigates to a specific form, then filters it out based on specific criteria specified in that hyperlink? The only way I could figure out how to achieve the same result was by creating a macro which filters the form for every set, and then hyperlink to its shortcut. The problem with this i... 2 20.07.2006 18:21:16 Formula for first day of month Could some one inform me what the formula is to make a cell always post the first day of the current month? For instance Collumn A has the 30/31 days listed for the current month. When the month ends I would like cell A1 to automatically change to the 1st day of the current month. ... 3 20.07.2006 14:07:56 Running a macro from the switchboard I have a macro which runs some procedures and it works fine if I just click and run it. But when I assign it to a button on the switchboard or form the macro runs OK but then it doesn't finish. The hourglass keeps going and I have to close the programme down. Thanks for any help.... 3 20.07.2006 09:52:14 Automate compacting an access database and opening it again Can someone help me with an Access 2003 problem? I have an Access database which needs to be able to automatically compact itself after deleting the records in five of it's tables via macros. Upon completion, the automated process needs to continue processing the remaining macros which includes importing the newest data, editing the data and exporting the information in text format.... 3 19.07.2006 21:30:23 Create a new column using information from separate columns Hello! I have a little bit of a problem, and I wasn't able to find the solution anywhere. I have column A "Title" that is linked with column B "Day of the week". Each title can have 1, 2 or 3 days of the week (which will then be column C, D, etc). It looks like this: TITLE DAY1 DAY2 DAY3 Math Mon Tue History Tue Fri Mon English Wed Mon How can I create a new column that lists a... 2 19.07.2006 21:01:01 assigning keyboard shortcut keys I used the following: ^{Insert} to assign Ctrl +Insert as a shortcut key combination. I posted it in the Macro Name column as instructed in Building Microsoft Access Applications 1994 version. It doesn't work. What would the current syntax be for assigning shortcut keys to macros?... 3 19.07.2006 18:13:01 43 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>