Search results for query: *

Spot-on Aceman - thanks. Regards, Graham

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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