Threads Replies Last Post 67 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>   "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 8/24/2006 5:23:02 PM 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 8/24/2006 3:34:01 PM 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 8/24/2006 9:19:58 AM 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 8/23/2006 8:22:52 PM 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 8/23/2006 4:53:02 AM Output To Excel - ... 1 8/22/2006 9:23:01 PM 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 8/22/2006 8:31:02 PM 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 8/22/2006 7:19:20 PM test ... 1 8/22/2006 6:17:52 PM 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 8/21/2006 8:09:09 PM 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 8/21/2006 7:46:02 PM 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 8/21/2006 7:06:28 PM 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 8/21/2006 5:30:01 PM 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 8/21/2006 3:31:00 PM 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 8/21/2006 8:35:01 AM 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 8/20/2006 8:07:51 PM 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 8/18/2006 10:17:03 PM Love Hotline Lady only 24-Hrs +91 9810577227 ... 1 8/18/2006 2:07:02 AM Record a Macro How do I create a macro that will run a make table query?... 4 8/17/2006 11:27:08 PM ledger for tracking payments ... 1 8/17/2006 10:44:01 PM 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 8/16/2006 7:34:02 PM 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 8/16/2006 6:51:41 PM 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 8/16/2006 6:42:52 PM just need to create a function and call it with a macro I have some code that I want to use to "pause" my macro, and in the macro designer I see where I can set a RunCode to call a function, but where exactly do I put the code for the function so the macro can call it? the simplest of frustrations... :) - Amanda... 2 8/15/2006 3:00:02 PM Macro / Query - Can't Update I have a macro that calls a query that I need to update. The Edit Mode on the macro is set to 'Edit' but no changes can be made... would someone please advise what else I should check on ? Thanks!... 5 8/15/2006 11:24:01 AM 67 Pages: <<  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38  39  40  41  42  43  44  45  >>