Recent content by Lierduh

A simple question for you. One of my form is based on a SELECT statement. I wan to know if the recordsource returns empty result at time the form is opened. Is there an easy way to do this? If I was to test if the result is empty? do I do at the form openning event? Thank you

The problem might be within the export step. You should be able to open two recordsets even from the same table. Normally I open the source as: Set source = Currentdb().OpenRecordSet ("...", dbOpenForwardOnly) or dbOpenSnapshot if not forward only. target as: Set Target =...

Thanks Tim for the info. It will be handy to know this. I have a routine to check user's PC's time setting against the servers as well as the date format when a user is logging into the Access front end. However if a user accidentally changes his/her time setting after login, then the database...

That means I would need to hard code the user name or password in the code or store the password etc in a local table. Each user uses a different set of ODBC user/password based on permission. It is easy to update the linked tables using the Linked Table Manager and not easy to maintain DSN in...

I think the code probably makes more sense for the experts than explaining. Function Duplicator(strSource As String, strTarget As String, strSkip As String, strIDName As String, varIDVal As Variant, varSetTo As Variant, Optional strExtrSQL As Variant) ...<removed unrelated code> 'Find out the...

html treats multiple spaces and line feeds etc with only one space. If you want to show two spaces in your post. Try to use:   for one space. eg. '  ' is made up by: '  ' ' ' should only have one. As for the replace, have you tried searching for the equivalent ascii code? eg. chr(32)...

I need to retrieve the MySQL's current time through MyODBC. I am not sure how to achieve this in VBA. I can do this by creating a pass-through query as: SELECT CURRENT_TIMESTAMP; The problem is I need to store the DSN information with the query which may not be practical. Is there a special...