Search results

I have a problem with a number of MDBs I created in Access 2003 and now use in Access 2010. When I right click on the database objects (Tables, Queries, Forms, etc.) The delete option is grayed out. It is not a security thing since I can use docmd.deleteobject from the VBA immediate window to...

I got my answer at another site. However, in case someone has the same problem the answer is the following: For Each ch In xlChart.ChartObjects ch.Copy xlSheet.Paste Destination:=xlSheet.Range(ch.TopLeftCell.Address) Next ch

After further investigation I think I can greatly simplify this question. I'm trying to copy a chart object from one sheet to another. When I do that manually, using Ctrl-C and Ctrl-V (copy and paste) it works fine. The result is a chart object. The following works in Access 2003/Excel 2003...

I have an application in Access 2003. It uses VBA to open an Excel file. The file has one tab for charts and one for data. The program counts how many charts needs to be created, one per project. It then will place 4 charts per tab, creating as many chart tabs as necessary, keep one data...

Well I have a work-around, although I still don't know what caused the problem. I simply recreated the query using SQL. I don't know why it works in 2003, but not 2010 with the old query. I guess it will be one of those great unsolved mysteries. You would probably need to work on the Access...

I've found the problem is not with the coding, but with the query. Here is the SQL for the query qryImportDocFilter: SELECT [D&D Dwg List].AFC, nz([D&D Dwg List].[JEG Proj]) AS CPN, [D&D Dwg List].[PrintedDoc#], SpecialPDN([APCDoc#],[PrintedDoc#]) AS MPDN, [D&D Dwg List].[ApcDoc#], [D&D Dwg...

Using Access 2003 I update a query dynamically and it works fine. Below is a snippet of the code. strSQLOrig = CurrentDb.QueryDefs("qryImportDocsFilter").sql strSQL = Replace(strSQLOrig, "ExtMDB", "'" & ImportFile & "'") If txtContractor = "Fluor" Then strSQL =...

In Access 2003 I have a shortcut menu with a "Filter For" option that is followed by a text box. It appears fine when I click the right button on my mouse. However, for some reason, the "Filter For" option does not appear on the same form when I try to use Access 2010. The database is still...

I don't really want to remove the password, but I thought that may be one way to update the form. I know the password, so it is not like I'm trying to break-in to the database. I can go to the target database and manually remove the problem coding. However, it a bit more complex. I have a...

I have a mdb file that does not have database or user level security, but it does have a VBA password. I want to transfer (overwrite) a new form to this database from another Access database. The form I'm exporting has VBA code. When I try using docmd.TransferDatabase I get an error. The...

I found the problem. I had an applyfilter event. The purpose was to notify the user in the case a filter for did not find any records. The default action is when filter for does not find any records it immediately goes into Add mode. This can confuse the user. So I grab the current filter...

Spikepl, I agree. If you and CJ London as very frequent posters don't have an answer that probably means there is not an answer. I'll just tell them that is a "feature" in 2010 and to just live with it. Thanks.

But it is set for all rows, right? Used and unused rows. I want the standard white on used or the new record row, and gray for the other non-used areas in datasheet view. Or perhaps easier said, I want the same display that is defaulted in 2003.

This is just a wrap of the runtime error issue. I never did resolve what was causing the problem. However, the problem did not occur when the development package was used. So we decided that everyone in the department gets the development package.

I'm moving from Access 2003 to 2010. I have a form with a subform. The subform is in datasheet view. I've noticed that while in 2003 rows below the "add" (final) row are grayed, in 2010 the rows appear in a white background with a lighter border color. The change may have occurred in 2007...

I'm getting an error message when I try to use a filter in Access 2010 development and 2010 using /runtime. This filter works in Access 2003. I use a custom shortcut menu with the Filter For (followed by a box to type in the filter). The field name is TOContractorProjectNo and it is combobox...

It hard to say since my runtime errors are not consistent. But now I see an error on the desktop runtime machine that I do not see on the laptop development machine using /runtime. I'm going to ask them to reinstall the Access runtime on the desktop machine.

Yes, the reference MOCAllDocsSF!MOCID is to a subform. I have it arranged as a form with some combo boxes for search and some command buttons for opening other forms with related data. This is activated by one of the command buttons cmdJumptoMOC click event, which I guess is probably obvious...

I do appreciate the help. I don't appreciate the tone. I've added a On Error Goto as follows: Private Sub Form_Open(Cancel As Integer) ' If open with an argument then jump to the record. However, turn off add rights On Error GoTo OpenErr If Parent.OpenArgs <> "" Then '...

I've gotten a new error in Access 2010 runtime. I'm trying to convert from Access 2003 to 2010. For Access 2003 everyone has a development copy. In the move to 2010 they decided to save some money and only provide the runtime for most users. I'm keeping the database as an MDB. Perhaps I...