Threads Replies Last Post 43 Pages: <<  13  14  15  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   help with background running and quitting I am writing a macro that will be envoked on the command line: winword /mmerge /q C:\file.doc The macro merges a datafile with file.doc and then prints the filled in document. I want it to run in the background without displaying the GUI. The /q turns off the splash screen. I think the following turns of the GUI. Application.Visible = False Does anyone know how to close without s... 6 15.02.2006 02:22:42 Call a marco on another form ? I have two forms - a mainform with a subform on it. Most of my code are on the main form, but I have startede to wirte some code on the subform. In the code on the subform I need to call some code from my main form. How can I do that ? I can remember from my old Delphi Pascal days, that you must include units to get access to code from other places, but how can I do it here ?? www.p... 9 21.02.2006 17:15:41 Print report to Adobe Acrobat printer file I'd like to automate printing a report to a pre-selected Acrobat pdf file name. I've set the printer for the report to use the specific printer "Acrobat PDF." When previewing the report, and selecting Print, a popup box will always prompt for a location and filename. I'd like to specify the filename, and print to that filename, overlaying an existing one if present. My old method of p... 5 21.02.2006 14:40:30 Runapp in Macro question I have a button on a form that, when clicked, will open a particular Word document. I have no problem doing that when I write in the specified directory. However, the database is deployed on 35 laptops, and the My Douments folder on each is stored under the users username. So for me, it would be "c:\documents and settings\steve\my documents\letter.doc". How can I have a script find the ... 1 21.02.2006 14:34:30 hi how are you hi how are you ... 1 21.02.2006 12:44:06 Macro to open Hyperlink then print that file then close & repeat I would like a macro to open a query then open, print and close all the hyperlinks in the query. The hyperlinks are HTML, Text or PDF. My problem is I can't get it to print the file and close it, it wants to print the query.... 1 20.02.2006 20:11:30 Control IDs for Menu Commands and Toolbar Buttons I am attempting to disable the “Tool/Database Utilities/Convert Database” menu item in Access 2003 for the duration of my deployment project. After installing the Office 2003 Resource Kit I now have an Administrative Template for Access 2003 in the Group Policy Snap-in. This Admin Template gives me the ability to disable menu options by Control ID. The problem is that I don’t kn... 1 20.02.2006 16:53:26 Is this possible??? I would like to have a field on my form which will allow me to add "x" number of days to a date in that form so that I can project when certain items contingent on the date are to take place. Can I do it? -- Thanks for your time!... 9 19.02.2006 21:30:08 Macro to confirm data entry I hope I'm not wearing out my welcome here. I've had some great answers to questions and now I have another. I want to add an "Add record" and "Cancel entry" button on a form so that once data is entered into the form, the user must select one of the two: either add the record or cancel adding it. We want to prevent users from accidently adding records they didn't intend to. Once ag... 7 18.02.2006 20:12:45 F1”_anymore. The macro is named, “autokeys”. The Condition is, “True”. The Action Name is, “runcode”. The Argument is, “=helprun()” This macro has worked for me in the past. Over a period of months I created a series of revised applications, importing each revised version into the new one from the previous version. Somewhere along the way, it stopped working. Did something eventu... 7 18.02.2006 19:10:32 Update macro I am writting a macro that will delete, make a table and then append data to another table for several tables. I unfortunately have to enter criteria on for each of the make table queries that runs. The criteria is the same for all the make table queries, beging date, end date and a type. Can I write a macro that holds the criteria for each query and access it as it needs it? Moses... 4 18.02.2006 02:05:04 How to combine to fields to one new name I am very new to writing macros ...sorry this is so basic. I have two fields PatientID and PatientSuffix. I want to combine these to be field MemberID. What is the proper way to write the sintax in a select statment of a macro? Thank you!!!!!!! Jill... 2 16.02.2006 16:19:48 Julian Dates Is there a way within an access database to change Julian Dates into regular dates? Any help would be greatly appreciated ... 3 15.02.2006 23:31:43 Use macro to have a password entered I have one form that is accessed from a switchboard that we want only a handful of people to access. We want just one password that those people would know. Users are not loggin in or anything. I was going to build a form which just one textbox for them to enter the password and then have a macro decide if they've entered the right password and if so, open the next form. I've search ... 6 15.02.2006 19:31:23 Can a macro be set up to select different printers and/or setting For multiple printers and printer settings, can a macro be set up for each printer and printer setting?... 5 15.02.2006 10:56:16 actioned failed message I have a macro attched to a command button. It opens up an eMail which a person can either send or decde not to send. If the user 'x's out if he does not want to send the eMail, they get the Microsoft ACTION FAILED message with "HALT" button. I do not want them to get this message. Is there a way to get around it?... 7 14.02.2006 21:12:26 How do I create a message box using macro/code? How do I create a message box to appear if the text box remains empty (meaning user didn't put any values in it) ... 2 14.02.2006 18:24:08 Run a Macro via .bat file Hi, I'm trying to run a macro via a .bat-file (to make a scheduled task). This is in my .bat file: C: CD Program Files\Microsoft Office\OFFICE11 Msaccess.exe C:\Database\ AutoAlertByEmail.adp /x Macro1 When I start the bat file nothing happens. Can anyone see what is wrong? Thanks in advance, christophe... 2 14.02.2006 16:33:15 Attachments in Outlook are in Chinese alphabet. How do I fix to When I open attachments, they often come up with Chinese letters. How do I fix this to read all in English?... 2 14.02.2006 07:52:46 change default number format in new access tables In MS Access, it is possible to change the dafault format for fields in a table that you create. However, it is not possible to do the same for tables that are created from a make-table query. It is unclear why, in this case, the default isn't simply "double". If a field contains only integers, Access selects long integer for the format. You then have to manually change the formattin... 2 14.02.2006 07:50:50 Export query and save as .xls? Hello, Right now my macro tha can save my query as a .csv file. I would like it to save as .xls. I am new to programing so please help me. Here is what my macro or "RunCode" is: ----------------------------------------------------------------------- Function QueryName() Dim path As String path = AppPath & "QueryName.csv" On Error Resume Next Kill path On Err... 2 14.02.2006 07:41:25 How-To: Use VBA code to fill in field name descriptions [This followup was posted to microsoft.public.access.modulesdaovba and a copy was sent to the cited author.] Hi All: Am generating a plethora of subsets of some 300GB of data (yes, 300GB). Being subsets, they all have the same 53 fields. The client has asked to fill-in the field name deascriptions (in design view) for all 53 fields. Am much proficient in Excel, however, knowing th... 3 14.02.2006 00:35:41 Access Macro RunApp Hi, I want to create a macro that could open a specific folder (with windows explorer). I went to create a new macro, and chose RunApp under 'Action'. In the command line I type the address (eg. C:\Windows). But this did not work. The error message says Microsoft Access could not invoke the application using the RunApp Action. Is that because windows explorer cannot be ran from an Acc... 4 13.02.2006 23:00:13 Generating Calendar Dates based upon a rule I am a new user creating a databse in Access 2003 to do some prospecting. Does anyone have a query or macro that will generate a date based upon another date. I receive a list of new contacts every day. I would like to send a letter to those contacts 5 times between the day I receive the list and a date that is usually five or six weeks in the future. I need a query or macro that gen... 1 13.02.2006 17:05:13 enable macro help I am trying to use the APA StyleEasy program and it says that Macro in this project are disabled. How do I enable this macro?... 2 12.02.2006 11:08:47 43 Pages: <<  13  14  15  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