Search results

Hello, I have a text box on a form, which is bound to a number field in a table (type: single, 2 decimal places). I only want to allow values between -20.00 and 20.00. This part is no problem for me. However, I would also like to limit the choices to be multiples of 0.25. (ex.: 0.25, 0.50...

Hi, The country was set to Canada, and changing that fixed my latest dilemna. I was fooled by Windows' alternate language feature. I was under the impression that simply changing that to US English would do the job. Wrong! Thanks again Rich! Cheers, Gord

Hi there, I have a date/time field in a table where I have set the format to "mm/dd/yyyy". Oh, I should mention that my Regional setting is "US English". Now, I have a form to add a record to this table, with this date field defaulting to today's date (Date()). I have set the format for this...

Hey Rich, Binding it works fine. Thanks for the help. I'd still like to know why you are unable to append the large number of characters to the memo field, though. Anyway, problem solved. I appreciate that. Cheers, Ace

Hi there, I have a form with a bunch of text boxes, etc. that eventually runs an append query to add the record to a table. One of the text boxes' contents is to be added as a memo field in the table. When I enter in a large amount of text (more than 255 characters), I recieve an "Invalid...

Hey, thanks Rich. I signed up for SmartAccess, and read your article. Good stuff! I had been playing around with the text boxes and their borders, but it wasn't working out the way I liked. I think your solution will work just great. It is a bit more work, but I'm a bit stubborn about these...

Hello, I have placed some vertical lines in the detail section of a report, to act as dividing lines between groups of related columns. A couple of the text fields have their CanGrow property set to true, as sometimes they are longer than average, and need to be seen. Is there a way to have...

Hello, I would like to be able to count the number of occurances of a particular time during a specified date/time range. For example: Start: September 1, 2001 7:00 AM End: September 3, 2001 9:00 AM 8:00 AM occurs 3 times during this range. Is there a way to have Access provide me with...

Woo Hooo!! That does the job!!!!!!! Thanks for this, Abby. Drinks are on me. Hahaha, Sorry I caused your eye to itch. I know how irritating that can get. Cheers, Gord

I am using Access 2000 SR-1 I tried the API code with no success, but it is quite possible I am doing it incorrectly. I put the given code into a module, and then tried setting the mouse pointer with something like this: Screen.Mousepointer = PointM("my Path to a cursor file") I'm not quite...

Yikes, I am confused as well! You pretty much did exactly as I have done with my project. No_data brings a message box, and setting cancel = true. Identical to what I have done. I went ahead and tried a new one, in a blank database, as you probably did, doing the same thing, but still received...

The problem I am trying to get around involves using the hyperlink properties. These labels are used to open some reports, which contain code that will display a messagebox and cancel the opening of the report if there is no data. When this occurs, another messagebox occurs, saying that Access...

Hello, Is it possible to change the mouse pointer on an Access form to something other than the 5 or 6 choices documented by Microsoft? (Hourglass, I-Beam, etc.) I want to make a label behave like a hyperlink, and have the mouse pointer turn to the hand on the on_mouse_move event. (and of...

Thanks Pat, I managed to get it done by doing it all programmatically. the .addnew and .update methods for the recordset allowed the big textbox contents to be added to the field in the new row. In order to use the update query, I would have do an append query first, and then run the update...

Heelo there, I have a text box on a form, along with a button that runs an Append query. The value of the text box is appended to a Memo Field in a table. Upon entering a larger amount of text (could be more than 255 characters), the append query doesn't seem to work. If I place a text box...

Hello, I have made a form and used a bunch of labels with hyperlinks to a series of reports. I've added some code to the reports themselves to display a MsgBox when there is no data. I also set Cancel = True to stop the report from opening. When I click on a hyperlink to a form with no...

I knew there should be something easy like this!! This is excellent. Thanks a bunch, Ian!

Hello, Well, I am encountering a similar problem with a few reports that I am building. Each record in the underlying query/table has a number of Yes/No Fields. I would like to provide a count of the "Yes's" for each of these fields in my report. So, it would look something like this: Field1...

Good point!!! Thanks a million!

Hi Rich, I was unable to use a combination of queries I had created, as there was a conflict in using a particular table. I have managed to get the report working now, though, by creating a temporary table, and putting the results from the various queries (they all either count or sum some...