Search results

thanks arnelgp! your db works.

i used your db. however, i noticed that when i close the form and open it again, the values are no longer shown. i have to open the combobox and click on ok again for the values to be shown in the box.

thanks arnelgp. this correctly shows in a textbox all the chosen values in a combobox. how do i show the corresponding name? the values shown are the account codes. i would like to show the corresponding account names.

I know what you are saying about one field and five records. i need separate fields because these 5 fields are used as columns for a report (5 columns). then in a subreport, these 5 "colors" should not be included anymore. my dilemma is, as you have mentioned, if in the future another...

I have a report that should show all colors except the colors indicated in 5 fields. My filter (found in Report Property Sheet) for the report is this: color <> DLookUp("color1","tbl_color") and color <> DLookUp("color2","tbl_color") and color <> DLookUp("color3","tbl_color") and color <>...

How can I show all the chosen values in a multivalue combobox in a textbox? When only one value is chosen, this value appears in the textbox. But when more than one value is chosen, the textbox does not show anything.

I have decided to use On Mousedown Event. Can you correct my syntax because the one below does not work. Thank you. Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) If Button = acRightButton And Me.ActiveControl = TextBox Then DoCmd.AddMenu...

I made my own right-click menu that has the Paste command. When a user right clicks on the form other than a text box and chooses Paste, Access will show the error message: The command or action 'Paste' isn't available now... I have tried including On Error (Fail) and Set Warnings (False) in...

Hidden data - fields such as version number.

Thanks for the suggestions. The scenario is the user does not have MS Access so I plan to use runtime. What I am thinking is to create another app that has the Update Query. Send this app to the user. The user will use Import> New Data Source> From Database> Access. Is there a better (and...

Assuming an Access app has been deployed to a user. There is a field in a table that is hidden from the user. How can we modify the value of the hidden field?

oh wow. that worked! i will try this with the real form and the several embedded macros. thanks a lot!

I did but still did not work. I could not get past the decompile process as it was pointing to the same issue. The form involved is also going to be used as subforms (but with a different table source) in other forms. Updating the name of the header forms in all the macros was cumbersome so I...

My form has SEVERAL macros and I used the 'Convert Form's Macros to VB.' Sadly, the actions stopped working. So I created a simple form to try to figure out the error. I created a macro on a field's On Mouse Down event: Message Box. Macro worked fine. Then I used the Convert Form's Macros...

hi. this is what i did but it still allows me to add more than 5 records.

The code below by WatsonDyar works to limit number of records entered in a form. Private Sub Form_BeforeInsert(Cancel As Integer) If Me.NewRecord = True And Me.RecordsetClone.RecordCount = 3 Then MsgBox "Cannot add more than 3 rating officials. Press OK to continue.", vbOKOnly, "Maximum Number...

thanks for the suggestions. i figured out a solution to the vertical scroll bar issue by trial and error - adjusting the height of the subform and the detail section of the main form. (played around with different heights until i finally got what i wanted.)

for clarification, if in my original form i have 5 text boxes, instead of using text boxes, i should use list boxes (5 list boxes)? am i understanding you correctly?

Is there a way that I can jump to another record (either previous or next rows) without having to go through all the fields for the row where my cursor is currently on without using the mouse (just using the arrow keys)?

the field types in the subform are textboxes.