Search results for query: *

Never mind. I finally found the problem. I have group membership in two different groups (forgot completely about one), and one group had rights and one didn't.

Hi, I have an access 2000 database with SQL 2000 back-end. I cannot delete from one table using Access. I get ODBC- delete on linked table xxx failed [Microsoft][ODBC SQL Server Driver][SQL Server] DELETE permission denied on object xxx, database xxx, owner DBO (#229) I can delete the record...

I inherited a website that I have to modify. I have installed SSL and it is working. I can get a page to display securely, but then I get the 'parts of this page are not secure message', and if you click YES, the lock disappears, indicating the page is no longer served securely (although the URL...

I inherited a website and have to make it 508 compliant. Apparently there is an iframe reference in webresource.axd, but I can't find the file to access it. Where is it stored, or how do you access the .axd file directly??

We have to access a very long web form from our bank that we have to fill out multiple times a day; all the data is duplicated in our access database. I'd like to fill in the web form fields from access via VBA to avoid re-keying data. Is there any way to do this? We don't control the web form...

Got it resolved. The macro adds a section break at the end of each document. A little code change to remove the additional breaks takes care of the issue. I also added code to look for the document name at the end of each document [contains a merge field unique to each person merged] and save...

I am running a nifty word macro, found on this board. If the source merged doc is 1 page per person, the macro adds 1 blank page to each split doc. If the source merged doc is 2 pages per person, the macro adds 2 blank pages at the end of each split doc, and so on. I can't see why it is adding...

My users have to enter data into a secure web form, while they are working in an access database. I'd like to populate part of the secure form with data from the access form that the user is on when they open the web form. We enter some payment info into our access database, then we have to...

I have access 2k, any way to accomplish this with that version? thanks

Hi, Because of CISP, we have to re-vamp our credit card authorization process. I want to have users press a button a form to send form data as an xml request to our payment processor, and then have the form parse the xml response returned. Can this be done with VBA, or do I have to shell out and...

I just had a similar problem and the users who couldn't send the e-mail were missing a service pack for Office. We run Office 2K on Win2K. Once I installed Office Service Pack 3, they were all fine.

Hi, The problem is in your connection string. The server referred to in the connection string is the SQL Server you are trying to connect to. The SQL Server must have the UID as a valid user, with appropriate rights to the database you are trying to access. HTH -- Lorraine

Thanks Gambit. I found the problem. Events weren't being triggered on the subform because I was working on a dummy subform. The 'real' subform was hidden behind the subform I was working on (the original programmers used this to save themselves a few steps, but it caused me a lot of trouble)...

Suave, yes, and much appreciated, but it still doesn't work...The subform, as a form on its own, executes the after update event for the field, just the way I want it to (and the code works). The subform used as a subform does not. I put a debug.print before any real code in the after update...

I want it to update some values in another table, and add a record to yet another table based upon values on the form and the subform...something like this, though form and subform would be changed to the names of the forms, once I know where the code should go (on the form or the subform....)...

Hi -- I have a form with a subform (with linkmaster and linkchild set up). I want some code to run when data in a particular control on the subform is changed. I have tried placing the code in the subform's before update event, but it never runs when the form is being used as a subform (it does...

Having done further testing, the problem appears not to be a "report" issue, but a VBA issue. I have been modifying an off-the-shelf registration database product. I had been asked to make my modifications fit the existing structures/naming conventions as much as possible. The original...

I wrote code that wrote all my report names to a table, then wrote code that pulled the report names from the table and did a transferdatabase acexport for each report name to a new .mdb that I created manually. I had 379 reports to transfer. The new .mdb appeared to have all 379 objects after...

Michael, I can see the reports in the db window. I can open them in design view, I can run them, etc. What I cannot do is save changes made to them, and I cannot get to the vba code for the report (mostly simple code to produce "no data in report" messages to users). If I CTRL-C on a...

Michael, Thanks for the suggestion. I gave it a try, and it doesn't improve my mystery reports. BTW, the objects aren't hidden. They are also not in a referenced db. Is there any restriction on the length of the object name either in VBA or in ACC2000? Lorraine