Recent content by Colman

Thanks. I'll get my coat.

Let me first say that what I am about to say is not on topic for this thread. I think there is some over thinking going on here but do accept that I mis-used the term 'transaction', using it to mean where someone has used the database to do something that added to or changed in some way, the...

Hi ridders. My database is indeed split with each station having its own copy of the front-end. I think what is confusing people is that each station is in a factory environment and in some instances it is shared by a number of people. In order to restrict some database features to certain...

Uncle Gizmo, many thanks for that. I do find your comments extremely interesting and helpful and look forward to seeing some videos if you get around to it. Regards Colman

Hi Jiri. Thanks for your input. I'm not wanting to close any forms and not wanting to close the app. I simply want a logged in user to be logged out after a short period (with a 1 minute warning) so that another user doesn't inadvertently use their log in to perform transactions. The reason...

Uncle Gizmo, I wonder if we could pursue your comments a little. My first database was for handling warranty returns for a manufacturer. Returned items were booked in and repair details logged and subsequently shipping details recorded and despatch paperwork generated. If you said I should aim...

Hi Uncle Gizmo. Thanks for your reply and for your wisdom. Levelling up sounds good. I'm in.

Thanks for the code arnelgp. I found the function was returning False both with and without a popup open. I think the 'Exit For' command meant that it only ever checked the first loaded form and then stopped. I inserted an extra If, then statement and it works now. If...

Thanks for your reply. I feel there are too many popup forms in my database to test each one by name to see if it is loaded/open (if that's what you mean). There are more than 100 of them. Currently thinking I should ask the database for all loaded/open forms and test each of those to see if...

I have created a database that includes my own functionality that allows a user to log into the database. I now want to add a timeout feature that logs the user out after a period of idle. I have it working fine using the timer feature on a hidden form but I have one issue to overcome. My...

Thanks all but namliam's suggestion did the trick. I've never defined a query using the SQL view before but using namliam's logic I just adjusted what was there and it makes sense and it works. If anyone is still curious, this is what I was after. User enters product part number "12345-V001"...

I should explain that product part numbers come with various prefixes, not just "12345"

Thanks. I think namliam has it, I will try it later. It might be odd but this is what its about. Database has a table of 'change' records, each detailing a change to a product. This table has a related table of 'product' part numbers so that each 'change' record gets set up with a number of...

I understand that a query can accept wildcards in the search criteria but this is different. I have a form on which a user selects a [product] part number in an unbound combo e.g. "12345-V111". I then need a subform on the form to list records where the relevant field matches the left most...

Thanks guys for both suggestions. I think both approaches will help me to move forward with improving the structure of my database.