Threads Replies Last Post 26 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   Making my Access export function work with Excel 2003 and 2000 I have an Access 2003 project that the sub below on one of the forms. The sub fires up a few queries to clear a table, fill it with the latest results, run a couple of crosstab queries on the data and export it to an Excel Spreadsheet. Finally it opens the spreadsheet and formats the two sheets a little bit. Where I run into trouble is opening the spreadsheet to format it. I refere... 3 11/9/2008 11:33:40 PM Stuck on acFirst I am trying to cycle through and compare the records for two tables. I start by going to the first record, make the comparison then execute acNext. My record counter increases but my compare process stays stuck on the first record in the table. Help ========================================== Dim RecordCount As Integer DoCmd.OpenTable "REQ_0", acViewNormal, acReadOnly DoCmd.OpenTable "RE... 7 11/6/2008 1:50:16 AM Need to open another database from existing database. I posted a message about a possible memory leak when using the outputtoPDF feature of Access 2007. I have not been able to resolve that problem and am looking for a work around. Here's the problem. I need to loop through a recordset that currently holds 651 rows (this will grow with time). My attempt to use OpenReport to create PDF file (I need PDF reports) results in Japanese chara... 2 10/24/2008 7:42:23 AM Refreshing linked data Hello, I am trying to relink external data with some code but the code does not like an external CSV file as a linked data source. Here is the code.. If I set the Spreadsheet in TABLE_TABLE as "Local" then the rest of the tables relink fine. Am i supposed to relink a CSV file diferently? Any ideas would be great... Thanks, Ernst. Set db = CurrentDb() For i = 0 To db.Ta... 5 10/24/2008 4:18:27 AM Self-Generating Number All, Below is a transcript of a code I am trying to utilize to create a self-generating number based off of the last two digits of the current year and a serial number. I need the numbers to reset at the beginning of each year and be unique. I keep getting a compile error. This is the error message: Function marked as restricted or uses a type not supported in Visual Basic. I am using a ... 3 10/23/2008 8:09:54 PM access report in visio window? hi, i have a visio diagram (visio professional 2003) that has shapes that are controlled from an access database (access 2003). most of the data for the database is imported into access from an sql backend via a brio query and export. the interaction between the visio diagram and the access database is driven by vba code. there are a couple of reports that the access database pro... 3 10/19/2008 8:17:51 AM Return Average from a query using Case I have a crosstab query that splits my data into corresponding months. I now need to be able to find the average of all of the fields in a given month. Below is my attempt at trying to solve this problem (please ignore every month but October). Function ErndHoursMonth(Ind As Integer) Dim db As Database Dim rs As Recordset Dim strRS As String db = CurrentDb() rs = db.OpenRecordset("q... 4 10/17/2008 12:33:17 AM Manage Multiple Monitor IDs Iam Developing a Multi monitor Application in C++ MFC VC 6.0 in which i need to manage the diffrent monitor IDs for eg if 6 monitors are connected windows will assign IDs as 1,2,3......6 to the monitors and it can be verified->with the help of Desktop->Properties->Settings->Right Click on Monitor which u want to Identify and click on identify it will display the assigned numbe... 2 10/14/2008 1:57:00 PM Show Roster of Users in Split Database I'd like to show a roster of users in a multiuser database. I used to use the ShowUserRosterMultipleUsers code which I found in a knowledge base article. This worked fine for the unsplit database which resided on a network server. Now, however, I've split the database and so only the back-end is on the server. The OpenSchema line in the following code no longer works: Dim cn As Ne... 5 10/13/2008 3:04:10 PM Possible Memory Leak when outputting reports to PDF I have a very odd problem. I have a database that is coded in the US but runs on a PC in Japan. We have reports (by person) that have both Japanese Characters and English Characters on them. We recently changed the reports process to put the report to PDF files with each persons report being a separate file rather than a few pages of a larger report. This is currently 615 reports. T... 11 10/13/2008 1:00:00 PM send emails with Outlook's default text format and default signatu while useing the Outlook object model how can i send emails with Outlook's default text format and default signature ? thanks ... 1 10/13/2008 7:19:01 AM ExportXML I need to create an XML file and have tried the ExportXML method in Access 2002. However, I need to create a header section at the top of the XML output file. Can anyone help with this or point me to more info? I want to be able to create an XML file similar to below: <submission fc:.....> <header_record> ...... </header_record> <detail_record> ....... ...... 2 10/10/2008 1:28:48 PM Email Using SendObject I have code using SendObject to send an email and it works well on my PC. But on another, network it appears to work (no error message) and I get the Outlook security message asking if its ok to send and can answer yes. However, the email message does not actually get sent. Can anyone point me in the right direction to resolve this issue?... 2 10/9/2008 1:43:16 PM Else without if problem Hi I have a txtNewText control where my user types in their new contact notes and after they tab out of the filed it automatically adds their New Text WITH a timestamp to the Notes memo field. The code puts a carriage return under the existing text before populating the memo field. This is great when I have existing text though if this is a first time comment then there is a blank l... 9 10/6/2008 12:18:29 PM Need function to change R1, R2, R3 into R1-3 I have a table that has a list of components on a circuit board. Each resistor and capacitor location on the circuit board is marked as Rx or Cx. I want to report in a query the Qty of parts on the board and their location but I want to neaten it up a bit. Here is a sample of the table Part ----- Location ResA R1 ResA R2 ResA R3 ResA R5 ResA R7 ResB ... 2 10/5/2008 2:30:06 AM Opening FE AND BE in Exclusive Mode Access 2003. I have code in a frontend (FE) module that makes changes to table properties in a table in the backend (BE). This does not work unless the BE is opened exclusive. How may I ensure that when the FE AND BE are initially opened that they are opened in exclusive mode only. It needs to be something that will work even if the user uses a desktop shortcut to open the FE and thu... 4 7/1/2007 1:39:15 AM How to Modify Linked Tables Programmatically Access 2003. I have all of my tables in a backend. I link to them from the front end. I have written a module in the front end (which is where I need to to be for obvious reasons). This module fixes tables when their autonumber seed gets messed up. The code works when run as a module in the backend. But I need to work from the front end. I access the tables alright, but when I try... 4 7/1/2007 1:26:02 AM Delete All Forms Procedure I would appreciate a procedure that deletes all the forms in a database. Thanks to anyone who can help. K. ... 4 6/30/2007 8:58:54 PM Hoping Access 2002 bug is fixed in 2003 - thoughts I've developed a large Access application over 8 years beginning with Access 97. It is deployed to roughly 20 users. After converting it to Access 2002, users started to experience a custom popup menu self-destructing under both Access 2002 retail and runtime and service packs 1 through 3 on different PCs all with WinXP Pro. The command bar is suddenly no longer part of the CommandBars ... 10 6/30/2007 6:34:47 PM Disable Right-Click within database.... Can anyone tell me how to disable right clicking within an Access Database? I know it is possible as I have seen it done, but can't figure out where that is done. Any help would be appreciated.... 2 6/29/2007 8:03:44 PM Can't find field error (2465) after upgrade to Access 2003 We have a proceedure that turns a label caption bold when the mouse cursor passes over it that has been working fine until recently. The only recent change is that we have upgraded (?!) to Vista and Access 2003. Now we get the dreaded: "Run-time error 2465. Microsoft Office Access can't find the field " referred to in your expression". Databases that are still in Access 2000 format ... 3 6/29/2007 10:18:00 AM How to refresh link to open database I have the following VBA that is used to refresh all links to linked tables. It functions correctly when the database that I link to is closed. But when it is opened (by me) I get the error message "The database has been placed in a state by user 'Admin' on machine 'PC-12345' that prevents it from being opened or locked.". I get the error message most times, but not always. I cannot find out... 3 6/26/2007 12:47:08 PM Build list from select query and read results I am trying to achieve the following in a module. I currently have a module that sends out reports via emails. However, the names of the recipients are hard coded into the module. I want to have the module create a list from a table that I built containing the names of the recipients. So here is the what I have: -------------------------------------------------------------------------------... 2 6/25/2007 8:44:13 PM Build list from select query and read results I am trying to achieve the following in a module. I currently have a module that sends out reports via emails. However, the names of the recipients are hard coded into the module. I want to have the module create a list from a table that I built containing the names of the recipients. So here is the what I have: -------------------------------------------------------------------------------... 1 6/25/2007 4:05:47 PM Prevent "TransferText" method creating a .ini file? Can I prevent TransferText from creating a .ini file when it creates a csv file? I can't see anything in VBA help. TIA Damien ... 1 6/24/2007 11:43:55 AM 26 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