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!

  • Congratulations gmmastros 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: *

  • Users: GBall
  • Order by date
  1. GBall

    Problem running a batch process

    Spot-on Aceman - thanks. Regards, Graham
  2. GBall

    Problem running a batch process

    ...As String strSchoolname = Left(Trim(rstcontrol!Name), 80) strSchoolnameSrch = SF_replaceAllOnce(strSchoolname, "'", "''") strSql = "select * from t_party@exii where lower(party_name) = '" & LCase(strSchoolnameSrch) & "'" Dim adoRS1 As New ADODB.Recordset With adoRS1...
  3. GBall

    Problem running a batch process

    Private Sub btnUpdate_Click() On Error GoTo Err_btnUpdate_Click Call Update_Schools_Database Exit_btnUpdate_Click: Exit Sub Err_btnUpdate_Click: MsgBox Err.Description Resume Exit_btnUpdate_Click End Sub Regards, Graham
  4. GBall

    Problem running a batch process

    Hi, I've got a form with one button and a label on it. The click event of the button starts an import process in a module and the label gets updated with the records processed. Problem is that when I click the button a maximised Access window appears with nothing in it (it's just white), I lose...
  5. GBall

    OX choices menu problem

    Thanks for the help. I couldn't see how to get round it - there was only one entry in the boot ini and only one partition. I had this idea that if I renamed the boot.ini, that MS would create a new one (this was after a couple of glasses of wine!). Big mistake - couldn't get into windows. Tried...
  6. GBall

    OX choices menu problem

    Hi, after an aborted upgrade to repair my installation, I now get the os choices menu displayed every time I boot up. One is my current opeating system, the other is 'Windows default'. I've been into boot.ini to get rid of the windows default, which doesn't work, but there is only 1 entry in...
  7. GBall

    Using a profile value in a database update

    Hi, I've got a formview on a page and the sql was generated automatically when I configured the datasource. What I want to do now is change one of the fields to pick up a value from a profile I've set up in web.config. It happens to be a unique userid, so that I can see who last updated the...
  8. GBall

    Delet query based on values in another table ?

    Yes, that was the sql I used. However, if the linked table is shown in the design pane, it comes up with that error message. Remove the table and paste that code back in and it works. I guess that somewhere there is some smallprint that shows how it should be done, but the error message could...
  9. GBall

    Delet query based on values in another table ?

    No, it's not linked. I think I may have stumbled on the answer though. I created a new query and typed some sql in from scratch and it worked. I went to design view and the new Access table with the keys of the records that I wanted to delete from p60_payment_detail didn't show. It would...
  10. GBall

    Delet query based on values in another table ?

    This is crazy. I've seen examples of this done on the net ! I've now created a table of the items to be deleted, created a delete query with a join to it and I still get the error message. There must be something very basic wrong here. Regards, Graham
  11. GBall

    Delet query based on values in another table ?

    Well, I've just tried something similar. I created a select query for the records that I wanted to delete, then created a delete query with a straight join from p60_payment_detail to the new query. Still get the same error. I pasted your query in and ran it, but after watching the hourglass for...
  12. GBall

    Delet query based on values in another table ?

    Well yes, that's what I thought. The designer, for some reason, created the first line as delete a.*, b.type and when I tried to run it I got the error message "Cannot delete from the specified tables". Thinking that it wanted to delete from the lookup table, which is a read-only link, I...
  13. GBall

    Delet query based on values in another table ?

    Hi, this is very simple in Oracle, but I can't see a way to do it in Access. Basically what I want to do is: delete from a where a.key = b.key and b.type not in (1,2,3). Am I missing something ? Regards, Graham
  14. GBall

    Recovering Word file

    Thanks. The recover text from any file option did work, but it seemed to have everything that had been typed before the system went down - corrections, backspaces, everything ! But at least the text was there and we finally made sense of it, although it may have been quicker to start again. B-(...
  15. GBall

    Recovering Word file

    Hi, last night I created a large Word document, when we had a power cut - I hadn't saved the document. I assumed when I next opened Word, it would pick up the file I had been working on from the temporary file it created (it is nearly 2005 after all). Anyway, I found the temporary file this...
  16. GBall

    Info 7 to Business Objects ?

    >>Not sure what "I didn't realise it had gone through Crystal as well. " means. Oh, so Seagate and Crystal were the same company - didn't know that either. Thanks. Regards, Graham
  17. GBall

    Info 7 to Business Objects ?

    Thanks. I didn't realise it had gone through Crystal as well. Regards, Graham
  18. GBall

    Info 7 to Business Objects ?

    Hi, we have Business objects here and have just taken on another business that uses info 7 for its reporting. We want to streamline things and get all our reporting under one app - Business objects. Also, no-one here knows Info 7 and we need to change a couple of regulatory reports. I've just...
  19. GBall

    Generically referencing form fileds

    Well something is weird here. I imported the proc I tried in 2K, set it to run from a button and it ran OK. I amended it to set a variable for the field name and it still worked. I changed my procedure to be the same as the one I imported and still it didn't work - it's running on a mouseover...
  20. GBall

    Generically referencing form fileds

    Yes, I know B-( But it's all I have to work with to get a scrolling text box. The idea is to simulate what would be seen on another screen in full size and is only to give an idea of what the end product would look like to the user. So, they do not need to see the actual content. I don't...

Part and Inventory Search

Back
Top