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  >>   Find code errors I am fairly new to recordsets and have two different databases that I am trying to get a search of tables to work. Having problem with both. I don't know if it is kosher to ask for solution to two problems on one post or not. Guess I will find out, huh. The first problem occurs at the rst.open line of code & I don't know why. Private Sub cmdFind_Click() Dim rst As ADODB.Recordset Di... 2 01.06.2006 05:20:39 using make table queries in report wizard Hello, try to create a report my make table queries are not available in the drop down (but their resulting tables are) I'm trying prompt using the make table queries when the report loads. it prompts on the query but can't be pulled into the report. does any one know how to use make table queries in reports? Also, does anyone know of a site or add-in for report designs, we're in desper... 4 31.05.2006 21:15:15 Automating Backup of Database I want to be able to have a button on my database front end that will automate the backing of my database. I have tried to assign a macro to my button that will run the backup command. However upon clicking the button I get the following message: The Command or Action 'Backup' isn't available now. Is there a way to assign the backup procedure to a button on a form or on a toolbar ? ... 6 31.05.2006 16:35:01 Add 1 to a counter when a button is pushed? I would like to create a counter, which advances by 1 each time a button is pushed.... 4 31.05.2006 15:32:02 Is there any way to have the message box ask yes or no questions? I am trying to set up a macro so if they answer yes it sends them to one place and if the answer no to another.... 4 31.05.2006 13:15:01 How to turnoff the Halt mess in a macro when running a qby cancel I am running a macro that runs several queries in a row. In one query I ask for user input example [enter info], which brings up a dialog box for input with enter and cancel buttons. If the user clikcs the cancel button a macro halt message comes up . This is what I need to stop from comming up and just return back to the previous form ANYONE CAN?... 2 31.05.2006 09:13:35 export Access data & enable excel macros I have done a project in access and created Report with the help of Macros to export into Excel sheet. After creating Excel sheet I have created one more Macro to create format & other things in Excel. Should I do it from Access itself to operate excel macro.? I mean my excel macro should work when I export from access itself. Pl. provide example also... Thanks, Siva from India ... 2 30.05.2006 21:57:58 Automatic excel open I have done a project in access and created Report with the help of Macros to export into Excel sheet. After creating Excel sheet I have created one more Macro to create good look in Excel. Should I do it from Access itself to operate excel macro.? I mean my excel macro should work when I export from access itself. Pl. provide example also...When I export with the help of access macros, it ... 2 30.05.2006 21:27:24 switch micros back on how do i switch micros back on when i go into word it tells me that micros is turned of i am using OFFICE 2003 ... 2 30.05.2006 20:59:13 My ritual question for each new version of Access since 2000 Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button remains desperatly grayed. It also seems impossible to open the library in another Access instance and modify it. This makes impossible to maintain a pure VBA Access database when this libr... 1 30.05.2006 13:54:02 Import a spreadsheet using a macro in access? Hi, Is it possible to run a macro that imports an excel s/s into access without having to go through the "Import spreadsheet wizard"? Thanks George... 5 30.05.2006 03:53:01 how to copy with a macro - I have a range of differents sku # in column G. - Each sku# has different data in columns I, J, K, L, M, P,T,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP,AR,AT,AV,AX,AZ - If I enter a new sku in Column G and if it is the same sku that I already enter previously, how to create the macro to copy the same information in colums I, J, K, L, M, P,T,X,Z,AB,AD,AF,AH,AJ,AL,AN,AP,AR,AT,AV,AX,AZ - Also give me bl... 2 30.05.2006 00:56:30 Msg Box Macro I am using a message box Macro in designing a database to keep track of incoming shipments. We check every 10th part we receive to make sure that it passes inspection. So every tenth peice of data I need the msg box macro to appear and ask if the part has passed inspection. If the answer is yes than it will return to the original form. If the answer is no I need to know how to send... 4 26.05.2006 22:54:49 Runapp with Sendkeys I'm trying to use the Runapp action in a macro and then send keystroke commands to the other app. The help for the Runapp action says that I should be able to do this, but when I put a Sendkeys action after the Runapp action, the keystrokes are sent in Access and not the other app that I just opened. What am I doing wrong? -- Tony Adler... 3 25.05.2006 20:33:02 TransferDatabase Hi all, I am running a macro which imports 3 tables from a different .mdb file on the same drive. However, I want the user to be able to run the macro regardless of whether or not the table actually exists in the other .mdb. In other words, the 2nd .mdb which I will be importing from is a station where an intern enters checks into the computer. However, sometimes there will only... 5 25.05.2006 18:31:02 ambiguous outer joins Hi I am new with access and when I joined a field I get the message about ambiguous outer joins. Where can I find information as to what this is? I have tried searching the help and this does not really explain it. thanks ... 2 25.05.2006 16:26:02 SendKeys When I run a macro, screen gets populated and asks for UserID and Password? How Can I use the send keys Action in this macro to enter my user id, tab, enter my password and then press enter to continue. Please help... 1 25.05.2006 15:08:02 Create a button that prints a report and emails a different report Is it possible to create one button, when clicked prints a report and emails a different report to email addresses based on a query? Alternatively one button that prints a report and another button that closes the form as well as emailing the second report? Any ideas?... 2 25.05.2006 04:24:34 find record & rename record Hi, I want to run a macro that opens a table and locates all the records that contain "SEEK" in the table and replace SEEK with SEK - is this possible? I can only find renames for table or query names? Thanks George... 3 25.05.2006 04:10:02 How can I convert access table data types using macros? Trying to work out if there is a macro function that will allow me to automate the process of changing a text data type to hyperlink on opening a table that has been created from a make table query.... 2 25.05.2006 03:36:47 How do I isolate the macro to one cell instead of a whole column? I need my macro to have the message box pop up every tenth cell. But right now it pops up on every cell. How can I get it to just the one cell.... 2 25.05.2006 03:28:13 By pass prompts on Macros running several make tables queries Bonjour! I think there is a way (option of something) to prevent MS Access to send prompts confirming deletion or updates and other messages while running macros/queries. I'm running about 15 make tables queries in a macro but it defeats the purpose of automation if I still have to be there and click ok on each query request. Does anybody know? Thanks ~~Marie... 2 25.05.2006 03:25:15 Setting values on Controls of Subform Hi, Can anyone can answer my query that how we can set Data on Subform from a recordset. when I'm trying to set it like Set frm1 = Forms("fsubroomsdept") Set frm1.Recordset = rstQry str1 = rstQry!BuildingName Do While rstQry.EOF <> True For Each ctl1 In frm1 If TypeOf ctl1 Is TextBox Or TypeOf ctl1 Is ComboBox Then Select Case ctl1.Na... 2 25.05.2006 00:13:39 show all records Hi, I have a form that has several combo boxes. Each time the user selects something from a combo box, queries are run and a record set returned to match the specified criteria. (i.e. the form opens with 200 records, but by using the combo boxes the user can get down to 1 record. ). Without closing and re-opening the form, how can I get the form to display all of the records again?... 4 24.05.2006 19:37:19 Access 2003 - Need an email button prefilled with info from the fo I have a form containing three fields that I need to use for an email. "Company", "EmailAddress", and "Program Contact". I'm hoping this is simple - I've never used Visual Basic or anything so I would REALLY appreciate someone walking me through this as if I were the idiot that I really am :-) I just want a button that pops up an email, pre-filled with the email address, a subject... 7 24.05.2006 19:36:38 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  >>