Search results

Yes, initially I also thought it was ordering the months alphabetically however looking at it closely I saw that Jannuary was being repeated several times. I also added the "month" filed in its original format to see how the numbers were being translated and it is just crazy: 1 is December, 2 is...

My report is reading from a table where I have a field called month with numbers from 1 to 12 representing the month of the year (field type is number). The report groups data by month and is working fine, and it shows months as numbers (1..2...etc). When trying to change the format properties...

By importing some forms to a new DB I was able to isolate the form that was giving me the problem... it was a subform. I deleted it and imported this subform from a backup of the database I had from a while ago. It worked! I have no idea what happened.... will try looking at the code to see if...

I've been using this database (Access 2000) for a while now without problems when suddenly... error message when trying to open one form. It says "You canceled the previous operation". I closed the database, compacted, copied every single object to a new database and still get the same error...

Duh! That was a really silly thing... yes, having the ResultID in the sorting list works!!! Sometimes the solution is right under your nose and still you can't smell it... thanks a bunch! :)

I tried that. I have the following in my sorting/grouping button: Campaign: Ascending Activity: Ascending It is sorting by the alpha field (Result), not the numeric one (ResultID). What else could it be?

I have a report that is based on a query that gives me the following data: Campaign Name, CampaignID, Campaign Activity, ActivityID, Activity results, ResultID. In my query I have ResultID in ascending order. In my report, I have a header for CampaignID, another for ActivityID and in the...

Could you please be more specific? How would I do that? thanks in advance! :)

In my database I added security, created user groups and usernames and everyone is required to have a userID and password. Is there a way I can force users to change their passwords after a certain period of time, like a password expiration date? Thanks!! P.S.: I'm using Access 2000

Yes, I am. Could this be a network connection problem?

Yes, I do have permissions to add, delete and modify. This error occurs only once in awhile, usually I use the DB for a week without problems.

See the error message attached. I was the only one using the database at that time. :confused:

I have my database set to compact on close. Sometimes Access gives me an error saying it could not compact the database. I have enough free space and no one else has the db opened. What could be happening? Any ideas? P.S.: I'm using Access 2000

Awesome! It works great. thanks a lot!

In my form I have a button to delete the current record. Is there a way of substituting the standard Access warning message "Relationships that specify cascading delete are about to cause 1 record to be deleted..." for a more user friendly one, like "are you sure you want to delete this record?"...

I realized what the problem was... my main form and my subform were still linked as parent-child and the query for All records would only work if I use an unbound subform. Thanks for the help!

Although I'm not experienced with VBA, if you could detail me the steps I should take to make it run it would be great. thanks!

This form shows me a list of projects and the combo-box allows me to view projects only for the selected "status". My combo-box is based on a value list where I have the following: "All";"Not Started";"Open";"On-Hold";"Closed";"Canceled" When I select any value but "All", the subform gives me...

Hi, I have a combo-box in my main form that allows the user to select from a list of options. There's a subform based on a query that will show the results based on the selection made in the combo-box. Everything works fine, except that I also want the user to be able to select "all" from the...

Great!!! Thanks a lot.