Recent content by tnago

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 Jfgambit Thanks for your help. The problem is resolved now.

Hi Tim Thanks for your responses. I was able to get the desired result by modifying somewhat the code that you suggested. I do appreciate your feedback. In my case I was trying to duplicate a VB front end functionality which was not working in win2000 enviornment. The person who developed...

Hi Jfgambit I used the code however it is not selecting the new record. I just want to clarify wheather "[IncidentNumber] is column name or TableName. Anyway that is how I have in the database. Private Sub Text150_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[IR] =...

I have tried what Tim suggested but I am getting runtime error. This how I have it in the database. ======================================= Private Sub Toggle141_Click() If Me.Toggle141 = -1 Then 'if pressed in Me.Text73 = "This" Me.Toggle141.Caption = "Closed" Else Me.Text73 =...

DCX693 thanks for your suggestion on the first part; below is some further explanation on the second part. I have all records in a table tied to incident number field. What I am trying to achieve is that if a user wants they can select a specific record and view or update the record by putting...

I have quite a number of records, as such I like to move next 10 or previous 10 record at a time to quickly go through them. I was unable to find anything which specifies how to navigate multiple records at a time. Also is there a way to jump to a specific record rather then going through Find...

Thanks, however as I am not in UK I am unable to use the solution that you suggested. I have read other solutions that others as well yourself have posted on similar problems, but I still did not find any suggestion as to how to get number of week day minus holidays which are defined in...

Yes Me.txtdiff = DateDiff("d", [Date Entered], [Deadline]) will give me number of days between two dates, however there is still an issue of only showing working days i.e # of days minus weekends and any public holidays. Any suggestion? Thanks

Hi I am trying to calculate number of day since a particular event. A user enters a date on which a an e-mail is received. Once that date has been entered, I like to automatically calculate the number of working days including holidays (which are in already defined in another table). So...

I am sorry to bug again, however I am unable to lauch the control wizard for some reason. The Select Object option remains active even when I select the magic wand, as a result when the control is put on the form the button can only be configured through the 'properties' option. Any suggestion...

Sorry to ask this question, however when you say to use control wizard you mean tool box? Or is it something else. I am new to Access so this question might look stupid to experienced user.

I am trying to use a toggle button on a form to update the value of a record in the database. I want to have a button whose default state is Open and when toggled changed to Close and update the corresponding record in the database. Any help will be greatly appreciated.

Thanks for the instruction, but maybe because of my inexperience with VBA and Access I am unable to get it to work. When ever I try to press the spin button I get Compile Error "Method or Data member not found" with (yourdatefield) highlighted. Is it looking for any Dim statement? This might...

I am trying to use spin button to move date up or down in a form field. A new record will have a blank field until a date has been entered into the form. The problem I have is, how to control the spin button so that date go up and down when the button is pressed. As well how to differentiate if...