Search results

...I hope! So, this form I've got that shows a lot of information, has an Option Group which is populated from the data source table and I want to show/hide other controls, based on which option is selected. I can do this when the Option Group is updated easily, but when I move from record to...

Ah, silly me! I'd kept the query in the database, but I'd already done the calculation in a text field on the form - so the query isn't needed! Thank you :-)

I have a fairly complex form used to display quite a lot of information, and the data source for this is a table. I also have a query that calculates dates for each record within that table (a calculated 'end' date) and which I would like to use in the same form. Should I use the table or the...

Of course, if I'd had my security settings configured correctly... D'oh! Thank you :-)

Well, I tried that, but to no avail. It seems to make logical sensethat your code should work, but absolutely nothing happens - not even an error code. I was wondering if I'd done something wrong when adding the Option Group. Pete

Thanks, GinaWhipp. I thought I tried that too, but I'lluse your code and see how I get on. This is a bit of a puzzle for me! Thanks, Pete

Hello. I'm trying to hide fields and labels on a simple form using the following After Update Event Procedure of a Frame: Private Sub Frame614_AfterUpdate() If Me.Frame614.Value = 1 Then With Me .Expiry.Visible = False .Limit.Visible = False...

Well, I thought this would be easy... I have 4 fields in a query, from which I would like to calculate a final figure. The fields are formatted as Currency, are in the same table and are as follows: (F)und - The organisation I'm getting funding from (S)ecured - Funding I've been promised...

Hi guys, Thanks for your suggestions, but I'm in need of a bit more detail... I get (most of) what you're saying, Ranman, but I'm not sure how I'd use the 'EnableBtns' in relation to the actual command buttons. Am I correct in understanding I would need to use the 'On Click' event on the Edit...

I'm using a form to allow users to enter new records and view existing ones. The existing forms occasionally need to be edited, but I'd rather use an Edit command button to enable the fields and therefore allow changes to be made, rather than leave them editable 'by accident'. Initially, I set...

Hello. I'm in Wiltshire, in the United Kingdom. I have limited experience with Access, but a good working relationship with Word and Excel and, quite some time ago, VBA when developing a database for my employer. I've been tasked to convert an Excel database into Access, to simplify user data...