Recent content by RippleJD

Silly me: Me.GraphName.ChartTitle.Text = "My Text Here" %-)

Hello All, Does anyone know how to change the Chart Title in a Microsoft Graph 2000 Chart Object programatically? Thanks, JD

I am having a similar problem. Does anyone have any suggestions? It seems to be an issue with Windows 2000 because I don't have the same problem using windows 98. JD

The combo box I am using is for data display and selection. The data are not stored in the table with mask characters, but the user wants the mask characters displayed. When searching for an account number, the user does not want to type in the dashes, but wants them shown automatically as he...

Hi folks, I've got this strange problem with Access 2000. I have an unbound ComboBox control that will be accepting an 8 character string. The row source is a query containing an 8 character text field. This field is really a series of numbers, some starting with zero (ie 01123400). This...

If I understand you correctly, the bottom line is you want to add up all the "S" transactions and subtract all the "R" transactions on your subform and show the one total on the main form. One possible solution is to create a hidden text box in the footer of your subform...

I would assume if you set a reference to the Microsoft Excel Object library inside your access app you should be able to set formatting for a given sheet. An easier method might be to set up a macro inside excel which would format the sheet (providing you are working with the same data each...

I have a program that must process a large number of records in a transaction block. I was getting error 3052 "File Sharing Lock Count Exceeded." According to an article from Microsoft's Knowledge Base (and another in this forum), the recommendation is to increase the default setting...

Thanks folks! I was able to use the same GL_Table, but I used the Max(GL_ID) function in a recordset instead of using the DMax function. Set rs = db.OpenRecordset("select max([GL_ID]) from [GL_Table]") I guess the key is using a recordset object instead of a domain aggregate...

I need to increment a field within a transaction block. I call a function like the following within the transaction (there is more to the function, but this is the relevant portion). Public Function UpdateGL() As Boolean Dim rsGL As Recordset Dim NewGLID As Integer Dim db as Database...

Thanks folks. I could have sworn I tried <> &quot;&quot;! I feel kind of silly now. JD :~/

I have a query in Access that is using a linked Excel table. I want to return only those records where the phone number is null. When I enter &quot;Is Not Null&quot; into the criteria for the phone number field, the result set still returns &quot;blank&quot; phone numbers. Excel is storing...

Try the function CInt().

I have an access program that links to Pervasive SQL 7 tables via ODBC. On one PC the performance is adequate. On another, the performance is much too slow. The only difference between the two PCs (as far as I can tell) is that the &quot;slow&quot; pc had Windows 98 and the &quot;fast&quot...

After rebooting my PC, it is now working with me.repaint. Those darn gremlins again!