Search results

Trevor Some forms are fed from tables, some from queries and some from SQL statements., I am now beginning to realise that this might be a bigger task than I thought. Is there a way to test the contents or a control and derive the data type?

Trevor Thanks for the guide but it is not giving the results I need, it is listing the control type rather than the data type of the underlying field. So for most controls it is listing Textbox where I need date/time, number, text etc.

Trevor Thanks for the ideas but not really what I want. I want to glean the datatype info from any control on any form, this is part of a bigger project. I don't need to differentiate between numeric types, just number, text, date/time and yes/no. Thanks

Hi I am trying to find the data type in the current control, is there something like screen.activecontrol.datatype ? Does anybody have a function to recover this attribute? I need to test whether the current control is a number, text, date/time ,yes/no, memo or something else. Thanks

Hi, thanks for the answer. Yes it is worth it, I need the filtering functionality provided the full version of Access for my run-time version. Filter by form, filter by selection and filter excluding selection are all good but limited but we often know part of a part number so it might be...

Hi I am trying to replicate the Filter By functionality on a custom popup (right click) toolbar. This is not specific to any form or any control on a form but allows a filter to be applied in any selected control. I started by making the custom property load a filter criteria form called...

I have an access 2003 database split front & back end. And have an issue with the findnext macro and vb function providing inconsistent results. I have a form that show 650k records. I have F8 autokey bring-up a (dialog) form with a text box where uses enter the first few characters of a...