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  >>   problem opening access database from a window service hi, for some reason this line 'mdbFile.OpenCurrentDatabase(mdbPath)' fails to work on a 'window service' project on a simple project (not service) it work's perfectly does anyone knows why?... 1 20.09.2006 13:07:01 Macro help please. I have two macros I'll put in order below after I explain, can I join them into one, or can I make another macro that runs the first, then the second? Each works fine, but second one loops, so combining them is beyond me, unless there is a way to benchmark loops in code? Anyways here they are..... Sheets("Data Entry").Select Range("B6:B1005").Select Application.CutCopyMode = Fals... 2 20.09.2006 00:42:59 Removing the possibility of macros I have a client who is cyber-agoraphobic. As a result he will not allow even the possibility of macros in the database I am trying to send him. Is there a way to eliminate all macros from a database so that the warning will not appear regardless of the security level setting? paul... 2 20.09.2006 00:24:05 Word bookmark name from Access I am trying to reference a bookmark name in Word 2002 from an Access macro. When I reference the .Name property I get "OLE_LINK1" as the name and not the name of the bookmark. I've read lots and can't seem to figure this one out. Here's my code. Private Sub Topic00() Dim myapp As Word.Application Dim mydoc As Word.Document Dim mymark As Word.Bookmark Dim myrange As Word.Range Di... 2 19.09.2006 22:53:01 Function Key - F1 F2 etc Does anyone know if it is possible to use a function key to open a form in access? Thanks in advance! ... 3 18.09.2006 22:18:09 Low on inc pop-up warning on every I am doing a Printer inventory and have two columns, type of cartridge and the quantity. What I would like to do is when the quantity of each cartridge goes below 3 when exiting, every time, a pop up warning “Inc is low for cartridge X. Order more “shows up. So far I have it giving a pop up that tells when the quantity is low, but want I really want it to do is tell the type of cartr... 7 18.09.2006 08:21:56 How do I create a "run query" macro? I would like to run an update query immediately after entering a record via a form. The form has a 'save' button. How can I create a macro to run the update query when I save the record entry? thanks Pat... 6 18.09.2006 08:13:54 WHAT IS A MACRO Hi All Excel Pros Can anyone tell me what is the function of macro? Tks ... 2 18.09.2006 02:49:38 The expression you entered has a function name that DB can't find When users start our application, some users get "The expression you entered has a function name that Database can't find." error. Any idea about this? and how to debug it? We are using macro autoExec() which calls autoExec2(). I loaded some status info to the status bar when macro starts. When the error occurs, the status bar has no info. It looks like the problem starts before macro r... 2 17.09.2006 21:40:08 In excel, I want in indent less than 1 character in a cell I want to get my numbers in a cell a little farther away from the right border. Putting a 1 in the indent box in the format cell dialogue box is too much. But it wont let me type a fraction or decimal 0.5. Am I the only one in the universe that wants this? Is there another way? Thanks Dan... 3 16.09.2006 18:59:01 Macro to compare two tables Hello, I am a relative novice at VB. I am currently trying to write a macro to compare two tables. The tables have the exact same columns and I save the table once a month. I want to be able to compare the new and the original databases. Any ideas in how to go about this? Thank You.... 6 14.09.2006 16:06:24 MS Access encountered a problem A2003 split DB. I am trying to create a macro in the FE.No problem selecting commands, but when I Rt-Click to use the expression builder for conditions, I get "MS Access has encountered a problem and needs to close....apologies for the inconvenience. There are no other macros in the FE. I have compiled. Also created a new DB and imported the forms/reports and queries. Same problem. No p... 2 14.09.2006 13:36:02 Open current record in form, from list view subform Here's what I've got, a 'call management' type database which has a main form with the users information in it, then a sub form in list view of all their service calls. We want to be able to double click on the call number (ID ) and have it open that record in a separate form in form view. I setup the 'on doubleclick' action to run a macro which opens the form with the criteria: [Workorder... 4 14.09.2006 03:34:49 Linking an Access Form to a Word Document with a User Form on Open I have a command button on my access form that opens up a word document and fills in data from access at the appropriate bookmarks in the word document. However, the document has a user form that pops up on open. The data from access doesn't populate into word until after the user form is filled out & closed. I'd like the data from the access form to fill in first, so the fields tha... 1 13.09.2006 23:21:02 macro help needed I have a macro that I'd like to limit the pages it can work on. Sub columnremove() Dim myRng As Range Set myRng = ActiveSheet.Rows(4) 'for rows that have 0's or blanks in column A 'set myRng = activesheet.range("a:a") With myRng .Replace What:=0, Replacement:="", LookAt:=xlWhole On Error Resume Next .Cells.SpecialCells(xlCellTypeBlanks).Entire... 2 13.09.2006 22:39:10 Value Tracking.... I'm somewhat new to Access, I have a location text box, which stores an items location, I am looking to see if it is possible to track where an item has been in the past. I am assuming this is possible by using the onChange to execute a macro that would take the current value then append it to the bottom of a memo box that would contain the history of every location that has been used in ... 2 13.09.2006 19:19:37 Automatic import into Access Hi. I have to say that this is the first time I have ventured into macros in Microsoft Access so I am a complete beginner!! I want to be able to run a macro in a database file that imports two files via odbc from sage line 100. Where do I start?? -- Chris... 1 13.09.2006 15:49:03 "Project is Unviewable" When I try to work with the macros in my access 2002 database project I get the message "Project is unviewable". I have not set any passwords on this project or on the database. I have gone through all the help info regarding adding, changing and removing passwords and as far as I can see there are no passwords at all in this database project. What would be causing this message? How can... 1 12.09.2006 23:27:01 macro to link multiple tables from different DB files Hi everybody, I have this big problem, over 200 small DB in a folder having each a table with the same name. I'd like to have a macro that looks into this folder to look for new DB files and in case create a new link to each table that is in the same new DB files. Is this possible to do? How can I start? Thank you! Larry ... 1 12.09.2006 21:08:47 Excel code convert to Access code - Concat & eliminate duplicates I have a database with 2 columns and more than million rows. The first column is the id Example of the data (2 columns)- 04731 CRM 04731 CRM 04731 CRM 04731 RVB 04731 RVB 25475 MMX 25475 MMX 25475 FRB 25475 FRB Result desired (2 columns)- 04731 CRM; RVB 25475 FRB; MMX Idea is to summarize the data and eliminate the duplicates. The second column shoul... 1 12.09.2006 16:04:18 how do i run liked table manager automatic I want to autoupdate every hour a flat CSV file. I have linked my CSV files to the tables section. How do i set up the auto update every hour? ... 2 12.09.2006 08:29:01 Linking a Form to a Word document I've managed to create a command button on an access form to open up a word document. Certain fields on the form populate into the document through use of bookmarks. The document also has a user-form that pops up. However, the user form pops up first, and afterwards the data from access fills in. I'd like the data from access to populate first, then the user form opens--and if possib... 1 12.09.2006 03:15:02 Access open RTF then run word macro I have a macro in access that exports (opens a) RTF document. Then I have to manually (mouse) enter: tools, Macro, macros, then I must select one of two files 1-weekend or 2-holiday, then I click run. Then the macro takes over adding columns, text and automatically printing. I want to have the macro in access open the previosly described series to run the word macro. How do I do this?... 1 12.09.2006 01:31:01 Email list I have a contacts table with an email field in it. How can I send an email blast to everyone in the table? Tia, kw ... 5 11.09.2006 23:24:12 Help with Print Macro Hi, it's me again. I am building a macro that will export certain information to a specific Excel spreadsheet. So far, I have the export working, and I can open the Excel Application. How do I get it to open a specific Excel file, instead of just a blank worksheet? This is what I have so far: Action: RunApp Command Line: C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE I... 3 11.09.2006 21:08:01 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  >>