Search results

I want to check for existing records on my subform. The problem is that my form is based on an intersection table. Table 1 CompanyID CompanyName Contact Table 2 OpportunityID OpportunityName Description Intersection Table CompanyID OpportunityID What I have done is that I have a form based...

:) Thanks

Hi: I am using the code below on the OnClick event of a button to check if the user entered the correct password. Right now the user has to click on the OK button. I want to run the same code when user presses the ENTER key after entering the password. Because some users do not want to click on...

Thanx mderby, this works.

Thanx for your reply mderby. I did put this in brackets, [Forms]![formName]![comboboxname], but access removes it..I don't know why? My combobox does not have multiple columns n nor am I using multiple criteria. Ekta

Hi: I am using a form to pass criteria in my query and my report is then based on this query. My form has a combobox with values: Criteria 1 Criteria 2 Criteria 3 I want that whatever criteria the user selects should be displayed on the report header. I created a text box on my report...

Thanx Autoeng. I will use the batch file. Is it better to put FE on the server or on users local machine. I read that the database gets slow if you place the FE on the server because all your queries and other stuff takes time to get through the server. I think now I am ready to split my...

Hi Autoeng: This certainly cleared a lot of my doubts. 1. I am not sure if I fully understood the batch file procedure. Althouh, you did a good job of explaining. It's probably me:). Is there no other way of doing it?Can't I manually copy the FE on every users machine. I know it'll be more work...

Hi Pat: Thanx for replying. This will definitely help me. I have a few more questions:) 1. After placing BE on server and linking it to the FE on my local machine, do I simply copy the FE on my machine and then place it on the users machine. Will I need to re-link the FE on users machine to...

Hi All: I have been reading a lot of forums on Database splitting. I get the idea but I still have few questions in my mind. I am doing this for the first time so bear with me if I ask silly questions. 1. After splitting the database into FE and BE I will place BE on the server and copy of FE...

ok Pat, I will create another table with one-to-many relationship. How should I open this checklist subform on a button click. I dont have space to display it on the existing form. Or should I create a tabbed form but then again I dont want to redesign my form. Thanx Ekta

Hi Autoeng: I want to add a button on my form which would open the checklist subform as seperate form and not on the same form. What oldsoftboss said is also a good suggestion. I can create a second tab. But for that will I have to redesign my entire form. Or is there a way to change a form to...

I know there are a lot of fields in this table but it is normalized. So after creating a subform can I open it by placing a button on my main form. Every record has just one checklist associated with it. Thanx for your help Ekta

I figured it. The code below works Thanx for your help Private Sub Command6_Click() On Error GoTo Err_Command6_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmKeyWordResults" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Close acForm...

ok I have unbound fields on my form which I want users to search. I have a query set up with all these fields and in the criteria for the query I use something like this Like "*" & IIf([Forms]![frmOppSearch]![Name]<>"",[Forms]![frmOppSearch]![Name],"*" & "*") & "*" The search results are...

I am sorry. Not very good with vb. stlinkcriteria = "criteria to set this string". What do you mean by this?

so what should I do?

Doesn't work. It tells me "Type mismatch"

I have a search form which passes the criteria in a query and opens the form frmKeyWordResults when I click on Perform Search button. I want to close the search when when Perform search button is clicked. I tried to put DoCmd.Close in my code but then my search doesn't work properly. Where...

No, I don't have parent child relationship b/w these 2 tables. I have too many fields on my form so I want to create another form and then link it with its record