Search results

Many thanks all for your advice and posts which is much appriciated.

Hi All, I am trying to work out a routine to extract a list of documents (with physical location) and meta data from ZyLab. Does anyone have any experience of this system and albe to advise me on the approach to take. Thanks

I have a colums with many rows of the following type of data: 3MIL001- 3mil I want to split the string at the "-" I am trawling the posts but not finding exactly what I want so any advice most welcome. Thanks

I have a query in my Db which contains a value in a column such as "1234 - ABC Company Limited" In my query I have two expressions using the Mid function to create separate columns to give 1234 and in another column ABC Company Limited I then want in my column with the 1234 to use...

so what was the answer???

Hi All, I am usiung the following code which is correctly running through a query and outputting PDF files. However, its not quite right. The query behind the report contains 194 lines and raltes to call records. I want to output 194 pdf files with each pdf the report just for the related row...

Hi All, I am using the following code to execute a batch file. The batch file runs a SQL script which in turn produces a CSV file. My batch file runs but doesnt produce the CSV file. The batch file works if triggered manually. Any help much appriciated. Dim wshThisShell As WshShell Dim...

Hi Bob and many thanks for your reply and guidance. Yes, there are two functions. One medium and one critical. They relate to amounts of data used (taken from an external MySQL billing system) compared to bandwidth allowance. The two functions are based on their own query so both do need to...

and yes i have spotted the intMediumCount error.. ;-)

I'm using the follow piece of code but I'm getting a resume error. I think the code is self explanatory but want to find the correct way to get the code to go to the next routine when it detects 0 Dim intCriticalCount As Integer intCriticalCount = DCount("PrimaryDataID"...

Thanks P, That was option I was also considering but not favouring. As the application is essentally providing a monitoring I think I may put in a number of monitorng wanrings which can be sent out before it needs to be manually reset.

Hi All, I have created a module which runs a query and sends out emails. I would like to be able to specify a time that the module runs but think there may be limitations using the OnTimer event. Any thoughts/advice? Thanks

That did it! Thanks

Hi, I am not sure if that helps. Basically I am developing a query which (based on an if) will only run on a specific day of the week. So, I need to identify in a query what day it is "today"

Does anyone know how to find out what day of the week it is using VBA? Thanks

Hi all, I'm getting a type mismatch error on the following DLookup syntax. strMonthlyTransferLimit = DLookup("Value", "radreply", "UserName =" & Me.txtUserName And "[Attribute] =" & "Monthly-Transfer-Limit") Any ideas? Thanks

Thanks Drake, One question though wont that create an entry - as in enter a zero? I'm basically wanting to say if a field is blank dont then ignore it. I'm trying with the following (non-working as yet) code If Not IsNull(Forms!FrmPrimaryData.txtEndUserContact) Then Dim...

Hi all, I'm using the following code and attempting to handle null but keep getting the afrementioned error?? Dim intAgentContactID As Integer intAgentContactID = Nz(Forms!FrmPrimaryData.txtAgentContact.Column(0), "")

Is there a way to make DateValue display 6 March 2006 instead of 6/3/2006 Thanks

GOT IT !! DocDateVal: IIf([DocumentDate] Is Not Null,DateValue(Left([DocumentDate],10)),"")