Search results

Hi Normaly it would be after the 4th number ie. PO12 4PR.

I have data which has a post code field. Some of the post codes do not have a space where they should ie. AB123CD instead of AB12 3CD. Is there code which I could run to update this to the correct format! Thanks in advance!

Hi The string works ok when the value is =<1440, above this the value returned is ie 31/12/1899 04:00:00.

Hi Is it possible to convert 2220 to time ie 37:00:00! The code below converts upto 24:00 but after this it shows a date! =TimeSerial(Int([MyTime]/60), [MyTime] Mod 60, 0) Thanks in advance..............

Hi By using a combo, is it possible to select the page on a tab control!

Is it possible to convert a number ie 330 to a time varaible 05:30:00. Thanks in advance

I have set a user and group account for myself, but I have made a error some where, I now cannot get into the data base as the password I am trying to use is incorrect. Is there any way of de-activating the password etc.............. Thanks in advance

Hi I am trying to link VB6 to Access 2000. I have been able to link a ADO Data Control to the data base with success, but when I try and attach a DataGrid to the ADO a Syntex error message is shown. I have updated the service pack to 5 still without success. Can anyone help me!!!!!

Hi I need to take a date, and show all data from this date a year ago. IE Date RollingYearDate 16/12/02 16/12/01 17/12/02 17/12/01 Can any one help!! Thanks in advance

Does any no how you can drag and drop from a list box to another list box! Thanks in advance...

Hi I have a field which contains data seperated by a space. I.e. StockRefField CT012 Freepost Envelope What I want to do is seperate the CT012 from FreePost Envelope into different fields. I.e StockCode Desc CT012...

How can I sort information held in a subform by date. My date format is 07-Nov-02.

Hi Does anyone no how to identify the Fridays date from a inputted date. i.e DateSorted FridayDate 21-Oct-02 25-Oct-02 23-Oct-02 25-Oct-02 Thanks in...

Hi Does anyone no how you can link the data you record in a inputbox to all field on a report. ie When the report opens the inputbox ask for a number, you input number then the report opens with the number inserted into a field.

I have data which I update any changes. The data contains 'Date of change'. In a query I want to show only the latest change not any previous changes. Can anyone help!! I have tried Max([DateOfChange]) This still shows all data.

I am trying to convert a access 97 db to 2000. When I try to do this, during the process I get a message 'The Visual Basic for applications project in the data base is currupt', then after clicking OK, a messsge appears 'File not found'. Can anyone advise me why this is happening, and how to...

I am trying to import a table from an existing access data base. The table has the auto number set which currently runs from 1 to 926. But when I have imported this table the auto number, when entering a new record jumps to 1852 (Double the records), not 927! Can anyone advise me why this is...

I have a Yes/No box in my report. I want to split he data into yes and no, calculate data in a summary at the end of the report. I have used a text box and tried: iif( [Yes/no box] = true,=sum([data])) This only shows one of the records not the total!

I have a form which contains a subform. With in the subform there are sets of records which I want to calculate a grand total in the main form in a textbox. I have tried using a textbox on the main form, then using a expression with out success. Can anyone help!!

I have two dates linked to a record. I want a query to select the newest date. ie............06-06-02 10-06-02 Result of query 10-06-02 Can anyone help!