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 derfloh 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: MikeAuz1979
  • Order by date
  1. MikeAuz1979

    Send Mail if table is empty

    Hi, I have a data flow task that truncates and appends to a table. The thing is that if this table has any results then these need to be investigated so after the data flow task I'd like a task that checks to see if the row count of the table is > 0 and if so sends an email. Also I have a few...
  2. MikeAuz1979

    Parameters in Oracle Open Query

    Thanks E, I took what you said, did some looking up and some guessing an came up with the following which works well for me. declare @SDate datetime set @SDate = '2008-04-01T00:00:00' declare @EDate datetime set @EDate = '2008-04-09T00:00:00' declare @SQLString...
  3. MikeAuz1979

    Parameters in Oracle Open Query

    Hi, Using SQL Server 2005 I'm trying to run an openquery statement that pulls data from an Oracle DB but with some date parameters and I'm getting a syntax error {Code Below}. I would just use an oracle linked server using a T-sql statement but I'm getting errors with datetimes converting into...
  4. MikeAuz1979

    Non Absolute references problem with items selected in a listbox

    Remou, works perfectly and saved me hours of staring at a screen, love your work. Mike
  5. MikeAuz1979

    Non Absolute references problem with items selected in a listbox

    Hi, Using access 2000 I have 2 list boxes that are supposed to perform the same action so I moved the code out to a module so I didn't have to repeat code, but I'm having trouble with that. Below is my code which works fine when the listbox name is hardcoded into the for each line but I get an...
  6. MikeAuz1979

    ADO recordset to populate excel combo

    Hi, Using acess and excel 2002, I have the below access vba that pulls data from local access tables and then adds the items to combo box on the excel sheet. (Connection lines omitted.) This works brillantly a populates the excel combo with all the data, until you save and close the excel file...
  7. MikeAuz1979

    ADO Recordset into local access table, null problem

    Hi, Using acess 2002 I'm sucessfully running an ado recordset and inserting it into a local access table until the recordset fields have null results. The trouble is that the string that I'm building (sqlIns) converts the nulls to empty strings as such and so I'm getting a syntax error with the...
  8. MikeAuz1979

    HTML field truncating when Parsed

    Great! thanks for the help
  9. MikeAuz1979

    HTML field truncating when Parsed

    Hi, This may be a noob question so pls forgive. Using PHP, Apache and MS_SQL2000 I have a page that has a text box, a select box and a submit button, this posts to another php file that then does a search using these parameters, the problem is that the select box's values have gaps and this...
  10. MikeAuz1979

    Simple ADO scrolling recordset from MSSQL

    Hey, Thanks for answering, I'm not sure about your first point but your second point was spot on. had an error in the adodb file adodb-lib.inc.php line 426. I then went googling and found that this line is most likely incorrect and can be fixed by replacing $rewritesql with $sql. Thanks Mate
  11. MikeAuz1979

    ADO Recordset with X out of X records statement

    Ah! good point thanks mate, well worth a star.
  12. MikeAuz1979

    ADO Recordset with X out of X records statement

    Hi, Using PHP,Apache and MS-SQL2000 I'm trying to get the required sql output and a counter at the top that says something like '100 out of 15000 records returned' I have the below code thanks to http://phplens.com and a bit of legwork but when I run this I get the result 100 out of 1 records...
  13. MikeAuz1979

    Simple ADO scrolling recordset from MSSQL

    Hi, Using PHP, Apache and a ms sql 2000 db I'm trying to recreate the simple scrolling through a recordset process as depicted on http://phplens.com/adodb/tutorial.implementing.scrolling.with.next.and.previous.html I get everything except for the scroll links and I'm wondering if this method...
  14. MikeAuz1979

    Top N records for each X

    Santa thats great and I'm sure it would work fine if we were using a current version of Oracle, I think the trouble I'm having is that were using an older version that doesn't support the rank function. You've already been heaps of help but would you have an idea how to do this in older oracle...
  15. MikeAuz1979

    Top N records for each X

    Hi, Using an access pass through query to oracle (Native oracle pl sql) I'm trying to return the 2 most recent records (Max PRICE_EFFECTIVE_DATES) for each contract. (SUBCONTRACT is the field in my code.) So the result I'm after is like: SUBCONTRACT P_E_DATE P_P_B 1...
  16. MikeAuz1979

    Multiple pass through queries to same db but different schema Problem

    Hi, [Originally posted in Access queries but reposted here in case there's a VBA solution] Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login...
  17. MikeAuz1979

    Multiple pass through queries to same db but different schema Problem

    Hi, Using access 97 and connecting to Oracle I have 2 pass through queries that are connecting to the same oracle db but two different schemas in that db. Access to these different schemas is by the login so I have different logins in either pt query which works fine when you run the 1st query...
  18. MikeAuz1979

    Multi Dimensional Array

    Finally Sucess! Thanks for your help Remou, well worth a star. It worked by using a multi-dimensional array and a DAO recordset. Dim RstArray(1, 2) Dim rs As DAO.Recordset Set acapp = CreateObject("Excel.Application") acapp.displayalerts = False acapp.Workbooks.Open ("G:\Bsprice\BA Team...
  19. MikeAuz1979

    Multi Dimensional Array

    Remou, It debug.printed all the table and tab names perfectly so I guess it's some kind of problem with the .copyfromrecordset, I thought maybe it was a timing thing but this error still happens when I step through the code also. Any more ideas? Thanks heaps for your help so far. Mike
  20. MikeAuz1979

    Multi Dimensional Array

    Sure Remou, My code is below and the code is running in access 2k but effectively copy and pastes to excel. Sub test() Dim con As New ADODB.Connection Dim rst As New ADODB.Recordset con.ConnectionString = CurrentProject.Connection con.Open Set rst.ActiveConnection = con Set acapp =...

Part and Inventory Search

Back
Top