Search results

  1. D

    Text Box question

    I have an unbound textbox. Whe the user enters something I want the contents updated without moving awa form the field. That is they enter text and then click a button, at that point the text box still contains null even though there has been data entered. It updates if I tab away from the text...
  2. D

    ODBC Question

    I have inherited a database that has worked fine until now. I have had to change the links to some tables as they have been moved to a new server. The links work fine but the old links had the 'sa' UID inbuilt whereas the now the user has to enter a password all the time. Here are the...
  3. D

    UID in linked table

    Tried that The NT userids do not have the authority and we don't want them to.
  4. D

    UID in linked table

    I have an ODBC that l inherited. It is used to link to SQL tables. When the users use the app they get straight in. We have now replaced our server. I changed the ODBC to look at the new server and re-linked all the tables. However it is now asking for a password when the users first go in...
  5. D

    WebBrowser Control

    I still need an answer for this, sorry for promoting post to top again, really by tomorrow morning UK time. thanks
  6. D

    WebBrowser Control

    READYSTATE_COMPLETE is a special register (not sure if thats the correct name) and gets set once the page has loaded. The If statement does work because I can see the code going thru the loop.
  7. D

    WebBrowser Control

    I have the following code which displays the correct URL, and populates the fields, when going thru in debug mode but loops when running normally. Somehting simple I guess but I cannot see it. Private Sub Command1_Click() Me!WebBrowser0.Navigate "https://www.lexisnexis.com/PowerInvoice"...
  8. D

    Error "Operation must use an updateable query"

    details would be nice if poss, thks
  9. D

    Error "Operation must use an updateable query"

    Thing is, I can run this statement OK ! ALTER TABLE Local_IA_CUR ADD NonBillHrsMktg Numeric
  10. D

    Error "Operation must use an updateable query"

    Iam trying to run the following code. I have administrator rights on the db and for good measure have added my user to have full rights but get the above error. Any other ideas apart from a permissions thing ? Thanks It works when I run it against the same tables on a SQL Server using Query...
  11. D

    Filesize

    Can i obtain the filesize of a file via VBA zt all ? Thanks
  12. D

    Import Access DB into IBM DB2

    I have IBM DB2 Universal Edition V8 and wish to import an Access DB. I cannot seem to find any info on how to do this. Has anybody had any experience of this at all ? Thanks
  13. D

    Upgrading a customer ?

    We have several customers using a system. We have made several changes to tables to improve the functionallity of the system. I am looking for suggestions for the best way / best practice to implement these changes throughout our customer base. I am thinking along the lines of sending a blank...
  14. D

    Viewing vba code

    I want to view the code behind a form.
  15. D

    Viewing vba code

    I believe it is possible with a combination of keys to view the vba code somehow. Is this true. Thanks Dave
  16. D

    Corrupt Database

    would it be worth using serversided cursor as well ? thanks
  17. D

    Corrupt Database

    Help Needed Urgently Please This is what we have VB6 Front End, Access 2000 DB. The VB6 front end uses ADO to access the DB. We have one customer with 13 client PCs, the DB resides on a server. We continue to get a position where the DB cannot be opened because it is corrupt. We have tried to...
  18. D

    Access 97 - 2000 - 2003 Upgrade

    I have an Access DB used by a VB6 Application. The customer intends to upgrade to Office 2003. I have so far upgraded to Access 2000 and re-compiled the VB6 with the DAO 3.6 refernce and everything looks and works fine. I have read of possible problems with DAO / ADO but believe the system is...
  19. D

    Posted this to wrong forum earlier

    I am feeling under the weather today and cannot get my head around this. Access 2000 won't let me import data into an existing table, the option is greyed out. I know it's simple so plse help me. Thank
  20. D

    Very strange happenings

    I support a customer remotely. I have connected to their network, mapped the drives OK. I am adding some vba to a command button. I type it all, save it, go back, check it is as I left it. I disconnect from network. when local users then use the system my changes have not taken affect. Any ideas...
Top Bottom