Search results

I dot think this is a permisssion issue(not sure though) since it happend also to me. also only this lock file can be deleted with out any problem. the normal lock file that produced automatically when some one open the software cannot be deleted. is this really a new issue? or is it due to some...

:cool: I got the computer where it is open, good tip!. But, my question is, why this lock file does not go away when the db is closed. NOT always, but rarely when the user gets some error. later on nobody can open the program. but, if I delete this 'lock' it works again.

Hi I have a problem with a cleint-Server accessdb that I created and works fine. But rarely (may be once in a week), I get a record lock file (normaly 1kb size) which is not the normal record lock taht appears when the system runs. This file does not get closed even if the db is closed. Also, I...

Thanks for such an optimised solution...!

yea IBIN is not the part of the bound table in that form. it belogs to another table which maps only the ibin with name. the details about the name is given in bound table but not the ibin. thats why I used it again. do u have any suggestions for that?? (to avoid dlookup.)

I made some small changes for the corresponding form and it words.. I wanted to search in a differet db. thats the only change I needed to make and it works. but just out of curiosity, why does nt it work with docmd.gotocontrol? I would like to know, so that I wont repeat that mistake again...

Hi yea that is true. the textboxes to be populated according to the search result are bound text boxes. only the search function is an unbound text box. and now, I tried the following way, Var_Haendler2 = DLookup("[Haendlername]", "Tbl_map_Haendler", "IBIN='" & Me.txt_IBIN_Srch & "'") MsgBox...

It is not bound to a table. should it be?

Hi Plog, the IBIN has a field type text. and I changed it as you suggested, but still i have error message, 3075_syntax failure.... 'IBIN='12341' anyidea where will be the problem?? thanks,

Hi All, I have a problem with Dlookup. I have s search function which should select a name corresponding to ibin number and then from the bound table, populate the text boxes in the form. this is the code I used. any body please tell me why thsi Dlookup is not giving the required output...

The error happens when the main form loads that means the first line of code itself.

Hi all, I have a problem with access forms. I am around 2 months working with access. I created an application/dataentry form and it was working very well. suddenly today, I got an error which says. Run-time Error 5 "Invalid Procedure Call or Argument. together with that or may be...

Hi CJ_London, thanks for the help. I got it workign what I was trying to do. ------------------- Private Sub proc_monthlyqry() 'the procedure which checks and run the query monthly once. Dim str_monthlyqry As String Dim cur_date As String Dim cur_mon As String cur_mon = Format(Date, "MM")...

it is openned and closed randomly. to be precise only when need comes but mostly once in 2-3 days but cannot assure. therefore on the first time it is opened in a month, it should be updated. splash form I do not have.

Hi, I want to run a query(to create a table) once in every month. But the application is run on a local computer. that means, on the first time when some one open the access, it should create the table. the next time it will be first time the application is run next month. that means, it must...

Till now the system works as I wish and the size of the pop up window is not changed automtically. :) also according to my code, the control should move to the pop up window till I double click a content. Thanks again.

Hi Mihail, I am not well versed in vb/access. Could you please explain little more what you meant in last post? should I change this setfocus? I have pop up yes already set for the search pop up window)

Thanks a lot it works fine as I wished I am also posting the code here for some one else further reference.

In first form, I have bounded text boxes (around 30 data fields to be populated) together with a button to search for a particular name. When I click on this search button, a pop up window opens with a search text box and a list box. where the list box lists the whole name according to search...

How to automatically populate the bound text box with data from a table for a specific entry. this is the code I wrote Private Sub ListBox_DblClick(Cancel As Integer) Dim ListBoxSel As String ListBoxSel = Me.ListBox.Value Call proc_Update_TxtBoxes(Me.ListBox.Value) DoCmd.Close End Sub...