Recent content by SunWuKung

  1. S

    export string to text file

    Yep, thanks for the help. This is the code I took from the help: Const ForReading = 1, ForWriting = 2, ForAppending = 3 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Dim fs, f, ts, s Set fs = CreateObject("Scripting.FileSystemObject") fs.CreateTextFile FileName...
  2. S

    export string to text file

    hi, could somebody tell me what is the syntax for exporting the content of a string variable into a text file? thanks SWK
  3. S

    hide control in continuous form

    I've done something similar to this here: http://www.access-programmers.co.uk/forums/showthread.php?t=91784 hth SWK
  4. S

    grouping on continuous form

    I think I finally cracked this. 1. Create a textbox in the detail section above your data Name=Separator ControlSource:=SeparatorVisible([TargetOrder]) 2. Create a textbox in the header Name=PreviousTargetOrder Visible=False 3. Put the following code in the form Function...
  5. S

    grouping on continuous form

    Hi Pat, I have a combo box on the form header that I use for filtering - which I guess is a similar setting to a form-subform. So I can have a look at the different groups separately its just I would like to have some formatting when the filter is not applied. The report is not an option here -...
  6. S

    Display on form

    If I understand you correctly while you are working on one record you are trying to display data from a previous record as well on the form. The only way I can imagine this is through code (though the big guys may have something more elegant). On Load Step1 - get the ID of the previous record...
  7. S

    Public Variables, OpenArgs and Compatability issues

    This won't be a high level answer but here is what I usually do: I usually store the selection of the user in a table - UserID, ObjecType, ObjectID. This way you can have user preferences stored and so on. When I am too lazy to do this I store user selections on the central switchboard form in a...
  8. S

    grouping on continuous form

    I have a list on a continuous form which goes like this: 1 adsf 1 qwer ----------------- 2 sdfg 2 rzrzur 2 gjkghjk 2 nmfhj ----------------- 3 sdfgrtwe 3 wrtwret I would like to have a line appearing under each category. Is it possible to do? Thanks for the help. SWK
  9. S

    display html formatted text

    Hi, I have html formatted text sitting in records - its a helptext for the application. I need to convince Access to display them correctly. I tried to create a data access page to display them - but I need to have the display as a floating window displaying only one record at a time with no...
  10. S

    different types of entities in the same table

    I think I know now what my problem was. I couldn't give a proper name for a table that contains ID for so different things as persons, jobs or companies - so I couldn't really imagine that table. Now Subject is good. And you helped me a lot. Although I couldn't recite any of the 5 rules. I...
  11. S

    different types of entities in the same table

    Hi, I am designing a database. It is going to store data from questionnaires. The natural way seems to be to have a table - that stores where the data comes from, what is it about, what is the question and what is the answer, like this: DataProviderID; FocusID; QuestionID; AnswerValue My...
  12. S

    application resize event

    I am on a seemingly hopeless mission of creating a proper application interface for my Access project. :) I have a main form that acts as the desktop of all other functionalities. Now Access seems to insist of beint a multidocument interface (a'la Excel) while I would like it to pretend to be...
  13. S

    application resize event

    Hi, does somebody know where would I capture the resize event of the application (not the resize of a form) ? Thanks. SWK
  14. S

    remove application scrollbar

    As far as I know the restore button always appear on a maximized form (if it is not popup which I don't want).
  15. S

    remove application scrollbar

    min/max, close, borderstyle, popup, dialog - I've tried them all, but couldn't achieve what I was looking for: a standard window with a menu, completeley filled with a form. oops, a thought while I was typing - in my IE there is a bitmap (windows logo) where Access would put the restore button...
Top Bottom