Search results for query: *

Hi Mike I did try most of the basic troubleshooting techniques before posting my request, in my case rebooting the machine did not close the ldb. Thanks for your suggestion.

Hi Ept Yes I did try to delete the file but it kept on giving the same message. Although, I am able to fix the problem by resaving the database on a machine which was running Access 97 as it was developed in that format.

I have a problem on the network drive where the access database reside there is lock file which is preventing the database from opening. I have checked the file and for the machine it is pointing to, the database is close on that. Whenever I try to open it I get the following error " The...

Hi Neil You are correct that the above example doesn't do everything however, it would have been nice if you had given the code to accomplish this without the ActiveX so that others could have learn another way of working with the calender.

Hi I am trying to get my form to load records from a specific time frame (e.g only year 2003 records or from a specific record id)and with most recent record as the record being displayed in the form. Also can we show all the records in the form if user so desire. Any suggestion?

Hi Bill Thanks for your suggestion. However, without checking for the first or last record it will get stuck before reaching either the beginning or end depending on the number of records in the database.

Hi Gol4 Thanks for your suggestion. I think it is very good in the sense that it allows the user to go forward and backward as many records they want rather the developer limiting them to any set number. Though I have one issue the way the code is running now. I think the code should move to...

Hi Gol4 An interesting way to do things. Though I have two questions. One it is only moving foward what about if a user wants to go backward. Second how you tell user that either they are at the first or the last record and further ckicking will do no good. Once again thanks for your suggestion.

Hi HP & Genimuse Thank you very much for your help in this regard. It is working as desired. Please accept stars for your effort and time.

Hi HP & Genimuse I tried the last suggestion by HP but I am getting error on every click (after every 5 records). Maybe I made an error in the code or something is missing. I have the code as follow: Private Sub Command10_Click() On Error Resume Next Dim i As Integer Dim...

Hi I saw another FAQ (http://www.tek-tips.com/faqs.cfm?spid=181&sfid=261) from the one suggested by ZmrAbdulla. This particular FAQ covers all the condition which I am looking for to do the calculation. However, being new to Access I have problem as to where to put the code. What I can...

Yes it works but now where I put my error message that user is at the end of database and there are no more records?

Hi JrBarnett Thanks for your help on this particular problem. Please accept 2 stars for your time and effort. Specially the sample database was very helpful in clearing any question that I had.

Hi Genimuse Thanks for your help in this regard and two stars for your effort and time. One more thing on the this subject, is it possible to stop on the last record and give the warning message that there are no further records rather than going to last empty record?

Hi Is it possible to move forward or backward more than one record at a time. If there are large number of records it is less time consuming if user can move say 5 or 10 records forward or backward. Access built it navigation just allow sigle record movement. Any suggestion?

Hi I tried what you suggested in terms of changing the icon but by right clicking it just brings up customize option in which there was no icon change. What am I doing wrong?

Hi JrBarnett I have made the changes as indicated however, I am not getting any results. ------------------------------------------------------- Private Sub Text150_AfterUpdate() Dim rsID As Variant rsID = DLookup("[ID]", "INCIDENTS", "[ID] = '" & Me.Text150 &...

Hi After reading some of the other threads on this issue I tried to do use the following code to select or search a specific record from the database which can be viewed or edited by the user. However, I am unable to make it work. Can someone guide what I am doing wrong...

Hi Rollie Thanks for the help on this issue. On Current does solve the issue of indicating if the record is open or close. Also by adding on Click for toggle it changes the open to close and vise versa.

Hi Rolliee Thanks for your suggestion. I am currently trying to use the following event procedure on click. ------------------------------------------------ Private Sub Toggle141_Click() If Me.Toggle141 = -1 Me.Toggle141.Caption = "CLOSE" Else Me.Toggle141.Caption =...