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!

Register Log in
  • Congratulations Rhinorhino 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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...
  7. GBall

    Generically referencing form fileds

    Hi, I have to process a number of controls and I want to have the code defined just once. So I have this piece of code. Problem is, I get 'invalid use of null on the 'Len' statement. If I replace it with say 50, the code works fine. I tried this out in access 2000 using len(me!text0) (text0...
  8. GBall

    Unexpected result from SQL wildcard Select

    Hi, can anyone tell me why this select SELECT TABLE_NAME FROM user_tables where table_name like 'P_%' returns PLAN_TABLE Regards, Graham
  9. GBall

    Refreshing combobox data

    Hi, I've tried cboBlah.Refresh() and cboBlah.Update(), but the list is not updated when I add a new item to the datasource to which it is bound. The cbo gives me a list of oracle tables within a schema and the form adds a new table dynamically. I just want to see the new table in the drop-down...
  10. GBall

    Problem updating Oracle from Excel VBA

    Hi, I'm updating a table from a spreadsheet and it all works fine except that one field is playing up. The destination column is varchar2(500) and I'm picking up the contents of a column which holds freeform notes. For some reason after running the procedure, the notes field(Oracle) just...
  11. GBall

    OO40 Problem using excel vba

    Hi, can anyone tell me what is wrong with this code, as I get an error on the oradatabase.execute statement that informs me that 'Object does not support this property or method' thanks. Private Sub Zeroise_Amount_Fields() Dim strSql As String Dim strDB As String Dim...
  12. GBall

    Stopping a Word process cleanly

    Hi, I have an application which creates a quote in a word document and displays it to the screen. The user has the option to go back to the application and enter another quote while Word is still open. This resulted in an error that c# could not create the quote document as it was already open...
  13. GBall

    Sequence values (Max & Min)

    Hi, I need to get the max and min values of a sequence. We have manually used different ranges for various areas of an application and I need to get all records that have been added automatically. Anyone any idea how I can do this ? I'm using oracle Inprocserver within VBA. thanks, Graham...
  14. GBall

    Excel combobox problem

    Hi, I'm tryinmg to populate a combobox I've created in a worksheet with the following code. i = 0 Do While Not x.EOF Sheet2.ComboBox3.Column(i, 0) = x!type_id Sheet2.ComboBox3.Column(i, 1) = x!type_name Sheet2.ComboBox3.Column(i, 2) = x!type_desc i = i +...
  15. GBall

    Can't get a tab character

    Hi, I'm trying to output a tab separeted piece of data like so. Dim strSeparator As String strSeparator = Chr$(9) strCSV = strCSV & """" & Me(i).Value & """" & strSeparator but all I'm getting is 4 spaces and a carriage control, linefeed. Even if I...
  16. GBall

    Browser Control interaction

    Hi, if I put a browser control on a form to point to an existing form on a web site, is there anyway that I can retrieve the information entered into the browser, so that I can keep a local record of what has been entered ? thanks. Regards, Graham
  17. GBall

    Why doesn't my scrollwheel work in VBA code windows ?

    TIA Regards, Graham
  18. GBall

    IE6 Address history lost on restart

    Hi, since upgrading from 5.5 to 6.0 using a cover CD, my address history dropdown gets reset every time I restart the computer. I've tried clearing the history and changing the number of days to keep it (various values 0 to 21), but to no avail. The history folder is fine. It's just the dropdown...
  19. GBall

    Maskedbox - error 308 invalid property value

    Hi I'm using VB6 SP5 and I am getting this error when I try to populate the masked edit box with a value. According to MSKB, this was a known problem in VB4, but has been fixed. The daft thing is that it was working fine under VB6/SP5 a few months ago, but the .exe stopped working properly when...
  20. GBall

    I want to generate a stylesheet from several stylesheets

    I know I could import or include, but it's more complicated than that. The resultant stylsheet is stored (and run from ) a field in a database table so import/include won't work. So what I will have is a collection of code snippets that I want to combine in various ways to create a stylesheet...
    • GBall
    • Thread
    • Replies: 0
    • Forum: XML

Part and Inventory Search

Back
Top