Search results

Count number of times a Db is accessed. Thanx for the help, I made an Autoexec macro and created an update query as you said, and it works like magic... Thanks Cindy ;)

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

I think I have found my answer...thanx for all the help guys !! DoCmd.Close

Re:- Login form closing Wayne, Sorry for coming back like this, but... What you have done is perfect, except, how do I get the form to close once a user has entered the correct data? Cindy

Re:- Login form closing Thanx Wayne

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

ComboBoxes and query Yes, I am using 1 table for the dates and another for the Years and both only have an ID field and the Year and Month fields respectively. They are both bound to column 1, ID's (Autonumber) is in Column 0.

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...

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

Attachment Thanks for the help guys, I got it to work this time.. BJackson, that looks pretty good, I like the idea. Once again, thanks guys, for your time and assistance, you have opened my eyes to a better way of approaching my problem. Cindy

Shrinking ComboBox List bjackson, The zip file you have attached does not seem to contain any data, is anybody else having a problem accessing the contents of the attachment? Mile-O-Phile, Thanks for the tip !! Cindy

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...

Re- Crosstab query Rich, Thanx for that suggestion, I have never used a CrossTab query before...I'll give it a go ! Cindy

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...

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

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