Search results

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

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

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 believe it is possible with a combination of keys to view the vba code somehow. Is this true. Thanks Dave

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

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

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

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

Is anybody aware of an ODBC available that links to SAP ?

Further to another question that I have had a great reply from pcs, is it possible to do a transfer delimited but append records to the file ?

Is it possible to use some vba code to test if a file is present in a specific directory. I am trying to append using TransferText but I do not think I can do it, therefore I need an alternative way, which I have if I can get a solution to this Question. Thanks Dave

I have the following code on one form; Dim stDocName As String Dim stLinkCriteria As String stDocName = "Order Review" Dim Formloaded As String Dim strform As String strform = "Logon BH" Formloaded = fIsLoaded(strform) If Formloaded = -1 Then...

I have a continuous form which has the following fields Qty, Price, Ext Price When a Qty is entered and the Enter key is pressed Ext Price is calculated Qty * Price fine. I also have a running total in the header section =sum(ExtPrice). This works fine until the last record on the form, when I...

I have all my forms maximised. When I try and do a report in preview it is hidden behind my forms. What can I do to make them appear. Thanks

I have a continuous form and I want to change the attributes of one filed dependant on another. If I put some code in Form_load it affects the whole form not just each record. How can I do it per record. Thanks