Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RaineSpencer

    delete on linked table failed

    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.
  2. RaineSpencer

    delete on linked table failed

    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...
  3. RaineSpencer

    https and smartnav

    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...
  4. RaineSpencer

    webresource.axd problem

    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??
  5. RaineSpencer

    populate a web form from access

    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...
  6. RaineSpencer

    extra empty pages added when macro executes

    ...Selection.GoTo What:=wdGoToLine, Which:=wdGoToAbsolute, Count:=1 With Selection.Find .Text = "U:\\data*" .Execute MatchWildcards:=True, Forward:=True, Wrap:=wdFindStop If .Found = True Then Selection.Extend Selection.Extend...
  7. RaineSpencer

    extra empty pages added when macro executes

    ...2 blank pages at the end of each split doc, and so on. I can't see why it is adding the blank pages. Can anybody see the problem??? TIA -- Raine ****************************************************** Sub SplitApart() Dim x As Long Dim sections As Long Dim doc As Document...
  8. RaineSpencer

    populate a web based form with data from an access form

    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...
  9. RaineSpencer

    send XML request from form and retrieve XML response

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

    send XML request from form and retrieve XML response

    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...
  11. RaineSpencer

    Send button does not work when using SendObject in Access

    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.
  12. RaineSpencer

    SQL server does not exist or access denied

    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
  13. RaineSpencer

    howto...subform vs form events

    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)...
  14. RaineSpencer

    howto...subform vs form events

    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...
  15. RaineSpencer

    howto...subform vs form events

    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....)...
  16. RaineSpencer

    howto...subform vs form events

    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...
  17. RaineSpencer

    limit to number of reports in a ACC2000 database

    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...
  18. RaineSpencer

    limit to number of reports in a ACC2000 database

    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...
  19. RaineSpencer

    limit to number of reports in a ACC2000 database

    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...
  20. RaineSpencer

    limit to number of reports in a ACC2000 database

    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

Part and Inventory Search

Back
Top