Threads Replies Last Post 225 Pages: <<  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  35  36  37  38  >>   XML Import Error Morning, all! I have an Access 2002 database that imports an XML file. It has been working fine. We just added a new client in south FL to the routine, and the import fails when it first encounters a name containing the "nya" character (tilde n or ñ). CodeWrite shows the value of the character as a Hex F1, and displays it as a "plus-minus" symbol. I'm guessing that it is a ch... 1 29.08.2006 14:04:02 debug query! I have the following message: "The report name 'dep' you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist." I think I know which report design it is coming from. When I highlight the report and click on the "code" button I get the message above. I haven't been able to find 'Dep' anywhere. Can someone help? cheers in advance... 1 29.08.2006 14:02:02 Declaring Subform Name This one should be easy (but not for me) I need to pass a Subforms name from a event on the form to a module which will then fully qualify the subform name. On event (lost focus Or wotever) =Subform_Name("frmame") The module will then add active form and subform to give me FQ name Currform = Screen.Activeform Formname = Currform.Name & "!" & PassedVariable Set Subfrm = Formname.Form... 2 29.08.2006 13:02:10 SendObject sends old version of Excel workbook. How send Excel 200 The Access 2003 VBA SendObject acFormatXLS OutputFormat sends Excel version 5.0/95 workbook. How can I get it to send an Excel 97-Excel 2003 version ?... 1 29.08.2006 12:46:02 How do I integrate Outlook and Access? How can I go about monitoring an Outlook mailbox from within MS Access, and then saving the mail into Access along with some of its details? TIA, JackStri.... 1 29.08.2006 12:33:02 subform undo hello, how can i undo the changes in the subform? i have the code like below, but it doesn't work Private Sub undo_Click() Me.undo Form_MySubform.undo End Sub thanks in advance :)... 2 29.08.2006 09:53:23 Access 2002 to Access 2003 Problem - Won't Create MDE in 2003 I have developed an application starting in 97 and upgraded to 2002. It has about 30 forms, 200 tables, 200 querries and about 10 VBA modules. I can create an MDE with Access 2002. I can open the program with Access 2003. It opens and runs. When I try to create an MDE it says it has a problem with its size and the number of table ID's and can't do it. Taking the same program back to Acce... 3 29.08.2006 08:29:02 MODI viewer control (Microsoft Office Document Imaging Control) Can someone please provide a link to or sample of Access code that displays mdi files on an Access form. Thank-You in advance. Top Dog... 4 29.08.2006 03:38:07 Need some guidance about Excel please... I haven't actually played with coding any VBA to make anything happen regarding Excel. (I'm running 2k3, as part of Office 2k3.) So while I know VBA (not as an expert mind you), I'm starting from scratch when it comes to dealing with Excel, regardless of whether we're talking workBOOK, workSHEET, or whatever. I was hoping that perhaps someone with more experience than I might provide some ... 5 28.08.2006 23:54:01 Code to delete all queries in database Group: I need to write a sub to delete all of the queries in the current database. I am hoping that someone can steer me in the right direction. I know that the statement to delete a query is db.QueryDefs.Delete (QueryName). But how do I go about getting the names of all of the queries and then delete them? Any sample code would be a great help. Thanks, Bob V ... 5 28.08.2006 20:59:43 Createdatabase and TransferDatabase We have an Access application running on a server. users connect via CITRIX. One function creates a new database on the user's local machine and then exports a table into it using the TransferDatabase method. this was working perfectly in Access 2000. We upgraded to Access 2003 and now we are getting errors, "cannot open file" , "do not have persmissions" or "file is corrupt". Any sugges... 1 28.08.2006 20:20:02 Programmatically Hide and UnHide a table I have not been able to figure out the correct VBA code to hide or unhide a table. I would appreciate a little help here. Thanks.... 3 28.08.2006 20:18:02 Update Subform Datasheet Record from Main Form Hi All, I have a main form combo box that I would like to set the After Update event to change all the records in the subform to match this value. Dim rst As Object Set rst = WHAT DO I TYPE HERE??? Do Until rst.EOF rst.MoveNext Loop -- Matt Campbell mattc (at) saunatec [dot] com Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/... 2 28.08.2006 18:07:38 Windows XP login name into a text box How do I Place the Windows XP User Logon Name in a Control (text box) on a Form in Microsoft Access... 7 28.08.2006 17:03:02 How to use the forms-collection Hi all, I have a problem using the forms collection in vb. I have statement like this myvalue = Forms(str1).Controls(str2).Value where str1 is a formname of a loaded form and str2 is the name of a control on that form. Let say str1 = "Myform" str2 = "Mycontrol" after executing it Myvalue is correctly retrieved from the form. But now my problem: when str1 holds the name of a subform ... 2 28.08.2006 16:28:44 Import multiple Excel Sheets into Access Table The goal is an Access VBA code that opens an Excel workbook and appends ALL the sheets ono by one into an Access table. Every Sheet has the same structure (columns) and the columns are identical to the Table fields. BUT, I dont know the number of the sheets (could be more than 100) on every workbook, as well as their names. Therefore i was looking for a code similar to the following: ... 1 28.08.2006 15:48:02 Passing 2-dimensional array to subroutine Help! (I am using Access 2003.) I am having problems passing a 2-dimensional array to a subroutine. The array is "redimed", as the number of elements is not known. The array fills successfully, as my debug.print statement shows: x=4: 84111 13 x=5: 87315 1 x=6: 87326 3 However, when the array is passed to another routine, the program crashes with an error when it tries to read the p... 10 28.08.2006 13:40:28 Union Query I am trying to build a UNION query. It consists of 4 SELECT statements. If I try everyone apart or I use any combination of 2 out of 4 SELECT statements, they work. The problem is that when I use more than 2 SELECTstatements I get the following message: "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." Does anyone know what sh... 4 28.08.2006 12:49:02 Printing a Word doc from Access double-sided Hello, I'm attempting to have a Word document print out duplexed (double-sided) but I'm not having much luck. I have a function that creates a reference to a file using GetObject(fileName) command then uses the .PrintOut command to print the document, but the command does not offer duplexing. Does does anyone have any tips on how to duplex print a Word doc from Access? Thanks in adva... 2 28.08.2006 08:48:59 Checkboxes conditions Hi I'm using MS Access 97. I have a continous form to give a progress summary. An item can have many parts and therefore has 10 checkboxes which can represent on time, late or very late. The checkboxes table contains all the checkboxes related to an item and is linked to the item table (master). I need to represent a green box with an unchecked box for the on time, late by a checked box or ve... 5 28.08.2006 07:42:17 split databases and connection settings.. I'm looking to deploy an MDB which contains queries and reports to my clients users. The queries are setup to use linked tables on an SQL 2005 Server database and I also use passthrough queries to execute stored procedures. Since I can't be sure they all have the same DSN setup I'm using can anyone clue me in as to how this should be done? Any suggestions would be appreciated. ... 3 27.08.2006 23:52:08 Compacting on fly... First, sorry for a lengthy post - am trying to provide as much info as I can. Am getting an error message in a new application I am trying to deploy - "cannot open any more tables." Error code 3014 is displayed by the help button, but the only reference to 3014 I have been able to find (even in the MSDN Library) is related to printing issues (not the issue in my case). I have never see... 2 27.08.2006 20:48:01 Bar Codes! I am looking to produce bar codes from access is this possible? ... 2 27.08.2006 19:10:22 share queries and reports Can someone direct me to a discussion of how to share queries and reports with users and be able to update them and redistribute after adding or making changes? I'm using SQL Server 2005 as the back end with mostly stored procedures and pass through queries. Thanks for any suggestions.... 2 27.08.2006 19:08:42 Putting values into Excel via Access program I need to open Excel from Access and place various values in various cells in an existing Excel spreadsheet. My code below does not work. I commented off my attempts. Can you help me correct what I am doing wrong. Thanks so much. -Beverly Set xlbook = xlApp.Workbooks.Open("E:\Trading System\Database\Excel Spreadsheets\AUD-JPY_LstGrp_Calc.xls", 3) ' 'set xlsheet = xlbook.worksheets.... 5 27.08.2006 12:30:01 225 Pages: <<  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  35  36  37  38  >>