Recent content by alfi

In that case my suggestion will be either to change the way login is done or to scan and attached the supervisor scanned confirmation. Another approach will be to provide the supervisor another way of confirming the user input . the user for example can send his timesheet as an attachment to...

Saving the file as csv is the fastest solution, another will be to loop through all the xsl spreadsheet lines and by code convert them into the CSV , this is a much slower and much more labor intensive approach.

It depends what you are trying to achieve, if you are trying to validate a user then a username and password should be enough. a more strongly validation will be to make sure that the user is logged in on his machine, this can be done by verifying the user with the windows login username through...

try to set your recordset open statement as follow : rs.Open tsql, conn, adOpenForwardOnly, adLockBatchOptimistic , mybe the problem is in the table/query use index/ key to improve proformance,

Hi guys Is there a way to call a public function on an open form when the method name is a string like this : Forms(formName).functions(functionName) and not the usual Forms(formName).functionName In other words is there a collections of public functions in a form ?? I want to...

Hi dK, thanks for the feedback, i am presenting the user with the content of one column and the others are hidden and used as keys, the problem is that one hidden column contain a sql statement that will be executed according to the user selection , but the sql statement is truncated and...

I created a recordSet that contains three columns of data, one of which the string value length exceeds 255 characters, When binding the recordSet with a listBox control the value was truncated to 255. I checked the record source to make sure the problem is not in the data coming from the...

in the attached file i build two text boxes where the input of one will effect the result on the other. i also created a button that emulates an automatic change.

I am looking for a way to identify data change on a linked table; one way is to look at the time stamp of the original file and to compare between the current time stamp and the one that I save in the database, I am looking to find out if there is some kind of a trigger mechanism, thanks guys.