Search results for query: *

I have a simple query that checks to see if there are any invalid values within a table. If there are invalid values it writes the results to a BAD file. However, I want the BAD file to be 0kb if there are no invalid records. I have used the SET NORCOUNT ON command in my query i.e isql -Usa...

Thank you!

I want to declare a global variable that will be used throughout my code. So when the main form loads for the first time I want the variable PASS = 0 When any function is called in the program I want to set PASS = 1, however, I dont know how to define a global vairbale in Access, could anybody...

Mucha clearer! Many thanks for your response it is appreciated, i forgot to say I am using Access 97, anyway, My code now looks like this: Runsql = " SELECT r4.[RULE ID]" Runsql = Runsql & " , r4.BRANCH" Runsql = Runsql & " , r4.DESCRIPTION" Runsql = Runsql & " ...

I receive a RunTime 3296 - Join Expression Not Supported error when I try to run this query through VBA. However, I cannot figure out why. Any ideas? 'RunSQL = " SELECT Sm_price_rule4![RULE ID], Sm_price_rule4!BRANCH, Sm_price_rule4!DESCRIPTION, " 'RunSQL = RunSQL & " CusGroup!GroupDescription...

I have noticed that I can run a query in SQL server and it pulls out records that are = 0 but have been qualified in my SQL statement as TEXT i.e = '0' eg. Select * from Rep_Sum where trackingNumber ='0' TrackingNumber is a numeric field However, in MS Access I get a data type mismatch error...

Hi Pat I am not quite with it on this yet. I want to load the application onto a server (1), this will not be the mail server(2). I dont think I will be able to use the SMTP method since systems will not provide me with a password to login to the mail server, OR could they give me a user...

OK. Thanks! I found this site to download a SMTP COM component! http://www.ostrosoft.com/smtp_component.asp Marvellous! Thank you.

No definitely not online, however, it had something to do with the email address in single quotes, the email went into the Outbox, then a few minutes later was in the sent folder. I never received the email! Anyway, I fixed it by using ".resolve" Thanks!

There is no reason why I am using MAPI. Do you know any good places for me to find how to use SMTP? I suspect my code will fail when I install it on the server, it is currently running fine on my laptop but that has Outlook installed. I want to avoid having to install Outlook on the server so...

I have an app in VB that sends emails and want to install on the server on a network. The server does not have Outlook installed and I am creating a MAPI session using ProfileName:=MS Exchange Settings Is there any software I need to load onto the server for my app to work? Any help with what...

Many thanks for your response! No I don't objmessage.recipients.resolve - is the syntax?

Before I re-install, I have migrated the scripts etc., to a test server. I want the test server to point to the LIVE data set so that we can still run some reports. I have mapped the drive of where the catalog sits of the LIVE dataset so my mapping is to H: drive - "\\servername\gains" Now, I...

I have created an app in VB to send emails automatically. The email appears in my OutBox for a few minutes then disappears, I look in my sent items and the email has moved to this folder but I am not on-line!! How can this happen? Thanks in advance

I have some code to send emails automatically. The recipients are added by objmessage.recipients.add("Test0@Test.com") objmessage.recipients.add("Test1@Test.com") objmessage.recipients.add("Test2@Test.com") However, the email that has been created in Outlook has single quotes around the send...

I have found this code from thread796-317791. I want a similar application that checks a folder for a file every few minutes then emails the files as an attachment. I am new to .net and want to modify this code to achieve the above. I have pasted the code but get the following error...

Thanks all. griffindm , I have tried CreateObject("CognosImpromptu.Application") (see very top of this thread) however the same thing happens, However, I will update the scripts to reflect the change you described. drlex, Cognos Configuration has been applied, I am migrating all the scripts to...

Thanks guys for all your help. JerryKlmns I did put your code in and re-ran the code, however, EXCEL.exe was still open in Task Manager, however, the clean up code you provided is much better I then combined user PHV code and re-ran my application and Excel.exe closed!! Marvellous! Thanks...

Thanks Nick, for your contribution. You know, I have not used Access at all since I came here and I have to say these forums have been fantastic and especially the people like you who help people like me out. Thanks again!! LOL

I am having trouble closing excel from VBA, there have been numerous threads on this subject but I still cant get my code to remove excel.exe Any ideas on how I can modify my code to remove Excel from Task Manager? My code is below: Thanks in advance! Public Function ExportRequest() As String...