Search results

  1. N

    Access 2003 runtime version and shortcut menus

    I have developed an application and packed it into a runtime version. However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse...
  2. N

    Need help on distributing data base

    I have developed a data base to be distributed to 10-15 users who do not have Access installed. I have the Sccess 2003 Developer Extensions and can thus package a runtime version. I guess that the best thing to do is to split the db in a back-end db with the tables to be installed on the server...
  3. N

    How to show a value from a closed form in a report header?

    I have a form where I through three parameters, chosen by combos, show a list of records. A code at the same time populates the label for the list showing the parameters plus some text to make it understandable. A print button closes the form and open a report with records from the form list...
  4. N

    Printing content of a form list box in a report

    Thanks for the valuable help I have got in this forum so far. Another, and probably simple question: I have a form where I ,through three parameters selected in combo boxes, populate an unbound list box with records. The list box has five columns. I want to be able to print a report that has all...
  5. N

    Populate list boxes when a form field changes value

    I have three list boxes on a form (lstSubjectName, lstTargetGrName, lstCountryName). The list boxes are populated from queries based upon tables that have a many-to-one relationship to the main table. The queries are the following: SELECT tblProjectSubject.ProjectID...
  6. N

    Using the NotInList event and updating two fields the table

    I have a data entry form where country(ies) (there can be more than one for each project) is/are entered in a sub-form on a tab control. Countries not listed are entered by the following: Private Sub CountryName_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim strMsg...
  7. N

    Tables and table structure needed for new DB

    Firstly, I want to admit that my knowledge about data base construction is fairly basic. I am trying to build a data base for humanitarian projects that do not at all resemple of the usual examples including customers, invoices, suppliers and what have you. My problem in constructing the DB is...
  8. N

    Query on a field that has several values

    I am using a form where I select values from combo boxes to enter parameters for a select query. It works fine where the table queried only has one value in the field concerned. However, it does not work on the fields that have several values (entered through a multi-selection box). Are there...
  9. N

    Shorter date/time format

    I wish to insert in a table, not the date, but just the month and year (yy/mm or mm/yy), for example 05/10 or 10/05 for October 2005 (the order of yy and mm does not matter). In addition, I need to be able to sort the records chronologically using the same field. I have tried various solutions...
  10. N

    Runtime for Access xp application

    I am developing an application in access xp (2002) and want to distribute it as a runtime application. I do not have the Office xp Developer version and thus need to buy the MS Office Developer. It is still available and if so, where can I buy it? Or can the Visual Studio Tools for the MS Office...
Back
Top Bottom