Search results

Does this actually work?

What do you want it to do?

You can, you need a Recordset object that will hold the data from your SELECT statement. Something like, Dim tmpRS As DAO.Recordset Dim tmpNo As Long tmpNo = 10 Set tmpRS = CurrentDB.OpenRecordset("SELECT * FROM yourTable WHERE yourField = " & tmpNo)

You are not making any sense Sandya. Your description is confusing, so is your example.

You can create a Pause function, something like. Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Public Sub Pause(intSeconds As Variant) ' Comments: Waits for a specified number of seconds ' Params : intSeconds Number of seconds to wait ' Source : Total Visual...

Could you please give some examples?

It could be reference issues. Was there any changes in the network?

What changes did you make? Is every computer in the network running the same configuration?

Thanks MackMan for your response. :) It is not an Access "Expert" gathering. It is purely a meetup of people who happen to be a part of the AWF Forum. I am no expert, I just like meeting people and putting some faces on the profiles I normally see on here. You are more than welcome. :) Guys...

BennyLinton, what happens when you try to append 0:00:00?

Vanakam Tamilvendhan. Chennaila enga? Nan Velachery. :)

Prabha could you please explain exactly what you are trying to do? Your question lacks detail

Thanks to everyone who filled in the survey. I was off on holiday, for about a week. I was hoping to see great response, but only 4 so far :( It would be nice to meetup. I think it is way too soon to inform about the outcome. So please, encourage other to do it, so we could make it happen :)

Cross Posted at Stack Overflow -> https://stackoverflow.com/questions/29917922/text-box-value-base-on-listbox Please have a quick read : http://www.excelguru.ca/content.php?184

No nothing is "sorted". I take you did not read the second part of the post? :rolleyes: Public Function AddWorkingDays(StartDate As Date, numworkdays As Integer) As Date Dim intCount As Integer Dim rst As DAO.Recordset Dim db As DAO.Database Dim EndDate As Date Dim...

Please use Code Tags when posting VBA Code

I hope this POST will help you, I remember helping another user with similar request. The other user wanted to send an email, you can ignore that part.

Thank you Tony, I have created this survey, you can find it at SurveyMoney. Please encourage people to take the effort to fill in. We will make it happen. :) Thanks to everyone who has shown an interest.

I did wonder whatever happened to him. I thought he just was a bit busy, as he does pop in occasionally, according to the "Last Seen status".

Of Course you can, something like. Public Function HasNumbers(InputStr As String) As Boolean Dim tmpArr() As String, lCtr As Integer tmpArr = Split(InputStr, ";") For lCtr = 0 To UBound(tmpArr) If Val(tmpArr(lCtr)) <> 0 Or InStr(tmpArr(lCtr), "Pant") <> 0 Then...