Search results

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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.

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...

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!

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...

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...

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 +...

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...