Search results

Hi. Were you able to find a solution to this? I am also finding a way for the vertical scroll bar of a subform not to appear. Setting Scroll Bars to Neither using the property sheet of the subform did not work.

Before Update worked. I just had to clean up the data as there were records that violated the validation rule. Thanks.

In the general tab of Table Property, there is the Validation Rule. What is the equivalent Event of this in forms? I cannot seem to make it work using On Current and Before Update in forms. I do not want the cursor to move on to the next record if the sum of field01 and field 02 is zero.

The Validation Rule/Text does not meet my requirement. The field is a number. What I could use that for is specify a range or start with a specific number, etc. If the user enters "ABC" in the number field, Access will not use what I indicated in the Validation Text. It will show the...

I want the messages to be short and simple. (Enter a date. Enter a number. Data entered should be a number...)

I have a form with 2 fields. If the data type entered is not the correct one entered for these fields, I would like to have a different message appear depending on which field trigerred the error. When I use the On Error event of the form, it applies to the whole form. How should I do this?

I do that specially when the entries are repetitive and you just change the amounts. I will assume that others will do that. I just want to anticipate possible problems.

This is the form. The user can copy that transaction (in red) and paste that to the next new transaction. That is okay but I want him to write a description first (in blue) before they paste the transaction. I found a way to undo the paste function and show my own message. There is no append...

It does not. Maybe I'm placing it in the wrong event. I have tried On Error, After Update.

I have a form. I want to suppress this message: Do you want to suppress further error messages telling you why records cannot be pasted? I made my own message box and the latter successfully appears but after I click on OK the above message still appears.

got it, thanks. another question: when the user installs the runtime, what file/s are installed in the user's computer?

what do you mean? i should save the runtime file in the folder where i created the db?

I am creating an application using Access 2007. The user does not have Access. Should I download the Access Runtime 2007 or can I use Runtime versions higher than 2007?

I misunderstood Isaac's question. I thought he did not know how to make a shortcut menu since I clearly mentioned in my post that I made the shortcut menu using a macro. Since I am not an expert programmer (and I thought he wanted to learn how to make a shortcut menu), I posted the db made by...

To solve my own problem, instead of using RunCommand - ExportExcel in the macro, I used OutputTo and chose Excel as the Output Format.

hi. this is the db i patterned my shortcut menu. i downloaded it from a forum.

Hi. I made my own Shortcut Menu (right click) on a report using a macro. I used runcommand - ExportExcel. When I right click on the report, this function is disabled but in the Print Preview Menu, the Excel Export is working. (Take a look at picture.)

thanks for this vital info.

to arnelgp - thanks. i was able to open it.

to arnelgp: thanks. i could not open your file. the message i get is: unrecognized database format. i had also thought of enabling in the report the shortcut menus (right-click) but i did not like the idea of the users trying to figure out where the print button was because they could not...