Search results

  1. J

    query or sql?

    Hello, I wonder if i'm posting inthe right forum, but this is driving me mad! I'm in the process of building a database whereby i can check whether there is any duplication of items. I have a form that lists the tables in the database and the the fields corresponding to the selected table...
  2. J

    Query Parameter help.

    Hello, :( I'm having a slightly wierd problem. I have a form that is based on a parameter query. The month field of the query has a parameter which is: Like IIF(IsNull(Me.combomonth.value),"*",Me.combomonth.value) combomonth refers to a combo box containing all the months. The query is...
  3. J

    select specific records in forms- Help!

    Hello, I'm sure this has a simple solution, but iv searched this forum and every solution that i get is filled with code that goes over my head! Well here goes... I have a main form called expense... which contains a tab control. the tabcontrol in turn has three pages containing a subform...
  4. J

    form no records message box.

    Hello, Am having a bit of a problem here. :( i have a form which contains three subforms. the subforms are based on queries which get their parameter value from an option group. all this was working fine until i had the bright idea of displaying a msgbox when no records are found in the...
  5. J

    query help!

    hello, I am having some trouble with a particular query. I basically have a table that contains all the expenses accrued over the year. I have a form which displays these expenses. I need to have options in this form whereby a user is given option buttons, where he can click on a button to view...
  6. J

    Color Alternate rows in a continuous form

    Hello, Does anyone know how to color alternate rows in two different colors in a continuous form? :(
  7. J

    lookup column help!

    hi, I have a form which is based on a query that displays the expenses for a given month(the parameter value). In my expense table i had set up the month field as a lookup column which basically consisted of two columns, one was the month and the other the numerical value of that month. for...
  8. J

    buttons and icons on a form

    hi, I would like to use icons and interactive buttons for my forms to give them a more professional look. does anyone know where i can get such icons? i'm quite an illiterate fool when it comes to making the icons using icon editors. i tried searching on the web but it always throws up stuff...
  9. J

    Switchboard and subforms

    Hi can someone pls tell me how i can open a form as a subform in a switchboard rather than as a form in a new window. I have a switchboard with about three options.... each of those again open into other switchboards with two - three options... when i click an option i want the form to open as...
Back
Top Bottom