Search results

  1. P

    Strange Error with Split Database

    Hello. I just split my Access 2000 database and receive the following Run-time error (#3251): Current provider does not support the necessary interface for Index functionality. This error occurs on the following line of code: tablename.Index = "PrimaryKey" Does anyone know why this occured...
  2. P

    Opening Db by holding down shift key

    Hello, Believe it or not, we just upgraded from Access 2000 to 2003. In Access 2000, I have my dbs set up so that you must hold the shift key down while opening the db in order to see the database window. In 2003, holding down the shift key isn't working. Is there another way to get the...
  3. P

    Scope of variables from Parent for to Subform

    Is it possible to have a variable declared and set in a parent form, and then referenced by a subform without making the variable public? For example, can you directly reference that variable from the subform in a similar way that you reference a field on the parent form? Thanks in advance.
  4. P

    Recordset Not Updating

    Hello. I am having a problem looping through a recordset and having it update. As a matter of fact, only the first record in the recordset is being updated. I am certian it has to do with the way I am looping. Here is a snipit of my code: rsMOE.Open "select * from MonthExecutionQ where...
  5. P

    Changing text color in Lotus Notes email via VBA

    I have been using a wonderful function (found on this forum!) in which I can send a Lotus Note via my MS Access database. The Lotus Note is a course roster with course information and then a list of student names. When the Lotus Note launches in Edit mode, my user changes the text color of the...
  6. P

    Opening a remote database from the switchboard of another database

    Hello, I am using the following code to open one database from another database. Sub OpenRT() Static acc As Access.application Dim db As DAO.Database Dim strdbname As String strdbname = "s:\CIO\ISI\RAG\RAMTRACK\Access2000\Backup\Ramrod.mdb" Set acc = New Access.application acc.Visible = True...
  7. P

    Problem getting multiple records to display in body of Lotus Notes email

    Hello, I found some code on this forum that showed me how to send a Lotus Notes email from MS Access. It works beautifully, with one exception. I am creating an email Student Roster. The email body pulls the Course Title and Course Dates from the database. I also want the related student...
  8. P

    Passing a password from one database to another

    Hi. I have searched the forum for answers, but have not yet come across anything that is similar to what I am trying to do. I have a database that serves as a switchboard to open several disparate, but related databases. One of the databases is password protected (at the database level -- the...
  9. P

    Charts -- Making a Horizontal Line "Stop"

    I have a column/line chart that displays budgeted verses actual expenses for each month (october through september). The columns represent the budgeted verses actual. In addition to the columns, I have a horizontal line representing the 60% mark. For example, if the total budget is $100,000...
  10. P

    Chart Question: Stacked/Column

    Good morning. I need to create a chart that compares Planned versus Actual spending. I have accomplished this very nicely using a column chart. My problem is that my user has two different sources (or buckets) of money (Source A and Source B). I am trying to create a stack on both columns...
  11. P

    Report Focus

    Hello. I have a complex report that takes a minute or so to open. I created a little form with a cute "please stand by..." message, which I open on the "onclick" event of the button that launches the report, before the 'open report' command. How do I get my little status form to have the...
  12. P

    Horizontal Page Breaks

    Hello. I created a budget report that uses all of the 21 inches of horizontal report design space. When I preview the report, fields that fall where the page breaks horizontally, display half on one page and half on the other. How can I force the page to break horizontally in the appropriate...
  13. P

    Dynamic Check Boxes

    Hello. Is there a way to create dynamic check boxes? What I would like to do is pull items from a table and have them display on a form to use as lables for check boxes. I suppose I can always use a list box, but I was wondering... Thanks
  14. P

    changing record source on subform

    Hello, I have a form with a subform. I want to change the record source on the subform during an OnClick event. I am not sure what I'm doing wrong, but I get a "object does not support this method" error. Can anyone help? Thanks in advance.
  15. P

    Script for importing tables and building relationships

    I am building a database where the data comes monthly on a CD from an external source, already in Access. There are three tables, two of which are related to the "main" table. When the data comes, the primary key field on the main table is not defined as the primary key, so I have to manually...
  16. P

    Access 2003 to 2002 Conversion

    Hello. I am developing an Access application in Access 2003 for a user who has XP and Access 2002. Will my 2003 database work with his 2002 Access? Thanks!
  17. P

    Auto-filling a list box

    Hello. I have a form with a list box. The user selects a radio button from an option group and the list box populates based upon the selection. My user now wants the ability to type the first few characters in a string and have it find the right value in the list box, particularly when there...
  18. P

    Problem Outputting to Excel

    I am trying to output a report to Excel with the following code: Private Sub cmdExcelExec_Click() On Error GoTo Err_Handler Dim strReport as String strReport = rpt_TransRegister Docmd.OutputTo acOutputReport, strReport, acFormatXLS, "expenditure_report.xls", True Exit_cmdExcelExec_Click...
  19. P

    Running Total Function acting Funky

    I found this code from a post several months ago: QUERY defined new column named CumTot passing Fcast as parameter: CumTot: CalcCumTot([Fcast]) FUNCTION in a module assumes long value in and out: function CalcCumTot(iValue as long) as Long Static new CumTotal as long CumTotal = CumTotal +...
  20. P

    Changing the way a chart is displayed

    I have an Access chart that I would like displayed as a combination column/line chart. I was able to go into the chart properties and select a colunm/line chart, but the chart displays with two columns and one line. What I really want is one column and two lines. Is there a way to change a...
Back
Top Bottom