Search results

Thanks Linq. I should have said that the combobox is used in a datasheet view (in a subform). Does this make a difference to your solution working? Thanks, -NS

Hey all, I'm trying to figure out the best way to hide an unused option in a combobox. Currently I have a tick box that the user can tick if the option is no longer needed. I then have a query that filters out the ticked boxes as the coboboxes record source. However, when this is done, the...

Are you using the query builder in Access? If so, you can simply click the Totals button and then select SUM on the field you wish to sum up.

Hey all, I have a query that has a calculated field (Number of Employees). This uses a simple IIF to calculate the number of employees and works fine. I have a second query that uses the first query. In this query I use the calculated field to 'Sum' the number of employees grouped by the field...

Thanks to the both of you. This is exactly what I needed :) -NS

Hey all, I'm wanting to resize a form depending on whether or not a checkbox is checked (on the same form). I believe this can be done in VBA by using twips but I'm wondering if anyone could point me in the right direction please? Many thanks, -NS

Ok, I shall try :) Many thanks.

Thanks for the quick reply David. However, would this mean that Notes would have to be part of the combo box? Would this not slow performance when making a selection if the notes were sizable? Thanks, -NS

Hey all, This is probably pretty simple but I'm unsure how to do it. I have a combo box that lets me select staff, this is bound to StaffID. In the staff table I have a "Notes" field. What I would like is when I select a staff member from the combo box, for it to populate the text box with the...

Thanks for confirming Bob. Please can I ask you this.. As I cannot select multiple Surnames using the autofilter, is there a way I can do it from a form control? I know how to refer to text and combo boxes but these obviously only allow you to select one Surname. I'm aware of List boxes but...

I guess this cant be done then? -NS

Thanks Bob.... The pic below is what happens with the query. The pic below is what I would like to happen (and does happen when I dont use the query). Thanks, -NS

Thanks Bob, however I'm not sure you know what I mean. I;ve uploaded 2 pics.. The first is what it looks like when using the query The second is what I would like it to look like. Thanks, -NS

Hey all, I found a great solution on this forum (http://www.access-programmers.co.uk/forums/showthread.php?t=103312) to enable me to filter a subform based on text boxes in a form. However, I would like to (need to!) use the autofilters in the subform. By this I mean the ones on the heading of...

Just saw the update! That is exactly what I wanted - I wasn't aware you even do that in datasheet view without using table level lookups! Many thanks, -NS

Thanks for the example Jzwp. I understand what you have done and how. However, what I ideally need is to have that laid out horiztonally and in a continuous form (in a subform, if that makes sense). However, the reason I was opting for datasheet view was so I could do bulk copy and pastes from...

Yes, that is what I meant (at the table level). Is there a suitable alternative? Thanks, -NS

Hey all, I was just wondering, in datasheet view (on a subform) I normally use Lookups to let the user select their options. However, I've been told this is poor design and impedes performance. Is there an alternative to this? I'd like to keep my subform in datasheet view so I can do bulk...

Thanks Brian, that helps a lot :)

Ooops yeah, Access to Excel! Thanks for the answer Brian. I understand most of what you said but is there anyway you could put it more in laymans terms? -NS