Recent content by anski

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.