Recent content by poet1234

Hi. It's the full sha-bang -- the developer version. I have always heard that splitting the db is beneficial. I suppose I could remove those index references (I didn't write that particular code. I have never set up an index in code and was wondering if it would hurt to just remove it). Thanks.

FE/BE both in Access 2000

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

Changing the text color of a string variable Hi. I was thinking about this question I posted, and realized that what I am really trying to do is have the string variable print out in a color. Is there a way to do that? I searched for ways in which to "format" the variable, such as the way...

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

Hi. I tried Macca's suggestion, however it doesn't quite do what I need it to do. It opens the other database, but it goes directly to the form specified in the "startup" menu, rather than the form I am telling it to open. I thought that perhaps if I removed any form reference from 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...

There is some code in the parent database that needs to be changed to reflect the correct path. You might check behind the buttons on the switchboard form, or whatever form is the first form launched when the parent database starts up. You can find the startup form by going to the to Tools -->...

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