Search results for query: *

I created a button with a VBA routine tied to it. The button has always worked perfectly. However, now when I click on the button, the button font size increases. The routine does execute also. If I click again, the font size continues to increase until I can no longer read the text. I am not...

I need to create a resource tree / org chart. I have a table Resources --------------------------------------------------- ResID Name MgrID Layer TreeID 1 Bill 2 2 Paul 0 3 Mary 4 4 John 2 5 Thom 2 6 Carl 4...

I don't seem to be able to set the filter or filteron properties in VB for a subreport. I have tried doing it in the parent report Open event, the parent report Detail section format event and the child report Open event. In all cases I get a Run-time Error 2101 - The setting you entered isn't...

The performance on my database is so bad it is unusable. I have a small database - It has 9 tables and very little data because it is still under development. The database is split into a front end and back end. The back end is on the network, the front end is on my desktop. When I try to...

I have a table with a structure that can be simplified to: Resource ID Autonumber Name, etc Multiple fields Manager ID Number (long) The manager ID is a link to another record in the same table. That person may also have a manager and so on. I want to write a report that...

In Microsoft Excel, you can create a XY scatterplot with a column of X data for each column of Y data. This is especially useful when the various columns of Y data are taken at different X values. I need to graph some test data. The X axis is Frequency, the Y axis will be distance. Each test...

I posted this yesterday and PHV tried to help but was unable. Still looking for an answer. any help is appreciated. I have 2 tables: Tests -TestID (Autonumber) -TestDesc (Text) TestInput - TestInputID - TestID - InputDesc Now, in my CONTINUOUS form I have 2 combo boxes: The first one...

OK, here is my problem: I have 2 tables: Tests -TestID (Autonumber) -TestDesc (Text) TestInput - TestInputID - TestID - InputDesc Now, in my CONTINUOUS form I have 2 combo boxes: The first one uses the tables TESTS as the rowsource. In the second one I want to display only the TestInput...

When I execute the following code in the BeforeUpdate event I get Error 3251 &quot;Operation is not supported for this type of object&quot; Here is the code: If ((Me![Plan date] <> Me![Plan date].OldValue) Then {insert code here} End If When I try to look at the value of the .OldValue...

I have a report with a text box that is bound to a function. The function returns a string that contains one or several text items separated by VbCrLf's. If that text box is placed in the Page Header, the field doesn't grow to show more than the first line. If that box is placed in the report...

I have seen this on both forms and reports. Here is are two specific examples: 1) I have a report with a text box that is bound to a function. The function returns a string that contains one or several items separated by VbCrLf's. If that text box is placed in the Page Header, the field...

I know how to detect the screen resolution using GetSystemMetrics, but is there a way to detect the number of colors in the palette? (ie 256, 16bit, 32bit, etc) Any help would be appreciated. Jonathan ________________________________________ It is not fair to ask of others what you are...

Assume Table A and Table B have the following fields: Table A AIndex AName AAddress AMemo etc. Table B BIndex AIndex BCode With obviously multiple entries in Table B for each entry in Table A I have a form that displays all of the records of Table A. On the form is a subform that displays...

I have a database (Access 2002) that has worked perfectly for some time. I didn't make any design changes to it, but started to get this error: Run-time error 3802 - Error evaluating CHECK constraint The help topic for this error simply says &quot;This is an unexpected error. Please contact...

I've programmed an image to &quot;look&quot; at the cursor, wherever it is. Here is the source for the image in the <Body> <img src=&quot;images\straight.gif&quot; name=&quot;follower&quot;> Here is the code that is called by onmousemove event: Looker = new Array(...

I know how to send Outlook e-mail from Access 97, but how would I send an Outlook 97 Meeting request? Jonathan ________________________________________ It is not fair to ask of others what you are unwilling to do yourself. -Eleanor Roosevelt

I have a form/subform. The form is set up with all the fields being unbound. When the user hits the Done button, the data is added to a new record in a table with VBA. This limits the possibilities for multi-user interference and other errors. I want to have a subform with the same...