Recent content by Davef28

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

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

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

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

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

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.

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"...

details would be nice if poss, thks

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

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

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

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

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

I want to view the code behind a form.

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