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

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

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

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

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

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

I have a small application that sends an email every 5 mins. The app is currently a form, when I open the form the timer event starts and scans a folder and sends an email with an attachment if a file is present. I want the application to hide in the background and moreover to start if the...

Hi, I am running this query below in VBA. It is a long query I know and not pleasing to look at, however, I get the following run time error - 2342 "A runSQL action requires an argument consisting of an sql statement." Could anybody help with what is wrong with the query? Thanks in advance...

I want to ping a folder every 5 mins to see if a file exists, if a file has been dropped in a folder I want to email the file automatically. I have the routine to email an attachment, however, I am not sure how to ping a folder to check if a files exists? Could somebody advise on how this can...

I want to automatically send an email with an attachment at certain time of the day. I want the app to sit on the server and if I file is dropped in a folder I want that file to be attached to an email and sent. Currently, the search is down here, has anybody got any similar code available for...

I am creating a String in VBA for a SQLquery. Does anybody know the maximum length of characters I can use to create a string? I do not want to call the query iteself since I am parsing parameter values into the query. Thanks in advance.

I want to write some data to excel worksheet using appXL.ActiveSheet.Range("A" & intStart).CopyFromRecordset rst However, I get a run time error 430 Class does not support automation or does not support expected interface. Could somebody advise how to fix this? Thanks in advance.

I have DTS package that calls a Macro detailed below. ----------------------------------------- 'File Constants Global Const ReportName = "AM_AC1_pdf" Global Const ReportInputPath = "d:\gains\erm\mayne\reports\input" Global Const ReportOutputPath = "e:\reports\PLANNER_AC1" Global Const...

Hi How do I return results of a query to a form? Ideally, I would like the user to be able to choose which query to run through a Combo Box first and then show the results of a query shown in the form. The difference in the query will only be in the filtering and the same fields will always...