Recent content by milte

Hello everyone, Although an easy question for all, I still need assistance. I have a text box which increments +1 when a new record is added. I have it placed on the control of the text box, but would like to have it automatically run when the form is opened. The code in the control is...

Thanks for the response. This database has gone from version 97, to 2000 and now to 2003. This statement has had to be changed each time. I just now fixed it by using: stLinkCriteria = "[ControlNumber] =" & "" & Me![ControlNumber] & "" I just tried your version and it works also. Thanks...

Hello everyone, I have a search form with columns and rows. A user can click a cell and it will filter by that cell. A user can double click a field and the record will open based upon the field that was double-clicked. We recently upgraded to Officer 2003 and now we are having issues with...

Hello all, I'm trying to build a graph in Access by using the wizard. The error I keep receiving is that the OLE server is not registered. To register the OLE server, reinstall it. How do I do that? Is it something I can do from my local machine? Is it something I can add in the references...

Thanks Paul, I'm in business. I would have thought it'd be DateCreated. Anyway, I appreciate your follow through to resolve this issue. Milt

Hello All, On my switchboard, I'd like to have a textbox that would give the date of the last update to the database (which is monthly). I need the datecreated date for a table shown in this textbox. The table name is tblUMD. Is this possible? Milt

Never mind. I just added a where statement to the query. Milt

Got another question. After thinking about this, probably should have went this route. What is the best way to have only the mismatches show up on the form? I have about 12,000 records and don't want to scroll through all of them looking for a red cell. Milt

Thanks, Bill. Works like a charm. Man, where do you find this stuff?? Milt

Hello all, I have a query from two tables. I want to compare certain cells in the two tables and highlight any changes where the cell doesn't match. I have the form built with the columns I want but the problem is that it highlights the entire column and not the particular cell. The code I'm...

Hello all, I'm not sure of the best way to accomplish this... I have a query, with parameters, based off of a table. I have a form and subform with the record source from this query. The subform is a datasheet. Fields on the datasheet/subform are filtered by using the filter buttons on the...

I put that code in the query. It's still prompting for parameters. Any other suggestions? Thanks, Mike

Hello all, I am having a problem sending an email using SendObject. When I use it once, it works fine. After trying the second time, I get an error 'The SendObject was canceled.' If I close the database, then reopen it, it works fine again. Although only once, of course. This is accomplished...

Thanks, Bob. I can't tell you how much I appreciate it.

Hello all, I have a form with an unbound combo box. I'd like the form to filter on the selection I made from the combo box. What is the best way to do this? Thanks for your help, Milt