Threads Replies Last Post 43 Pages: <<  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  31  32  33  34  >>   Application.AutomationSecurity command and Access 2003 I have a lot of macros and VB apps that open MS Access 2000 databases. This worked great until I started using Access 2003 (and it's new security model). In a Visual Basic app, I've been issuing the "Application.AutomationSecurity = MsoAutomationSecurityLow" command, then opening an Access 2003 database. Even with that command, the user still has to click the [Open] button, to get th... 2 28.04.2006 10:19:26 Send Keystrokes I have a macro that runs when a button is pushed, this appends some tables with fresh information, but it will not allow the information to be duplicated. I get the normal message that says x number or records could not be appended due to duplication. I have sent a sendkey y in the macro to try and make this seamless for the operators but it does not seem to work, is there something el... 3 27.04.2006 23:11:01 TransferText File Selection I am using an Access Macro to transfer text files to may database. Using the TransferText Command I want to enter the name of the file to be transferred. I have tried the script of: C:\FirstNM\Forms![frmImportB]![TextA] in the Argument Column. I input the name of the file in TextA on a form called frmImportB. Can this be done and does anyone know the correct syntax if it can b... 2 27.04.2006 20:07:12 Error message when retrieve report-here are the VB codes Dear All, > Dear All, > > I create a Command Button to retrieve a report , it work at my PC. > > But when I sent it to other state in SA (through our share drive), it does > not work. > When staff in SA press the button, it show the error message such as: > > Microsoft Office Access > --------------------------- > The OpenReport action was cancele... 1 27.04.2006 06:32:01 Transfer Spreadsheet from a CSV file I have an Excel spreadsheet where the columns have a comma for their delimiter. The file was send to me from my bank (it has a csv extension) and I cannot get it to import into my access database. The TransferSpreadsheet will only work with an xls extension. Can this be done using MS Access? Thanks in advance Len ... 2 26.04.2006 20:35:11 SendObject subject line with field names I have a report that I am using the SendObject macro to send the report via email to multiple people. Right now I have the properties set so that I can edit the email before its sent so that I can include today's date and the count of records on the report in the subject line of the email. Does anyone know how to add field names in the macro's Subject field? I have tried =Date() [Count... 2 26.04.2006 19:27:33 How Can i run a module in access Hi, I am trying to run a module that i have created in access to prevent people entering certain sections of the database. I have constructed a password request when a button is pressed to prevent people being able to access an admin toolbar with all the master controls. However whenever i try and run this module i have a error message advising me that it cannot find the function name i ha... 2 26.04.2006 14:16:03 time and date stamp Any one know how to build a macro to run a control button on a form to populate a field on a from? kind of like a time clock? ... 2 26.04.2006 03:55:42 Access 2000 - Macro I need the code for a macro that will try to Find "#Num!" without the quotes, within a field called 'Date'. If it finds #Num! then Quit the database. If it doesn't find #Num! then stay in the database. Can this be done? Many thanks in advance. -- Richard... 3 25.04.2006 13:02:02 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:24:27 Close Function I would like to create a macro that will close the whole database. Can anybody give me the proper way to do this with a macro or VBA. Basically I have the database set to open a report when the database is opened. I would like to close the database when that report is closed. -- Thanks in advance Stefan... 2 24.04.2006 23:51:45 printing single pg of a multi pg form I setup a search macro and need to be able to set up a print option to print just the first pg of the form any suggestions?... 2 24.04.2006 23:50:25 How to avoid being prompted in access Please help me to avoid being prompted "The existing table will be deleted before you run the make table query" when I run macro and inside this macro I run the command "Open make-table queries". Althought I turned off the check box "Action query" under "Confirm" label in "Edit/Find" options of Tool Menu, thank you.... 2 24.04.2006 04:28:58 How to enable or desable macros on Word or Excel? ... 2 22.04.2006 22:29:33 Running a macro on all sheets in a file. Hi all, Today I have a spreadsheet that contains 100 different sheets in it. In my module I have to run a macro in each sheet in order to recieve the final outcome. Is there a way I could run one macro that will run on all the sheets at once, instead of what I am doing today which is to log into each sheet and run the macro. ... 2 22.04.2006 18:40:49 Changing field size of text via macro Good day, I have a macro which runs several queries and finally makes a table of that compiled information. This final table is where I need to change the field size of a text field from 5 to 6, however I don't seem to be able to do that via a macro. I'm wondering if there is an expression I can use within the make table query? If tried a calculated field within the query (looking a... 3 21.04.2006 21:49:02 Autonumber Re-use I have a form that uses an auto number and a command button that should cancel the entry if there is a user error (if user initiated a record by mistake and needs to clear it). I need this command button (ran by a macro) to not save the mistakenly entered record, and reuse this number instead of going on to the next number. I want the table to show all consecutive numbers, no missed nu... 2 20.04.2006 22:32:20 Using expressions in Msgbox Hi, According to Access help, it is possible to display expressions in a message box, as opposed to just text. I am not sure how to do this properly, but I want a msgbox to display some text as well as a text string that is referenced off another form. The expression is: =[Forms]![Step 1 Msg]![txt_step1msg] When I insert only this into the message argument of the Msgbox macro action,... 3 20.04.2006 13:29:59 Override an existing file I am trying to move files using a macro in Access. I create files weekly and move to a shared folder. However, there is an error (File already exist) due to the existing files. Is there a way I can override them? Thanks.... 3 19.04.2006 20:36:51 Uncheck box if date is updated I'm full of questions today :) I have a Date Completed field (date format) and a Awaiting Signature field (which is a check box). I would like to know if there is a way to automatically have the awaiting signature box "uncheck" once the date completed field is updated? I'm not that knowledgeable about code or macros so any detailed help would be greatly appreciated. Thanks.... 3 19.04.2006 15:08:02 Macro to highlight Does anyone have a macro that asks for a range like A1:J5000 and highlights that range? That would be a nice macro if anyone would share it.... 2 19.04.2006 14:58:10 How do I get a form to automatically open when starting access I'm trying to get a form to automatically open when starting a MS Access database, i need the Macro Required I've triey creating a marco to Open the form and Naming it Auto_Open, but his doesn't seem to work.... 3 18.04.2006 16:56:02 Openquery I have a few append queries that I want to run with a macro. I have done this many times before and never got the results I am now. Which is the queries all stay open or open the tables they are appending to. I have put in a setwarning to no but still get all the tables open at the completion of each openquery. What could I be doing wrong? Thanks... 4 18.04.2006 15:27:02 automate to run multiple email macros Due to privacy considerations I have created a sendObject macro for each of the recipients reports separately. There are 100 reports. Is their a simple shortcut I can add so I do not have to run and click 'yes' to each email macro individually? -- Thanks.... 3 17.04.2006 22:13:02 Is there a simple way to create multiple output files from a single query? I need the ability to build up to 58 output files from a single query. There's a field that can be used to control this. Tough question? ... 11 17.04.2006 18:18:21 43 Pages: <<  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  31  32  33  34  >>