Search results for query: *

I am attempting to share a back-end Access database to allow multiple users. There seems to quite a slowdown when the second user opens a form to view any data. I have searched for the proper way to configure connections and am coming up a little short. I have all forms using queries not...

I am attempting to create a report in Excel with the ability to include a variable name in the custom header area. It seems that if the ability to include current date and time, that a variable could be available. I want to refer to cell A1 for example to include that cell value in the report...

I have used SUMPRODUCT in the following way: =SUMPRODUCT((CNUM=A6)*(LTD <=$F$1)) where CNUM is a named range of customer numbers and LTD is a named range of numeric values. $F$1 currently has the value of 10. I have created a new sheet with updated data and #N/A is being returned as opposed to...

I am trying to use a field in a table to provide the variable for this query. I get an error: "The column prefix 'tblvdte' does not match with a table name or alias name used in the query." I have searched the error and found little to aid me. Here is the query: declare @rundte as int set...

OOPS Posted this in Tables etc. S/B Here. I am trying to figure out how to allow the users to use the right mouse button to select / sort records in a form. I have created a front end - back end scenario and created a .mde file in Access 2000. During testing on my machine of course the menus...

I am trying to figure out how to allow the users to use the right mouse button to select / sort records in a form. I have created a front end - back end scenario and created a .mde file in Access 2000. During testing on my machine of course the menus work. On the user machine with only...

I have a report based on a query. It is grouped on a equipment type. I am trying to use dlookup to place the description in the group header. I can't seem to figure out the third parameter for dlookup. Any thoughts as to how to refer to the value from the report. I have tried...

I have been trying to present a pie chart and then dbl click on a piece of the pie to show some detail supporting the graphic. I can trap the dblclick event but am at a loss to figure out how to get any data tellimg me what I have. The object is OLEUnbound0_dblclick that I have focused on to...

I have a series of data Colum headings are a event types Rows are minutes by date Example: t1 | t2 | t3 | t4 | t5 | 1/1/04 | 10 | 10 | | 5 | | 1/2/04 | | 5 | | 10 | 15 | 1/3/04 | 15 | 10 | 17 | | | etc What I need is for a row to be created like t1 | 1/1/04 | 10...

Question regarding return value from DLookup.. The help states that DLookup will return NULL if no data is returned. I have used the example: dim varx as Variant and then checked varx for NULL value. I can't seem to get the check to work. I want to direct the user to renter a correct value...

I have sheet1 with data that shows some detail. I would like to enable the user to double click on a cell and have the data clicked on be passed to another sheet to show additional information. I can use the BeforeDoubleClick action to send me to the next sheet, but cannot fgure out how to...