Search results

  1. C

    Count number of times a Db has been opened.

    Hi, Is there any way that one can count the number of times that their database has been opened, or number of times a button has been clicked? Sort of like a 'Hit Counter'. Cindy
  2. C

    Stop login form from closing when incorrect info entered.

    Hi, In the attached example of a 'Login form' is there any way for me to prevent the form from closing if a user has entered an incorrect password or user name. I want the form to remain, so that the user can try again! (This is not my own form or code) Cindy
  3. C

    Passing criteria to a query

    Hi, I have a form with 2 ComboBoxes, 1 holds all the months from 1 to 12 and the other holds years 2003 2004 etc etc. Why is it that I cant get my query to work using the ComboBoxes, yet if I use TextBoxes instead it works fine. I am using the format... [Forms]![Myform]![Combo1] but...
  4. C

    Can I Choose from list of Queries in Combobox

    Hi, I was wondering if it was at all possible to have a list of queries in a CombBox and be able to choose one to run. (Based on the same table, but displaying a different field's records in the different queries) Cindy
  5. C

    How do I add a record and ComboBox list gets smaller

    How do I reduce combo list size after selecting a record. Hi, I don't know if this can be done, but here goes.... I am trying to make a roster of sorts, whereby I need to insert a name into a work position for a day. 1 row would represent a day, with columns for each position...eg Bay1 Bay2...
  6. C

    Split query results into 5 fields in a report

    Hi, I have a query, which gives me the weekday number for each day of the year, excluding weekends ...Monday to friday, using SELECT [Table3].[TheDate], [Table3].[Message], DatePart("w",[TheDate]) AS Expr1 FROM Table3 WHERE (((DatePart("w",[TheDate])) Between 2 And 6)); Is there any way of...
  7. C

    1 Form - many queries

    Hi, Is it possible to use one form to preform different queries over different tables. ie, Query by Form, querying, table XYZ, or the user can choose another query on table ABC. Does that make sense? Cindy
  8. C

    Showing query results in a form

    Hi, How does one go about showing the results from a query in a form, whether there is one result or say 10, how would all of the results be displayed simultaneously, instead of 1 at a time. I know the results can be viewed in a report, but how does one get them to appear in a form? Cindy
Back
Top Bottom