Threads Replies Last Post 43 Pages: <<  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  31  32  33  34  35  >>   Auto Report and Macros Hello - I'm trying to include an auto report in my macro. The data in my query is constantly changing an a 'regular' report will omit any data not included in the original. The autoreport will capture all of the current data. Any ideas how to include an auto report in a macro? Thanks, Marc... 3 17.04.2006 10:18:01 Using Macro to Export Text to Notepad I am trying to run a macro that exports text from a query to notepad, this works, but Access attempts to put a frame around each result, I need raw text. See below - Can you help? -Mark Matzke I need the result in notpad to be: 1a234567 2a987654 3b543210 I get something like this: -------------- |1a234567| -------------- -------------- |2a987654| -------------- -------... 5 17.04.2006 00:03:02 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:28:34 Inserting pictures from files Inserting clip art works ok. Inserting pictures from files causes Pub 2003 to lock up. Has been working fine up to some time this month. Save As also causes lock up depending on file(?). Similar problem in Word 2003. Pub 2000 & Word 2000 on same computer ok. Norton's antivirus can not find anything nor was anything indicated by spy sweeper. Uininstalled Office 2003 and re- install... 2 16.04.2006 10:48:04 macro halt on parameter query cancel I am running a macro with the OpenQuery action to run an update query, which is set up as a parameter query to prompt the user for the new value in the updated field: [To change BIN NUMBER, enter new value:] If the user selects the [Cancel] button, the Action Failed dialog with the [Halt] button pops up for the macro. Is there some way to avoid this pop-up or to test for [Cancel] as ... 4 15.04.2006 18:09:45 Help!! Let a Macro wait... I use a tool (wget) to download (automatic) a file from a website. This works fine but when I call it with a macro I cannot let Access wait until the wget command is finished, (my idea is to download the file and after that some queries and code changes alot off record but when I use the shell command to call the "wget" file the macro does al the other actions but the file is not downloa... 3 15.04.2006 09:35:02 creating macros How do you create macros in Microsoft Word, if possible. ... 2 14.04.2006 20:18:38 Using Macros to require data entry Hi, I would like to set up a macro to require data entry. I have a form that has Main form and sub form. One of the fields that located on the main form is CALL (yes/No type) One of the fields located in the subform is CALLDATE field. It is wonderful if soon I check CALL field located main form, it will pop up the message " please enter CALLDATE field in subform". If I don't chec... 5 14.04.2006 16:21:02 determine how to enable macros When I open a macro I get an error message saying "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enabl macros." ... 3 14.04.2006 15:06:02 determine how to enable macros When I open a macro I get an error message saying "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enabl macros." ... 1 14.04.2006 04:28:06 How do I automatically export a table to a dbiii file from Access. I currently use the transfer text action in macros to import delimited text files into an Acces Database. What I am trying to do is setup a macro to transfer or export the information from those tables into dbIII files. Is this possible???... 3 13.04.2006 15:31:02 going to word from access Hi, I want to wrote a macro using VBA in access such that it opens a word file. How I can do it? Surena ... 2 13.04.2006 15:00:01 Collecting Data from Word Formfields Hello, I know a little about Word and practically nothing about Access. I send out surveys as Word documents with formfields. I collect the response in a common directory and compile the results in a Word table. At the bottom of this message is a bit of code that I cobbled together and currently use that extracts data from the forms and stores it is a DataObject (I am not sure if i... 1 13.04.2006 13:50:18 macro error due to editor I have an Access database with a visual Basic module run by a macro. The macro runs fine until I use the VB editor. If I just open and close the VB editor I get “Run Time error 13 Type Mismatch” on the following line. “Set EMP_No = DB.OpenRecordset("ct01 UnFilled Employees", dbOpenDynaset)” This appears to be a VB problem as I have changed nothing in the VB module, only open ... 6 13.04.2006 02:47:04 Macros that conmntain runapp and it's a command prompt executing batch files It seems that the command prompt runs along BUT the rest of the macro keeps executing rather than waiting on the command prompt to finish. Is there a way to force the command prompt to finish before the rest of the macro executes? ... 3 12.04.2006 16:51:52 DATA ACCESS PAGES in Access 2000 - Missing?? I created a report in Access 2002. A macro opens it up. However, in the "Output Format" options, DAP is not there...the only thing that will work is Snap Shot (under Access 2000). The DAP seems to open faster...so I'd like to go with that, if possible. Is there an update to enable that feature in Access 2000....or is it simply not an option....? Thanks very much. -- Messa... 1 12.04.2006 16:47:01 going to word from access Hi, I want to wrote a macro using VBA in access such that it opens a word file. How I can do it? Surena ... 1 12.04.2006 16:16:25 calculate, insert and append I'm thinking I need to generate a table field (PMTemp.wono) by finding the last record in another table (WO), adding one to the field of interest and inserting that number into the table record. That record then needs to be appended into WO. Any suggestions on how to start? Right now I am using a query to generate a table, PMTemp. I then condense the information with another query to gen... 1 12.04.2006 14:40:46 Looping problems Hi all, I really need your help now.. I have got form with tabular view. I generate the code below and test it, what is happened is that the form only count the val for the first row only. I think I should use LOOP, but I don't know how.. I am a noob in using Access 2003. ======================================================= Private Sub Form_Activate() Dim Avg As Double Dim P A... 2 12.04.2006 11:22:48 help still needed See posting "macro error due to editor" from 04/10. Can anybody assist, please... 1 11.04.2006 21:17:02 Delete records based on criteria Hi I need to write a macro that will delete records from the output of a query, based on the value of one of the fields. The main problem I am having is that the criteria for deletion is over 2700 'things' long. Is there a way I can compare the value of the field to this list, and if it matches, delete the whole record? Any info would be much appreciated! Thanks & Regards, ... 4 11.04.2006 14:34:55 Referring to controls as Me?? I want to create a macro that will upon double-clicking a control.. set the value of the control to Todays Date. I want to create ONE macro that can be called from any control that I assign it to. In the macro window I think I want to use the SETVALUE action. Item: ?????????????? <<-- what goes here? Expression: Date() Can someone tell me the syntax to put in as the it... 4 11.04.2006 08:09:28 How to change criteria in a query using a macros I have aprrox 50 queries that all have one field on common (Division). I need to run each query for each division (10 of them). Fortunately, I was ably to write VBA code in Excel that automatically runs and down loads the queries to an excel sheets. Unfortunately, each time I run 50 queries, I have to stop and go in to each individual query and change the division number to set it up fo... 9 11.04.2006 01:38:39 Downloading a Template with a Macro I have created a template to be downloaded from our intranet. However when the template is downloaded, I loose the macro's? -- Robert... 1 10.04.2006 20:41:02 Send a report through electronic mail at predetermined time I would like a report to be sent to the Top Management at 9.00PM Daily without anyone running the Macro. I had already set a Macro for Sendobject. But, the report is sent only when the Macro is run. I want to run it (send the report ) on a daily basis at 9.00PM automatically. ( Even if no one is available in office to run the Macro).... 2 10.04.2006 12:32:02 43 Pages: <<  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  31  32  33  34  35  >>