Search results

  1. I

    Check Status of Excel Spreadsheet

    Hi I am using code to import data from a Excel Spreadsheet. Is there code that will check to see if the workbook is open or closed! I would like this to happen befor the import process starts. Thanks in advance.
  2. I

    Transfer to excel

    Can you transfer data to excel other than in a column format. I would like to have headings on the top line and also on the left column. Is this possible!
  3. I

    decimal point

    Hi I have data numbers: 1500 60000 8900 How can I put a decimal point two from the right ie: 15.00 600.00 89.00 Thanks.........
  4. I

    Hierarchical Data

    Hi Does anyone have knowledge on how to append data to excel in a hierarchical format. I need to create a file which Actinic Ecommerce can import, unfortunatly a flat file is no good. Can anyone help!
  5. I

    Opposite to Val

    Can anyone tell me what the opposite to the Val function, I only want letters from a string of data!
  6. I

    Data Field Format

    I am linking to a table in Sage then making a table. One of the fields is a number format, how can I change the format to text!
  7. I

    Real Date format

    I am using this code to convert a string date to real date. Dim newDate As String newDate = Left(strDate, 2) & "/" & Mid(strDate, 4, 2) & "/" & Right(strDate, 4) ConvertDate = newDate The problem is that if the format of the date is not like dd/mm/yyyy (10/10/2005) the code errors...
  8. I

    Start of month

    Hi This is probally really easy........ I have data with dates like 15/05/2005, 30/09/2005. I need to convert the dates to 01/05/2005 and 01/09/2005 Can anyone help!
  9. I

    Specail Characters

    Hi I have data which has & ' with-in the data. How can I remove these! Thanks in advance.
  10. I

    Call fOSUserName()

    Thanks.......... Thats not really the issue. It appears that when access is used on this specific machine the vba code is not always recognised, as though a setting has been changed on this machine!!
  11. I

    Call fOSUserName()

    I have successfully been using fOSUserName() code to identify the network user of the database. We have just had a pc repaired, using this pc to use the database, the code for fOSUserName() will not work! In fact access does not seem to use the call to get the code. Is there a setting...
  12. I

    TransferSpreadsheet

    I am using the DoCmd.TransferSpreadsheet acExport to export data to a Excel spreadsheet. I am getting a error message saying 'Too many fields defined'. Is there a way to overcome this as in help it says that there are more than 255 fields, but there is only 12.
  13. I

    Days in month

    I have a field containing a date ie 25/05/2005. How can I calculate the number of days in the month ie March 2005 = 31 days!
  14. I

    Show record

    I have a query which is showing data below: ComparisonUser DateLogged iant 22/08/2005 16:15:23 siobhanr 11/08/2005 16:52:44 I only want the query to show the record with the oldest date ie 11/08/2005 16:52:44. I have tried 'First' etc. Can any one help!
  15. I

    Spaces in string

    How can I remove the spaces in the example string! HICX108-Standard Top -Vendered Thanks in advance!
  16. I

    Data Format

    I have a string "HICX106-StandardTop-Venderedstest", I only want the first 30 letters or numbers ie "HICX106-StandardTop-Vendereds". Can anyone help, guess this is really easy!!!!!!!!!!
  17. I

    Relationships

    Hi Is there a way to delete then re-instate a relationship using code! Thanks in advance
  18. I

    String

    Split Data I am trying to use this code to identify data from a table like 'M123456~K456789'. Split the string then look for a association in another set of data using each string. Unfortunatly this is not working, can anyone help! Case "BunzlHousekeeping" Set objActivity =...
  19. I

    String

    Hi I have a string which contains M100652-P633230. What I want to do is pick up each set of text ie M100652 then P633230. Can any one help!
  20. I

    Update table

    I have a form which has variables I wish to append to a table. What is the best way to achieve this. Would it be a SQL stsatement or is there another way as there is no reference to table data!
Back
Top Bottom