Recent content by JMS

Unfortunately, report_load does not exist. (Unlike forms, there is no corresponding function to form_load.) Besides, in forms, the 'open' function executes before the 'load' function.

I've tried it both ways and it didn't work. The syntax with the extra bracketing was actually generated by the expression builder when I tried to do it that way.

I suggest you look up the VB commands OpenQuery and OpenTable. This should be pretty simple.

It might be easier to write a script on the mailserver for this, if you have access to the mailserver's cofiguration, that is. As to your sig, Outlook adds it when you compose a message. It's added before you hit send. Since you composed (generated) the message in Access, Outlook does not get...

You might want to look into the pager service's details as opposed to Access. For example, many cellphone providers allow you to send e-mail to 1234567890@msg.servicepovider.com and it sends a text message to that phone. Perhaps there is a similar service for that pager provider. You could...

rowsource is missing?- strange error msg!! I am attempting to use VBA to change the rowsource on a chart. The code is like this: Private Sub Report_Open(Cancel As Integer) Me.[ChartOLEUnbound].[RowSource] = SQLCode End Sub I am 100% sure that the SQL code is correct and I have tested...

If the second input would appear on some other form, you could pass the first input to the second form and have it detected automagically. Look up the OpenForm method.

From what you have described, my opinion is that you need to rethink your design NOW before too much data gets put in there and it becomes hard to change your system. I suggest you do some web searches for information about Normalising your database. Pay special attention to the requirements...

If you are using a really old version of access (i.e. 2.0) then this is a limitation of the program... you have to break your calcualtion up into a group of smaller queries. I do not know why this would appear in a newer access version. Still, breaking up the SQL work into smaller queries...

I would generate an HTML index using QueryWeb (www.query-web.com). It can be regenerated automatically and you don't need an extra .mdb. This tool is really powerful once you get into it, but you need to know how to write real SQL code. I am not so experienced but I can't think of a simple...

I just thought of a better way to explain this ... I'm trying to graph [SomeColumn] vs. [SomeOtherColumn] from [SomeTable] . And in each possible table, all the columns have the same names. Only the data is different. Yes, I think that that is a clear explanation.

I am hoping someone can tell me about how to do this: I'm trying to get Access97 to create a nice bar graph for me where the user selects the y and x data from table columns. (i.e. I'm not taking a static set of columns in every case. It changes depending on what display the user asks for.)...