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  >>   Importing Blank Date Fields Hello, I have a macro that imports data from a spreadsheet into a DB. it works fine however, Recently I added a column in the DB and Spreadsheet macro for another Date Field. The majority of the time this field is null. When I run the macro it always fails on the new date field. I know it is because it is a null field. I have entered dates into the field on the spreadsheet for testing p... 4 19.07.2006 15:30:02 highlight an entire row if a date in one column falls between a given range This is my second post today, this time for a separate issue. Is there a macro to highlight an entire row if a date located in one column falls between a given range? TITLE DAY1 DATE 1 Math Mon 5/15/06 2 History Tue 6/17/06 3 English Wed 8/13/06 If I have the above information, can I create a macro to highlight in bold the entire row if a cell in column "DATE' is between 6/01/06 and ... 2 19.07.2006 09:28:05 Can a macro run several databases? Is this possible: I have several (49) identically structured databases with the same update macro in each. Each macro has shortcut on desktop. Currently I have to: click 1st shortcut, wait until the update macro finishes, and close Access click 2nd shortcut,wait until the update macro finishes, and close Access.... repeat all above 49x. This process takes about 40 min to ... 2 19.07.2006 09:24:31 How do I set up a Macro in Access 2003 using the System Time? I would like to set up a macro that will execute based on the system time and date. Is this possible in Access 2003? Thank you... 2 18.07.2006 19:09:59 Macro to display error message when no records found Hi all, I want to create a macro which displays an error message when a report is run and no records are found. Any ideas? Thanks a lot. ... 2 18.07.2006 15:55:02 Argument problem Getting the 'type mismatch' error for this macro's function name action argument and I don't know how to enter the requirements for defining dates, although I have researched this as best I can. Can anyone help me out? Thanks in advance. The action argument is: WorkingDays2([Forms]![TestForm1]![Val1],[Forms]![TestForm1]![PlanD1]-[Forms]![TestForm1]![ActD1]) The name of the macro is... 14 17.07.2006 20:03:03 Macro to fill in cells? I need a macro to fill in cells in a column, with information from the above cell, til it reaches a new number and then repeat and end. Can anybody help? Thanks, Tammy... 2 17.07.2006 19:43:34 screen "jumps" when macro opens/closes forms I have macros on text boxes to navigate from one form to another. In those macros, I Open one form and then close the forms from which I just came. When these run, the screen jumps. It functions fine, but the "jumping screen" (I'm assuming as it's opening one form and closing the other) is really annoying. What haven't I done right? Thanks.... 12 16.07.2006 20:11:02 how do I create macro to run office clipboard in access 2003 dont appear to havethe record macro facility... 4 16.07.2006 20:08:33 Automation of the "OutputTo" Macro ...... On the "OutputTo" Macro I am sending a report to the following location, in an automation attempt of mine: ="C:\DB_OUT\" & [Forms]![FORM_Link_Websites]![TheDomainName] & "\public_html\" & [Queries]![QUERY_E_O_Report_Download_One_Screen]![subdomain] & "\index.html" As far as I have gathered, the only problem I am having is with the: [Queries]![QUERY_E_O_Report_Download_One_Screen]![sub... 2 16.07.2006 08:47:29 how to do a macro... I have a database with a date in it. When I enter that date, I'd like another field to automatically calculate a related date. How? Specifically, I'd like the second date field to be the monday which is 4 weeks before the date I entered, not counting the monday that week... thanks, Taylor... 6 15.07.2006 01:03:12 TransferSpreadsheet Is there a way for me to run the TransferSpreadsheet macro then have it automatically pull up the file in excel once the data has been exported? I like the way that OutputTo works but it only allows me to have one worksheet. The transferSpreadsheet allows me to input two different worksheets in the workbook. Do i need to do some VB coding in order to accomplish this? If so, what code... 5 14.07.2006 19:04:07 Can MSAccess be programmed such that a chg to a record send mail? I'd like to know if a user changes specific fields in a record and have it automated by receiving email to my Outlook mailbox. Can this be done. Perhaps there's another way of invoking the detection of changed data in a record - please disclose in specific terms.... 3 14.07.2006 18:55:53 Append Query to add unrelated info from one table to another ... I have 1 table (Called Paths) with data that has 2 columns of data [ID (Primary Key), Source Path] -- the other table is my (Import Buget) table (from my EXCEL spreadsheet), which does not contain the field Source Path. Here's what I'm trying to do ... I created an Append Query with the Import Budget table, and Paths table -- since there isn't a common field in both tables, I'm having... 4 14.07.2006 15:53:14 Problem with RunApp I'm trying to use RunApp to open an excel spreadhseet. I keep getting an error message: Microsoft Access can't invoke the application using the RunApp action The path to the application is invalid, or a component of the application is missing. Check the path in Windows Explorer or File Manager I've checked the path, and it seems to be OK. I can start the spreadsheet normally, by ... 4 14.07.2006 13:34:02 Browsing to find a file instead of using an Input Box In a Macro I am creating, I need to import a delimited text file. Rather than using a simple text box for someone to enter the file name, can a dialogue box open so that the user can browse to find the correct file? Right now in the TransferText action in the Macro, I use the following for the filename: =InputBox("Filename") Is there a simple way to replace this input box with a file... 8 13.07.2006 20:52:25 Format of condition statement I'm making a macro to run query of travel data How do I format my condition statement so only 2nd travel legs are displayed in datatable? Note: "Travel_Leg" is a variable in table named "Trips" I've tried various combinations, like [Trips.Travel_leg] = 2 but with no success -- Richard... 8 13.07.2006 19:50:41 Importing EXCEL data into ACCESS I have an Aggregate Transfer Spreadsheet Macro that runs a series of Delete Queries and Individual Transfer Spreadsheet Macros to import my EXCEL data into ACCESS. I've been tasked with additional criteria that I'm having problems with: At this point, I'm not even sure if a Macro can handle all these additional criteria -- Is there a way (In ACCESS) to accomplish the following: 1. ... 2 13.07.2006 00:07:31 Generate Report with a Form Filter. I am trying to call a report using the OpenReport action. I am using a dialog form to call the report, this dialog form is opened from my main swtichboard. The problem I am having is that my report's design is based on a query whose parameters are on controls in a form (EMpID, StartDate, and EndDate). How do I use the OpenReport action to call the report and at the same time impleme... 6 12.07.2006 23:15:23 Code to make an excel spreadsheet shared from Access Does anyone know if code exists to make an excel spreadsheet shared from within Access? Basically, I need to overwrite an excel .XLS file from access on a regular basis. I'm doing this using the docmd.outputTo method since docmd.transferspreadsheet was horribly problematic. It works, however, once the file is overwritten I can't overwrite it again; the new .XLS file defaults back to not being... 5 12.07.2006 17:08:26 Connecting programs I have created a database that works somewhat like a timer that is going to be used to track the productivity of some employees. Right now the only I can make it work is if the employee clicks a start and stop button but that will interfere with their process so if i can avoid them having to do any extra clicking that would be great. The employees currently work with Envision. Is ther... 4 12.07.2006 12:15:01 access sendkeys - can i send 'Enter" or 'Return' ? hi, in access im am trying to run a macro. OpenReport (conditioned) OutputTo Close (repeat for other conditions) The first time it runs ok, but the second time i run it it asks if it is ok to save over the existing file. The answer to this will always be yes. I have tried to SetWarnings before the OpenReport but that didnt work, so now im looking for a SendKeys command to alwa... 5 12.07.2006 11:46:13 Need if statement in macro I need to write a macro that if a table already exists in the database it will skip importing the table and if the table doesn't exist the macro will import it. Any help is appreciated. Thanks.... 2 11.07.2006 11:08:58 Using =GetOpenFile() in a macro In a Macro I am creating, I want the user to be able to select a text file to import, rather than having to specify an exact file name and path in the macro. The macro uses the TransferText action, and I have tried using the following function for the file name: =GetOpenFile("text file") but the dialogue box that opens will only look for .mdb files. Any idea how I can get it to let... 2 11.07.2006 10:58:35 Macro problems from command button I'm experiencing a variety of problems getting macros to run predictably when invoked from a command button. My previous post talked about SendKey problems, but I have other problems also (SetValue). These macros work fine when ran directly from the macro window, and also worked from command buttons in Access 97. My latest question is: why does a macro behave differently in Access 20... 2 10.07.2006 21:54:03 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  >>