Search results

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

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

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

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

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