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  >>   Using OutputTo Action to export query results in Excel I have been able to get the query results to export to the desired file path, but when I go to open it I get a dialog box "Windows cannot open this file"..."To open this file windows needs to know what program created it" I specified in the OutputTo action to use Excel Any help would be appreciated Thanks! Pants00... 2 24.08.2006 19:31:02 Need template.html for continuous form report I am using Access 2003 and have a report I need to generate in .html format - which I can do - but it is one page at a time with a Next - Previous etc at the bottom of each page - and I don't want these end of page breaks. I have a macro generating the report but the format is wrong. I want this to be all one continuous page without these page breaks and I know I'm supposed to use a t... 2 24.08.2006 19:15:30 "Type Mismatch" error with search macro I have the following macro attached to a textbox used to find records in a database. It's used as a condition to display a msgbox if there are no records found. The condition reads: [Last]<>([txtSearch] OR "*" &[txtSearch] OR "*" &[txtSearch]&"*" OR [txtSearch]& "*") The original condition simply read [Last]<>[txtSearch], but its addition seemed to disable the use ... 3 24.08.2006 17:23:02 Documenting Macros I inherited a database that contains numerous Macros. I need to document all these macros and the documentor within Access format is not the greatest. Prefer table format within Word. Can anyone recommend a third-party tool or VBA code that will allow me to document the Macros in a table format? Thanks, -- Karen... 1 24.08.2006 15:34:01 Compare multiple fields on 2 similar tables I'm creating a process to compare like data from one month to another by building a table for each month to compare one to the other. There are multiple fields that can change from month-to-month. How can I return only rows where one or more of these fields has changed from one month to the next? thanks... 6 24.08.2006 09:19:58 Two in report Report open event: Macro1 runs. It brings up a form for a client ID range. I have Macro2 that should bring up a form for a DATE range in the same report. I have a macro for each but can only put one in the on open event. What should I do? How can I get one to run, then the other? They look like this: Macro1: macroopen1 openform not isloaded (cl... 2 23.08.2006 20:22:52 requirement to run OutputToText, OutputToExcel commands I have a macro which use several RunCommands with different command arguments Two of command arguments are disabled (greyed)-- OutputToText and OutputToExcel when running application. But, They are available in the debug mode. Is there any special permissions or settings required to run these commands? We noticed this issue starts to happen since we use InstallShield WindowInstaller pro... 2 23.08.2006 04:53:02 Output To Excel - ... 1 22.08.2006 21:23:01 Macro timer? I run a macro everyday which imports a txt file that goes through some manipulation then exports out. The problem is that the import file varies in size so that macro run time varies as well. What I want to do is add a timer to the macro that records the amount of time the macro took to run. I would use this time figure to track run time trends. So my question is how do I add the tim... 3 22.08.2006 20:31:02 Zip file with Macro I am currently using a macro to export a table as a .csv file and sending the resulting .csv. Unforuntately the size of the .csv file is reaching 7MB our internal attachment size limit. Is there anyway I can use a function to winzip (or other comperssion) of the .csv file prior to using 'SendObject'? Don't want to get into writing a batch file for WinZip!!! Thanks... 2 22.08.2006 19:19:20 test ... 1 22.08.2006 18:17:52 macro gets deleted I created a Macro that ran a few action queries and imported data (using the TransferText action). I had SetWarnings set to NO. When I did a test run the file to be imported was missing. This caused an error message to be displayed (which was fine) and the macro to stop (also ok). When I went back to the listing of macros it was gone. It had been saved - had even been run successful... 6 21.08.2006 20:09:09 If / Then I posted this in another board too. Hi - hope someone can help me. I have a form with 4 combo boxes. Each combo box stores a piece of info into the table. But I need to be able to restrict what the users are selecting. For example if the field Service is selected, then I need the field NonService to be null. Also if my field Service is selected, I need field Product and field Concern... 1 21.08.2006 19:46:02 Append query works in DB view not in macro Hi, I have form which the user enters data into. Upon clicking a "Finish" button, a query is run which takes the information from the form, queries it against a linked table, and appends the results to an internal table. The button also then takes the user to the next record in the form. The macro steps are: SetValue (sets a time stamp value on the form) SetWarnings (No) OpenQuery (runs... 3 21.08.2006 19:06:28 how to print a temp table I have an Excel report output from Access. I need to change the fields in the report. In the Excel macros you can't tell what the field definition names are. There is a temporary table created from the make query reports that I would like to look at the fields names. What I want to know is how do I get access to the temporary table before it creates the report? Here is the query: i... 1 21.08.2006 17:30:01 Run macro till EOF I have creaded a command button to run the following to export my reports and save them each with a name in one of the fields. It works but it comes up with an error at the end because it tries to go to the next record and one doesn't exist. I need it to either stop at the last record or stop when the field is blank. DoCmd.RunCommand acCmdRecordsGoToFirst DoCmd.RunMacro "Macro4", 100... 3 21.08.2006 15:31:00 About The Text Qualifier Dear all, By using TransferText Action running inside the macro, the text file will have text qualifiers like this: "7412","000000","000000000","7612","29000","100","100","0000","000000","00000",0.00,0.00,5246380.38,0.00,"","",0,"" Is it possible to elimiate those text qualifiers like this? 7412,000000,000000000,7612,29000,100,100,0000,000000,00000,0.00,0.00,5246380.38,0.00,,,0.00, Thx ... 7 21.08.2006 08:35:01 convert upper case text to lower case with the first letter upper How do I convert text that is in all upper case to lower case with the first capitalized... 2 20.08.2006 20:07:51 remove a text row in Excel rpt before the pagebreak with [Placehol I have a placeholder value that prints a row of text across the columns on every spreadsheet for each department. I want to comment out the code so it deletes the row at the end of every sheet for ea dept without harming the procedure that prints an Excel repport. I found 3 instances of [placeholder] in my procedure. Here are the 3 references in order found. Can you tell me what... 5 18.08.2006 22:17:03 Love Hotline Lady only 24-Hrs +91 9810577227 ... 1 18.08.2006 02:07:02 Record a Macro How do I create a macro that will run a make table query?... 4 17.08.2006 23:27:08 ledger for tracking payments ... 1 17.08.2006 22:44:01 Looping through Macro I have a loop within a loop in a macro. It is working, however this causes an error if it loops more than the allowed 20 times. I am not a coder, but may have to do this with code. Can someone help with code? Or maybe I am just doing this all wrong. Need to run report for each monthly period for each of 5 or more waste types. Parameter inputs on a form: FromDate = 1/1/06 ToDate ... 9 16.08.2006 19:34:02 Macro help! Hi, I hope someone can help me, whit my problem. There is an number field (User ise typing a price). I need a macro to check if typed number is between 0-2000 or 2000-5000 or 5000-10000. If it is between 0-2000 then = typed price + 1000 When 2000-5000 then = typed price + 1500 When between 5000-10000 then = typed price + 2000 Form ........................................................ 3 16.08.2006 18:51:41 first/last conversion I have a field that for a number of reasons needs to be entered as FirstName LastName in access. I have a second field which is the field that I use to sort. Is there a way to automatically take the first field data, convert to a lastname, firstname format, from which I can stick into that sort field. Usually, this would be quite easy with macros in excel, but I'm at a bit of a loss in ... 2 16.08.2006 18:42:52 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  >>