Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

Hi, Using access 2000 I'm kinda stumped on how to restrict daily information to just last financial years data. (Assuming an Australian fin year of 1-July to 30-Jun) My table looks like: Date Site Amount 01-jan-00 1 1001 02-jan-00 1 987 01-jan-00 2 7899 etc...

Hi Using Access 2000 and excel 2003 I'm trying to write a sub that will basically copy and paste data from three access tables to three different excel tabs on a excel template. (Range A2 on all 3 tabs) So the below is as far as I have got and I get the error 'Can't assign to array' on the...

Hi, Using Access 2000 I'm using CDO to send emails to internal staff via their payroll number. (Our outlook is configured so you can send emails using payroll number.) This all works fine but the system that I'm pulling the payroll number from is truncating the 6 digit number to 4 digits (As...

Hi using access 2000 and xl2000 I have an access db that runs some ADO code and then dumps the results to xl. As an extra help to the user I want to apply some conditional formatting. The con formatting code works fine in xl but has the error invalid procedure call or arguement in access...

Hey Y'all, Using access 2000 I have a macro that installs the analysis toolpak (which is needed for some xl sheet calcs) [the code is below] and I thought it worked fine until I tried this code on a PC that had only just had office 2000 installed and found that this code appears to only swicth...

Hi, Using a userform in excel 2000, I want to check that the mandatory fields (With a Tag property of 'Pg1') are not blank/empty before proceding. The code I'm using is below and all works well except for ctrl.text = "", any ideas how to check if the controls text is empty or not? Thanks for...

Hi, Using access 2000 and outlook 2003 I'm using the below code to send emails from an outlook group mailbox(all good) The problem with this is the sent email is still in my email box and any undelivereds return to me also. Does anyone have any idea how I can get emails to send from the group...

Hi, Using Access 2000 and Outlook 2003 I'm automatically sending emails using the below code which sets the reply to address if the recipient replies to the email. This works fine but what I'm finding is some unhelpful recipients are replying to the email and replacing the correct reply...

Hey all, I have a report which is an excel 2000 pivot table sourcing data from an MS Access 2000 which is fine until a guy with excel 97 tries to open it and the pivot table doesn't refresh. So I'm thinking that I could email a snapshot to the 97 guy when the access database import runs which...