Recent content by OnMyBike

Hi I am passing an array to a function but sometimes the array has not got any elements. So... How can I either create an empty array that I can determine in the function OR make the array an optional parameter (I can do that bot) and then test to see if it has been passed to the function...

The comma's can be anywhere as they are in just normal email type text. Using the code that you pointed me to I just treat the contents of the text file as one long character string. It works fine.

Thanks jdraw Whilst your contribution solves my problem it does not explain why the UNPUT function is doing funny things. I can move forward now and finish the project. I'm creating a automated email system whereby I take prepared text from text files and replace what amount to merge fields...

Hi I am reading a text file line by line into an array and despite the help stating this: "The Line Input # statement reads from a file one character at a time until it encounters a carriage return (Chr(13)) or carriage returnlinefeed (Chr(13) + Chr(10)) sequence. Carriage returnlinefeed...

Thanks for responding. I gave that a go and it does not make a difference. I've had this problem years ago and can't remember the cure. Irrespective of what height I set the detail section, the space at the bottom is the same.

Hi. I have a a smple Tabular form with buttons in the footer. There is an element of white space between the bottom of the last record and the start of the footer. I remove the footer and the problem still exists. Does anybody know how to get rid of this? It just looks bad but does not...

Hi Thanks for responding. I am sure that there are more enjoyanle things to do in your neck of the woods but you are on here today and that is appreciated. No blank records. Not sure about page feed, enlighten me but I dont't think that I am as the spaces are after the first group and...

Evening all. I am plagued by white space or a number of blank lines appearing in my reports. All is fine in Report View but Print Preview is affected. I want to export to pdf and the problem still persists. I know that others have had this problem but none of the suggestions have helped me...

I am importing csv files into tables in a batch routine and I get the following error messages. The error number is always 2391. Field 'F1' Doesn't Exist in Destination Table Field 'F4' Doesn't Exist in Destination Table Field 'F36' Doesn't Exist in Destination Table I understand the first one...

I am led to believe that one needs to use a piece of third party software to retrieve a Workgroup Password. If this is the case then can someone please suggest which software is legitimate as I have been onto one apparently legitimate site only for it to be blocked. If finding out the...

I have a 2003 .mdb file and the associated Workgroup Information File which normaly resides on a network in a folder V:\V-Base-Database\DATA\. I have the Workgroup Information File. The database is unsupported and we need to migrate the data to a new web based database. When I try to open the...

The windows 7 default text size had been increased to medium (125%) instead of 100%. Changing it to 100 has sorted the problem out. Thanks

Please see attached. I have blotted out some personal details. Close button had to be moved to close the form. Thanks

I have developed a database with a number of forms on a laptop with a screen resolution of 1366 * 768. I did some modifications to the database using a larger external monitor but when I came back to view it on the 1366 * 768 monitor one of the forms overlaps the bottom of the screen. Does...

I have a button on a form that changes the DataEntry property to True to enable a new record to be created. I have a Save button which has the following code: RunCommand acCmdSaveRecord Me.DataEntry = False The Me.DataEntry = False code causes Access to restart. Any ideas anybody...