Search results

  1. I

    Output to Excel 2003

    Hi I use this VBA "DoCmd.OutputTo acOutputQuery, "qry_total", acFormatXLS, "C:\Apteka\Total.xls", False and it seems that Excel file is written with BIFF5 format, but I need to be written in BIFF8 format..What is the difference and how to do it Thanks
  2. I

    adding blank lines in a report

    I am preparing a report with two or three or more lines but always there must be 10 lines ..which means adding some blank lines up to ten Can you help me how to do it Thanks
  3. I

    Import XML

    Hi From this address http://www.fzo.org.mk/?section=lekaripzz I need to Import XML file into a table. I want to do it from my access application. On the site there is Export to XML. Thanks
  4. I

    27 char string long adding space after

    Thanks Michael Lueck this is it...
  5. I

    27 char string long adding space after

    Well this is my plain English...From recordset I have to create a text file that is use in another application. The rule for crating this text file is described by the manual and I can send a copy of this file created with Clipper. See attach and spaces in the line.. Thanks
  6. I

    27 char string long adding space after

    Hi I need to use Format functon in VBA code...So this is my problem. I have a string with variable length...I need to get a string which is 27 char long adding space after ..ie "rade ivanoski ", "peter white " and so on I tried to use this Format(name,space(27))...
  7. I

    increase field size from 10 to 50

    Hi How to increase field size in a certain table from 10 to 50 from Database (programaticaly) Thanks
  8. I

    form and subform

    Is it possible to link two Master fields in Main form with two Child fields in subform and how to do it. One of the Master fields contains only three letters and Child field should give Left([Childfield];3) & "*" Can anybody help Thanks
  9. I

    Navigation form

    thenks for your effort but there is no error number..I cannot see it..this message shows only in ACCDE file format , not in others
  10. I

    Navigation form

    I use navigation form and compiled ACCDE file..When I click on a navigation button I get this message: Requested type library or wizard is not a VBA projet..When I click Ok it goes on and open another form... I dont want this message to show...What should I do? Thanks
  11. I

    Dos BAT file from Access

    Thanks a lot
  12. I

    Dos BAT file from Access

    Hi How can I run a Dos BAT file from Access? Thanks
  13. I

    delete key

    well..it is ok with key preview set yes Thanks..and have a nice day
  14. I

    delete key

    Thanks jkl0 for your effort to answer my quastion..The point is the user must use a command button to delete a record becouse there are still some other comands to do with VBA, but not to delete with Del or Delete key becouse this key is deleteing only current record in a subform
  15. I

    delete key

    well..what else can be..haha..sorry it is a question...thanks
  16. I

    delete key

    hi i want to disable the Del key to be pressed in subform. Thanks
  17. I

    copying text file onto USB flesh stick

    Hi from Access aplication I want to copy two text file onto USB flesh stick..The names of the files change every month but the extensions stay the same. Can you show me some examples...Thanks
  18. I

    values from subform to main form

    In a form with subform I want to transfer the value from subform onto form. The value in a field in subform footer is =count([code]) In a mainform I use this =[subform].[form]![field] which I used before and get the value, but now I constantly receive this #Name? as value in main form...
  19. I

    move method

    Thanks a lot ..Now it is OK!...Thanks...Thanks..
  20. I

    move method

    Thanks man..You are genius...
Back
Top Bottom